Transaction already associated - Teiid 8.9.0-Alpha1
blaxell Aug 19, 2014 10:19 AMHi,
I run the following statement on teiid 8.9.0-Alpha1.
begin insert into test_tables.target select * from test_tables.source; end
While it is running (source table is quite big), i just run this query again and get the following exception
ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue1610) +Pd1Qn6RePZf TEIID30019 Unexpected exception for request +Pd1Qn6RePZf.604: java.lang.AssertionError: Transaction al ready associated with request. at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.Request.getTransactionContext(Request.java:320) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.Request.createProcessor(Request.java:310) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:439) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:609) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
if the insert statement is not inside an anonymous procedure, it works fine. Also if you wait till the first query has completely finished before starting it again.