'InnoDB', '', '
=====================================
2017-12-20 17:44:42 0x7fc6c8796700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 28 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 386 srv_active, 0 srv_shutdown, 20797 srv_idle
srv_master_thread log flush and writes: 21169
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2617
OS WAIT ARRAY INFO: signal count 2359
RW-shared spins 0, rounds 4598, OS waits 1306
RW-excl spins 0, rounds 4129, OS waits 66
RW-sx spins 275, rounds 2863, OS waits 62
Spin rounds per wait: 4598.00 RW-shared, 4129.00 RW-excl, 10.41 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2017-12-20 17:30:49 0x7fc6c8670700
*** (1) TRANSACTION:
TRANSACTION 937488, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 2
MySQL thread id 109, OS thread handle 140491738633984, query id 15725 localhost 127.0.0.1 root update
INSERT INTO USER_CUSTOMER (USER_ID,CLIENT_ID,TX_ID) values ( 87,4,1) ON DUPLICATE KEY UPDATE TX_ID = 1 , id =last_insert_id(id)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 972 page no 4 n bits 128 index UC_UK of table `um`.`USER_CUSTOMER` trx id 937488 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) TRANSACTION:
TRANSACTION 937487, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1136, 6 row lock(s), undo log entries 2
MySQL thread id 110, OS thread handle 140491742447360, query id 15697 localhost 127.0.0.1 root update
INSERT INTO USER_CUSTOMER (USER_ID,CLIENT_ID,TX_ID) values ( 86,38,1) ON DUPLICATE KEY UPDATE TX_ID = 1 , id =last_insert_id(id)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 972 page no 4 n bits 128 index UC_UK of table `um`.`USER_CUSTOMER` trx id 937487 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 972 page no 4 n bits 128 index UC_UK of table `um`.`USER_CUSTOMER` trx id 937487 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
 0: len 8; hex 73757072656d756d; asc supremum;;

*** WE ROLL BACK TRANSACTION (1)