Error faced during creation of Internal Materialized views
pranavk Jul 9, 2015 2:04 AMHi,
I faced the following error while creating a cache using Int Mat views. I am using Teiid embedded 8.11, with the view ttl of 120mins. I ran a select * query over a view which was simply mapped to a source model having 48MN string records and 7 columns. I feel it was critically going against a deliberately defined behavior. Any reason you could think this would be happening?
Caused by: org.teiid.jdbc.TeiidSQLException: Batch removed
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:700) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:539) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:269) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:307) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
INFO | jvm 1 | 2015/07/08 13:24:39 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_45]
INFO | jvm 1 | 2015/07/08 13:24:39 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_45]
INFO | jvm 1 | 2015/07/08 13:24:39 | at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at com.sun.proxy.$Proxy236.read(Unknown Source) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:406) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:548) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
INFO | jvm 1 | 2015/07/08 13:24:39 | at com.pb.spectrum.edi.jdbc.runtime.AbstractJdbcDataSourceReader.executeQuery(AbstractJdbcDataSourceReader.java:223) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | ... 9 common frames omitted
INFO | jvm 1 | 2015/07/08 13:24:39 | Caused by: org.teiid.core.TeiidException: Batch removed
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1064) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:559) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:365) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | ... 3 common frames omitted
INFO | jvm 1 | 2015/07/08 13:24:39 | Caused by: java.lang.AssertionError: Batch removed
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.common.buffer.SPage.getValues(SPage.java:227) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.common.buffer.STree.setBatchInsert(STree.java:177) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.afterCompletion(TempTable.java:107) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:271) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTable$InsertUpdateProcessor.process(TempTable.java:102) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTable.insert(TempTable.java:683) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTableDataManager$7.createTupleSource(TempTableDataManager.java:722) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTableDataManager$4.load(TempTableDataManager.java:620) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTableDataManager$4.createTupleSource(TempTableDataManager.java:556) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) ~[na:na]
INFO | jvm 1 | 2015/07/08 13:24:39 | ... 8 common frames omitted
Thanks,
Pranav