[JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4688?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4688.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-4451
> PrestoDB translator - no value available
> ----------------------------------------
>
> Key: TEIID-4688
> URL: https://issues.jboss.org/browse/TEIID-4688
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Evaluation of query \[1\] ends up with exception produced by Teiid \[2\].
> {code:sql|title=\[1\]}
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> {code}
> {code:plain|title=\[2\]}
> 15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> {code}
> {code:plain|title=Log}
> 15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> 15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
> 15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
> ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
> JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
> AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey]
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
> 15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
> 15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
> 15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
> 15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
> 15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
> 15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 2 months
[JBoss JIRA] (TEIID-3990) Issues with nested correlated references
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3990?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3990:
----------------------------------
Fix Version/s: (was: 8.12.6.6_3)
> Issues with nested correlated references
> ----------------------------------------
>
> Key: TEIID-3990
> URL: https://issues.jboss.org/browse/TEIID-3990
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> There are several issues with nested correlated reference handling generally around having the same table name/alias in several levels of the query. For example with a having c1, c2 columns, b having c3, c4, and c having c5, c6:
> SELECT (select c2 from b where c3 = (select c5 from c as x where c6 = c1)) FROM a as x group by c1, c2
> Results in an exception since the inner most reference to c1 is seen as actually resolving to c as x - rather than the outer a as x.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 2 months
[JBoss JIRA] (TEIID-3990) Issues with nested correlated references
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3990?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3990:
----------------------------------
Fix Version/s: 8.12.6.6_3
> Issues with nested correlated references
> ----------------------------------------
>
> Key: TEIID-3990
> URL: https://issues.jboss.org/browse/TEIID-3990
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.2
>
>
> There are several issues with nested correlated reference handling generally around having the same table name/alias in several levels of the query. For example with a having c1, c2 columns, b having c3, c4, and c having c5, c6:
> SELECT (select c2 from b where c3 = (select c5 from c as x where c6 = c1)) FROM a as x group by c1, c2
> Results in an exception since the inner most reference to c1 is seen as actually resolving to c as x - rather than the outer a as x.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 2 months
[JBoss JIRA] (TEIID-4686) PrestoDB translator - ordering of joined tables fails
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-4686?page=com.atlassian.jira.plugin... ]
Juraj Duráni commented on TEIID-4686:
-------------------------------------
The bug should be fixed in next release (0.162) which has been already tagged on GitHub. I will wait for official release. Maybe we could close this without note in the doc.
> PrestoDB translator - ordering of joined tables fails
> -----------------------------------------------------
>
> Key: TEIID-4686
> URL: https://issues.jboss.org/browse/TEIID-4686
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Issuing query like \[1\] causes an exception in PrestoDB. This seems to be PrestoDB issue. I found similar issue \[2\], but that one should be fixed. I have created a new issue \[3\]. Removing one column from ORDER BY, query returns correct result.
> Not sure if we can do something about it without avoiding pushing JOIN.
> I suggest either to fix this (if simple enough) or add a note to the documentation.
> \[1\]
> {code:sql}
> SELECT a.intkey, b.intkey FROM BQT1.SmallA AS a INNER JOIN BQT1.SmallB AS b on a.intkey = b.intkey ORDER BY 1, 2
> {code}
> \[2\] https://github.com/prestodb/presto/issues/1621
> \[3\] https://github.com/prestodb/presto/issues/7010
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 2 months
[JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4688?page=com.atlassian.jira.plugin... ]
Work on TEIID-4688 started by Steven Hawkins.
---------------------------------------------
> PrestoDB translator - no value available
> ----------------------------------------
>
> Key: TEIID-4688
> URL: https://issues.jboss.org/browse/TEIID-4688
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Evaluation of query \[1\] ends up with exception produced by Teiid \[2\].
> {code:sql|title=\[1\]}
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> {code}
> {code:plain|title=\[2\]}
> 15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> {code}
> {code:plain|title=Log}
> 15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
> 15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
> 15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
> 15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
> ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
> JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
> AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey]
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
> 15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
> 15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
> 15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
> 15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
> 15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
> 15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
> 15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
> 15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
> 15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
> 15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
> 15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
> 15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
> 15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
> 15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
> 15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
> 15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
> 15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
> 15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
> 15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
> 15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 2 months
[JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-4688:
-----------------------------------
Summary: PrestoDB translator - no value available
Key: TEIID-4688
URL: https://issues.jboss.org/browse/TEIID-4688
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.8.6_3
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Evaluation of query \[1\] ends up with exception produced by Teiid \[2\].
{code:sql|title=\[1\]}
SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
{code}
{code:plain|title=\[2\]}
15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
{code}
{code:plain|title=Log}
15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey]
15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
{code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 3 months
[JBoss JIRA] (TEIID-4636) In the SWARM readme's, need to indicate the URL to connect
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4636?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4636:
------------------------------------
No, I just account for Van, why swarm teiid can no use system property to bind port, that because DV server also not design to use system property bind a port.
Do you think we need use system property to bind the jdbc and odbc port? if yes, I can do this.
> In the SWARM readme's, need to indicate the URL to connect
> ----------------------------------------------------------
>
> Key: TEIID-4636
> URL: https://issues.jboss.org/browse/TEIID-4636
> Project: Teiid
> Issue Type: Enhancement
> Components: Quick Starts
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Minor
>
> The quickstarts needs to include the information (i.e, URL, username, password, etc.) needed to connect to the swarm example.
> Per Kylin:
> By default 0.0.0.0 be bound as IP, 31000 as port. To bind a specific IP use system properties
> ---
> -Dswarm.bind.address=127.0.0.1
> ---
> Some Fractions use a system properties to change the port number, but teiid not support it at moment.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 3 months