You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Bassel_kh <bk...@hotmail.com> on 2008/04/07 17:31:01 UTC
Re: Derby crash (urgent)
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-tp16217446p16537506.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by shabz <sh...@sphere.ae>.
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.
Re: Derby crash (urgent)
Posted by shabz <sh...@sphere.ae>.
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-tp16217446p16557276.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.