db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: XSDB6 Another instance of Derby may have already booted
Date Fri, 24 Oct 2014 20:56:42 GMT
On 10/24/14 1:37 PM, Thomas Hill wrote:
> Hi,
>
> I am getting below error even after the derby server and the server machine
> had been shutdown and brought up again. Might this indicate the data base is
> corrupt? Is ther any way to further diagnose what is going on?
>
> Thanks
>
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ040,
> SQLERRMC: Failed to start database 'PMT' with class loader
> sun.misc.Launcher$AppClassLoader@77cde100, see the next exception for
> details.::SQLSTATE: XSDB6Another instance of Derby may have already booted
> the database /webs/web1540/pmtdata/PMT.
> 	at java.util.concurrent.FutureTask.report(Unknown Source)
> 	at java.util.concurrent.FutureTask.get(Unknown Source)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
> 	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
> 	at java.util.concurrent.FutureTask.run(Unknown Source)
> 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
> 	at java.lang.Thread.run(Unknown Source)
> Caused by: java.lang.RuntimeException: java.sql.SQLException: DERBY SQL
> error: SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database
> 'PMT' with class loader sun.misc.Launcher$AppClassLoader@77cde100, see the
> next exception for details.::SQLSTATE: XSDB6Another instance of Derby may
> have already booted the database /webs/web1540/pmtdata/PMT.
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
> 	... 5 more
> Caused by: java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE:
> XJ040, SQLERRMC: Failed to start database 'PMT' with class loader
> sun.misc.Launcher$AppClassLoader@77cde100, see the next exception for
> details.::SQLSTATE: XSDB6Another instance of Derby may have already booted
> the database /webs/web1540/pmtdata/PMT.
> 	at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> 	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> 	at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
> 	at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.
> getConnection(SQLDriverManager.java:133)
> 	at
> net.sourceforge.squirrel_sql.client.mainframe.action.
> OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
> 	... 7 more
> Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error:
> SQLCODE: -1, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'PMT' with
> class loader sun.misc.Launcher$AppClassLoader@77cde100, see the next
> exception for details.::SQLSTATE: XSDB6Another instance of Derby may have
> already booted the database /webs/web1540/pmtdata/PMT.
> 	at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
> 	at
> org.apache.derby.client.net.NetConnectionReply.
> parseRdbAccessFailed(Unknown
> Source)
> 	at
> org.apache.derby.client.net.NetConnectionReply.
> parseAccessRdbError(Unknown
> Source)
> 	at org.apache.derby.client.net.NetConnectionReply.
> parseACCRDBreply(Unknown
> Source)
> 	at
> org.apache.derby.client.net.NetConnectionReply.
> readAccessDatabase(Unknown
> Source)
> 	at
> org.apache.derby.client.net.NetConnection.
> readSecurityCheckAndAccessRdb(Unknown
> Source)
> 	at
> org.apache.derby.client.net.NetConnection.
> flowSecurityCheckAndAccessRdb(Unknown
> Source)
> 	at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown
> Source)
> 	at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
> 	at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
> 	at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
> 	at
> org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.
> newNetConnection(Unknown
> Source)
> 	... 10 more
>
>
>
Hi Thomas,

This may mean that the server was brought down ungracefully. It may also 
mean that another process really is using the database. You should see 
some files with the file extension ".lck" in the root directory of the 
database. If you are absolutely sure that no other process is accessing 
the database, you can delete those files and try again.

Hope this helps,
-Rick

Mime
View raw message