NullPointerException in SortUtility
rakeshsagar Oct 29, 2013 5:45 AMHi,
We are getting NullPointerException when executing the following query:
We are using teiid 8.5 with the patch applied for the JIRA [TEIID-2672] java.lang.AssertionError: Assertion failed in SourceState - JBoss Issue Tracker
select kc_datasources.DATASOURCE_NAME, kc_datasources.DATASOURCE_KEY, kc_datasources.DATASOURCE_INDEX_LOCATION FROM (
SELECT DATASOURCE_NAME, DATASOURCE_KEY, DATASOURCE_INDEX_LOCATION,'in_platform' as ORDER_POS from chorus_platform_chorus_metadata.kc_datasource
union
SELECT DATASOURCE_NAME, DATASOURCE_KEY, DATASOURCE_INDEX_LOCATION,'others' as ORDER_POS from dbmzdb2_chorus_metadata.kc_datasource
) AS kc_datasources ORDER BY kc_datasources.ORDER_POS,kc_datasources.DATASOURCE_NAME ASC
Both the data sources are file data sources.
Caused by: org.teiid.core.TeiidException
at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:194)
at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:958)
at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:543)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:346)
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.GeneratedMethodAccessor119.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:607)
at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)
at org.teiid.jboss.TransportService$2.invoke(TransportService.java:234)
at com.sun.proxy.$Proxy19.executeRequest(Unknown Source)
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:607)
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:137)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
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 com.sun.proxy.$Proxy19.executeRequest(Unknown Source)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509)
... 59 more
Caused by: java.lang.NullPointerException
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:303)
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:190)
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:111)
at org.teiid.query.processor.relational.SortNode.nextBatchDirect(SortNode.java:91)
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102)
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.RelationalPlan.nextBatch(RelationalPlan.java:136)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:155)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)
... 80 more
Is this a teiid bug or are we doing something wrong?
Thanks
Rakesh