[DERBY-4735] prepare of an XA read only transaction with a declared global temporary table gets and ASSERT in SANE mode.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.7.1.1
• Component/s: JDBC
• Labels: derby_triage10_8
• Urgency: Low
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Mike Matrigali
• Created: 07/Jul/10 00:22
• Updated: 16/Feb/11 14:39

Description

An ASSERT while attempting to do a prepare on a readonly XA transaction that has done
work with an a declare global temporary table.

java ReproXATempTableAssert
ot 1rows from session.t1 before commit
Exception in thread "main" org.apache.derby.shared.common.sanity.AssertFailure:
ASSERT FAILED real connection should have been idle at this point
at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityMana
er.java:120)
at org.apache.derby.jdbc.EmbedXAResource.prepare(EmbedXAResource.java:29
)
at ReproXATempTableAssert.tempTableInXA(ReproXATEmpTableAssert.java:54)
at ReproXATempTableAssert.main(ReproXATEmpTableAssert.java:14)
--------------
tack traces for all live threads:
[snip thread dump]

Issue Links

• is related to: DERBY-4731 XA two phase commit with active GLOBAL TEMPORARY TABLE causes An internal error identified by RawStore module