PM19268; 7.0.0.9: embedded derby failure during SQL delete processing

Download Description

PM19268 resolves the following problem:

ERROR DESCRIPTION:
Description: While issuing a DELETE operation from application to Derby by way of JDBC, the derby server fails with the 4X0T0 error and fails to commit the transaction.

The exception seen in the Derby log is:

2010-06-30 20:10:08.043 GMT
Thread[WorkManager.wpsDefaultWorkManager :
0,5,main] (XID = 391657), (SESSIONID = 7), (DATABASE =
C:/IBM/WebSphere/portalServer/derby/wpsdb),
(DRDAID =
null), Failed Statement is: DELETE FROM
SESSION.ICMTT_0e00b2cc_6922_4e5e_b65d_8e389223d3a2
ERROR 42X05: Table/View
'SESSION.ICMTT_0E00B2CC_6922_4E5E_B65D_8E389223D3A2' does not
exist. at
org.apache.derby.iapi.error.StandardException.newException(Unkno
wn Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescrip
tor(Unknown Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables
(Unknown Source)
at
org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown
Source)
at
org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Un
known Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Un
known Source)
.
WebSphere log shows:
Caused by: ERROR 40XT0: An internal error was identified by
RawStore
module.
at
org.apache.derby.iapi.error.StandardException.newException(Unkno
wnSource)
at
org.apache.derby.impl.store.raw.xact.Xact.setActiveState(Unknown
Source)
at
org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown
Source)
at org.apache.derby.impl.store.access.heap.Heap.create(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.
createConglomerate(Unknown Source)

LOCAL FIX:
NA

PROBLEM SUMMARY

USERS AFFECTED:
All users of IBM WebSphere Application Server V7.0

PROBLEM DESCRIPTION:
On a DELETE operation from the application to Derby by way of JDBC, the derby server fails with the ERROR 40XT0 on commit

RECOMMENDATION:
None

While issuing a DELETE operation from the application to Derby by way of JDBC, the derby server fails with the error 4X0T0 and fails to commit or rollback the transaction.

The use case that causes this error is : Application creates 3 temporary tables using the the command
"DECLARE GLOBAL TEMPORARY TABLE..." and these temp tables are created as part of their delete where data from other tables is deleted using the entries in these tables. The creation of the temp tables and the delete is contained in the same transaction. When the commit is called on the transaction they run into the issue.

If an XA two phase commit is performed while an GLOBAL TEMPORARY TABLE is active, embedded derby database server might fail with:
XAER_RMERR
Exception in thread "main" javax.transaction.xa.XAException:
An internal error was identified by RawStore module.
at
org.apache.derby.jdbc.EmbedXAResource.wrapInXAException(EmbedXAR
esource.java:820)
at
org.apache.derby.jdbc.EmbedXAResource.commit(EmbedXAResource.jav
a:143)
at ReproXATempTable.tempTableInXA(ReproXATempTable.java:51)
at ReproXATempTable.main(ReproXATempTable.java:14)
..
..
Caused by: ERROR 40XT0: An internal error was identified by
RawStore module.
at
org.apache.derby.iapi.error.StandardException.newException(Unkno
wn Source)
at
org.apache.derby.impl.store.raw.xact.Xact.setActiveState(Unknown
Source)
at
org.apache.derby.impl.store.raw.xact.Xact.addContainer(Unknown
Source)
at org.apache.derby.impl.store.access.heap.Heap.create(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.
createConglomerate(Unknown Source)

PROBLEM CONCLUSION:
This problem is fixed in the Embedded Derby Database server. The fix for this APAR is currently targeted for inclusion in fix pack 7.0.0.13. Refer to the Recommended Updates page for delivery information:
http://www.ibm.com/support/docview.wss?uid=swg27004980