db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas J. Taylor" <Thomas.Tay...@INFOTECHSoft.com>
Subject Recovering from 'Failed to Start Database'
Date Fri, 01 Feb 2008 17:06:09 GMT
Hello,

I have an 800MB derby database that has suddenly stopped working, giving an
SQLException - "Failed to start database" when started from my code and
SQuirreL (see first stack trace). I get a different error when I try to
start the database through IJ (see second stack trace): "ERROR XSDG3:
Meta-data for Container ...RAFContainer@c8f6f8 could not be accessed"

Does anyone know how I can recover this database?

Thanks in advance.

Thomas Taylor
INFOTECH Soft, Inc.

System Details:
Derby: 10.2.2.0
  O/S: Windows Vista and Windows XP
  JVM: jre 1.6.0-oem-b104 and jre 1.5.0_04

*****************************
BEGIN STACKTRACE FOR SQuirreL
----------------------------------------------------------------
java.sql.SQLException: Failed to start database 'C:/derby-dbs/error-db', see
the next exception for details.
	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.bootDatabase(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.EmbeddedDriver.connect(Unknown Source)
	at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriver
Manager.java:133)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.e
xecute(OpenConnectionCommand.java:97)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$S
heetHandler.run(ConnectToAliasCommand.java:279)
	at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Failed to start database
'C:/derby-dbs/error-db', see the next exception for details.
	at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
	at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossD
RDA(Unknown Source)
	... 17 more



**********************
BEGIN DERBY LOG FOR IJ
----------------------------------------------------------------
2008-02-01 16:48:39.350 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby -
10.2.2.0 - (485682): instance a816c00e-0117-d5e3-b7ee-00000047f408
on database directory C:\derby-dbs\error-db  


------------  BEGIN SHUTDOWN ERROR STACK -------------

ERROR XSDG3: Meta-data for Container
org.apache.derby.impl.store.raw.data.RAFContainer@c8f6f8 could not be
accessed
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown
Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at
org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(Unknown
Source)
	at
org.apache.derby.impl.store.raw.data.FileContainer.setIdent(Unknown Source)
	at
org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown
Source)
	at
org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown
Source)
	at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown
Source)
	at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
	at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unkno
wn Source)
.
.
.
	at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown
Source)
	at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown
Source)
	at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown
Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
============= begin nested exception, level (1) ===========
java.io.EOFException
	at java.io.RandomAccessFile.readFully(Unknown Source)
	at java.io.RandomAccessFile.readFully(Unknown Source)
	at
org.apache.derby.impl.store.raw.data.FileContainer.getEmbryonicPage(Unknown
Source)
	at
org.apache.derby.impl.store.raw.data.FileContainer.readHeader(Unknown
Source)
	at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown
Source)
	at java.security.AccessController.doPrivileged(Native Method)
.
.
.
	at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.apache.derby.impl.tools.ij.ij.dynamicConnection(Unknown
Source)
	at org.apache.derby.impl.tools.ij.ij.ConnectStatement(Unknown
Source)
	at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown
Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
============= end nested exception, level (1) ===========
------------  END SHUTDOWN ERROR STACK -------------


2008-02-01 16:48:39.366 GMT:
Shutting down instance a816c00e-0117-d5e3-b7ee-00000047f408
----------------------------------------------------------------



Mime
View raw message