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

Steven Hawkins (Commented) (JIRA) jira-events at lists.jboss.org
Wed Jan 4 11:14:10 EST 2012 

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

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

EDS 5.1 is generally available.  If you don't have 5.1 or 5.2 instance available, then we can just resolve based upon what you have in 7.6.  Can you provide the SHOWPLAN DEBUG output?  This will show the planning state before RuleAssignOutputElements.  If this appears unrelated to the original issue, then we'll open another JIRA so that this one can be resolved.
                
> 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