java.lang.AssertionError

[gamvi01]

Hi

We are seeing java.lang.AssertionError error during execution of below query. I have attached the plan and corresponding views for your reference.

SELECT COUNT(*) FROM (SELECT CHORUS_B.runErrorStatus,'analysis_service.current_cost_summaries'

    AS "__objecttype__" FROM (SELECT CHORUS_B.* FROM (SELECT * FROM analysis_service.current_cost_summaries) AS CHORUS_B)

    AS CHORUS_B

    ) AS CHORUS_C

[shawkins]

That looks like an unexpected expression is being sent to the translator.  Can you reproduce this in 8.3 or latest?

Steve

[gamvi01]

yes its reproducible on teiid 8.3

----------------------------------------------------------------------------

OPTIMIZATION COMPLETE:

PROCESSOR PLAN:

AccessNode(2) output=[anon_grp1.agg0 AS expr1] SELECT COUNT(*) FROM (SELECT g_2.SCENARIO_TYPE AS c_0 FROM ((((((((((((analysis_service_h2.ANALYSIS_SER

VICE_H2.PUBLIC.ROI_ANALYSIS_RUN AS g_0 LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_HOST AS g_1 ON g_1.ID = g_0.HOST_ID) INNER J

OIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO AS g_2 ON g_2.ID = g_0.SCENARIO_ID) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVI

CE_H2.PUBLIC.ROI_CATEGORY AS g_3 ON g_3.ID = g_2.CATEGORY) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_LOCALE AS g_4 O

N g_3.VISIBLE_NAME_LOC_ID = g_4.ID AND g_4.LOCALE = 'en_US') INNER JOIN (SELECT g_5.HOST_ID AS c_0, MAX(g_5.RUN_START) AS c_1, g_7.SCENARIO_ID AS c_2

FROM (analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_ANALYSIS_RUN AS g_5 LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_ANALYS

IS_RUN AS g_6 ON g_6.SCENARIO_ID = g_5.SCENARIO_ID AND g_6.RUN_START > g_5.RUN_START AND ((g_6.HOST_ID = g_5.HOST_ID) OR ((g_6.HOST_ID IS NULL) AND (g

_5.HOST_ID IS NULL)))) INNER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO AS g_7 ON g_7.ID = g_5.SCENARIO_ID WHERE g_6.RUN_START I

S NULL GROUP BY g_7.SCENARIO_ID, g_5.HOST_ID) AS v_0 ON ((g_0.HOST_ID = v_0.c_0) OR ((g_0.HOST_ID IS NULL) AND (v_0.c_0 IS NULL))) AND g_0.RUN_START =

v_0.c_1 AND g_2.SCENARIO_ID = v_0.c_2) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_ANALYSIS_RUN_RESULT AS g_8 ON g_8.ID = g_0.

RESULT_VALUE) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_VARIABLE AS g_9 ON g_9.ID = g_8.ID) INNER JOIN analysis_serv

ice_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_DETAIL AS g_10 ON g_2.ID = g_10.SCENARIO_ID) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PU

BLIC.ROI_ANALYSIS_RUN_DETAIL AS g_11 ON g_11.RUN_ID = g_0.ID AND g_11.METRIC_NAME = g_8.VARIABLE_NAME AND g_11.ATTR_NAME = 'DisplayAs') LEFT OUTER JOI

N analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_LOCALE AS g_12 ON g_10.ATTR_VALUE = convert(g_12.ID, string) AND g_12.LOCALE = 'en_US')

INNER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_DETAIL AS g_13 ON g_2.ID = g_13.SCENARIO_ID) LEFT OUTER JOIN analysis_service_h

2.ANALYSIS_SERVICE_H2.PUBLIC.ROI_SCENARIO_ZOOMS AS g_14 ON g_2.ID = g_14.SCENARIO_ID) LEFT OUTER JOIN analysis_service_h2.ANALYSIS_SERVICE_H2.PUBLIC.R

OI_SCENARIO_LOCALE AS g_15 ON g_13.ATTR_VALUE = convert(g_15.ID, string) AND g_15.LOCALE = 'en_US' WHERE (g_10.METRIC_NAME = '''Solution''') AND (g_10

.ATTR_NAME = 'VisibleName') AND (g_13.METRIC_NAME = '''Solution''') AND (g_13.ATTR_NAME = 'Description') ORDER BY severity LIMIT 1000000) AS v_1 WHERE

v_1.c_0 = 'CostAnalysis'

============================================================================

16:55:28,475 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue16) OEJGevaspE1x TEIID30019 Unexpected exception for request OEJGevaspE1x.0: java

.lang.AssertionError

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:558) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:523) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:241) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:189) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:314) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:278) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:238) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.LanguageBridgeFactory.translate(LanguageBridgeFactory.java:163) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.<init>(ConnectorWorkItem.java:105) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.datamgr.ConnectorManager.registerRequest(ConnectorManager.java:122) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:665) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:142) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:412) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:195) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:140) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:206) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:131) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:110) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:400) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:296) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:224) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.3.0.Final.jar:8.3.0.Fi

nal]

        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.3.0.Final.jar:8.3.0.Final]

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

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

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

[shawkins]

Thanks, I can reproduce this as well.  There is an issue with how the effectively unrelated order by is being hanled when pushed down.  I'll provide a fix shortly.

Steve

[shawkins]

Resolved as https://issues.jboss.org/browse/TEIID-2492

Steve