Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1868

Internal Materialized View - Load/Refresh and Assertion Failed

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7, 8.0
    • 7.3, 7.4, 7.6
    • Server
    • None
    • Hide

      1. Set a view cached with internal materialized with cache hit ttl:XXXXX
      2. Add certain loads and after 1-2 refresh cycle, the issue will occur

      Show
      1. Set a view cached with internal materialized with cache hit ttl:XXXXX 2. Add certain loads and after 1-2 refresh cycle, the issue will occur

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            j3hntan John Tan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: