LATEST DETECTED DEADLOCK
------------------------
2019-07-16 12:37:48 7f25bcf1eb00
*** (1) TRANSACTION:
TRANSACTION 3010249, ACTIVE 0 sec inserting
mysql tables in use 2, locked 2
LOCK WAIT 40 lock struct(s), heap size 6544, 557 row lock(s)
MySQL thread id 537494, OS thread handle 0x7f25c990cb00, query id 3713063 10.42.1.108 sdnctl Sending data
INSERT INTO UPLOAD_CONFIG (request_id, originator_id, service_description, action, vnf_id, vnf_name, vm_name, vnf_type, vnfc_type, host_ip_address, config_indicator, content) SELECT request_id, originator_id, service_description, action, vnf_id, vnf_name, vm_name, vnf_type, vnfc_type, host_ip_address, 'Current', content FROM UPLOAD_CONFIG WHERE vnf_id = '33522854-d7bb-4fca-8102-b843ff64c606' AND config_indicator = 'Running' AND (pending_delete IS NULL OR pending_delete != 'Y')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 126 page no 75026 n bits 80 index `PRIMARY` of table `sdnctl`.`UPLOAD_CONFIG` trx table locks 2 total table locks 4  trx id 3010249 lock_mode X insert intention waiting lock hold time 0 wait time before grant 0 
*** (2) TRANSACTION:
TRANSACTION 3010242, ACTIVE 0 sec inserting
mysql tables in use 2, locked 2
40 lock struct(s), heap size 6544, 557 row lock(s)
MySQL thread id 537419, OS thread handle 0x7f25bcf1eb00, query id 3713057 10.42.1.108 sdnctl Sending data
INSERT INTO UPLOAD_CONFIG (request_id, originator_id, service_description, action, vnf_id, vnf_name, vm_name, vnf_type, vnfc_type, host_ip_address, config_indicator, content) SELECT request_id, originator_id, service_description, action, vnf_id, vnf_name, vm_name, vnf_type, vnfc_type, host_ip_address, 'Current', content FROM UPLOAD_CONFIG WHERE vnf_id = '33522854-d7bb-4fca-8102-b843ff64c609' AND config_indicator = 'Running' AND (pending_delete IS NULL OR pending_delete != 'Y')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 126 page no 75026 n bits 80 index `PRIMARY` of table `sdnctl`.`UPLOAD_CONFIG` trx table locks 2 total table locks 4  trx id 3010242 lock mode S lock hold time 0 wait time before grant 0 
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 126 page no 75026 n bits 80 index `PRIMARY` of table `sdnctl`.`UPLOAD_CONFIG` trx table locks 2 total table locks 4  trx id 3010242 lock_mode X insert intention waiting lock hold time 0 wait time before grant 0 
*** WE ROLL BACK TRANSACTION (2)