add more information to the XSDB1:ERROR XSDB1: Unknown page format at page error

• Key: DERBY-3725
• Type: Improvement
• Status: Resolved
• Resolution: Fixed
• Priority: Minor
• Assignee: Mike Matrigali
• Reporter: Mike Matrigali
• Component/s: Store
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.2.0, 10.5.1.1

Description

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) ===========

Comments

[Mike Matrigali]

fix has been applied to trunk, 10.4 branch and 10.3 branch.