14:39:12,310 DEBUG [org.teiid.TRANSPORT] (New I/O worker #7) processing message:MessageHolder: key=0 contents=[B@7df7a58a 14:39:12,311 DEBUG [org.teiid.SECURITY] (New I/O worker #7) authenticateUser jdurani JDBC 14:39:12,311 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful for " jdurani " 14:39:12,312 DEBUG [org.teiid.SECURITY] (New I/O worker #7) Logon successful, created session: sessionid=ovw1n8r5etW9; userName=jdurani@teiid-security; vdbName=odata; vdbVersion=1; createdTime=Thu Jun 11 14:39:12 CEST 2015; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=null; IPAddress=127.0.0.1; securityDomain=teiid-security; lastPingTime=Thu Jun 11 14:39:12 CEST 2015 14:39:12,312 DEBUG [org.teiid.TRANSPORT] (New I/O worker #7) send message: MessageHolder: key=0 contents=[B@42c45efe 14:39:12,333 DEBUG [org.teiid.TRANSPORT] (New I/O worker #7) processing message:MessageHolder: key=1 contents=Invoke interface org.teiid.client.DQP.executeRequest 14:39:12,334 TRACE [org.teiid.PROCESSOR] (New I/O worker #7) before executeRequest:org.teiid.dqp.internal.process.DQPCore@18d92423(0,org.teiid.client.RequestMessage@624c4375) 14:39:12,334 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #7) START USER COMMAND: startTime=2015-06-11 14:39:12.334 requestID=ovw1n8r5etW9.0 txID=null sessionID=ovw1n8r5etW9 applicationName=JDBC principal=jdurani@teiid-security vdbName=odata vdbVersion=1 sql=[UPDATE BQT.SmallA SET BigDecimalValue = 10.0 WHERE IntNum = 1, UPDATE BQT.SmallA SET BigDecimalValue = 20.0 WHERE IntNum = 2, UPDATE BQT.SmallA SET BigDecimalValue = 30.0 WHERE IntKey > 4, UPDATE BQT.SmallA SET BigDecimalValue = 40.0 WHERE IntKey < 2] 14:39:12,335 TRACE [org.teiid.RUNTIME] (Worker0_QueryProcessorQueue1) Beginning work with virtual worker Worker0_QueryProcessorQueue1 14:39:12,335 TRACE [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0 start processing MORE_WORK 14:39:12,335 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) Request Thread ovw1n8r5etW9.0 with state NEW 14:39:12,335 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0 Non-cachable command. 14:39:12,336 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0 executing [UPDATE BQT.SmallA SET BigDecimalValue = 10.0 WHERE IntNum = 1, UPDATE BQT.SmallA SET BigDecimalValue = 20.0 WHERE IntNum = 2, UPDATE BQT.SmallA SET BigDecimalValue = 30.0 WHERE IntKey > 4, UPDATE BQT.SmallA SET BigDecimalValue = 40.0 WHERE IntKey < 2] 14:39:12,344 TRACE [org.teiid.PLANNER.RESOLVER] (Worker0_QueryProcessorQueue1) Resolving command BatchedUpdate{U,U,U,U} 14:39:12,344 TRACE [org.teiid.PLANNER.RESOLVER] (Worker0_QueryProcessorQueue1) Resolving command UPDATE BQT.SmallA SET BigDecimalValue = 10.0 WHERE IntNum = 1 14:39:12,345 TRACE [org.teiid.PLANNER.RESOLVER] (Worker0_QueryProcessorQueue1) Resolving command UPDATE BQT.SmallA SET BigDecimalValue = 20.0 WHERE IntNum = 2 14:39:12,345 TRACE [org.teiid.PLANNER.RESOLVER] (Worker0_QueryProcessorQueue1) Resolving command UPDATE BQT.SmallA SET BigDecimalValue = 30.0 WHERE IntKey > 4 14:39:12,346 TRACE [org.teiid.PLANNER.RESOLVER] (Worker0_QueryProcessorQueue1) Resolving command UPDATE BQT.SmallA SET BigDecimalValue = 40.0 WHERE IntKey < 2 14:39:12,347 TRACE [org.teiid.PROCESSOR] (New I/O worker #7) after executeRequest : org.teiid.client.util.ResultsFuture@147b24f2 14:39:12,348 TRACE [org.teiid.PLANNER] (Worker0_QueryProcessorQueue1) ============================================================================ USER COMMAND: BatchedUpdate{U,U,U,U} ---------------------------------------------------------------------------- OPTIMIZE: BatchedUpdate{U,U,U,U} ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: BatchedUpdatePlan { ProjectNode(0) output=[Count] [Count] BatchedUpdateNode(1) output=[Count] } ============================================================================ 14:39:12,348 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ProcessTree for ovw1n8r5etW9.0 BatchedUpdatePlan { ProjectNode(0) output=[Count] [Count] BatchedUpdateNode(1) output=[Count] } 14:39:12,348 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@16de2e62(ovw1n8r5etW9) 14:39:12,349 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) after getOrCreateTransactionContext : ovw1n8r5etW9 NONE ID:NONE 14:39:12,350 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) before begin:org.teiid.dqp.internal.process.TransactionServerImpl@16de2e62(ovw1n8r5etW9 NONE ID:NONE) 14:39:12,352 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) after begin : null 14:39:12,352 TRACE [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue1) PLAN USER COMMAND: endTime=2015-06-11 14:39:12.352 requestID=ovw1n8r5etW9.0 txID=null sessionID=ovw1n8r5etW9 principal=jdurani@teiid-security vdbName=odata vdbVersion=1 finalRowCount=null plan=BatchedUpdatePlan + Output Columns:Count (integer) + Batch Plan 0: ProjectNode + Output Columns:Count (integer) + Child 0: BatchedUpdateNode + Output Columns:Count (integer) + Select Columns:Count 14:39:12,354 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue1) Creating TupleBuffer: 1 [Count] [class java.lang.Integer] batch size 2048 of type PROCESSOR 14:39:12,355 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) before resume:org.teiid.dqp.internal.process.TransactionServerImpl@16de2e62(ovw1n8r5etW9 REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:-325c3ed4:55798148:12 status: ActionStatus.RUNNING >) 14:39:12,355 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) after resume : null 14:39:12,355 TRACE [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue1) Reserving buffer space 114688 FORCE 14:39:12,356 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Create State 14:39:12,356 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Processing NEW request: BatchedUpdate{U,U,U,U} 14:39:12,357 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Obtained execution 14:39:12,357 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue1) START DATA SRC COMMAND: startTime=2015-06-11 14:39:12.357 requestID=ovw1n8r5etW9.0 sourceCommandID=1 executionID=1 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-325c3ed4:55798148:12 status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=ovw1n8r5etW9 principal=jdurani@teiid-security sql=BatchedUpdate{U,U,U,U} 14:39:12,357 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) Source-specific command: UPDATE smalla SET BigDecimalValue = 10.0 WHERE smalla.IntNum = 1 14:39:12,357 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) Source-specific command: UPDATE smalla SET BigDecimalValue = 20.0 WHERE smalla.IntNum = 2 14:39:12,358 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) Source-specific command: UPDATE smalla SET BigDecimalValue = 30.0 WHERE smalla.IntKey > 4 14:39:12,359 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) Source-specific command: UPDATE smalla SET BigDecimalValue = 40.0 WHERE smalla.IntKey < 2 14:39:12,359 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Executed command 14:39:12,359 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Processing MORE request 14:39:12,360 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Getting results from connector 14:39:12,360 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue1) ERROR SRC COMMAND: endTime=2015-06-11 14:39:12.36 requestID=ovw1n8r5etW9.0 sourceCommandID=1 executionID=1 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-325c3ed4:55798148:12 status: ActionStatus.RUNNING > modelName=Source translatorName=postgresql sessionID=ovw1n8r5etW9 principal=jdurani@teiid-security finalRowCount=null 14:39:12,360 ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) Connector worker process failed for atomic-request=ovw1n8r5etW9.0.1.1: java.lang.NullPointerException at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.next(ConnectorWorkItem.java:378) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:396) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:205) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.BatchedUpdateNode.nextBatchDirect(BatchedUpdateNode.java:135) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchedUpdatePlan.nextBatch(BatchedUpdatePlan.java:151) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:450) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:332) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:260) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_71] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_71] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71] 14:39:12,361 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue1) ERROR USER COMMAND: endTime=2015-06-11 14:39:12.361 requestID=ovw1n8r5etW9.0 txID=TransactionImple < ac, BasicAction: 0:ffff7f000001:-325c3ed4:55798148:12 status: ActionStatus.RUNNING > sessionID=ovw1n8r5etW9 principal=jdurani@teiid-security vdbName=odata vdbVersion=1 finalRowCount=null 14:39:12,361 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) TEIID30019 Unexpected exception for request ovw1n8r5etW9.0: java.lang.NullPointerException at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.next(ConnectorWorkItem.java:378) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:396) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:205) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.BatchedUpdateNode.nextBatchDirect(BatchedUpdateNode.java:135) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchedUpdatePlan.nextBatch(BatchedUpdatePlan.java:151) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:450) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:332) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:260) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.redhat-2.jar:8.7.3.redhat-2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_71] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_71] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71] 14:39:12,362 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) QueryProcessor: closing processor 14:39:12,362 TRACE [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue1) Releasing buffer space 114688 14:39:12,362 TRACE [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) closed atomic-request: ovw1n8r5etW9.0.1.1 14:39:12,362 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Remove State 14:39:12,363 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Processing Close : BatchedUpdate{U,U,U,U} 14:39:12,363 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Closed execution 14:39:12,363 DEBUG [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0.1.1 Closed connection 14:39:12,363 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) Removing tuplesource for the request ovw1n8r5etW9.0 14:39:12,363 DEBUG [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue1) Removing TupleBuffer: 1 14:39:12,363 TRACE [org.teiid.BUFFER_MGR] (Worker0_QueryProcessorQueue1) Releasing orphaned buffer space 114688 14:39:12,364 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) before rollback:org.teiid.dqp.internal.process.TransactionServerImpl@16de2e62(ovw1n8r5etW9 REQUEST ID:TransactionImple < ac, BasicAction: 0:ffff7f000001:-325c3ed4:55798148:12 status: ActionStatus.RUNNING >) 14:39:12,365 DEBUG [org.teiid.TXN_LOG] (Worker0_QueryProcessorQueue1) after rollback : null 14:39:12,365 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) java.lang.NullPointerException Sending error to client ovw1n8r5etW9.0 14:39:12,365 DEBUG [org.teiid.TRANSPORT] (Worker0_QueryProcessorQueue1) send message: MessageHolder: key=1 contents=ResultsMessage rowCount=0 finalRow=-1 14:39:12,371 TRACE [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0 end processing WORKING 14:39:12,372 TRACE [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue1) ovw1n8r5etW9.0 done processing WORKING 14:39:12,417 DEBUG [org.teiid.TRANSPORT] (New I/O worker #7) Channel closed 14:39:12,418 DEBUG [org.teiid.SECURITY] (New I/O worker #7) closeSession ovw1n8r5etW9 14:39:12,418 DEBUG [org.teiid.TXN_LOG] (New I/O worker #7) before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@16de2e62(ovw1n8r5etW9,false) 14:39:12,418 DEBUG [org.teiid.TXN_LOG] (New I/O worker #7) after cancelTransactions : null