0 Replies Latest reply on Jul 3, 2014 9:42 AM by Madhu Garimilla

    Exception while closing a connection

    Madhu Garimilla Newbie

      We are using EAP 6.1.0 final + Teiid 8.7. Below exception is seen when ever a connection is  being closed. I see a related post in Jboss but didn't find how to fix this in EAP 6.1.

       

      Why do I get "Trying to return an unknown connection2"?

       

       

      03 Jul 2014 18:47:06,872 INFO  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (http-/0.0.0.0:8080-4) SHFOQSThBz69 IJ000311: Throwable from unregister connection: java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@31068d1f

          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.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.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.proc.ProcedurePlan.executePlan(ProcedurePlan.java:563)

          at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68)

          at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:356)

          at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:283)

          at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:257)

          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.GeneratedMethodAccessor105.invoke(Unknown Source) [:1.7.0_03]

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

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

          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 $Proxy41.executeRequest(Unknown Source)    at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) [:1.7.0_03]

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

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

          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_03]

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

          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 $Proxy41.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]

          at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:391) [common-db-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:346) [common-db-4.0.0-SNAPSHOT.jar:]

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getFilterTreeWithoutRoot(ObjectsServiceImpl.java:310) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getFilterTreeWithoutRoot(ObjectsServiceImpl.java:276) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$$EnhancerByGuice$$d1a43bb5.CGLIB$getFilterTreeWithoutRoot$57(<generated>)

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$$EnhancerByGuice$$d1a43bb5$$FastClassByGuice$$9e4375c9.invoke(<generated>)

          at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]

          at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

          at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]

          at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

          at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$$EnhancerByGuice$$d1a43bb5.getFilterTreeWithoutRoot(<generated>)

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getTreeForSection(ObjectsServiceImpl.java:3394) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getTreeNodeChildren(ObjectsServiceImpl.java:3758) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]

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

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

          at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]

          at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

          at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$15cd3fdf.CGLIB$invoke$1(<generated>)

          at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$15cd3fdf$$FastClassByGuice$$835ce784.invoke(<generated>)

          at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]

          at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

          at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]

          at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]

          at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

          at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]

          at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$15cd3fdf.invoke(<generated>)

          at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]

          at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]

          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]