On 12/12/14 3:15 AM, Michele Castriotta wrote:
Hi all,
I have a big problem with my database DerbyDB embedded. I have used it
for my Java Application for storage data on it. From three day I
received this error if I try to execute a SELECT, INSERT, DELETE query
on it.
DEBUG
[AWT-EventQueue-0](MyLog4J.java:45)-java.sql.SQLException:Formatopagina sconosciuto
alla pagina Page(51,Container(0,1136)),segue il dump di
pagina:Hexdump:00000000:00000000000000000000000000000000................00000010:00000000000000000000000000000000................00000ff0:00000000000000000000000000000000................at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(UnknownSource)at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(UnknownSource)at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(UnknownSource)at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(UnknownSource)at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(UnknownSource)at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(UnknownSource)at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(UnknownSource)at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(UnknownSource)at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(UnknownSource)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(NativeMethod)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(NativeMethod)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)Causedby:java.sql.SQLException:Formatopagina
sconosciuto alla pagina Page(51,Container(0,1136)),segue il dump di
pagina:Hexdump:00000000:00000000000000000000000000000000................00000010:00000000000000000000000000000000................00000020:00000000000000000000000000000000................00000030:00000000000000000000000000000000................00000040:00000000000000000000000000000000................00000050:00000000000000000000000000000000................00000060:00000000000000000000000000000000................00000ff0:00000000000000000000000000000000................at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(UnknownSource)at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(UnknownSource)...51more
Causedby:ERROR XSDBB:Formatopagina sconosciuto alla pagina
Page(51,Container(0,1136)),segue il dump di
pagina:Hexdump:00000000:00000000000000000000000000000000................00000010:00000000000000000000000000000000................00000020:00000000000000000000000000000000................00000030:00000000000000000000000000000000................00000040:00000000000000000000000000000000................00000050:00000000000000000000000000000000................00000920:00000000000000000000000000000000................00000930:00000000000000000000000000000000................00000940:00000000000000000000000000000000................00000950:00000000000000000000000000000000................00000960:00000000000000000000000000000000................00000970:00000000000000000000000000000000................00000980:00000000000000000000000000000000................00000990:00000000000000000000000000000000................000009a0:00000000000000000000000000000000................000009b0:00000000000000000000000000000000................000009c0:00000000000000000000000000000000................000009d0:00000000000000000000000000000000................000009e0:00000000000000000000000000000000................000009f0:00000000000000000000000000000000................00000a00:00000000000000000000000000000000................00000a10:00000000000000000000000000000000................00000a20:00000000000000000000000000000000................00000a30:00000000000000000000000000000000................00000a40:00000000000000000000000000000000................00000a50:00000000000000000000000000000000................00000a60:00000000000000000000000000000000................00000a70:00000000000000000000000000000000................00000a80:00000000000000000000000000000000................00000a90:00000000000000000000000000000000................00000aa0:00000000000000000000000000000000................00000ab0:00000000000000000000000000000000................00000ac0:00000000000000000000000000000000................00000ad0:00000000000000000000000000000000................00000ae0:00000000000000000000000000000000................00000af0:00000000000000000000000000000000................00000b00:00000000000000000000000000000000................00000b10:00000000000000000000000000000000................00000b20:00000000000000000000000000000000................00000b30:00000000000000000000000000000000................00000b40:00000000000000000000000000000000................00000b50:00000000000000000000000000000000................00000b60:00000000000000000000000000000000................00000b70:00000000000000000000000000000000................00000b80:00000000000000000000000000000000................00000b90:00000000000000000000000000000000................00000ba0:00000000000000000000000000000000................00000bb0:00000000000000000000000000000000................00000bc0:00000000000000000000000000000000................00000bd0:00000000000000000000000000000000................00000be0:00000000000000000000000000000000................00000bf0:00000000000000000000000000000000................00000c00:00000000000000000000000000000000................00000c10:00000000000000000000000000000000................00000c20:00000000000000000000000000000000................00000f70:00000000000000000000000000000000................00000f80:00000000000000000000000000000000................00000f90:00000000000000000000000000000000................00000fa0:00000000000000000000000000000000................00000fb0:00000000000000000000000000000000................00000fc0:00000000000000000000000000000000................00000fd0:00000000000000000000000000000000................00000fe0:00000000000000000000000000000000................00000ff0:00000000000000000000000000000000................at
org.apache.derby.iapi.error.StandardException.newException(UnknownSource)at
org.apache.derby.impl.store.raw.data.CachedPage.changeInstanceTo(UnknownSource)at
org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(UnknownSource)at
org.apache.derby.impl.services.cache.ConcurrentCache.find(UnknownSource)at
org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(UnknownSource)at
org.apache.derby.impl.store.raw.data.FileContainer.getNextHeadPage(UnknownSource)at
org.apache.derby.impl.store.raw.data.BaseContainer.getNextPage(UnknownSource)at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.getNextPage(UnknownSource)at
org.apache.derby.impl.store.access.conglomerate.GenericScanController.positionAtNextPage(UnknownSource)at
org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(UnknownSource)at
org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(UnknownSource)at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(UnknownSource)at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(UnknownSource)at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(UnknownSource)at
org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(UnknownSource)at
org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(UnknownSource)at
org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(UnknownSource)at
org.apache.derby.impl.sql.execute.SortResultSet.openCore(UnknownSource)at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(UnknownSource)at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(UnknownSource)at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(UnknownSource)...45more
I think that my database is corrupted. There is a mode for recover the
data?
Best reguards
Michele Castriotta
CEL: 340-0963483
http://www.mikelecastriotta.altervista.org
Skype: michele.castriotta87
Hi Michele,
The following web page lists some techniques for analyzing and repairing
corrupt databases: https://wiki.apache.org/db-derby/DatabaseCorruption.
In addition, you should check out the troubleshooting tips listed at
https://issues.apache.org/jira/browse/DERBY-6425?focusedCommentId=13837695&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13837695
Hope this helps,
-Rick
