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

Steven Hawkins (Commented) (JIRA) jira-events at lists.jboss.org
Sat Dec 31 10:34:10 EST 2011 

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

Steven Hawkins commented on TEIID-1868:
---------------------------------------

So we've now seen three issues that may be independent.  As for catching errors to treat the situation as no cache, that is not currently possible.  These are low level unexpected planning errors which we should be able to address with patches.

The original projection error seems to have been addressed with the patch.  Is that correct?

The NPE occurs in logic that was added in 7.4, which is why you aren't seeing it in 7.3.  If it is separable, can you open another JIRA possibly with a stripped down VDB to reproduce?
 
I'm also unsure what the RuleAssignOutputElements error may have do with the original issue as well.  From the stacktrace it is occurring in a user query and not during the load of a mat view.  Is the user query against the mat view that was originally failing to load correctly?
                
> 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, 7.6
>         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