1 Reply Latest reply on Jun 4, 2014 1:31 PM by markaddleman

    Throwable from unregister connection: java.lang.IllegalStateException: Trying to return an unknown connection2!

    rakeshsagar

      Hi all,

       

      We see the following exceptions in the log while performing some operations. Not sure why we are getting this exception.

      We are using Teiid 8.7 with JBoss EAP 6.1.0

      Is it really an information message? What are the side effects of this exception? How to fix this problem?

       

       

      04 Jun 2014 16:07:35,545 INFO  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (http-CA31/141.202.65.31:30804-2) 6/tJ91vJ1pQR IJ000311: Throwable from unregister connection: java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@63dd144f

        at org.jboss.jca.core.connectionmanager.ccm.CachedConnectionManagerImpl.unregisterConnection(CachedConnectionManagerImpl.java:347)

        at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.connectionClosed(TxConnectionListener.java:371)

        at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:568)

        at org.jboss.jca.adapters.jdbc.WrappedConnection.close(WrappedConnection.java:264)

        at org.teiid.translator.jdbc.JDBCExecutionFactory.closeConnection(JDBCExecutionFactory.java:295)

        at org.teiid.translator.jdbc.JDBCExecutionFactory.closeConnection(JDBCExecutionFactory.java:57)

        at org.teiid.translator.BaseDelegatingExecutionFactory.closeConnection(BaseDelegatingExecutionFactory.java:85) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

        at com.ca.chorus.teiid.safety.SafetyHarnessExecutionFactory.closeConnection(SafetyHarnessExecutionFactory.java:80)

        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.close(ConnectorWorkItem.java:231)

        at org.teiid.dqp.internal.process.DataTierTupleSource.fullyCloseSource(DataTierTupleSource.java:323)

        at org.teiid.dqp.internal.process.DataTierTupleSource.closeSource(DataTierTupleSource.java:353)

        at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:390)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)

        at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)

        at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)

        at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)

        at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269)

        at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202)

        at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112)

        at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:91)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)

        at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)

        at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)

        at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92)

        at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:163)

        at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)

        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136)

        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)

        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)

        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159)

        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141)

        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254)

        at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295)

        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source) [:1.7.0]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0]

        at java.lang.reflect.Method.invoke(Method.java:607) [rt.jar:1.7.0]

        at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

        at org.teiid.jboss.TransportService$2.invoke(TransportService.java:228)

        at com.sun.proxy.$Proxy29.executeRequest(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source) [:1.7.0]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0]

        at java.lang.reflect.Method.invoke(Method.java:607) [rt.jar:1.7.0]

        at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:170)

        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0]

        at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258)

        at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:168)

        at com.sun.proxy.$Proxy29.executeRequest(Unknown Source)

        at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

        at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

       

      Thanks

      Rakesh