[ https://issues.jboss.org/browse/TEIID-4875?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-4875: ------------------------------------ [~shawkins] I think we need to reopen this issue. I tested with 8.12.11.6_3 version: {code:sql|title=query} SELECT max(t3.e4),max(t2.e4) as s FROM pm1.teiid4875g1 as t1, pm1.teiid4875g2 as t2, pm1.teiid4875g3 as t3, pm1.teiid4875g4 as t4, pm2.teiid4875g1 as t5 WHERE t1.e1 = t2.e1 and (t2.e2 = t3.e2 and t1.e3 || t2.e3 = t3.e3) and t3.e3 = t4.e3 and t4.e4 = t5.e4 {code} I am getting an exception about non-existent column (tested on h2 database): {code:plain|title=stacktrace} org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 pm1: 42122 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:721) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:560) at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:268) at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98) at com.sun.proxy.$Proxy25.read(Unknown Source) at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:569) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:422) at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:353) at org.jboss.qe.dvqe.reproducers.Teiid4875Test.testMultiJoinCriteria(Teiid4875Test.java:92) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86) at org.testng.internal.MethodInvocationHelper$1.runTestMethod(MethodInvocationHelper.java:197) at org.jboss.qe.DVQETestListener.run(DVQETestListener.java:276) at org.testng.internal.MethodInvocationHelper.invokeHookable(MethodInvocationHelper.java:209) at org.testng.internal.Invoker.invokeMethod(Invoker.java:639) at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820) at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128) at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129) at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112) at org.testng.TestRunner.privateRun(TestRunner.java:782) at org.testng.TestRunner.run(TestRunner.java:632) at org.testng.SuiteRunner.runTest(SuiteRunner.java:366) at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361) at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319) at org.testng.SuiteRunner.run(SuiteRunner.java:268) at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244) at org.testng.TestNG.runSuitesLocally(TestNG.java:1169) at org.testng.TestNG.run(TestNG.java:1064) at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:132) at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.executeSingleClass(TestNGDirectoryTestSuite.java:112) at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:99) at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:147) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:290) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:242) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:121) Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 pm1: 42122 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1] at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:161) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:391) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:211) at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:158) at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.shouldIndex(EnhancedSortMergeJoinStrategy.java:360) at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.loadRight(EnhancedSortMergeJoinStrategy.java:250) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:232) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) at org.teiid.query.processor.relational.GroupingNode.groupSortPhase(GroupingNode.java:490) at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:366) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:211) at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:158) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:211) at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:158) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) at org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:566) at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:362) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:281) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.teiid.translator.TranslatorException: 42122 Remote org.teiid.translator.jdbc.JDBCExecutionException: 42122 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1] at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy81.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) ... 6 common frames omitted Caused by: java.sql.SQLException: Remote org.h2.jdbc.JdbcSQLException: Column "ANON_GRP1.GCOL0" not found; SQL statement: SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1 [42122-168] at org.h2.engine.SessionRemote.done(SessionRemote.java:567) at org.h2.command.CommandRemote.prepare(CommandRemote.java:67) at org.h2.command.CommandRemote.<init>(CommandRemote.java:46) at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:439) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:626) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:744) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:730) at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405) at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:196) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:121) ... 18 common frames omitted {code} {code:xml|title=vdb} <vdb name="teiid4875" version="1"> <model name="pm1"> <source name="pm1" translator-name="h2-override" connection-jndi-name="java:/h2-localhost-9292-ds" /> <metadata type="DDL"> <![CDATA[ CREATE FOREIGN TABLE teiid4875g1(e1 string, e2 string, e3 string , e4 string); CREATE FOREIGN TABLE teiid4875g2(e1 string, e2 string, e3 string , e4 string); CREATE FOREIGN TABLE teiid4875g3(e1 string, e2 string, e3 string , e4 string); CREATE FOREIGN TABLE teiid4875g4(e1 string, e2 string, e3 string , e4 string); ]]></metadata> </model> <model name="pm2"> <source name="pm2" translator-name="h2-override" connection-jndi-name="java:/h2-localhost-9292-ds2" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE teiid4875g1(e1 string, e2 string, e3 string , e4 string); ]]></metadata> </model> <translator name="h2-override" type="h2"> <property name="MaxInCriteriaSize" value="2" /> <property name="SupportsInnerJoins" value="false" /> <property name="SupportsOuterJoins" value="false" /> </translator> </vdb> {code} {code:plain|title=teiid-command.log} 11:51:15,600 INFO [org.teiid.COMMAND_LOG] (New I/O worker #2) xB8yWvRcaM5p START USER COMMAND: startTime=2017-05-22 11:51:15.6 requestID=xB8yWvRcaM5p.0 txID=null sessionID=xB8yWvRcaM5p applicationName=JDBC principal=user@teiid-security vdbName=teiid4875 vdbVersion=1 sql=SELECT max(t3.e4),max(t2.e4) as s FROM pm1.teiid4875g1 as t1, pm1.teiid4875g2 as t2, pm1.teiid4875g3 as t3, pm1.teiid4875g4 as t4, pm2.teiid4875g1 as t5 WHERE t1.e1 = t2.e1 and (t2.e2 = t3.e2 and t1.e3 || t2.e3 = t3.e3) and t3.e3 = t4.e3 and t4.e4 = t5.e4 11:51:15,810 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) xB8yWvRcaM5p START DATA SRC COMMAND: startTime=2017-05-22 11:51:15.809 requestID=xB8yWvRcaM5p.0 sourceCommandID=12 executionID=0 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sql=SELECT DISTINCT g_0.e1 AS c_0, g_0.e3 AS c_1 FROM pm1.teiid4875g1 AS g_0 ORDER BY c_0 11:51:15,810 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue4) xB8yWvRcaM5p START DATA SRC COMMAND: startTime=2017-05-22 11:51:15.81 requestID=xB8yWvRcaM5p.0 sourceCommandID=16 executionID=4 txID=null modelName=pm2 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sql=SELECT DISTINCT g_0.e4 AS c_0 FROM pm2.teiid4875g1 AS g_0 ORDER BY c_0 11:51:15,810 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue2) xB8yWvRcaM5p START DATA SRC COMMAND: startTime=2017-05-22 11:51:15.81 requestID=xB8yWvRcaM5p.0 sourceCommandID=13 executionID=1 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sql=SELECT DISTINCT g_0.e1 AS c_0, g_0.e2 AS c_1, g_0.e3 AS c_2, g_0.e4 AS c_3 FROM pm1.teiid4875g2 AS g_0 ORDER BY c_0 11:51:15,810 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue3) xB8yWvRcaM5p START DATA SRC COMMAND: startTime=2017-05-22 11:51:15.81 requestID=xB8yWvRcaM5p.0 sourceCommandID=14 executionID=2 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sql=SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM pm1.teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1 11:51:15,810 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue5) xB8yWvRcaM5p START DATA SRC COMMAND: startTime=2017-05-22 11:51:15.81 requestID=xB8yWvRcaM5p.0 sourceCommandID=15 executionID=3 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sql=SELECT DISTINCT g_0.e3 AS c_0, g_0.e4 AS c_1 FROM pm1.teiid4875g4 AS g_0 ORDER BY c_0 11:51:15,816 DEBUG [org.teiid.COMMAND_LOG] (Worker4_QueryProcessorQueue5) xB8yWvRcaM5p SOURCE SRC COMMAND: endTime=2017-05-22 11:51:15.816 requestID=xB8yWvRcaM5p.0 sourceCommandID=15 executionID=3 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sourceCommand=[SELECT DISTINCT g_0.e3 AS c_0, g_0.e4 AS c_1 FROM teiid4875g4 AS g_0 ORDER BY c_0] 11:51:15,816 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue3) xB8yWvRcaM5p SOURCE SRC COMMAND: endTime=2017-05-22 11:51:15.816 requestID=xB8yWvRcaM5p.0 sourceCommandID=14 executionID=2 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sourceCommand=[SELECT anon_grp1.gcol0 AS c_0, anon_grp1.gcol1 AS c_1, anon_grp1.agg0 AS c_2 FROM teiid4875g3 AS g_0 GROUP BY anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.agg0 ORDER BY c_0, c_1] 11:51:15,816 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) xB8yWvRcaM5p SOURCE SRC COMMAND: endTime=2017-05-22 11:51:15.816 requestID=xB8yWvRcaM5p.0 sourceCommandID=12 executionID=0 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sourceCommand=[SELECT DISTINCT g_0.e1 AS c_0, g_0.e3 AS c_1 FROM teiid4875g1 AS g_0 ORDER BY c_0] 11:51:15,816 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue2) xB8yWvRcaM5p SOURCE SRC COMMAND: endTime=2017-05-22 11:51:15.816 requestID=xB8yWvRcaM5p.0 sourceCommandID=13 executionID=1 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sourceCommand=[SELECT DISTINCT g_0.e1 AS c_0, g_0.e2 AS c_1, g_0.e3 AS c_2, g_0.e4 AS c_3 FROM teiid4875g2 AS g_0 ORDER BY c_0] 11:51:15,817 DEBUG [org.teiid.COMMAND_LOG] (Worker5_QueryProcessorQueue4) xB8yWvRcaM5p SOURCE SRC COMMAND: endTime=2017-05-22 11:51:15.816 requestID=xB8yWvRcaM5p.0 sourceCommandID=16 executionID=4 txID=null modelName=pm2 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security sourceCommand=[SELECT DISTINCT g_0.e4 AS c_0 FROM teiid4875g1 AS g_0 ORDER BY c_0] 11:51:15,835 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue6) xB8yWvRcaM5p END SRC COMMAND: endTime=2017-05-22 11:51:15.835 requestID=xB8yWvRcaM5p.0 sourceCommandID=12 executionID=0 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security finalRowCount=15 cpuTime(ns)=12980517 11:51:15,836 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue3) xB8yWvRcaM5p ERROR SRC COMMAND: endTime=2017-05-22 11:51:15.836 requestID=xB8yWvRcaM5p.0 sourceCommandID=14 executionID=2 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security 11:51:15,840 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue6) xB8yWvRcaM5p END SRC COMMAND: endTime=2017-05-22 11:51:15.84 requestID=xB8yWvRcaM5p.0 sourceCommandID=13 executionID=1 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security finalRowCount=15 cpuTime(ns)=11535709 11:51:15,854 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue6) xB8yWvRcaM5p END SRC COMMAND: endTime=2017-05-22 11:51:15.854 requestID=xB8yWvRcaM5p.0 sourceCommandID=15 executionID=3 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security finalRowCount=15 cpuTime(ns)=4359862 11:51:15,860 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue6) xB8yWvRcaM5p END SRC COMMAND: endTime=2017-05-22 11:51:15.86 requestID=xB8yWvRcaM5p.0 sourceCommandID=16 executionID=4 txID=null modelName=pm2 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security finalRowCount=15 cpuTime(ns)=6678508 11:51:15,866 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue7) xB8yWvRcaM5p END SRC COMMAND: endTime=2017-05-22 11:51:15.866 requestID=xB8yWvRcaM5p.0 sourceCommandID=14 executionID=2 txID=null modelName=pm1 translatorName=h2-override sessionID=xB8yWvRcaM5p principal=user@teiid-security finalRowCount=0 cpuTime(ns)=15503645 11:51:15,873 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue7) xB8yWvRcaM5p ERROR USER COMMAND: endTime=2017-05-22 11:51:15.872 requestID=xB8yWvRcaM5p.0 txID=null sessionID=xB8yWvRcaM5p principal=user@teiid-security vdbName=teiid4875 vdbVersion=1 finalRowCount=null 11:51:15,949 INFO [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue7) xB8yWvRcaM5p END USER COMMAND: endTime=2017-05-22 11:51:15.949 requestID=xB8yWvRcaM5p.0 txID=null sessionID=xB8yWvRcaM5p principal=user@teiid-security vdbName=teiid4875 vdbVersion=1 finalRowCount=0 {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)