AssertionError in LanguageBridgeFactory

[rakeshsagar]

Hi,

I am getting an AssertionError in the LanguageBridgeFactory class for one of the SQL.

From the code I see that we have handled all the cases which can occur but still we are getting this exception.

Is there something that we can look up to see why this exception is coming. Query Plan?

The following is the stack trace:

Caused by: java.lang.AssertionError

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:609)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:434)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:348)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:442)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:350)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:442)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:350)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:442)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:350)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:245)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:193)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:283)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:250)

    at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:167)

    at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.<init>(ConnectorWorkItem.java:154)

    at org.teiid.dqp.internal.datamgr.ConnectorManager.registerRequest(ConnectorManager.java:161)

    at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:774)

    at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:177)

    at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:475)

    at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:248)

    at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)

    at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95)

    at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:142)

    at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)

    at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:143)

    at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)

    at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:127)

    at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:82)

    at org.teiid.query.processor.relational.JoinStrategy.openRight(JoinStrategy.java:105)

    at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145)

    at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)

    at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:127)

    at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:231)

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

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

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

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

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

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

[shawkins]

What version are you on?

[rakeshsagar]

Teiid 8.7 with Teiid-2946 and Teiid-2928 patches applied.

[shawkins]

Can you provide a query and even change the assertion error to:

throw new AssertionError(expr.getClass().getName() + " " + expr); //$NON-NLS-1$

which will show us immediately what is failing.

[rakeshsagar]

The following is the output:

java.lang.AssertionError: org.teiid.query.sql.symbol.Reference ?

[shawkins]

Yes, that is unexpected as the access node logic should have replaced the references with their actual values.

[rakeshsagar]

Anything else to debug or look for?

[shawkins]

It will need to be converted into an issue.  If you have a test case then I'll be able to get a fix quickly.

[rakeshsagar]

I do not have a test case for this now. Is there a existing test case in Teiid code that I can modify to reproduce this error?

[shawkins]

> Is there a existing test case in Teiid code that I can modify to reproduce this error?

It's mostly dependent upon the user sql / source capabilities involved.  The query plan may be sufficient for me to determine what is going on.

[shawkins]

If you are able to post the query plan or even better the debug query plan log, that should help.

[rakeshsagar]

Thanks Steve. There is a problem with the SQL, once that is fixed I will post the query plan.

[shawkins]

If your scenario used an ordering over a subquery, then this is likely [TEIID-3025] Issues with sorting by a subquery - JBoss Issue Tracker