Server TroubleShooting
Hi,
If the server has an exception when it comes up. Who is the contact person for troubleshooting, considering the fact we tried the advice written in the troubleshooting manual. This exception prevents any operation on the server. (even login fails). Though this is a general question, Some details on the problem, it seems that the Derby DB is corrupted. (I tried to export it but it failed) Though using a new repository failed. Thanks, David. |
9 answers
On Thu, 22 May 2008 12:38:00 +0000, davida wrote:
Hi, Why don't you post the stack trace here and see if somebody can help you? - Dmitry |
Please use this forum for support.
davida wrote: Hi, |
On Thu, 22 May 2008 12:38:00 +0000, davida wrote: Hi, Why don't you post the stack trace here and see if somebody can help you? - Dmitry Hi, Here are two stack traces 1) Occurs when server is up 2) Occurs when trying to export the DB 1) 23:42:59,984 WARN com.ibm.team.repository - An exception occurred while trying to add some log entries t o the feed com.ibm.team.repository.common.TeamRepositoryException: Failed to create change event for log entry at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:67) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.r unTask(LogChangeEventAppenderTask.java:82) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.execu teTask(AbstractAutoScheduledTask.java:116) at com.ibm.team.repository.service.internal.scheduler.InstrumentedAsynch ronousTask.executeTask(InstrumentedAsynchronousTask.java:63) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRu nner.run(AsynchronousTaskRunner.java:147) at java.lang.Thread.run(Thread.java:801) Caused by: com.ibm.team.repository.common.validation.PropertyConstraintException: Validatio n errors for item: type = ChangeEvent, itemId = Value of attribute "eventDescription" is 32776 bytes, which is greater t han the allowed encoded length of 32768 bytes at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fa ilIfNecessary(RdbRepositoryDataMediator.java:286) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.va lidateItem(RdbRepositoryDataMediator.java:276) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cr eateSimpleItem(RdbRepositoryDataMediator.java:567) at com.ibm.team.repository.service.internal.RepositoryItemService.doCrea teSimpleItem(RepositoryItemService.java:1605) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave SimpleItem(RepositoryItemService.java:1576) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave Item(RepositoryItemService.java:1390) at com.ibm.team.repository.service.internal.RepositoryItemService.access $14(RepositoryItemService.java:1366) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1360) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans action.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr ansaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn Transaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTran saction(TransactionService.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveIt em(RepositoryItemService.java:1357) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy50.saveItem(Unknown Source) at com.ibm.team.repository.service.internal.ComponentRepositoryItemServi ce.saveItem(ComponentRepositoryItemService.java:222) at com.ibm.team.repository.service.internal.ChangeEventService.save(Chan geEventService.java:160) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy53.save(Unknown Source) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:61) ... 5 more 23:43:10,765 WARN com.ibm.team.repository - An exception occurred while trying to add some log entries t o the feed com.ibm.team.repository.common.TeamRepositoryException: Failed to create change event for log entry at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:67) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.r unTask(LogChangeEventAppenderTask.java:82) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.execu teTask(AbstractAutoScheduledTask.java:116) at com.ibm.team.repository.service.internal.scheduler.InstrumentedAsynch ronousTask.executeTask(InstrumentedAsynchronousTask.java:63) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRu nner.run(AsynchronousTaskRunner.java:147) at java.lang.Thread.run(Thread.java:801) Caused by: com.ibm.team.repository.common.validation.PropertyConstraintException: Validatio n errors for item: type = ChangeEvent, itemId = Value of attribute "eventDescription" is 32776 bytes, which is greater t han the allowed encoded length of 32768 bytes at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fa ilIfNecessary(RdbRepositoryDataMediator.java:286) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.va lidateItem(RdbRepositoryDataMediator.java:276) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cr eateSimpleItem(RdbRepositoryDataMediator.java:567) at com.ibm.team.repository.service.internal.RepositoryItemService.doCrea teSimpleItem(RepositoryItemService.java:1605) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave SimpleItem(RepositoryItemService.java:1576) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave Item(RepositoryItemService.java:1390) at com.ibm.team.repository.service.internal.RepositoryItemService.access $14(RepositoryItemService.java:1366) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1360) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans action.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr ansaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn Transaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTran saction(TransactionService.java:77) at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveIt em(RepositoryItemService.java:1357) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy50.saveItem(Unknown Source) at com.ibm.team.repository.service.internal.ComponentRepositoryItemServi ce.saveItem(ComponentRepositoryItemService.java:222) at com.ibm.team.repository.service.internal.ChangeEventService.save(Chan geEventService.java:160) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy53.save(Unknown Source) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:61) ... 5 more 23:44:00,937 WARN com.ibm.team.repository - An exception occurred while trying to add some log entries t o the feed com.ibm.team.repository.common.TeamRepositoryException: Failed to create change event for log entry at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:67) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.r unTask(LogChangeEventAppenderTask.java:82) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.execu teTask(AbstractAutoScheduledTask.java:116) at com.ibm.team.repository.service.internal.scheduler.InstrumentedAsynch ronousTask.executeTask(InstrumentedAsynchronousTask.java:63) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRu nner.run(AsynchronousTaskRunner.java:147) at java.lang.Thread.run(Thread.java:801) Caused by: com.ibm.team.repository.common.validation.PropertyConstraintException: Validatio n errors for item: type = ChangeEvent, itemId = Value of attribute "eventDescription" is 32776 bytes, which is greater t han the allowed encoded length of 32768 bytes at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.fa ilIfNecessary(RdbRepositoryDataMediator.java:286) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.va lidateItem(RdbRepositoryDataMediator.java:276) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cr eateSimpleItem(RdbRepositoryDataMediator.java:567) at com.ibm.team.repository.service.internal.RepositoryItemService.doCrea teSimpleItem(RepositoryItemService.java:1605) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave SimpleItem(RepositoryItemService.java:1576) at com.ibm.team.repository.service.internal.RepositoryItemService.doSave Item(RepositoryItemService.java:1390) at com.ibm.team.repository.service.internal.RepositoryItemService.access $14(RepositoryItemService.java:1366) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1360) at com.ibm.team.repository.service.internal.RepositoryItemService$24.run (RepositoryItemService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans action.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr ansaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runIn Transaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTran saction(TransactionService.java:77) at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy25.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveIt em(RepositoryItemService.java:1357) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy50.saveItem(Unknown Source) at com.ibm.team.repository.service.internal.ComponentRepositoryItemServi ce.saveItem(ComponentRepositoryItemService.java:222) at com.ibm.team.repository.service.internal.ChangeEventService.save(Chan geEventService.java:160) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in voke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac cess$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1. invoke(ExportProxyServiceRecord.java:106) at $Proxy53.save(Unknown Source) at com.ibm.team.repository.service.internal.LogChangeEventAppenderTask.s aveChangeEventsForLogEntries(LogChangeEventAppenderTask.java:61) ... 5 more |
|
2)
2008-05-22 14:22:03,171 Exporting data from the database "repositoryDB" to the file "./export_from_Beta1.tar". 2008-05-22 14:22:03,390 Exception preparing SQL: SELECT UUID FROM REPOSITORY.CONTENT_STORAGE WHERE OWNER_ITEM_UUID = ? AND MODIFIED < ? 2008-05-22 14:22:03,406 The user ADMIN has logged out of the database "repositoryDB". 2008-05-22 14:22:03,406 Internal error com.ibm.team.repository.common.InternalRepositoryException: Internal error at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cleanupUnclaimedContent(RdbRepositoryDataMediator.java:1031) at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanup.doAllPendingItemCleanup(ItemCleanup.java:229) at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService$1.run(ItemCleanupService.java:115) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:218) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:77) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.invoke(ExportProxyServiceRecord.java:106) at $Proxy22.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.dataaccess.delete.ItemCleanupService.completePartialItemDeletions(ItemCleanupService.java:120) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.invoke(ExportProxyServiceRecord.java:106) at $Proxy46.completePartialItemDeletions(Unknown Source) at com.ibm.team.repository.migration.internal.service.AbstractMigrationService.exportRepositoryPartial(AbstractMigrationService.java:187) at com.ibm.team.repository.migration.internal.service.MigrationService.exportRepositoryPartial(MigrationService.java:107) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:324) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:316) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.invoke(ExportProxyServiceRecord.java:106) at $Proxy65.exportRepositoryPartial(Unknown Source) at com.ibm.team.repotools.rcp.internal.ExportApplicationModel.exportData(ExportApplicationModel.java:196) at com.ibm.team.repotools.rcp.internal.ExportApplicationModel.run(ExportApplicationModel.java:262) at com.ibm.team.repotools.rcp.internal.ApplicationModel.run(ApplicationModel.java:399) at com.ibm.team.repotools.rcp.RepositoryToolsApplication.run(RepositoryToolsApplication.java:605) at com.ibm.team.repotools.rcp.RepositoryToolsApplication.start(RepositoryToolsApplication.java:637) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) at org.eclipse.equinox.launcher.Main.main(Main.java:1148) Caused by: java.sql.SQLException: Invalid checksum on Page Page(0,Container(0, 2096)), expected=53,250,794, on-disk version=794,879,553, page dump follows: Hex dump: 00000000: 0076 0000 0001 0000 0000 0000 1ac8 0000 .v.............. 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................ 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................ 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................ ----- omitted due to space limitations ------------ 00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00007ff0: 0000 0000 0000 0000 0000 0000 2f60 e641 ...............A 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.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at com.ibm.team.repository.service.internal.db.jdbcwrappers.ConnectionStatWrapper.prepareStatement(ConnectionStatWrapper.java:276) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ConnectionErrLogWrapper.prepareStatement(ConnectionErrLogWrapper.java:334) at com.ibm.team.repository.service.internal.db.jdbcwrappers.ConnectionLeakWrapper.prepareStatement(ConnectionLeakWrapper.java:226) at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.selectKeys(AbstractBackgroundDeleter.java:224) at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.doIt(AbstractBackgroundDeleter.java:106) at com.ibm.team.repository.service.internal.dataaccess.delete.AbstractBackgroundDeleter.run(AbstractBackgroundDeleter.java:62) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.cleanupUnclaimedContent(RdbRepositoryDataMediator.java:1029) ... 51 more Caused by: ERROR XSDG2: Invalid checksum on Page Page(0,Container(0, 2096)), expected=53,250,794, on-disk version=794,879,553, page dump follows: Hex dump: 00000000: 0076 0000 0001 0000 0000 0000 1ac8 0000 .v.............. 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................ 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................ ---omitted due to space limitations------ 00007fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00007fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................ 00007ff0: 0000 0000 0000 0000 0000 0000 2f60 e641 ...............A at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.data.StoredPage.validateChecksum(Unknown Source) at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(Unknown Source) at org.apache.derby.impl.store.raw.data.AllocPage.initFromData(Unknown Source) at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source) at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source) at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source) at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source) at org.apache.derby.impl.services.cache.Clock.find(Unknown Source) at org.apache.derby.impl.store.raw.data.FileContainer.getAllocPage(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown Source) at org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown Source) at org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown Source) at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown Source) at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source) at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source) at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown Source) at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown Source) at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source) at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 62 more |
|
Are you trying to migrate from Beta1 to Beta3?
avida wrote: 2) |
|
On Sun, 25 May 2008 14:37:59 +0000, davida wrote:
1) Occurs when server is up This is described in workitem 46049 and is fixed in RC2. 2) Occurs when trying to export the DB This is a much more serious problem and seems to indicate DB corruption. Are you sure you brought down the server before running export? |
Are you trying to migrate from Beta1 to Beta3? Not at all. Our jazz server has stopped working suddenly because of the above errors. So I tried to investigate the problem and tried to export the DB. The export didn't work and it seems to have the same problem as the server it self. My thoughts is that somehow the DB is corrupted. I have no idea how to overcome this. It seems we can loose a week work! Thx, David |
David, a couple questions to help debug this:
- what build of RTC are you running? - Other than the truncation errors, is the server running happily? Does the Derby error only occur when you try to export? - Do you stop your app server to run back-ups? Is it possible your backup procedure connected to the Derby DB while it is running? - Can you check the file system for errors? The two most common causes of this kind of exception are low-level I/O problems on the file system, and multiple processes concurrently accessing the DB. I think we could be most helpful if we created a work item to continue the investigation of this problem. Can you open one with a Major severity and address it to the Repository component? If you can attach a derby.log file from the runnning server as well as the export, we can get more details on any possible corruption. Thanks, Scott Rich Jazz Team |
|
I opened a workItem Defect 57329.
I use 0.6M5a. The server is not running at all. (even login from client fails) I attached the files as requested. The file system looks ok to me. David, a couple questions to help debug this: |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.