java.lang.AssertionError: Assertion failed in teiid code in 8.5

[rakeshsagar]

Hi all,

We are using Teiid8.5 and while executing a particular SQL with Union and Join, we are getting an Assertion Failed Error in teiid code.

Attached is the SQL which is throwing the exception. The following is the exception stack trace.

Can you please let us know the reason for this error and how to fix this?

23 Sep 2013 19:56:24,950 IST ERROR [org.teiid.PROCESSOR] (http-/127.0.0.1:8080-2) 74NqnxAiy8n8 TEIID30019 Unexpected exception for request 74NqnxAiy8n8.32: java.lang.AssertionError: Assertion failed.

  at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:197)

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

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

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

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

  at org.teiid.query.processor.relational.UnionAllNode.nextBatchDirect(UnionAllNode.java:151)

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

  at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69)

  at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70)

  at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84)

  at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48)

  at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:257)

  at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)

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

  at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:202)

  at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:250)

  at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:290)

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

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

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

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

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

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

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

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

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

  at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)

  at $Proxy19.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source) [:1.7.0_03]

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

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

  at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_03]

  at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_03]

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

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

  at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:135)

  at $Proxy19.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.5.0.Final.jar:8.5.0.Final]

  at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.5.0.Final.jar:8.5.0.Final]

  at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:378) [common-db-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:883) [common-db-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.db.DbExecutor.gatherResults(DbExecutor.java:876) [common-db-4.0.0-SNAPSHOT.jar:]

  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getAuthorizedModuleLibraries(ObjectsServiceImpl.java:4623) [chorus-service-4.0.0-SNAPSHOT.jar:]

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_03]

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_03]

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

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

  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:272) [chorus-service-4.0.0-SNAPSHOT.jar:]

  at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) [gwt-servlet-2.4.0.jar:]

  at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) [gwt-servlet-2.4.0.jar:]

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]

  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]

  at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:54) [chorus-service-4.0.0-SNAPSHOT.jar:]

  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:43) [chorus-service-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:19) [transaction-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.CGLIB$invoke$1(<generated>)

  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211$$FastClassByGuice$$8b9821a3.invoke(<generated>)

  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) [guice-3.0.jar:]

  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:75) [common-utils-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:92) [common-utils-4.0.0-SNAPSHOT.jar:]

  at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31) [transaction-4.0.0-SNAPSHOT.jar:]

  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72) [guice-3.0.jar:]

  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52) [guice-3.0.jar:]

  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$b1a07211.invoke(<generated>)

  at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:42) [chorus-service-4.0.0-SNAPSHOT.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118) [guice-servlet-3.0.jar:]

  at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113) [guice-servlet-3.0.jar:]

  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

  at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]

[shawkins]

Ideally you could provide a reproducing scenario.  Can you open an issue with a vdb/sql?

[rakeshsagar]

I attached the SQL which is causing the problem.

I will try to come up with a test case for this problem,

If there is a quick solution that I can try that would be helpful.

[rakeshsagar]

Opened a new JIRA issue. [#TEIID-2672] java.lang.AssertionError: Assertion failed in SourceState - JBoss Issue Tracker