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 "Suresh Thalamati (JIRA)" <de...@db.apache.org> on 2006/03/14 21:19:57 UTC
[jira] Created: (DERBY-1113) transaction logs files requried for
recovery are getting deleted when backup and checkpointas are running in
parallel.
transaction logs files requried for recovery are getting deleted when backup and checkpointas are running in parallel.
----------------------------------------------------------------------------------------------------------------------
Key: DERBY-1113
URL: http://issues.apache.org/jira/browse/DERBY-1113
Project: Derby
Type: Bug
Components: Store
Versions: 10.2.0.0
Reporter: Suresh Thalamati
Priority: Critical
----------------------------------------------------------------
2006-03-14 19:45:40.573 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.0.0 alpha - (1): instance c013800d-0109-fa4a-bf58-0000001078a0
on database directory E:\suresht\backuptests\wombat
DEBUG LogTrace OUTPUT: log control file ckp instance = (328,1153619)
DEBUG LogTrace OUTPUT: log control file, was derby.system.durability set to test = false
DEBUG LogTrace OUTPUT: Found checkpoint at (328,1153619) Checkpoint : redoLWM (328,17661)
undoLWM (327,2986503)
**************************
org.apache.derby.impl.store.raw.xact.TransactionTable@1a52fdf
Transaction Table: size = 2 largestUpdateXactId = 59155
Xid=59155 gid=null firstLog=(328,1153581) lastLog=null transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
Xid=59154 gid=null firstLog=(327,3151974) lastLog=(328,1153500) transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
---------------------------
DEBUG LogTrace OUTPUT: E:\suresht\backuptests\wombat\log\log327.dat does not exist
Exception trace:
org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
at org.apache.derby.tools.ij.main(ij.java:60)
------------ BEGIN SHUTDOWN ERROR STACK -------------
ERROR XSLA6: Cannot recover the database.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:1219)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
at org.apache.derby.tools.ij.main(ij.java:60)
============= begin nested exception, level (1) ===========
org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
at org.apache.derby.tools.ij.main(ij.java:60)
============= end nested exception, level (1) ===========
------------ END SHUTDOWN ERROR STACK -------------
2006-03-14 19:45:40.823 GMT:
Shutting down instance c013800d-0109-fa4a-bf58-0000001078a0
----------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1113) transaction logs files requried for
recovery are getting deleted when backup and checkpointas are running in
parallel.
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1113?page=all ]
Mike Matrigali updated DERBY-1113:
----------------------------------
I reviewed and committed this patch to the trunk.
m1_142:67>svn commit
Sending java\engine\org\apache\derby\impl\store\raw\log\LogToFile.java
Transmitting file data .
Committed revision 394981.
> transaction logs files requried for recovery are getting deleted when backup and checkpointas are running in parallel.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1113
> URL: http://issues.apache.org/jira/browse/DERBY-1113
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.2.0.0
> Reporter: Suresh Thalamati
> Assignee: Suresh Thalamati
> Priority: Critical
> Attachments: derby-1113.diff
>
> ----------------------------------------------------------------
> 2006-03-14 19:45:40.573 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.0.0 alpha - (1): instance c013800d-0109-fa4a-bf58-0000001078a0
> on database directory E:\suresht\backuptests\wombat
> DEBUG LogTrace OUTPUT: log control file ckp instance = (328,1153619)
> DEBUG LogTrace OUTPUT: log control file, was derby.system.durability set to test = false
> DEBUG LogTrace OUTPUT: Found checkpoint at (328,1153619) Checkpoint : redoLWM (328,17661)
> undoLWM (327,2986503)
> **************************
> org.apache.derby.impl.store.raw.xact.TransactionTable@1a52fdf
> Transaction Table: size = 2 largestUpdateXactId = 59155
> Xid=59155 gid=null firstLog=(328,1153581) lastLog=null transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> Xid=59154 gid=null firstLog=(327,3151974) lastLog=(328,1153500) transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> ---------------------------
> DEBUG LogTrace OUTPUT: E:\suresht\backuptests\wombat\log\log327.dat does not exist
> Exception trace:
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSLA6: Cannot recover the database.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:1219)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= begin nested exception, level (1) ===========
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= end nested exception, level (1) ===========
> ------------ END SHUTDOWN ERROR STACK -------------
> 2006-03-14 19:45:40.823 GMT:
> Shutting down instance c013800d-0109-fa4a-bf58-0000001078a0
> ----------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-1113) transaction logs files requried for
recovery are getting deleted when backup and checkpointas are running in
parallel.
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1113?page=all ]
Suresh Thalamati resolved DERBY-1113:
-------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
> transaction logs files requried for recovery are getting deleted when backup and checkpointas are running in parallel.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1113
> URL: http://issues.apache.org/jira/browse/DERBY-1113
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.2.0.0
> Reporter: Suresh Thalamati
> Assignee: Suresh Thalamati
> Priority: Critical
> Fix For: 10.2.0.0
> Attachments: derby-1113.diff
>
> ----------------------------------------------------------------
> 2006-03-14 19:45:40.573 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.0.0 alpha - (1): instance c013800d-0109-fa4a-bf58-0000001078a0
> on database directory E:\suresht\backuptests\wombat
> DEBUG LogTrace OUTPUT: log control file ckp instance = (328,1153619)
> DEBUG LogTrace OUTPUT: log control file, was derby.system.durability set to test = false
> DEBUG LogTrace OUTPUT: Found checkpoint at (328,1153619) Checkpoint : redoLWM (328,17661)
> undoLWM (327,2986503)
> **************************
> org.apache.derby.impl.store.raw.xact.TransactionTable@1a52fdf
> Transaction Table: size = 2 largestUpdateXactId = 59155
> Xid=59155 gid=null firstLog=(328,1153581) lastLog=null transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> Xid=59154 gid=null firstLog=(327,3151974) lastLog=(328,1153500) transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> ---------------------------
> DEBUG LogTrace OUTPUT: E:\suresht\backuptests\wombat\log\log327.dat does not exist
> Exception trace:
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSLA6: Cannot recover the database.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:1219)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= begin nested exception, level (1) ===========
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= end nested exception, level (1) ===========
> ------------ END SHUTDOWN ERROR STACK -------------
> 2006-03-14 19:45:40.823 GMT:
> Shutting down instance c013800d-0109-fa4a-bf58-0000001078a0
> ----------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1113) transaction logs files requried for
recovery are getting deleted when backup and checkpointas are running in
parallel.
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1113?page=all ]
Suresh Thalamati reassigned DERBY-1113:
---------------------------------------
Assign To: Suresh Thalamati
> transaction logs files requried for recovery are getting deleted when backup and checkpointas are running in parallel.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1113
> URL: http://issues.apache.org/jira/browse/DERBY-1113
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.2.0.0
> Reporter: Suresh Thalamati
> Assignee: Suresh Thalamati
> Priority: Critical
>
> ----------------------------------------------------------------
> 2006-03-14 19:45:40.573 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.0.0 alpha - (1): instance c013800d-0109-fa4a-bf58-0000001078a0
> on database directory E:\suresht\backuptests\wombat
> DEBUG LogTrace OUTPUT: log control file ckp instance = (328,1153619)
> DEBUG LogTrace OUTPUT: log control file, was derby.system.durability set to test = false
> DEBUG LogTrace OUTPUT: Found checkpoint at (328,1153619) Checkpoint : redoLWM (328,17661)
> undoLWM (327,2986503)
> **************************
> org.apache.derby.impl.store.raw.xact.TransactionTable@1a52fdf
> Transaction Table: size = 2 largestUpdateXactId = 59155
> Xid=59155 gid=null firstLog=(328,1153581) lastLog=null transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> Xid=59154 gid=null firstLog=(327,3151974) lastLog=(328,1153500) transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> ---------------------------
> DEBUG LogTrace OUTPUT: E:\suresht\backuptests\wombat\log\log327.dat does not exist
> Exception trace:
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSLA6: Cannot recover the database.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:1219)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= begin nested exception, level (1) ===========
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= end nested exception, level (1) ===========
> ------------ END SHUTDOWN ERROR STACK -------------
> 2006-03-14 19:45:40.823 GMT:
> Shutting down instance c013800d-0109-fa4a-bf58-0000001078a0
> ----------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1113) transaction logs files requried for
recovery are getting deleted when backup and checkpointas are running in
parallel.
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1113?page=all ]
Suresh Thalamati updated DERBY-1113:
------------------------------------
Attachment: derby-1113.diff
The reason for missing log files is truncation logic at checkpoint was
incorrectly deleting the log files that were needed for crash recovery
if the backup is progress at the same time; The first log file that should
not be deleted was incorrectly assigned to the log file number that is yet
to be written to the backup.
Attached patch changes the logic, so that all the log files that are required for both crash recovery and the backup are not deleted. Basically the first log file that should not be deleted is the lowest of first log needed for crash recovery or the log file that is yet to be copied to the backup.
TESTS: derbyall test suite passed on jdk142/Windows XP.
It would be great if some one can review and commit this patch.
svn stat:
M java\engine\org\apache\derby\impl\store\raw\log\LogToFile.java
> transaction logs files requried for recovery are getting deleted when backup and checkpointas are running in parallel.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1113
> URL: http://issues.apache.org/jira/browse/DERBY-1113
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.2.0.0
> Reporter: Suresh Thalamati
> Assignee: Suresh Thalamati
> Priority: Critical
> Attachments: derby-1113.diff
>
> ----------------------------------------------------------------
> 2006-03-14 19:45:40.573 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby - 10.2.0.0 alpha - (1): instance c013800d-0109-fa4a-bf58-0000001078a0
> on database directory E:\suresht\backuptests\wombat
> DEBUG LogTrace OUTPUT: log control file ckp instance = (328,1153619)
> DEBUG LogTrace OUTPUT: log control file, was derby.system.durability set to test = false
> DEBUG LogTrace OUTPUT: Found checkpoint at (328,1153619) Checkpoint : redoLWM (328,17661)
> undoLWM (327,2986503)
> **************************
> org.apache.derby.impl.store.raw.xact.TransactionTable@1a52fdf
> Transaction Table: size = 2 largestUpdateXactId = 59155
> Xid=59155 gid=null firstLog=(328,1153581) lastLog=null transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> Xid=59154 gid=null firstLog=(327,3151974) lastLog=(328,1153500) transactionStatus=0 myxact=null update=true recovery=true prepare=false needExclusion=true
> ---------------------------
> DEBUG LogTrace OUTPUT: E:\suresht\backuptests\wombat\log\log327.dat does not exist
> Exception trace:
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSLA6: Cannot recover the database.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:304)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:1219)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= begin nested exception, level (1) ===========
> org.apache.derby.iapi.services.sanity.AssertFailure: ASSERT FAILED scan null at (327,2986503)
> at org.apache.derby.iapi.services.sanity.SanityManager.THROWASSERT(SanityManager.java:150)
> at org.apache.derby.impl.store.raw.log.Scan.<init>(Scan.java:141)
> at org.apache.derby.impl.store.raw.log.LogToFile.openForwardsScan(LogToFile.java:2655)
> at org.apache.derby.impl.store.raw.log.LogToFile.recover(LogToFile.java:758)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java:336)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java:987)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java:542)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java:418)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java:738)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java:178)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java:1993)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java:290)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java:1831)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(BaseMonitor.java:1697)
> at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(BaseMonitor.java:1577)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(BaseMonitor.java:990)
> at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Monitor.java:541)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java:1583)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:213)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:72)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:73)
> at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:199)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java:873)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java:723)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java:553)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:289)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java:203)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:169)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:55)
> at org.apache.derby.tools.ij.main(ij.java:60)
> ============= end nested exception, level (1) ===========
> ------------ END SHUTDOWN ERROR STACK -------------
> 2006-03-14 19:45:40.823 GMT:
> Shutting down instance c013800d-0109-fa4a-bf58-0000001078a0
> ----------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira