How to set the transaction timeout?
kchen007 Oct 1, 2013 6:46 PMWe have some long running queries that will run in SEQUENCE(one after the other) and from time to time, the server will thow exceptions saying the transaction has been "aborted" when it try to get a managed connection.
Strange thing is that if we run each one of the queries in the SEQUENCE individually, the query will pass without any error.
Once the server throw exception, we cannot issue any query to that datasource, we have to restart server.
Is this related to transaction timeout? How can I adjust it? we are running Teiid 8.4 final + JBoss EAP6.1
Here is the exception:
11:54:50,737
TRACE [com.arjuna.ats.jta] (Worker0_QueryProcessorQueue1201)
TransactionImpleManager.resume
11:54:50,737 TRACE [com.arjuna.ats.arjuna] (Worker0_QueryProcessorQueue1201)
BasicAction::addChildThread () action 0:ffff868498c3:6cc3d41e:524afb89:10
adding Thread[Worker0_QueryProcessorQueue1201,5,main]
11:54:50,737 TRACE [com.arjuna.ats.arjuna] (Worker0_QueryProcessorQueue1201)
BasicAction::addChildThread () action 0:ffff868498c3:6cc3d41e:524afb89:10
adding Thread[Worker0_QueryProcessorQueue1201,5,main] result = false
11:54:50,739 TRACE [com.arjuna.ats.jta] (Worker0_QueryProcessorQueue1201)
TransactionImple.getStatus
11:54:50,741 DEBUG [org.teiid.COMMAND_LOG]
(Worker0_QueryProcessorQueue1201) ERROR SRC
COMMAND: endTime=2013-10-01 11:54:50.741
requestID=knUuht8CMFW+.111
sourceCommandID=0 executionID=7
txID=TransactionImple < ac, BasicAction: 0:ffff868498c3:6cc3d41e:524afb89:10
status: ActionStatus.ABORTED >
modelName=OW5000 translatorName=delegate
sessionID=knUuht8CMFW+
principal=user@dsds-security-domain finalRowCount=null
11:54:50,741 DEBUG [org.teiid.COMMAND_LOG]
(Worker0_QueryProcessorQueue1201) ERROR SRC
COMMAND: endTime=2013-10-01 11:54:50.741
requestID=knUuht8CMFW+.111
sourceCommandID=0 executionID=7
txID=TransactionImple < ac, BasicAction: 0:ffff868498c3:6cc3d41e:524afb89:10
status: ActionStatus.ABORTED > modelName=OW5000
translatorName=delegate sessionID=knUuht8CMFW+
principal=user@dsds-security-domain finalRowCount=null
11:54:50,741 WARN [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1201)
Connector worker process failed for atomic-request=knUuht8CMFW+.111.0.7:
org.teiid.translator.TranslatorException: TEIID60000 javax.resource.ResourceException:
IJ000460: Error checking for a transaction
at
org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:171)
[teiid-api-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:190)
[teiid-api-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.translator.BaseDelegatingExecutionFactory.getConnection(BaseDelegatingExecutionFactory.java:116)
[teiid-api-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:218)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:446)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:285)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:306)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:149)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
[teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[rt.jar:1.6.0_27]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[rt.jar:1.6.0_27]
at
java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]
Caused by: javax.resource.ResourceException: IJ000460: Error checking for a
transaction
at
org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362)
[ironjacamar-core-impl-1.0.15.Final.jar:1.0.15.Final]
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
[ironjacamar-core-impl-1.0.15.Final.jar:1.0.15.Final]
at
org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58)
[teiid-api-8.4.0.Final.jar:8.4.0.Final]
at
org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:169)
[teiid-api-8.4.0.Final.jar:8.4.0.Final]