db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Created: (DERBY-749) Currupt Database after high cpu usage
Date Thu, 08 Dec 2005 17:37:09 GMT
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
> 
> 


Mime
View raw message