db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5579) Trigger fails with ERROR XSAI2: The conglomerate (136,048) requested does not exist possibly related to compress
Date Thu, 16 Feb 2012 00:51:11 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Kathey Marsden updated DERBY-5579:

    Affects Version/s:
> Trigger fails with ERROR XSAI2: The conglomerate (136,048) requested does not exist possibly
related to compress
> ----------------------------------------------------------------------------------------------------------------
>                 Key: DERBY-5579
>                 URL: https://issues.apache.org/jira/browse/DERBY-5579
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions:
>         Environment: Derby version: - (1073208) 
> ava.vendor=IBM Corporation
> java.runtime.version=pwi32devifx-20110209 (SR11 FP2 +IZ94331)
> java.fullversion=J2RE 1.5.0 IBM J9 2.3 Windows Server 2003 x86-32 j9vmwi3223ifx-20100511
(JIT enabled)
> J9VM - 20100509_57823_lHdSMr
> JIT  - 20091016_1845ifx7_r8
> GC   - 20091026_AA
>            Reporter: Kathey Marsden
> I do not have a lot of information on this issue but want to get it filed in case someone
sees something in the code that could cause this problem..
> After the user started doing regular compress
> The report was on an error:
> java.sql.SQLException: The conglomerate (136048) requested does not exist.
> 	at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> 	at org.apache.derby.client.am.PreparedStatement.execute(Unknown Source)
> 	at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
> ERROR XSAI2: The conglomerate (136,048) requested does not exist.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
> 	at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
> 	at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
> 	at org.apache.derby.impl.store.access.RAMTransaction.getDynamicCompiledConglomInfo(Unknown
> 	at org.apache.derby.impl.sql.execute.DMLWriteResultSet.<init>(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.<init>(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DeleteResultSet.<init>(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown
> 	at org.apache.derby.exe.acfb160050x0134xa4edxddadx000001381ca0102.fillResultSet(Unknown
> 	at org.apache.derby.exe.acfb160050x0134xa4edxddadx000001381ca0102.execute(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeSubStatement(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.RowTriggerExecutor.fireTrigger(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.UpdateResultSet.fireAfterTriggers(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(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.execute(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
> 	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> The problem statement was tracked to a trigger that had a invalid conglomerate in its
stored plan. Dropping and recreating the triggers resolved the immediate symptoms  at the
user site.  The root cause is thought to be related to some sort of problem with compress
that the trigger stored prepared statements did not get invalidated.
> FYI: There was a prior runtime error (not sure if it was during compress or not).  I
tend to think this one may related to s JVM JIT issue.
> java.sql.SQLException: The heap container with container id Container(-1, 1320304910265)
is closed.
> I don't have a stack trace for that one, but wonder if compress fails, is it possible
that the compression could take place but we don't invalidate the statements.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message