Maximum number of sessions exceeded

[José Fernandes]

Hi guys, i started to use ebean but im having some problems:

I am testing with a webapp, when the server starts, it loads each
database schema connection.But for several times i am having the
error:

Dec 31, 2011 4:43:27 AM
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool
notifyDataSourceIsDown
SEVERE: FATAL: DataSourcePool [dip] is down!!!
java.sql.SQLException: ORA-00018: maximum number of sessions exceeded

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
278)
at
oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:141)
at
oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:524)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
1156)
at
com.avaje.ebeaninternal.server.lib.sql.PooledConnection.commit(PooledConnection.java:
658)
at
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.testConnection(DataSourcePool.java:
482)
at
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.checkDataSource(DataSourcePool.java:
348)
at
com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.checkDataSource(DataSourceManager.java:
235)
at
com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.access
$100(DataSourceManager.java:38)
at com.avaje.ebeaninternal.server.lib.sql.DataSourceManager
$Checker.run(DataSourceManager.java:248)
at com.avaje.ebeaninternal.server.lib.BackgroundThread
$Runner.runJobs(BackgroundThread.java:206)
at com.avaje.ebeaninternal.server.lib.BackgroundThread
$Runner.run(BackgroundThread.java:170)
at java.lang.Thread.run(Thread.java:619)
Dec 31, 2011 4:43:27 AM
com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue reset
INFO: Reseting DataSourcePool [dip] min:0 max:50 free:0 busy:2 waiting:
0 highWaterMark:2 waitCount:0 hitCount:193
Dec 31, 2011 4:43:27 AM
com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue reset
INFO: Busy Connections:
name[dip.0] startTime[1325306036604] stmt[null] createdBy[null]
name[dip.2] startTime[1325306607764] stmt[null] createdBy[null]

Dec 31, 2011 4:43:27 AM
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool
validateConnection
WARNING: heartbeatsql test failed on connection[dip.2]
Dec 31, 2011 4:43:27 AM
com.avaje.ebeaninternal.server.lib.sql.PooledConnection
closeConnectionFully
INFO: Closing Connection[dip.2] psReuse[0] psCreate[0] psSize[0]
Dec 31, 2011 4:43:39 AM
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool
notifyDataSourceIsUp
SEVERE: RESOLVED FATAL: DataSourcePool [dip] is back up!
Dec 31, 2011 4:43:39 AM
com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue reset
INFO: Reseting DataSourcePool [dip] min:0 max:50 free:0 busy:2 waiting:
0 highWaterMark:2 waitCount:0 hitCount:195
Dec 31, 2011 4:43:39 AM
com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue reset



Dip is one of the schemas. But i just have created the server through
EbeanServerFactory.create(serverConfig), nothing else.

I dont know what could be doing so many sessions to cause maximum
number of sessios. I setted max connection to 50 and max sessions in
database for this schema per machine is setted to 500.

Im not understanding the cause of this.


Thanks

[Rob Bygrave]

>>
INFO: Reseting DataSourcePool [dip] min:0 max:50 free:0 busy:2 waiting: 0 highWaterMark:2 waitCount:0 hitCount:193
<<

In theory your db pool had 2 connections in it. You should look from the oracle side to see what sessions exist.

Cheers, Rob.