db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rohnny Moland" <rmol...@gmail.com>
Subject Recovery of derby databases
Date Thu, 24 Jul 2008 13:37:33 GMT
Hello,

We have an embedded derby database, which seems to have been corrupted
in some way after a windows crash. So, the db file structure seems to
be right - one seg0 directory containing  alot of *.dat files and a
log directory containg log1.dat, log.ctrl and logmirror.ctrl. No *.lck
files.

When trying to connect to the db via squirrelsql we get this exception:

Caused by: java.sql.SQLException: The conglomerate (16) requested does
not exist.
	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.generateCsSQLException(Unknown Source)
	... 12 more
Caused by: ERROR XSAI2: The conglomerate (16) requested does not exist.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
Source)
	at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
	at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
	at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.openScan(Unknown
Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.readDbProperties(Unknown
Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.getCachedDbProperties(Unknown
Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.getCachedProperty(Unknown
Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.getProperty(Unknown
Source)
	at org.apache.derby.impl.store.access.PC_XenaVersion.upgradeIfNeeded(Unknown
Source)
	at org.apache.derby.impl.store.access.PropertyConglomerate.<init>(Unknown
Source)
	at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
	at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
	at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
	at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
Source)
	at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown

I am looking for tools etc about how to repair a corrupt derby
database. I know taking backup often is a good alternative. ;-)

Kind regards,
Rohnny

Mime
View raw message