[teiid-issues] [JBoss JIRA] (TEIID-4688) PrestoDB translator - no value available

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)