[ http://issues.apache.org/jira/browse/DERBY-749?page=all ]
Mike Matrigali updated DERBY-749:
---------------------------------
Component: Store
(was: Services)
Summary: Corrupt Database after high cpu usage (was: Currupt Database
after high cpu usage)
I asked for some more info on the list, have not heard anything back:
What happens when you stop all processes and then start up again and
try to access the database? Just to verify, is that a complete
derby.log from when the error happened?
If you can access the database after starting again, what happens when
you run check table on the WORKTAB table?
What type of media is the database on? (ide, scsi, flash drive?)
Are you seeing any errors from the media that the disk is on?
If the db is corrupt after restarting, will it be possible to attach
the database to the JIRA?
> Corrupt Database after high cpu usage
> -------------------------------------
>
> Key: DERBY-749
> URL: http://issues.apache.org/jira/browse/DERBY-749
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.1.2.1
> Environment: Sun Java 1.5.0_06, Windows 2000, Derby 10.1.2.1, Hibernate
> 3.1rc3, IBM DB2 JDBC Universal Driver Architecture 2.6.80
> Reporter: Thomas Feldmann
> Priority: Critical
>
> We are connect with the internal JDBC Driver. We are using the Network Server
> only for debuging.
> The application was working for hours on 100% cpu usage.
> After the stop and start of the application we are getting the follwing error.
> No access to the database is posible.
> derby.log
> Server is ready to accept connections on port 9000.
> ----------------------------------------------------------------
> 2005-12-08 13:55:29.171 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby -
> 10.1.2.1 - (330608): instance c013800d-0108-0aa7-b496-000000000c7e
> on database directory C:\MTDecs\db\mtdecsDB
> Database Class Loader started - derby.database.classpath=''
> ------------ BEGIN SHUTDOWN ERROR STACK -------------
> ERROR XSDB0: Unexpected exception on in-memory page null
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)
> at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.doInsert(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.insertAndFetchLocation(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.InsertResultSet.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.executeUpdate(Unknown
> Source)
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> at
> org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2061)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2426)
> at
> org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:908)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:344)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> at com.swissbyte.decs.db.dao.WorktabDAO.put(WorktabDAO.java:222)
> at com.swissbyte.decs.Decs.generateHeartBeat(Decs.java:819)
> at com.swissbyte.decs.Decs.workLoop(Decs.java:383)
> at
> com.swissbyte.tools.threads.CHBMainThread.start(CHBMainThread.java:63)
> at com.swissbyte.decs.Decs.start(Decs.java:262)
> at com.swissbyte.decscust.mt.MTDecs.main(MTDecs.java:83)
> at com.swissbyte.decscust.mt.MTDecsService.main(MTDecsService.java:44)
> 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.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
> at java.lang.Thread.run(Unknown Source)
> ------------ END SHUTDOWN ERROR STACK -------------
> 2005-12-08 13:55:35.734 GMT Thread[WrapperStartStopAppMain,5,main] (XID =
> 188859908), (SESSIONID = 10), (DATABASE = mtdecsDB), (DRDAID = null), Cleanup
> action starting
> 2005-12-08 13:55:35.734 GMT Thread[WrapperStartStopAppMain,5,main] (XID =
> 188859908), (SESSIONID = 10), (DATABASE = mtdecsDB), (DRDAID = null), Failed
> Statement is: insert into WORKTAB (DECSID, ORIGINID, PRIORITY, EVENT_TS,
> DATACLASS, XDATA, CLIENT, QUEUE, DATAID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
> ERROR XSDB0: Unexpected exception on in-memory page null
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.initSlotTable(Unknown Source)
> at org.apache.derby.impl.store.raw.data.StoredPage.initFromData(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.doInsert(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapController.insertAndFetchLocation(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.InsertResultSet.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.executeUpdate(Unknown
> Source)
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> at
> org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2061)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2426)
> at
> org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:908)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:344)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> at com.swissbyte.decs.db.dao.WorktabDAO.put(WorktabDAO.java:222)
> at com.swissbyte.decs.Decs.generateHeartBeat(Decs.java:819)
> at com.swissbyte.decs.Decs.workLoop(Decs.java:383)
> at
> com.swissbyte.tools.threads.CHBMainThread.start(CHBMainThread.java:63)
> at com.swissbyte.decs.Decs.start(Decs.java:262)
> at com.swissbyte.decscust.mt.MTDecs.main(MTDecs.java:83)
> at com.swissbyte.decscust.mt.MTDecsService.main(MTDecsService.java:44)
> 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.tanukisoftware.wrapper.WrapperStartStopApp.run(WrapperStartStopApp.java:159)
> at java.lang.Thread.run(Unknown Source)
> 2005-12-08 13:55:35.734 GMT Thread[IC02,5,main] (XID = 188859899), (SESSIONID
> = 5), (DATABASE = mtdecsDB), (DRDAID = null), Cleanup action starting
> 2005-12-08 13:55:35.734 GMT Thread[IC02,5,main] (XID = 188859899), (SESSIONID
> = 5), (DATABASE = mtdecsDB), (DRDAID = null), Failed Statement is: select
> this_.CLIENT as CLIENT14_0_, this_.QUEUE as QUEUE14_0_, this_.DATAID as
> DATAID14_0_, this_.DECSID as DECSID14_0_, this_.ORIGINID as ORIGINID14_0_,
> this_.PRIORITY as PRIORITY14_0_, this_.EVENT_TS as EVENT7_14_0_,
> this_.DATACLASS as DATACLASS14_0_, this_.XDATA as XDATA14_0_ from WORKTAB
> this_ where this_.QUEUE=? order by this_.PRIORITY desc, this_.EVENT_TS asc
> java.lang.ClassCastException: org.apache.derby.iapi.store.raw.PageKey
> at
> org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.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.ProjectRestrictResultSet.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
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
> 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.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1375)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:298)
> at
> com.swissbyte.decs.db.dao.WorktabDAO.getNextEventList(WorktabDAO.java:94)
> at com.swissbyte.decs.work.WorkThread.work(WorkThread.java:96)
> at
> com.swissbyte.decs.tools.DecsThreadAbstract.run(DecsThreadAbstract.java:107)
> 2005-12-08 13:55:35.734 GMT Thread[WP00,5,main] (XID = 188859898), (SESSIONID
> = 3), (DATABASE = mtdecsDB), (DRDAID = null), Cleanup action starting
> 2005-12-08 13:55:35.734 GMT Thread[WP00,5,main] (XID = 188859898), (SESSIONID
> = 3), (DATABASE = mtdecsDB), (DRDAID = null), Failed Statement is: select
> this_.CLIENT as CLIENT14_0_, this_.QUEUE as QUEUE14_0_, this_.DATAID as
> DATAID14_0_, this_.DECSID as DECSID14_0_, this_.ORIGINID as ORIGINID14_0_,
> this_.PRIORITY as PRIORITY14_0_, this_.EVENT_TS as EVENT7_14_0_,
> this_.DATACLASS as DATACLASS14_0_, this_.XDATA as XDATA14_0_ from WORKTAB
> this_ where this_.QUEUE=? order by this_.PRIORITY desc, this_.EVENT_TS asc
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
