[
https://issues.apache.org/jira/browse/DERBY-3725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13046582#comment-13046582
]
Jayaprakash Kumar commented on DERBY-3725:
------------------------------------------
Mike,
Below is the derby.log
Apache Derby Network Server - 10.4.1.3 - (648739) started and ready to accept
connections on port 1527 at 2011-06-09 13:52:55.780 GMT
----------------------------------------------------------------
2011-06-09 13:53:10.483 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.4.1.3
- (648739): instance a816c00e-0130-74ad-5909-fffffe3e043d
on database directory C:\DB\DBDIMB\Database\mbcdb
Database Class Loader started - derby.database.classpath=''
2011-06-09 14:02:10.527 GMT Thread[DRDAConnThread_4,5,main] (XID = 821264864),
(SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID =
NF000001.G4EA-4197072070104639719{2}), Cleanup action starting
2011-06-09 14:02:10.527 GMT Thread[DRDAConnThread_4,5,main] (XID = 821264864),
(SESSIONID = 1), (DATABASE = C:/DB/DBDIMB/Database/mbcdb), (DRDAID =
NF000001.G4EA-4197072070104639719{2}), Failed Statement is: CALL
SYSCS_UTIL.SYSCS_BACKUP_DATABASE('C:\DatabaseBackup')
ERROR XSDB1: Unknown page format at page Page(194123,Container(0, 1217))
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.FileContainer.getLatchedPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.RAFContainer.privBackupContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at
org.apache.derby.impl.store.raw.data.RAFContainer.backupContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.backupContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.backupDataFiles(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.backup(Unknown
Source)
at org.apache.derby.impl.db.BasicDatabase.backup(Unknown Source)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_BACKUP_DATABASE(Unknown Source)
at
org.apache.derby.exe.ac48d7402ax0130x74adx5909xfffffe3e043d0.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Caused by: ERROR XBM0U: No class was registered for identifier 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown
Source)
at
org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown
Source)
... 31 more
============= begin nested exception, level (1) ===========
ERROR XBM0U: No class was registered for identifier 0.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown
Source)
at
org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown Source)
at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.FileContainer.getLatchedPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.RAFContainer.privBackupContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at
org.apache.derby.impl.store.raw.data.RAFContainer.backupContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.backupContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.backupDataFiles(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.raw.RawStore.backup(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.backup(Unknown
Source)
at org.apache.derby.impl.db.BasicDatabase.backup(Unknown Source)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_BACKUP_DATABASE(Unknown Source)
at
org.apache.derby.exe.ac48d7402ax0130x74adx5909xfffffe3e043d0.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
============= end nested exception, level (1) ===========
2011-06-09 14:02:10.699 GMT:
Shutting down instance a816c00e-0130-74ad-5909-fffffe3e043d
----------------------------------------------------------------
Cleanup action completed
> add more information to the XSDB1:ERROR XSDB1: Unknown page format at page
> error
> ---------------------------------------------------------------------------------
>
> Key: DERBY-3725
> URL: https://issues.apache.org/jira/browse/DERBY-3725
> Project: Derby
> Issue Type: Improvement
> Components: Store
> Affects Versions: 10.4.1.3
> Reporter: Mike Matrigali
> Assignee: Mike Matrigali
> Priority: Minor
> Fix For: 10.4.2.0, 10.5.1.1
>
>
> A likely cause of this error is some sort of page level corruption which has
> corrupted the format id field of the page itself. Some more information
> about the data on the page may help diagnose what is going on - for instance
> a page dump may give some insight.
> ERROR XSDB1: Unknown page format at page Page(122,Container(0, 1248))
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getNextHeadPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.BaseContainer.getNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericScanController.positionAtNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown
> Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown
> Source)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
> at org.hibernate.loader.Loader.doList(Loader.java:2147)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
> at org.hibernate.loader.Loader.list(Loader.java:2021)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
> at
> ae.sphere.arena.networkManager.db.dao.SyslogDAO.getAllSyslogSortedByDate(SyslogDAO.java:40)
> at
> ae.sphere.arena.networkManager.server.syslog.dataPurging.SyslogHistoryPurgerManager.purge(SyslogHistoryPurgerManager.java:35)
> at
> ae.sphere.arena.networkManager.db.DbPurger$DataPurgerJob.run(DbPurger.java:41)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
> Caused by: ERROR XBM0U: No class was registered for identifier 23364.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown
> Source)
> ... 37 more
> ============= begin nested exception, level (1) ===========
> ERROR XBM0U: No class was registered for identifier 23364.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.classFromIdentifier(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.newInstanceFromIdentifier(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.newInstanceFromIdentifier(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getNextHeadPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.BaseContainer.getNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericScanController.positionAtNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown
> Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown
> Source)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
> at org.hibernate.loader.Loader.doList(Loader.java:2147)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
> at org.hibernate.loader.Loader.list(Loader.java:2021)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
> at
> ae.sphere.arena.networkManager.db.dao.SyslogDAO.getAllSyslogSortedByDate(SyslogDAO.java:40)
> at
> ae.sphere.arena.networkManager.server.syslog.dataPurging.SyslogHistoryPurgerManager.purge(SyslogHistoryPurgerManager.java:35)
> at
> ae.sphere.arena.networkManager.db.DbPurger$DataPurgerJob.run(DbPurger.java:41)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
> ============= end nested exception, level (1) ===========
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
