[JBoss JIRA] (TEIID-4285) TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4285?page=com.atlassian.jira.plugin... ]
Steve Tran updated TEIID-4285:
------------------------------
Affects Version/s: 8.7.1.6_2
(was: 8.12.x)
> TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4285
> URL: https://issues.jboss.org/browse/TEIID-4285
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> My VDB stopped accepting ODBC-based connections. I wasn't able to identify the root cause, but I've gathered some facts.
> - JDBC connections still worked
> - ODBC connections to other VDBs worked fine
> - Reloading via web-console of this particular VDB restored functionality
> - Here's the stack trace
> {code}
> [Server:cdtssoa126d-jdv-one] 10:06:23,830 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763648) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.2: java.lang.AssertionError: Batch not found in storage 16855
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:80) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:455) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:920) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:646) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,246 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763650) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.4: java.lang.AssertionError: Batch not found in storage 11173
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:223) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:383) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:208) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,467 ERROR [org.teiid.PROCESSOR] (New I/O worker #17) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.5: java.lang.AssertionError: Batch not found in storage 14803
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:502) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4285) TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4285?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4285:
---------------------------------------
Did you retest this in 8.12.x or do you mean the affects version is 8.7.x?
> TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4285
> URL: https://issues.jboss.org/browse/TEIID-4285
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> My VDB stopped accepting ODBC-based connections. I wasn't able to identify the root cause, but I've gathered some facts.
> - JDBC connections still worked
> - ODBC connections to other VDBs worked fine
> - Reloading via web-console of this particular VDB restored functionality
> - Here's the stack trace
> {code}
> [Server:cdtssoa126d-jdv-one] 10:06:23,830 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763648) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.2: java.lang.AssertionError: Batch not found in storage 16855
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:80) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:455) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:920) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:646) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,246 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763650) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.4: java.lang.AssertionError: Batch not found in storage 11173
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:223) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:383) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:208) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,467 ERROR [org.teiid.PROCESSOR] (New I/O worker #17) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.5: java.lang.AssertionError: Batch not found in storage 14803
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:502) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4288) Cancel method against a socket based jdbc query can wait for synch timeout
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4288:
-------------------------------------
Summary: Cancel method against a socket based jdbc query can wait for synch timeout
Key: TEIID-4288
URL: https://issues.jboss.org/browse/TEIID-4288
Project: Teiid
Issue Type: Bug
Components: JDBC Driver
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1, 9.0.1
If a JDBC socket query is cancelled using a separate thread, the cancel call may wait until the timeout due to being synchronized which prevents the main execution thread from processing it's response.
Details were also added to TEIID-3781
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4283) External Materialization interleaving loads SYSADMIN.loadMatView
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4283?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4283:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1348466|https://bugzilla.redhat.com/show_bug.cgi?id=1348466] from NEW to MODIFIED
> External Materialization interleaving loads SYSADMIN.loadMatView
> ----------------------------------------------------------------
>
> Key: TEIID-4283
> URL: https://issues.jboss.org/browse/TEIID-4283
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.1, 8.12.5, 9.0.1
>
> Attachments: jdg-log.txt
>
>
> There is a possibility of two concurrent loads of single materialized view when using SYSADMIN.loadMatView function. I observed the issue while:
> # Waiting for ttl-driven reload and in right time I triggered another load explicitly by invoking the loadMatView function.
> # Invoking SYSADMIN.loadMatView function multiple times in quick succession.
> The view definition:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable',
> "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table ${db.table.prefix}dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view_stage TO ${db.table.prefix}dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view TO ${db.table.prefix}dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view_temp TO ${db.table.prefix}dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT',
> "teiid_rel:MATVIEW_TTL" 20000)
> AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;
> {code}
> Query to explicitly load the view:
> {code:sql}
> exec SYSADMIN.loadMatView(schemaName=>'View',viewname=>'external_long_ttl', invalidate=>'true')
> {code}
> I attached a log which starts with ttl-driven load, then the explicit load is performed. The issue noticed is in teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT , where primary and staging tables are being swapped. The second load (explicit) can't find the original table, as the ttl-driven load had already renamed it.
> But this situation of two concurrent loads should never occur.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4283) External Materialization interleaving loads SYSADMIN.loadMatView
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4283?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4283.
-----------------------------------
Fix Version/s: 9.1
8.12.5
9.0.1
Resolution: Done
Changed the conditions for initiating the load and allowed invalidation to be applied separately if needed.
> External Materialization interleaving loads SYSADMIN.loadMatView
> ----------------------------------------------------------------
>
> Key: TEIID-4283
> URL: https://issues.jboss.org/browse/TEIID-4283
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.1, 8.12.5, 9.0.1
>
> Attachments: jdg-log.txt
>
>
> There is a possibility of two concurrent loads of single materialized view when using SYSADMIN.loadMatView function. I observed the issue while:
> # Waiting for ttl-driven reload and in right time I triggered another load explicitly by invoking the loadMatView function.
> # Invoking SYSADMIN.loadMatView function multiple times in quick succession.
> The view definition:
> {code:sql}
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable',
> "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table ${db.table.prefix}dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view_stage TO ${db.table.prefix}dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view TO ${db.table.prefix}dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE ${db.table.prefix}dv_matviews_mat_view_temp TO ${db.table.prefix}dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT',
> "teiid_rel:MATVIEW_TTL" 20000)
> AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;
> {code}
> Query to explicitly load the view:
> {code:sql}
> exec SYSADMIN.loadMatView(schemaName=>'View',viewname=>'external_long_ttl', invalidate=>'true')
> {code}
> I attached a log which starts with ttl-driven load, then the explicit load is performed. The issue noticed is in teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT , where primary and staging tables are being swapped. The second load (explicit) can't find the original table, as the ttl-driven load had already renamed it.
> But this situation of two concurrent loads should never occur.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4287) An exception is thrown by PostgreSQL when nested CTEs are pushed down
by Salvatore R (JIRA)
Salvatore R created TEIID-4287:
----------------------------------
Summary: An exception is thrown by PostgreSQL when nested CTEs are pushed down
Key: TEIID-4287
URL: https://issues.jboss.org/browse/TEIID-4287
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Salvatore R
Assignee: Steven Hawkins
I defined the following views in my VDB, based on a table in PostgreSQL:
{code:sql}
create view tv0 as
WITH
cte1 as (SELECT 1 as a),
alias2 as (select a from cte1),
cte3 as (select a from alias2)
SELECT cte3.a FROM alias2 join cte3 on cte3.a=alias2.a;
create view tv1 as
WITH
cte1 as (SELECT a from pg.test_a),
alias2 as (select a from cte1),
cte3 as (select a from alias2)
SELECT cte3.a FROM alias2 join cte3 on cte3.a=alias2.a;
create view tv2 as
WITH
alias2 as (select b, a from pg.test_a),
cte4 as (select a from alias2)
SELECT cte4.a FROM cte4 join alias2 on cte4.a=alias2.a ;
{code}
The following query, based on views tv0 and tv1:
{code:sql}
with
CTE1 as (
select a from (
with CTE11 as (select a from views.tv0)
select a from CTE11
) as SUBQ1),
CTE2 as (
select a from (
with CTE21 as (select a from views.tv1)
select a from CTE21
) as SUBQ2)
select * from CTE1 as T1 join CTE2 as T2 on T1.a=T2.a
{code}
throws this exception:
{code:sql}
18:55:23,260 WARN [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue773) qPWXuJPW78go TEIID30020 Processing exception for request qPWXuJPW78go.3 'TEIID30504 test_tables_pg: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH alias2__1 (a) AS (SELECT g_0."a" FROM "public"."test_a" AS g_0) SELECT g_1.a AS c_0 FROM alias2__1 AS g_0, alias2 AS g_1 WHERE g_1.a = g_0.a AND g_1.a = 1 ORDER BY c_0]'. Originally TeiidProcessingException 'ERROR: Relation "alias2" does not exist
Position: 113' QueryExecutorImpl.java:2157. Enable more detailed logging to see the entire stacktrace.
19:00:13,379 WARN [org.teiid.CONNECTOR] (Worker28_QueryProcessorQueue775) qPWXuJPW78go Connector worker process failed for atomic-request=qPWXuJPW78go.4.7.144: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH alias2__1 (a) AS (SELECT g_0."a" FROM "public"."test_a" AS g_0) SELECT g_1.a AS c_0 FROM alias2__1 AS g_0, alias2 AS g_1 WHERE g_1.a = g_0.a AND g_1.a = 1 ORDER BY c_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:365)
at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy56.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: Relation "alias2" does not exist
Position: 113
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
... 17 more
{code}
A similar query based on view tv2, throws a different exception:
{code:sql}
with
CTE1 as (
select a from (
with CTE11 as (select a from views.tv2)
select a from CTE11
) as SUBQ1),
CTE2 as (
select a from (
with CTE21 as (select a from views.tv2)
select a from CTE21
) as SUBQ2)
select * from CTE1 as T1 join CTE2 as T2 on T1.a=T2.a
{code}
{code:sql}
19:05:02,784 WARN [org.teiid.CONNECTOR] (Worker30_QueryProcessorQueue778) qPWXuJPW78go Connector worker process failed for atomic-request=qPWXuJPW78go.5.2.145: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH alias2 (b, a) AS (SELECT NULL, g_0."a" FROM "public"."test_a" AS g_0), alias2__1 (a, b) AS (SELECT NULL, g_0."a" FROM "public"."test_a" AS g_0) SELECT g_2.a, g_0.a FROM alias2 AS g_0, alias2 AS g_1, alias2 AS g_2, alias2__1 AS g_3 WHERE g_2.a = g_3.a AND g_0.a = g_1.a AND g_0.a = g_2.a]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:365)
at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
at com.sun.proxy.$Proxy56.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: ERROR: failed to find conversion function from unknown to integer
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
... 17 more
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-4285) TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIID-4285?page=com.atlassian.jira.plugin... ]
Steve Tran commented on TEIID-4285:
-----------------------------------
Reloading the individual VDB only delayed it from breaking again. We just had to bounce the entire service. Will continue to monitor it.
> TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
> ----------------------------------------------------------------------------------------------------
>
> Key: TEIID-4285
> URL: https://issues.jboss.org/browse/TEIID-4285
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x
> Reporter: Steve Tran
> Assignee: Steven Hawkins
>
> My VDB stopped accepting ODBC-based connections. I wasn't able to identify the root cause, but I've gathered some facts.
> - JDBC connections still worked
> - ODBC connections to other VDBs worked fine
> - Reloading via web-console of this particular VDB restored functionality
> - Here's the stack trace
> {code}
> [Server:cdtssoa126d-jdv-one] 10:06:23,830 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763648) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.2: java.lang.AssertionError: Batch not found in storage 16855
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.access$100(ODBCServerRemoteImpl.java:80) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl$4.onCompletion(ODBCServerRemoteImpl.java:455) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:516) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:920) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:646) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:218) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:189) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,246 ERROR [org.teiid.PROCESSOR] (Worker2055_QueryProcessorQueue3763650) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.4: java.lang.AssertionError: Batch not found in storage 11173
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:223) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:383) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SourceState.getTupleBuffer(SourceState.java:243) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadLeft(EnhancedSortMergeJoinStrategy.java:229) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:187) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:269) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:208) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> [Server:cdtssoa126d-jdv-one] 10:06:24,467 ERROR [org.teiid.PROCESSOR] (New I/O worker #17) TEIID30019 Unexpected exception for request Z/WnBvmBk+w1.5: java.lang.AssertionError: Batch not found in storage 14803
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.impl.BufferManagerImpl$BatchManagerImpl.getBatch(BufferManagerImpl.java:306) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.getValues(SPage.java:237) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.SPage.search(SPage.java:139) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.STree.find(STree.java:246) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.setPage(TupleBrowser.java:146) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.common.buffer.TupleBrowser.nextTuple(TupleBrowser.java:210) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTable$QueryTupleSource.nextTuple(TempTable.java:192) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:110) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:295) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:174) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258) [teiid-engine-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:172) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at com.sun.proxy.$Proxy135.executeRequest(Unknown Source)
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.getPgColInfo(ODBCServerRemoteImpl.java:1099) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.odbc.ODBCServerRemoteImpl.prepare(ODBCServerRemoteImpl.java:502) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) [:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42) [netty-3.6.10.Final-redhat-1.jar:3.6.10.Final-redhat-1]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]
> [Server:cdtssoa126d-jdv-one]
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months
[JBoss JIRA] (TEIID-3781) Queries are not killed even if the client sends a cancel request
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3781?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3781:
---------------------------------------
> I am not sure what is the exact point prior to which is cancellation "safe" (without TimeoutException).
This should be logged as a different issue. From these logs you can see that the server is sending a response to the client about the cancellation:
08:06:44,972 DEBUG [org.teiid.TRANSPORT] (New I/O worker #63) processing message:MessageHolder: key=2 contents=Invoke interface org.teiid.client.DQP.cancelRequest
...
08:06:46,782 DEBUG [org.teiid.TRANSPORT] (New I/O worker #63) send message: MessageHolder: key=2 contents=true
However I can see on the client side that there is a soft dead lock between the main reader thread and the cancel thread, such that the synchronization of the cancel method can prevent it from receiving the response.
> Queries are not killed even if the client sends a cancel request
> ----------------------------------------------------------------
>
> Key: TEIID-3781
> URL: https://issues.jboss.org/browse/TEIID-3781
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Affects Versions: 7.0
> Reporter: Salvatore R
> Assignee: Steven Hawkins
> Fix For: 8.12.1, 8.13
>
>
> I have different behaviors when I try to cancel the following queries:
> {code:sql}
> SELECT COUNT(*)
> FROM
> (SELECT * FROM my.address) as x1,
> (SELECT * FROM my.address) as y1
> {code}
> and
> {code:sql}
> SELECT COUNT(*)
> FROM
> (SELECT * FROM my.address limit 10000) as x1,
> (SELECT * FROM my.address limit 10000) as y1
> {code}
> where "my.address" is a table with around 20000 rows in MySQL.
> The first query is immediately cancelled but the second one continues to run until the end and it is never killed.
> Looking at the generated plans, the main difference is that the first query is fully pushed down to MySQL while the second one is not.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 3 months