2019-08-02 17:11:04,676 TRACE [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Begin transaction threadId=zQviPsbtOB3h transactionId=NONE 2019-08-02 17:11:04,693 TRACE [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Finish begin transaction threadId=zQviPsbtOB3h transactionId=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffc0a8008c:-3ccc1e9e:5d4451f8:22 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) 2019-08-02 17:11:04,694 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Create State 2019-08-02 17:11:04,695 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing NEW request: SELECT g_0.id, g_0.user_id, g_0.reference, g_0.originalReference, g_0.type, g_0.amount, g_0.discount, g_0.currency, g_0.isProcessed, g_0.isCancelled, g_0.success, g_0.createdAt, g_0.updatedAt, g_0.log, g_0.paymentMethod, g_0.status, g_0.purchaseOrder_id, g_0.lockDate, g_0.version, g_0.paymentGateway, g_0.testChargeOnly FROM lingoda_read_replica.transaction AS g_0 2019-08-02 17:11:04,824 WARN [com.arjuna.ats.arjuna] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h ARJUNA012142: You have chosen to enable multiple last resources in the transaction manager. This is transactionally unsafe and should not be relied upon. 2019-08-02 17:11:04,882 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained execution 2019-08-02 17:11:04,886 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Source-specific command: SELECT g_0.`id`, g_0.`user_id`, g_0.`reference`, g_0.`originalReference`, g_0.`type`, g_0.`amount`, g_0.`discount`, g_0.`currency`, case when g_0.`isProcessed` is null then null when g_0.`isProcessed` = -1 or g_0.`isProcessed` > 0 then 1 else 0 end, case when g_0.`isCancelled` is null then null when g_0.`isCancelled` = -1 or g_0.`isCancelled` > 0 then 1 else 0 end, case when g_0.`success` is null then null when g_0.`success` = -1 or g_0.`success` > 0 then 1 else 0 end, g_0.`createdAt`, g_0.`updatedAt`, g_0.`log`, g_0.`paymentMethod`, g_0.`status`, g_0.`purchaseOrder_id`, g_0.`lockDate`, g_0.`version`, g_0.`paymentGateway`, case when g_0.`testChargeOnly` is null then null when g_0.`testChargeOnly` = -1 or g_0.`testChargeOnly` > 0 then 1 else 0 end FROM `linguando`.`transaction` AS g_0 2019-08-02 17:12:03,977 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Executed command 2019-08-02 17:12:03,977 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:12:03,977 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:12:04,029 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 512 2019-08-02 17:12:04,030 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:12:04,030 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:12:04,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 1024 2019-08-02 17:12:04,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Create State 2019-08-02 17:12:04,055 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:12:04,055 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:12:04,080 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 1536 2019-08-02 17:12:04,080 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing NEW request: INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:12:04,126 WARN [com.arjuna.ats.arjuna] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h ARJUNA012141: Multiple last resources have been added to the current transaction. This is transactionally unsafe and should not be relied upon. Current resource is LastResourceRecord(XAOnePhaseResource(LocalXAResourceImpl@72b02a1b[connectionListener=4c438bc5 connectionManager=222e8322 warned=false currentXid=< formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a8008c:-3ccc1e9e:5d4451f8:22, node_name=1, branch_uid=0:ffffc0a8008c:-3ccc1e9e:5d4451f8:27, subordinatenodename=null, eis_name=java:/lingoda_read_replica > productName=MySQL productVersion=5.6.34-log jndiName=java:/lingoda_read_replica])) 2019-08-02 17:12:04,127 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained execution 2019-08-02 17:12:04,127 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Source-specific command: INSERT INTO "business_process"."test_datavirt_3" ("id", "user_id", "reference", "originalreference", "type", "amount", "discount", "currency", "isprocessed", "iscancelled", "success", "createdat", "updatedat", "log", "paymentmethod", "status", "purchaseorder_id", "lockdate", "version", "paymentgateway", "testchargeonly") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Executed command 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing MORE request 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Getting results from connector 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained results from connector, current row count: 256 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing MORE request 2019-08-02 17:12:04,621 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Getting results from connector 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained results from connector, current row count: 512 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing MORE request 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Getting results from connector 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained results from connector, current row count: 768 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing MORE request 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Getting results from connector 2019-08-02 17:12:04,622 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained results from connector, current row count: 1024 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing MORE request 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Getting results from connector 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Obtained last batch, total row count: 1024 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Remove State 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Processing Close : INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Closed execution 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.2 Closed connection 2019-08-02 17:12:04,623 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:12:04,624 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:12:04,628 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 2048 2019-08-02 17:12:04,629 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.3 Create State 2019-08-02 17:12:04,629 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:12:04,629 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:12:04,634 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 2560 2019-08-02 17:12:04,634 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.3 Processing NEW request: INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:12:04,634 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.3 Obtained execution 2019-08-02 17:14:47,733 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.509 Processing Close : INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:14:47,733 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.509 Closed execution 2019-08-02 17:14:47,733 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.509 Closed connection 2019-08-02 17:14:47,733 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:14:47,733 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:14:47,736 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained results from connector, current row count: 521216 2019-08-02 17:14:47,736 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Create State 2019-08-02 17:14:47,736 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing MORE request 2019-08-02 17:14:47,736 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Getting results from connector 2019-08-02 17:14:47,738 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Obtained last batch, total row count: 521682 2019-08-02 17:14:47,738 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing NEW request: INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:14:47,738 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained execution 2019-08-02 17:14:47,738 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Source-specific command: INSERT INTO "business_process"."test_datavirt_3" ("id", "user_id", "reference", "originalreference", "type", "amount", "discount", "currency", "isprocessed", "iscancelled", "success", "createdat", "updatedat", "log", "paymentmethod", "status", "purchaseorder_id", "lockdate", "version", "paymentgateway", "testchargeonly") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Executed command 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing MORE request 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Getting results from connector 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained results from connector, current row count: 256 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing MORE request 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Getting results from connector 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained results from connector, current row count: 512 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing MORE request 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Getting results from connector 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained results from connector, current row count: 768 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing MORE request 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Getting results from connector 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained results from connector, current row count: 1024 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing MORE request 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Getting results from connector 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Obtained last batch, total row count: 1024 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Remove State 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Processing Close : INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Closed execution 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.510 Closed connection 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Remove State 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Processing Close : SELECT g_0.id, g_0.user_id, g_0.reference, g_0.originalReference, g_0.type, g_0.amount, g_0.discount, g_0.currency, g_0.isProcessed, g_0.isCancelled, g_0.success, g_0.createdAt, g_0.updatedAt, g_0.log, g_0.paymentMethod, g_0.status, g_0.purchaseOrder_id, g_0.lockDate, g_0.version, g_0.paymentGateway, g_0.testChargeOnly FROM lingoda_read_replica.transaction AS g_0 2019-08-02 17:14:48,052 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Closed execution 2019-08-02 17:14:48,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.1.1 Closed connection 2019-08-02 17:14:48,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Create State 2019-08-02 17:14:48,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Processing NEW request: INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:14:48,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Obtained execution 2019-08-02 17:14:48,053 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Source-specific command: INSERT INTO "business_process"."test_datavirt_3" ("id", "user_id", "reference", "originalreference", "type", "amount", "discount", "currency", "isprocessed", "iscancelled", "success", "createdat", "updatedat", "log", "paymentmethod", "status", "purchaseorder_id", "lockdate", "version", "paymentgateway", "testchargeonly") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Executed command 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Processing MORE request 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Getting results from connector 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Obtained results from connector, current row count: 256 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Processing MORE request 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Getting results from connector 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Obtained last batch, total row count: 463 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Remove State 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Processing Close : INSERT INTO storage77.test_datavirt_3 (id, user_id, reference, originalreference, type, amount, discount, currency, isprocessed, iscancelled, success, createdat, updatedat, log, paymentmethod, status, purchaseorder_id, lockdate, version, paymentgateway, testchargeonly) VALUES (...) 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Closed execution 2019-08-02 17:14:48,171 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h zQviPsbtOB3h.13.0.511 Closed connection 2019-08-02 17:14:48,171 TRACE [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h Commit transaction threadId=zQviPsbtOB3h transactionId=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffc0a8008c:-3ccc1e9e:5d4451f8:22 status: ActionStatus.RUNNING >, owner=Local transaction context for provider JBoss JTA transaction provider) 2019-08-02 17:14:48,237 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (Worker1_QueryProcessorQueue33) zQviPsbtOB3h IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@4c438bc5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@2f7d6958 connection handles=0 lastReturned=1564758664673 lastValidated=1564758664672 lastCheckedOut=1564758664744 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4bced85c mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@160eaa84[pool=lingoda_read_replica] xaResource=LocalXAResourceImpl@72b02a1b[connectionListener=4c438bc5 connectionManager=222e8322 warned=false currentXid=null productName=MySQL productVersion=5.6.34-log jndiName=java:/lingoda_read_replica] txSync=TransactionSynchronization@1813907131{tx=Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffffc0a8008c:-3ccc1e9e:5d4451f8:22 status: ActionStatus.PREPARING >, owner=Local transaction context for provider JBoss JTA transaction provider) wasTrackByTx=true enlisted=true cancel=false}]: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1700) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:96) at org.jboss.jca.core.tx.jbossts.LocalXAResourceImpl.commit(LocalXAResourceImpl.java:172) at com.arjuna.ats.internal.jta.resources.arjunacore.XAOnePhaseResource.commit(XAOnePhaseResource.java:120) at com.arjuna.ats.internal.arjuna.abstractrecords.LastResourceRecord.topLevelPrepare(LastResourceRecord.java:152) at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2664) at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2614) at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2157) at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1503) at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:96) at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288) at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126) at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:89) at org.wildfly.transaction.client.LocalTransaction.commitAndDissociate(LocalTransaction.java:77) at org.wildfly.transaction.client.ContextTransactionManager.commit(ContextTransactionManager.java:71) at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:386) at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:520) 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.logging.LogManager$LoggingProxy.invoke(LogManager.java:117) at com.sun.proxy.$Proxy27.commit(Unknown Source) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:514) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:43) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:281) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:113) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:199) 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)