Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 356190

Summary: Problem selecting expired sessions java.sql.SQLException: Database 'sessions' not found.
Product: [RT] Jetty Reporter: Greg Wilkins <gregw>
Component: serverAssignee: Jan Bartel <janb>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: janb, jetty-inbox, mgorovoy
Version: 7.5.0   
Target Milestone: 7.5.x   
Hardware: PC   
OS: Linux   
Whiteboard:

Description Greg Wilkins CLA 2011-08-30 08:47:03 EDT
This exception is sometimes printed out during tests.  The test does not fail

Running org.eclipse.jetty.server.session.MaxInactiveMigrationTest
2011-08-30 22:44:48.239:INFO:oejs.Server:jetty-7.5.0-SNAPSHOT
2011-08-30 22:44:48.249:INFO:oejsh.ContextHandler:started o.e.j.s.ServletContextHandler{,null}
2011-08-30 22:44:48.251:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:44853 STARTING
2011-08-30 22:44:48.252:INFO:oejs.Server:jetty-7.5.0-SNAPSHOT
2011-08-30 22:44:48.262:INFO:oejsh.ContextHandler:started o.e.j.s.ServletContextHandler{,null}
2011-08-30 22:44:48.264:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:42141 STARTING
2011-08-30 22:44:48.340:INFO:oejsh.ContextHandler:stopped o.e.j.s.ServletContextHandler{,null}
2011-08-30 22:44:48.413:INFO:oejsh.ContextHandler:stopped o.e.j.s.ServletContextHandler{,null}
2011-08-30 22:44:48.603:WARN:oejs.session:Problem selecting expired sessions
java.sql.SQLException: Database 'sessions' not found.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
	at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:207)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.getConnection(JDBCSessionIdManager.java:452)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.scavenge(JDBCSessionIdManager.java:658)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.access$000(JDBCSessionIdManager.java:53)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager$1.run(JDBCSessionIdManager.java:245)
	at java.util.TimerThread.mainLoop(Timer.java:512)
	at java.util.TimerThread.run(Timer.java:462)
Caused by: 
java.sql.SQLException: Database 'sessions' not found.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
	at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:207)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.getConnection(JDBCSessionIdManager.java:452)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.scavenge(JDBCSessionIdManager.java:658)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager.access$000(JDBCSessionIdManager.java:53)
	at org.eclipse.jetty.server.session.JDBCSessionIdManager$1.run(JDBCSessionIdManager.java:245)
	at java.util.TimerThread.mainLoop(Timer.java:512)
	at java.util.TimerThread.run(Timer.java:462)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.492 sec
Running org.eclipse.jetty.server.session.ClientCrossContextSessionTest
2011-08-30 22:44:48.729:INFO:oejs.Server:jetty-7.5.0-SNAPSHOT
2011-08-30 22:44:48.915:INFO:oejsh.ContextHandler:started o.e.j.s.ServletContextHandler{/contextA,null}
2011-08-30 22:44:48.915:INFO:oejsh.ContextHandler:started o.e.j.s.ServletContextHandler{/contextB,null}
Comment 1 Jan Bartel CLA 2011-09-04 23:52:14 EDT
Fixed for 7.5.1.