[teiid-issues] [JBoss JIRA] (TEIID-1868) Internal Materialized View - Load/Refresh and Assertion Failed

John Tan (Commented) (JIRA) jira-events at lists.jboss.org
Sat Dec 17 09:55:09 EST 2011 

    [ https://issues.jboss.org/browse/TEIID-1868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651808#comment-12651808 ] 

John Tan commented on TEIID-1868:
---------------------------------

@Ramesh I will test 7.6

@Steven No there is no alter statement. The mat view refresh is given at transformation query using ttl:XXXXX
        Some tables upon initialization get Assertion Failed, however, if we explicitly hit these tables first, it wil l be loaded alright. It is not the same case when the ttl expires and the view reloads. Assertion failed error will surface and the vdb is unusable and the only wait to continue is to restart which is not acceptable.
                
> Internal Materialized View - Load/Refresh and Assertion Failed
> --------------------------------------------------------------
>
>                 Key: TEIID-1868
>                 URL: https://issues.jboss.org/browse/TEIID-1868
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 7.3, 7.4
>         Environment: Windows Server 2008 R2 64 bits, JBoss EAP 5.1
>            Reporter: John Tan
>            Assignee: Steven Hawkins
>
> We have about 20 tables translated to 20 materialized view (internal with cache hint - /*+ cache(ttl:14400000) */). 2 dreaded behaviours:
>   1. On start up with application (application starts hitting app), certain query will cause ASSERTION FAILED
>   2. On reloading cache, teiid starts to fails with same behaviour.
> 2011-12-14 18:26:40,201 WARN  [org.teiid.CONNECTOR] (Worker2228_QueryProcessorQueue1132419) Connector worker process failed for atomic-request=mCMnhhZ9fLcU.100.3.334092
> [JDBCExecutionException] 0: Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s):[....]
> 1 [TeiidSQLException]ASSERTION FAILED: expected reference to be not null
> 2 [TeiidException]ASSERTION FAILED: expected reference to be not null
> 3 [AssertionError]ASSERTION FAILED: expected reference to be not null
> 	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90)
> 	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
> 	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
> 	at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:107)
> 	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
> 	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
> 	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> 	at java.lang.Thread.run(Thread.java:662)
> Caused by: org.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null
> 	at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
> 	at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
> 	at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:497)
> 	at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:214)
> 	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
> 	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86)
> 	... 12 more
> Caused by: [TeiidException]ASSERTION FAILED: expected reference to be not null
> 1 [AssertionError]ASSERTION FAILED: expected reference to be not null
> 	at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:177)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:557)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.attemptClose(RequestWorkItem.java:335)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:218)
> 	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
> 	... 6 more
> Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
> 	at org.teiid.core.util.Assertion.failed(Assertion.java:73)
> 	at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
> 	at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
> 	at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:366)
> 	at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:141)
> 	at org.teiid.query.tempdata.TempTable$QueryTupleSource.<init>(TempTable.java:130)
> 	at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:410)
> 	at org.teiid.query.tempdata.TempTable.createTupleSource(TempTable.java:402)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerQuery(TempTableDataManager.java:437)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:182)
> 	at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:170)
> 	at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:197)
> 	at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:118)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95)
> 	at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:138)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:72)
> 	at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:250)
> 	at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:152)
> 	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:134)
> 	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> 	at org.teiid.query.processor.relational.SubqueryAwareEvaluator.evaluateSubquery(SubqueryAwareEvaluator.java:129)
> 	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:445)
> 	at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:218)
> 	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:203)
> 	at org.teiid.query.processor.relational.SelectNode.nextBatchDirect(SelectNode.java:102)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> 	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:162)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> 	at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70)
> 	at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69)
> 	at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:82)
> 	at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)
> 	at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:214)
> 	at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:168)
> 	at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96)
> 	at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:85)
> 	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
> 	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:161)
> 	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
> 	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
> 	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
> 	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
> 	... 7 more
> 2011-12-14 18:26:40,201 WARN  [org.teiid.PROCESSOR] (Worker2205_QueryProcessorQueue1132421) Processing exception 'Error Code:0 Message:Error Code:0 Message:'ASSERTION FAILED: expected reference to be not null' error executing statement(s): [....] for request mCMnhhZ9fLcU.100.  Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.core.util.Assertion.failed(Assertion.java:73). Enable more detailed logging to see the entire stacktrace.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the teiid-issues mailing list