[
https://issues.apache.org/jira/browse/DERBY-6782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244699#comment-14244699
]
Mike Matrigali commented on DERBY-6782:
---------------------------------------
from the posted information it does look like that table is corrupt. It seems
to have
all 0's which is not a valid page for derby.
The only supported recovery option for an error of this type is to recover from
a derby
backup. If you are not maintaining derby backups maybe the following link will
help:
https://wiki.apache.org/db-derby/DatabaseCorruption
It has information about running a consistency checker to show which tables
have
problems.
can you post information about your environment, ie. derby version, OS version,
JVM version,
are you using write cache enabled on your disk/filesystem? Do you run derby
compress?
> Unknown page format at page Page(51,Container(0, 1136))
> -------------------------------------------------------
>
> Key: DERBY-6782
> URL: https://issues.apache.org/jira/browse/DERBY-6782
> Project: Derby
> Issue Type: Bug
> Reporter: Michele
>
> Hi, from three days I have this error when I try to execute a simple query on
> all table of my database. The error message is this:
> DEBUG [AWT-EventQueue-0] (MyLog4J.java:45) - java.sql.SQLException: Formato
> pagina sconosciuto alla pagina Page(51,Container(0, 1136)), segue il dump di
> pagina: Hex dump:
> 00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.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 esempio.Visualizzazioni.estraiMesiEAnno(Visualizzazioni.java:286)
> at
> com.mcsolution.easyMgmt.Amministrazione.AbstractAmministrazione.settaVariabiliComuni(AbstractAmministrazione.java:108)
> at
> com.mcsolution.easyMgmt.Amministrazione.PanelAmministrazione.creaSwing(PanelAmministrazione.java:102)
> at esp.TestaFrame$MenuLookDemo22$7.actionPerformed(TestaFrame.java:358)
> at
> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
> at
> javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
> at
> javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
> at
> javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
> at
> javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
> at java.awt.Component.processMouseEvent(Component.java:6297)
> at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
> at java.awt.Component.processEvent(Component.java:6062)
> at java.awt.Container.processEvent(Container.java:2039)
> at java.awt.Component.dispatchEventImpl(Component.java:4660)
> at java.awt.Container.dispatchEventImpl(Container.java:2097)
> at java.awt.Component.dispatchEvent(Component.java:4488)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
> at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
> at java.awt.Container.dispatchEventImpl(Container.java:2083)
> at java.awt.Window.dispatchEventImpl(Window.java:2489)
> at java.awt.Component.dispatchEvent(Component.java:4488)
> at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:674)
> at java.awt.EventQueue.access$400(EventQueue.java:81)
> at java.awt.EventQueue$2.run(EventQueue.java:633)
> at java.awt.EventQueue$2.run(EventQueue.java:631)
> at java.security.AccessController.doPrivileged(Native Method)
> at
> java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
> at
> java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
> at java.awt.EventQueue$3.run(EventQueue.java:647)
> at java.awt.EventQueue$3.run(EventQueue.java:645)
> at java.security.AccessController.doPrivileged(Native Method)
> at
> java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:644)
> at
> java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
> at
> java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
> at
> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
> Caused by: java.sql.SQLException: Formato pagina sconosciuto alla pagina
> Page(51,Container(0, 1136)), segue il dump di pagina: Hex dump:
> 00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000040: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000060: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: ERROR XSDBB: Formato pagina sconosciuto alla pagina
> Page(51,Container(0, 1136)), segue il dump di pagina: Hex dump:
> 00000000: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000010: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000020: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000030: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000040: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000920: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000930: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000940: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000950: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000960: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000970: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000980: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000990: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009c0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009d0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009e0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000009f0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a00: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a10: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a20: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a30: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a40: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a50: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a60: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000a90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000aa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ab0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ac0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ad0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ae0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000af0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b00: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b10: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b20: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b30: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b40: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b50: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b60: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000b90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ba0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000bb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000bc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000bd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000be0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000bf0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000c00: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000c10: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000c20: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000f70: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000f80: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000f90: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000fa0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000fb0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000fc0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000fd0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000fe0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000ff0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 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.ProjectRestrictResultSet.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.executeStmt(Unknown
> Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> ... 45 more
> Can we help me?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
