Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Thu, 16 Feb 2012 00:51:11 +0000 (UTC)
From: "Kathey Marsden (Updated) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1963520584.44144.1329353471147.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <442339202.60828.1327082440946.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (DERBY-5579) Trigger fails with ERROR XSAI2: The
 conglomerate (136,048) requested does not exist possibly related to
 compress
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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: 10.5.3.2
    
> 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: 10.5.3.2
>         Environment: Derby version:  10.5.3.2 - (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 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.getDynamicCompiledConglomInfo(Unknown Source)
> 	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 Source)
> 	at org.apache.derby.exe.acfb160050x0134xa4edxddadx000001381ca0102.fillResultSet(Unknown Source)
> 	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