Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 356190 - Problem selecting expired sessions java.sql.SQLException: Database 'sessions' not found.
Summary: Problem selecting expired sessions java.sql.SQLException: Database 'sessions'...
Status: RESOLVED FIXED
Alias: None
Product: Jetty
Classification: RT
Component: server (show other bugs)
Version: 7.5.0   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: 7.5.x   Edit
Assignee: Jan Bartel CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-08-30 08:47 EDT by Greg Wilkins CLA
Modified: 2011-09-04 23:52 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.