Actually, I removed C3P0 totally, and upgraded derby to 10.4, the new
Exception occured:
2008-06-11 10:50:37.997 GMT Thread[Worker-60,5,main] (XID = 825230855),
(SESSIONID = 29), (DATABASE = db/networkManager), (DRDAID = null), Cleanup
action starting
2008-06-11 10:50:37.997 GMT Thread[Worker-60,5,main] (XID = 825230855),
(SESSIONID = 29), (DATABASE = db/networkManager), (DRDAID = null), Failed
Statement is: select monitor.status as status , count(monitor.status) as
statusCount , sum (monitor.metthresholdtimes) as thresholdTimes from
NetworkManager.ACTIVE_MONITOR as monitor where monitor.col1 <> 'Yes' group
by monitor.status
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at
org.apache.derby.impl.store.raw.data.AllocPage.ReadContainerInfo(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.readHeader(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at
org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
Source)
at
org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
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.custom.CustomLoader.list(CustomLoader.java:109)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1475)
at
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:121)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:168)
I got tired of using Derby, It is not that professional, and still not
stable!!
I don’t know how they included it in Java 6!!!
Also new bug came today: Inconsistent index!!
I think Derby 100.100 will be stable, isn’t it?
Kristian Waagan-4 wrote:
>
> Bassel_kh skrev:
>> Guys,
>> I'm still waiting for any reply..
>>
>
> You wrote that removing c3p0 reduced the frequency of the corruption. Is
> it just reduced, or has it gone away completely?
> If it still happens, are you getting the same stack trace?
> Is the corruption still on page 0?
>
> If you have have possibility to try out the latest release candidate for
> 10.4, I would suggest doing that. A fix went in for a possibly related
> bug, where page 0 was corrupted.
>
>
> --
> Kristian
>
>> kindly help me :(
>>
>
>
>
--
View this message in context:
http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p17778534.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
