[teiid-issues] [JBoss JIRA] (TEIID-4303) Insert into temporary table fails

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13257827#comment-13257827 ] 

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 at 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 at 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 at teiid-security vdbName=vdb3    vdbVersion=14   finalRowCount=0



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)