[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:all-tabpanel ]

Steven Hawkins resolved TEIID-4303.
-----------------------------------
    Resolution: Rejected


> 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)