You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Thomas Feldmann (JIRA)" <de...@db.apache.org> on 2005/12/08 15:41:08 UTC
[jira] Created: (DERBY-749) Currupt Database after high cpu usage
Currupt Database after high cpu usage
-------------------------------------
Key: DERBY-749
URL: http://issues.apache.org/jira/browse/DERBY-749
Project: Derby
Type: Bug
Components: Services
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
Re: [jira] Created: (DERBY-749) Currupt Database after high cpu usage
Posted by Kathey Marsden <km...@sbcglobal.net>.
Suresh Thalamati wrote:
> Following error is interesting :
> java.lang.ClassCastException: org.apache.derby.iapi.store.raw.PageKey
>
> By chance did u change the derby jar files when the system is running
> or are there two versions of derby jars in the classpath ?
I am curious why two derby.jar's might cause a ClassCastException. Stan
mentioned this as well. Does anyone understand why having two versions
of derby.jar in the classpath might cause this exception?
Re: [jira] Created: (DERBY-749) Currupt Database after high cpu usage
Posted by Suresh Thalamati <su...@gmail.com>.
Following error is interesting :
java.lang.ClassCastException: org.apache.derby.iapi.store.raw.PageKey
By chance did u change the derby jar files when the system is running
or are there two versions of derby jars in the classpath ?
Thanks
-suresht
Thomas Feldmann (JIRA) wrote:
> Currupt Database after high cpu usage
> -------------------------------------
>
> Key: DERBY-749
> URL: http://issues.apache.org/jira/browse/DERBY-749
> Project: Derby
> Type: Bug
> Components: Services
> 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
>
>
Re: [jira] Created: (DERBY-749) Currupt Database after high cpu usage
Posted by Mike Matrigali <mi...@sbcglobal.net>.
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?
Thomas Feldmann (JIRA) wrote:
> Currupt Database after high cpu usage
> -------------------------------------
>
> Key: DERBY-749
> URL: http://issues.apache.org/jira/browse/DERBY-749
> Project: Derby
> Type: Bug
> Components: Services
> 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
>
>
[jira] Resolved: (DERBY-749) Corrupt Database after high cpu usage
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-749?page=all ]
Mike Matrigali resolved DERBY-749:
----------------------------------
Resolution: Incomplete
At this point there is not enough information to do anything about this issue.
> 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
[jira] Updated: (DERBY-749) Corrupt Database after high cpu usage
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ 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