]
Steven Hawkins commented on TEIID-4303:
---------------------------------------
The exception reported is "'TEIID30223 javax.transaction.RollbackException:
ARJUNA016083: Can't register synchronization because the transaction is in aborted
state'" which means that the transaction had already been aborted by the time
that the temp table logic was trying to enlist itself. Are there any other logs or
indications of why the transaction has already been aborted?
Insert into temporary table fails
---------------------------------
Key: TEIID-4303
URL:
https://issues.jboss.org/browse/TEIID-4303
Project: Teiid
Issue Type: Bug
Affects Versions: 9.0
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Attachments: debugplan.txt
When executing a insert query in a temporary table the execution fails with the following
error:
2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed execution
2016-06-28 08:54:35,700 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 3bZw8VxEr4t7.26.4.30 Closed connection
2016-06-28 08:54:35,700 DEBUG [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 END SRC COMMAND: endTime=2016-06-28 08:54:35.7
requestID=3bZw8VxEr4t7.26 sourceCommandID=4 executionID=30
txID=TransactionImple < ac, BasicAction: 0:ffff7f000101:2f4a8c3a:576d4165:72fc status:
ActionStatus.ABORTED > modelName=iziswh translatorName=sybase
sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security finalRowCount=21504
cpuTime(ns)=120503397
2016-06-28 08:54:35,701 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 ERROR USER COMMAND: endTime=2016-06-28 08:54:35.701
requestID=3bZw8VxEr4t7.26 txID=TransactionImple < ac, BasicAction:
0:ffff7f000101:2f4a8c3a:576d4165:72fc status: ActionStatus.ABORTED >
sessionID=3bZw8VxEr4t7 principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14
finalRowCount=null
2016-06-28 08:54:35,701 WARN [org.teiid.PROCESSOR] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 TEIID30020 Processing exception for request 3bZw8VxEr4t7.26 'TEIID30223
javax.transaction.RollbackException: ARJUNA016083: Can't register synchronization
because the transaction is in aborted state'. Originally TeiidProcessingException
TransactionImple.java:396. Enable more detailed logging to see the entire stacktrace.
2016-06-28 08:54:35,701 WARN [com.arjuna.ats.arjuna] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 ARJUNA012077: Abort called on already aborted atomic action
0:ffff7f000101:2f4a8c3a:576d4165:72fc
2016-06-28 08:54:35,702 INFO [org.teiid.COMMAND_LOG] (Worker12_QueryProcessorQueue243)
3bZw8VxEr4t7 END USER COMMAND: endTime=2016-06-28 08:54:35.702
requestID=3bZw8VxEr4t7.26 txID=null sessionID=3bZw8VxEr4t7
principal=veerle@teiid-security vdbName=vdb3 vdbVersion=14 finalRowCount=0