I removed c3p0, now its working good. shabz wrote: > > Hi, > > I am also facing same issue. I tried disabling the disk cache also, but > still the same problem. > > > > Bassel_kh wrote: >> >> 1- SYSINFO : >> Java Version : 1.5.0_11-b03 >> os version : 5.1 Windows XP >> For derby, I'm using *10.3.2* >> 2- I'm not be able to restore from the corrupted database, the full trace >> is: >> >> --------------------------------------------------------------- >> 2008-04-07 14:41:59.109 GMT: >> Booting Derby version The Apache Software Foundation - Apache Derby - >> 10.3.2.1 - (599110): instance c013800d-0119-2956-0e45-000000162900 >> on database directory >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena >> >> >> >> 2008-04-07 14:41:59.297 GMT: >> Shutting down instance c013800d-0119-2956-0e45-000000162900 >> ---------------------------------------------------------------- >> 2008-04-07 14:41:59.484 GMT Thread[ModalContext,6,main] Cleanup action >> starting >> java.sql.SQLException: Failed to start database >> 'C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena', >> see the next exception for details. >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >> Source) >> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) >> at org.apache.derby.impl.jdbc.Util.seeNextException(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.jdbc.Driver30.getNewEmbedConnection(Unknown Source) >> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) >> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127) >> at >> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897) >> at >> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) >> Caused by: java.sql.SQLException: Error copying file (during backup) from >> C:\Documents and Settings\bassel\Desktop\Rafi >> test\db\Arena\BACKUP.HISTORY to >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY. >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >> Source) >> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >> Source) >> ... 10 more >> Caused by: ERROR XSRS5: Error copying file (during backup) from >> C:\Documents and Settings\bassel\Desktop\Rafi >> test\db\Arena\BACKUP.HISTORY to >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY. >> at org.apache.derby.iapi.error.StandardException.newException(Unknown >> Source) >> at >> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown >> Source) >> at org.apache.derby.impl.store.raw.RawStore.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.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 >> Source) >> ... 10 more >> ============= begin nested exception, level (1) =========== >> java.sql.SQLException: Error copying file (during backup) from >> C:\Documents and Settings\bassel\Desktop\Rafi >> test\db\Arena\BACKUP.HISTORY to >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY. >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown >> Source) >> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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.jdbc.Driver30.getNewEmbedConnection(Unknown Source) >> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) >> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127) >> at >> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897) >> at >> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) >> Caused by: ERROR XSRS5: Error copying file (during backup) from >> C:\Documents and Settings\bassel\Desktop\Rafi >> test\db\Arena\BACKUP.HISTORY to >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY. >> at org.apache.derby.iapi.error.StandardException.newException(Unknown >> Source) >> at >> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown >> Source) >> at org.apache.derby.impl.store.raw.RawStore.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.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 >> Source) >> ... 10 more >> ============= end nested exception, level (1) =========== >> ============= begin nested exception, level (2) =========== >> ERROR XSRS5: Error copying file (during backup) from C:\Documents and >> Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to >> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY. >> at org.apache.derby.iapi.error.StandardException.newException(Unknown >> Source) >> at >> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown >> Source) >> at org.apache.derby.impl.store.raw.RawStore.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.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 >> 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.jdbc.Driver30.getNewEmbedConnection(Unknown Source) >> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) >> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185) >> at >> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127) >> at >> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897) >> at >> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113) >> ============= end nested exception, level (2) =========== >> Cleanup action completed >> >> >> I'll tell you what also did: >> >> - As I know, as soon as the all the database connections got closed, >> derby is automatically shutdown, but even though, I created a shutdown >> Hook in order to regularly shutdown the database to avoid any alive >> transaction or resource, and now derby is regularly shutdown. >> >> - I also read about durability and IO flushing problem, so because of >> that, I’m doing check point before closing the database, by calling >> SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE(), to make sure that all cached data >> are already flushed to the disk, I can't do more!! >> >> - I’m using Hibernate 3.1.rc3 as an entity library, I’m not talking to >> derby directly, I thought that Hibernate is keeping some derby resources >> alive, so before shutdown derby, I’m cleaning up the hibernate sessions & >> connections >> I did debugging on that and I could open the database using cloudscape >> after a regular shutdown, means I’m 100% sure that the database has a >> quite regular shutdown and there is no resources still there. >> >> >> - The problem is not happing al the times, it happens in two different >> cases: >> A. When I’m trying to do online backup (the db size is only 3 MB !!) >> B. When I restart my Application’s service (I’m using java service >> wrapper for doing this), you can check it out: >> http://wrapper.tanukisoftware.org/doc/english/introduction.html >> >> >> - OS & hardware: >> I checked it on: >> • Windows XP professional edition SP 2 , with 2 GB RAM, HP dx6120 >> , Pentium 4, CPU 3.2 GHz >> • I also checked it on a server, HP ML370, Windows Server 2003. >> >> Note: >> I've created another build with (H2) database, it is working fine for me, >> but I don’t want to replace such a good database like Derby at any >> reason, but our deployment is stooping till we sort this problem out, >> >> So Kindly advice, >> >> >> Best regards >> >> >> >> > >
-- View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16585356.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
