Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 98438105BF for ; Fri, 12 Dec 2014 20:07:13 +0000 (UTC) Received: (qmail 87837 invoked by uid 500); 12 Dec 2014 20:07:13 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 87797 invoked by uid 500); 12 Dec 2014 20:07:13 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 87756 invoked by uid 99); 12 Dec 2014 20:07:13 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Dec 2014 20:07:13 +0000 Date: Fri, 12 Dec 2014 20:07:13 +0000 (UTC) From: "Mike Matrigali (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-6782) Unknown page format at page Page(51,Container(0, 1136)) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)