0 Replies Latest reply on Sep 9, 2009 11:36 AM by C S

    Oracle Datasource: Unable to fill pool. OutOfMemoryException

    C S Newbie

      Hello NG,

      we develope our first project on JBoss, and so we are not very experienced. But for several months we were very happy with JBoss where we also have a Oracle Datasource which we use. So everythings fine,
      BUT for 2-3 days now, we've got the following error. The ConnectionPool tell us that he is unable to fill the Pool and the database is OutOfMemory. Other connections (outside Jboss) to the database lead to the OutOfMemory-Error, too. Everytime we have to stop JBoss to get the database work again.

      Can anyone tell me what we've done wrong? What can I figure out or monitor inside JBoss to discover the error(s)? Are there any suggestions or ideas?
      Thanks a lot for any help!

      Chris


      Here is the terrible Excpetion:
      2009-09-09 17:11:51,868 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-01034: ORACLE not available
      ORA-27102: out of memory
      Linux-x86_64 Error: 12: Cannot allocate memory
      Additional information: 1
      Additional information: 65536
      Additional information: 8
      )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:524)
      at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: java.sql.SQLException: ORA-01034: ORACLE not available
      ORA-27102: out of memory
      Linux-x86_64 Error: 12: Cannot allocate memory
      Additional information: 1
      Additional information: 65536
      Additional information: 8

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:243)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:304)
      at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:348)
      at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:151)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
      ... 4 more