1 Reply Latest reply on Aug 30, 2016 6:28 AM by rareddy

    Teiid assertion error

    masuman82

      One of our customer ran into an issue which we are finding it difficult to reproduce.

       

      They are getting Teiid assertion error while performing certain operations. It looks like the column on which sort has to be performed is not present in the schema list.

       

      Logs show the below exception

       

      20:09:54,727 WARNING [org.teiid.jdbc.NonBlockingRowProcessor] (Worker624_QueryProcessorQueue191770) Unhandled exception from Stateme

      ntCallback: org.teiid.jdbc.TeiidSQLException: TEIID30563 57014

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

        at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:402)

        at org.teiid.jdbc.ResultSetImpl.access$000(ResultSetImpl.java:63)

        at org.teiid.jdbc.ResultSetImpl$1.onCompletion(ResultSetImpl.java:230)

        at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

        at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

        at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:812)

        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:249)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123)

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157) [rt.jar:1.7.0]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627) [rt.jar:1.7.0]

        at java.lang.Thread.run(Thread.java:798) [vm.jar:1.7.0]

      Caused by: org.teiid.core.TeiidProcessingException: TEIID30563 57014

        at org.teiid.dqp.internal.process.RequestWorkItem.addCancelCode(RequestWorkItem.java:822)

        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:808)

        ... 10 more    

      Caused by: org.teiid.core.TeiidProcessingException: TEIID30563 The request NMWeKs0oJs0B.49 has been cancelled.=======

        at org.teiid.dqp.internal.process.RequestWorkItem.setCanceledException(RequestWorkItem.java:325)

        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:472)

        ... 9 more     

      020:09:54,739 ERROR [org.teiid.PROCESSOR] (http--0.0.0.0-22010-1) TEIID30019 Unexpected exception for request NMWeKs0oJs0B.195: java.

      lang.AssertionError: Assertion failed.

        at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.1.0.FinalCAFix-SNAPSHOT.jar:8.1.0.FinalCAFix-SNAPSH

      OT]             

        at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.1.0.FinalCAFix-SNAPSHOT.jar:8.1.0.FinalCAFix-SN

      APSHOT]         

        at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.1.0.FinalCAFix-SNAPSHOT.jar:8.1.0.FinalCAFix-SN

      APSHOT]         

        at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:145)

        at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:99)

        at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:91)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)

        at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:101)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)

        at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)

        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.hasNext(AbstractTupleSource.java:91)

        at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:163)

        at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:202)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)

        at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146)

        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)

        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:148)

        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)

        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:112)

        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)

        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)

        at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)

        at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) [:1.7.0]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56) [rt.jar:1.7.0]

        at java.lang.reflect.Method.invoke(Method.java:620) [rt.jar:1.7.0]

       

        Our product uses Teiid 8.1 running on JBoss 7.1.1.

        Are you aware of any likely scenario that could have caused this error. Is there any workaround for this.

        • 1. Re: Teiid assertion error
          rareddy

          Yes, sort looks like it needs the same expression in the selection clause. Teiid 8.1 is too old of release for community to provide any advise. You can check with latest, but I think it behaves same way.