2019-07-25 14:55:42,257 DEBUG [org.teiid.TRANSPORT] (NIO1) 1024 key exchange being used. 2019-07-25 14:55:42,396 DEBUG [org.teiid.TRANSPORT] (NIO1) processing message:MessageHolder: key=0 contents=[B@2a38ebe7 2019-07-25 14:55:42,406 DEBUG [org.teiid.AUDIT_LOG] (NIO1) [SvcSourceVdb_json11, null user USERPASSWORD localhost.bitwiseglobal.net 127.0.0.1 null false] 2019-07-25 14:55:42,406 DEBUG [org.teiid.SECURITY] (NIO1) authenticateUser user JDBC 2019-07-25 14:55:42,455 DEBUG [org.teiid.SECURITY] (NIO1) Logon successful for " user " in security domain teiid-security 2019-07-25 14:55:42,456 DEBUG [org.teiid.SECURITY] (NIO1) Logon successful, created session: sessionid=QMyoDDOdnAiW; userName=user; vdbName=SvcSourceVdb_json11; vdbVersion=1; createdTime=Thu Jul 25 14:55:42 IST 2019; applicationName=JDBC; clientHostName=localhost.bitwiseglobal.net; clientHardwareAddress=null; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Thu Jul 25 14:55:42 IST 2019 2019-07-25 14:55:42,457 DEBUG [org.teiid.AUDIT_LOG] (NIO1) [user] 2019-07-25 14:55:42,464 DEBUG [org.teiid.TRANSPORT] (NIO1) send message: MessageHolder: key=0 contents=[B@1e08fbd6 2019-07-25 14:55:42,525 DEBUG [org.teiid.TRANSPORT] (NIO1) processing message:MessageHolder: key=1 contents=Invoke interface org.teiid.client.DQP.executeRequest 2 2019-07-25 14:55:42,528 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW Request Thread QMyoDDOdnAiW.0 with state NEW 2019-07-25 14:55:42,528 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0 Command has no cache hint and result set cache mode is not on. 2019-07-25 14:55:42,528 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0 executing SELECT * from emp 2019-07-25 14:55:42,544 DEBUG [org.teiid.PLANNER] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW [LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[f], props={NESTED_COMMAND=EXEC json11.getFiles('abc.json'), SYMBOL_MAP={f.file=json11.getFiles.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[x], props={TABLE_FUNCTION=XMLTABLE('/emp/employees' PASSING JSONTOXML('emp', f.file) COLUMNS name string PATH '../name', email string PATH '../email') AS x, CORRELATED_REFERENCES={f.file=f.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[f], props={NESTED_COMMAND=EXEC json11.getFiles('abc.json'), SYMBOL_MAP={f.file=json11.getFiles.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[x], props={TABLE_FUNCTION=XMLTABLE('/emp/employees' PASSING JSONTOXML('emp', f.file) COLUMNS name string PATH '../name', email string PATH '../email') AS x, CORRELATED_REFERENCES={f.file=f.file}, OUTPUT_COLS=null}, MEDIUM [XQuery Planning] The column path contains an invalid reverse axis ../name - Document streaming will not be used, MEDIUM [XQuery Planning] Projection conditions met for /emp/employees - Document projection will be used] 2019-07-25 14:55:42,544 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW ProcessTree for QMyoDDOdnAiW.0 ProjectNode(0) output=[x.name, x.email] [x.name, x.email] JoinNode(1) [NESTED TABLE JOIN] [CROSS JOIN] output=[x.name, x.email] ProjectNode(2) output=[f.file] [json11.getFiles.file] AccessNode(3) output=[json11.getFiles.file, json11.getFiles.filePath, json11.getFiles.lastModified, json11.getFiles.created, json11.getFiles.size] EXEC json11.getFiles('abc.json') XMLTableNode(4) output=[x.name, x.email] 2019-07-25 14:55:42,544 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@1076773f(QMyoDDOdnAiW) 2019-07-25 14:55:42,545 DEBUG [org.teiid.TXN_LOG] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW after getOrCreateTransactionContext : QMyoDDOdnAiW NONE ID:NONE 2019-07-25 14:55:42,545 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW Creating TupleBuffer: 116 [json11_viewModel.emp.name, json11_viewModel.emp.email] [class java.lang.String, class java.lang.String] batch size 512 of type PROCESSOR 2019-07-25 14:55:42,547 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Create State 2019-07-25 14:55:42,568 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW Running task for parent thread Worker2_QueryProcessorQueue26 2019-07-25 14:55:42,568 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW Creating TupleBuffer: 117 [f.file] [class org.teiid.core.types.BlobType] batch size 256 of type PROCESSOR 2019-07-25 14:55:42,568 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Processing NEW request: EXEC json11.getFiles('abc.json') 2019-07-25 14:55:42,568 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Blocking on source query QMyoDDOdnAiW.0.3.0 2019-07-25 14:55:42,568 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0 Blocking on source request(s). 2019-07-25 14:55:42,568 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Blocking on source query QMyoDDOdnAiW.0.3.0 2019-07-25 14:55:42,569 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW QMyoDDOdnAiW.0 Blocking on source request(s). 2019-07-25 14:55:42,569 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue26) QMyoDDOdnAiW Request Thread QMyoDDOdnAiW.0 - processor blocked 2019-07-25 14:55:42,574 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Obtained execution 2019-07-25 14:55:42,694 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW Getting 1 file(s) 2019-07-25 14:55:42,695 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Executed command 2019-07-25 14:55:42,695 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Processing MORE request 2019-07-25 14:55:42,695 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Getting results from connector 2019-07-25 14:55:42,695 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW Getting abc.json 2019-07-25 14:55:42,709 DEBUG [org.teiid.CONNECTOR] (Worker4_QueryProcessorQueue27) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Obtained last batch, total row count: 1 2019-07-25 14:55:42,710 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW Request Thread QMyoDDOdnAiW.0 with state PROCESSING 2019-07-25 14:55:42,711 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Remove State 2019-07-25 14:55:42,711 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Processing Close : EXEC json11.getFiles('abc.json') 2019-07-25 14:55:42,711 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Closed execution 2019-07-25 14:55:42,712 DEBUG [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QMyoDDOdnAiW.0.3.0 Closed connection 2019-07-25 14:55:42,907 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW TEIID30019 Unexpected exception for request QMyoDDOdnAiW.0: java.lang.NullPointerException at org.teiid.core.types.BlobImpl.getBytes(BlobImpl.java:100) at org.teiid.core.types.BlobType.getBytes(BlobType.java:66) at org.teiid.common.buffer.LobManager.persistLob(LobManager.java:229) at org.teiid.common.buffer.LobManager.updateReferences(LobManager.java:145) at org.teiid.common.buffer.TupleBuffer.addTuple(TupleBuffer.java:171) at org.teiid.common.buffer.TupleBuffer.addTupleBatch(TupleBuffer.java:193) at org.teiid.query.processor.BatchCollector.flushBatchDirect(BatchCollector.java:226) at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:220) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:191) at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:207) at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:154) at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:252) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:195) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) 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) 2019-07-25 14:55:42,921 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QueryProcessor: closing processor 2019-07-25 14:55:42,921 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW Removing tuplesource for the request QMyoDDOdnAiW.0 2019-07-25 14:55:42,921 DEBUG [org.teiid.BUFFER_MGR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW Removing TupleBuffer: 116 2019-07-25 14:55:42,922 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW QMyoDDOdnAiW.0 Finished Processing 2019-07-25 14:55:42,922 DEBUG [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW java.lang.NullPointerException Sending error to client QMyoDDOdnAiW.0 2019-07-25 14:55:42,925 DEBUG [org.teiid.TRANSPORT] (Worker2_QueryProcessorQueue28) QMyoDDOdnAiW send message: MessageHolder: key=1 contents=ResultsMessage rowCount=0 finalRow=-1 2019-07-25 14:55:43,019 DEBUG [org.teiid.TRANSPORT] (NIO1) TEIID40114 Unhandled exception, closing client instance: An existing connection was forcibly closed by the remote host: java.io.IOException: An existing connection was forcibly closed by the remote host at sun.nio.ch.SocketDispatcher.read0(Native Method) at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43) at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223) at sun.nio.ch.IOUtil.read(IOUtil.java:192) at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380) at io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes(PooledUnsafeDirectByteBuf.java:288) at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:1100) at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:372) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:123) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:624) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:559) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:476) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:438) at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858) at java.lang.Thread.run(Thread.java:745) 2019-07-25 14:55:43,030 DEBUG [org.teiid.TRANSPORT] (NIO1) Channel closed 2019-07-25 14:55:43,030 DEBUG [org.teiid.SECURITY] (NIO1) QMyoDDOdnAiW closeSession QMyoDDOdnAiW 2019-07-25 14:55:43,030 DEBUG [org.teiid.AUDIT_LOG] (NIO1) QMyoDDOdnAiW [user] 2019-07-25 14:55:43,031 DEBUG [org.teiid.TXN_LOG] (NIO1) QMyoDDOdnAiW before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@1076773f(QMyoDDOdnAiW,false) 2019-07-25 14:55:43,031 DEBUG [org.teiid.TXN_LOG] (NIO1) QMyoDDOdnAiW after cancelTransactions : null 2019-07-25 14:58:00,841 DEBUG [org.teiid.TRANSPORT] (NIO2) 1024 key exchange being used. 2019-07-25 14:58:00,906 DEBUG [org.teiid.TRANSPORT] (NIO2) processing message:MessageHolder: key=0 contents=[B@ac85933 2019-07-25 14:58:00,907 DEBUG [org.teiid.AUDIT_LOG] (NIO2) [SvcSourceVdb_json11, null user USERPASSWORD localhost.bitwiseglobal.net 127.0.0.1 null false] 2019-07-25 14:58:00,908 DEBUG [org.teiid.SECURITY] (NIO2) authenticateUser user JDBC 2019-07-25 14:58:00,908 DEBUG [org.teiid.SECURITY] (NIO2) Logon successful for " user " in security domain teiid-security 2019-07-25 14:58:00,909 DEBUG [org.teiid.SECURITY] (NIO2) Logon successful, created session: sessionid=cZzhdo5xbiG0; userName=user; vdbName=SvcSourceVdb_json11; vdbVersion=1; createdTime=Thu Jul 25 14:58:00 IST 2019; applicationName=JDBC; clientHostName=localhost.bitwiseglobal.net; clientHardwareAddress=null; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Thu Jul 25 14:58:00 IST 2019 2019-07-25 14:58:00,909 DEBUG [org.teiid.AUDIT_LOG] (NIO2) [user] 2019-07-25 14:58:00,909 DEBUG [org.teiid.TRANSPORT] (NIO2) send message: MessageHolder: key=0 contents=[B@6fc4f016 2019-07-25 14:58:00,958 DEBUG [org.teiid.TRANSPORT] (NIO2) processing message:MessageHolder: key=1 contents=Invoke interface org.teiid.client.DQP.executeRequest 2 2019-07-25 14:58:00,960 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 Request Thread cZzhdo5xbiG0.0 with state NEW 2019-07-25 14:58:00,960 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0 Command has no cache hint and result set cache mode is not on. 2019-07-25 14:58:00,960 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0 executing SELECT * from emp 2019-07-25 14:58:00,964 DEBUG [org.teiid.PLANNER] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 [LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[f], props={NESTED_COMMAND=EXEC json11.getFiles('abc.json'), SYMBOL_MAP={f.file=json11.getFiles.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[x], props={TABLE_FUNCTION=XMLTABLE('/emp/employees' PASSING JSONTOXML('emp', f.file) COLUMNS name string PATH '../name', email string PATH '../email') AS x, CORRELATED_REFERENCES={f.file=f.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[f], props={NESTED_COMMAND=EXEC json11.getFiles('abc.json'), SYMBOL_MAP={f.file=json11.getFiles.file}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join is CROSS - Rejecting dependent join Source(groups=[x], props={TABLE_FUNCTION=XMLTABLE('/emp/employees' PASSING JSONTOXML('emp', f.file) COLUMNS name string PATH '../name', email string PATH '../email') AS x, CORRELATED_REFERENCES={f.file=f.file}, OUTPUT_COLS=null}, MEDIUM [XQuery Planning] The column path contains an invalid reverse axis ../name - Document streaming will not be used, MEDIUM [XQuery Planning] Projection conditions met for /emp/employees - Document projection will be used] 2019-07-25 14:58:00,964 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 ProcessTree for cZzhdo5xbiG0.0 ProjectNode(0) output=[x.name, x.email] [x.name, x.email] JoinNode(1) [NESTED TABLE JOIN] [CROSS JOIN] output=[x.name, x.email] ProjectNode(2) output=[f.file] [json11.getFiles.file] AccessNode(3) output=[json11.getFiles.file, json11.getFiles.filePath, json11.getFiles.lastModified, json11.getFiles.created, json11.getFiles.size] EXEC json11.getFiles('abc.json') XMLTableNode(4) output=[x.name, x.email] 2019-07-25 14:58:00,964 DEBUG [org.teiid.TXN_LOG] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@1076773f(cZzhdo5xbiG0) 2019-07-25 14:58:00,964 DEBUG [org.teiid.TXN_LOG] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 after getOrCreateTransactionContext : cZzhdo5xbiG0 NONE ID:NONE 2019-07-25 14:58:00,964 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 Creating TupleBuffer: 118 [json11_viewModel.emp.name, json11_viewModel.emp.email] [class java.lang.String, class java.lang.String] batch size 512 of type PROCESSOR 2019-07-25 14:58:00,965 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Create State 2019-07-25 14:58:00,966 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 Creating TupleBuffer: 119 [f.file] [class org.teiid.core.types.BlobType] batch size 256 of type PROCESSOR 2019-07-25 14:58:00,966 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Blocking on source query cZzhdo5xbiG0.0.3.1 2019-07-25 14:58:00,966 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0 Blocking on source request(s). 2019-07-25 14:58:00,966 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Blocking on source query cZzhdo5xbiG0.0.3.1 2019-07-25 14:58:00,966 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 cZzhdo5xbiG0.0 Blocking on source request(s). 2019-07-25 14:58:00,966 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue29) cZzhdo5xbiG0 Request Thread cZzhdo5xbiG0.0 - processor blocked 2019-07-25 14:58:00,967 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue30) cZzhdo5xbiG0 Running task for parent thread Worker7_QueryProcessorQueue29 2019-07-25 14:58:00,968 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue30) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Processing NEW request: EXEC json11.getFiles('abc.json') 2019-07-25 14:58:00,968 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue30) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Obtained execution 2019-07-25 14:58:00,976 WARN [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue30) cZzhdo5xbiG0 Connector worker process failed for atomic-request=cZzhdo5xbiG0.0.3.1: org.teiid.translator.TranslatorException: Can not open multiple ftp stream based file in one connection at org.teiid.translator.file.FileExecutionFactory$VirtualFileProcedureExecution.execute(FileExecutionFactory.java:208) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:392) 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:229) at com.sun.proxy.$Proxy36.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) 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: javax.resource.ResourceException: Can not open multiple ftp stream based file in one connection at org.teiid.resource.adapter.ftp.FtpFileConnectionImpl.getFiles(FtpFileConnectionImpl.java:81) at org.teiid.translator.file.FileExecutionFactory$VirtualFileProcedureExecution.execute(FileExecutionFactory.java:206) ... 18 more 2019-07-25 14:58:00,978 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 Request Thread cZzhdo5xbiG0.0 with state PROCESSING 2019-07-25 14:58:00,980 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Remove State 2019-07-25 14:58:00,980 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Processing Close : EXEC json11.getFiles('abc.json') 2019-07-25 14:58:00,981 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Closed execution 2019-07-25 14:58:00,981 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 cZzhdo5xbiG0.0.3.1 Closed connection 2019-07-25 14:58:00,981 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 QueryProcessor: closing processor 2019-07-25 14:58:00,982 WARN [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 TEIID30020 Processing exception for request cZzhdo5xbiG0.0 'TEIID30504 json11: Can not open multiple ftp stream based file in one connection'. Originally TeiidProcessingException FtpFileConnectionImpl.java:81.: org.teiid.core.TeiidProcessingException: TEIID30504 json11: Can not open multiple ftp stream based file in one connection at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:401) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:207) at org.teiid.query.processor.relational.SourceState.rowCountLE(SourceState.java:154) at org.teiid.query.processor.relational.JoinNode.nextBatchDirectInternal(JoinNode.java:252) at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:195) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) 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: Can not open multiple ftp stream based file in one connection at org.teiid.translator.file.FileExecutionFactory$VirtualFileProcedureExecution.execute(FileExecutionFactory.java:208) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:392) 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:229) at com.sun.proxy.$Proxy36.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) ... 6 more Caused by: javax.resource.ResourceException: Can not open multiple ftp stream based file in one connection at org.teiid.resource.adapter.ftp.FtpFileConnectionImpl.getFiles(FtpFileConnectionImpl.java:81) at org.teiid.translator.file.FileExecutionFactory$VirtualFileProcedureExecution.execute(FileExecutionFactory.java:206) ... 18 more 2019-07-25 14:58:00,983 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 Removing tuplesource for the request cZzhdo5xbiG0.0 2019-07-25 14:58:00,983 DEBUG [org.teiid.BUFFER_MGR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 Removing TupleBuffer: 118 2019-07-25 14:58:00,983 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 cZzhdo5xbiG0.0 Finished Processing 2019-07-25 14:58:00,983 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 org.teiid.core.TeiidProcessingException: TEIID30504 json11: Can not open multiple ftp stream based file in one connection Sending error to client cZzhdo5xbiG0.0 2019-07-25 14:58:00,984 DEBUG [org.teiid.TRANSPORT] (Worker7_QueryProcessorQueue31) cZzhdo5xbiG0 send message: MessageHolder: key=1 contents=ResultsMessage rowCount=0 finalRow=-1 2019-07-25 14:58:01,061 DEBUG [org.teiid.TRANSPORT] (NIO2) TEIID40114 Unhandled exception, closing client instance: An existing connection was forcibly closed by the remote host: java.io.IOException: An existing connection was forcibly closed by the remote host at sun.nio.ch.SocketDispatcher.read0(Native Method) at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43) at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223) at sun.nio.ch.IOUtil.read(IOUtil.java:192) at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:380) at io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes(PooledUnsafeDirectByteBuf.java:288) at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:1100) at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:372) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:123) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:624) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:559) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:476) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:438) at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858) at java.lang.Thread.run(Thread.java:745) 2019-07-25 14:58:01,062 DEBUG [org.teiid.TRANSPORT] (NIO2) Channel closed 2019-07-25 14:58:01,062 DEBUG [org.teiid.SECURITY] (NIO2) cZzhdo5xbiG0 closeSession cZzhdo5xbiG0 2019-07-25 14:58:01,062 DEBUG [org.teiid.AUDIT_LOG] (NIO2) cZzhdo5xbiG0 [user] 2019-07-25 14:58:01,062 DEBUG [org.teiid.TXN_LOG] (NIO2) cZzhdo5xbiG0 before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@1076773f(cZzhdo5xbiG0,false) 2019-07-25 14:58:01,064 DEBUG [org.teiid.TXN_LOG] (NIO2) cZzhdo5xbiG0 after cancelTransactions : null