]
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}