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

John Tan (Commented) (JIRA) jira-events at lists.jboss.org
Mon Jan 2 09:38:09 EST 2012 

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

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

It seems that original error has been addressed in the patch as I let it run and refresh and it hasn't show error yet.
However, we cannot upgrade to 7.6.x due to RuleAssignOutputElements error and "there are alot of warning WARN [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue2992) Not performing dependent join using source $dsc/id3, since the number of distinct rows for expression XXXXXXXX exceeds 922.356. You should ensure that your source statistics, including column distinct value counts, accurately reflect the source or use a MAKE_DEP hint to force the join."

                
> 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