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}