------------------------
LATEST DETECTED DEADLOCK
------------------------
160901 15:19:22
*** (1) TRANSACTION:
TRANSACTION 1F47CB57, ACTIVE 3 sec, process no 1941, OS thread id 140406859773696 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 7 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 2
MySQL thread id 33485, query id 304629512 172.31.110.154 foreman Updating
UPDATE `operatingsystems` SET `hosts_count` = COALESCE(`hosts_count`, 0) + 1 WHERE `operatingsystems`.`id` = 16
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 507 page no 3 n bits 88 index `PRIMARY` of table `foreman`.`operatingsystems` trx id 1F47CB57 lock_mode X locks rec but not gap waiting
Record lock, heap no 15 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80000010; asc     ;;
 1: len 6; hex 00001f477be1; asc    G{ ;;
 2: len 7; hex 00000002c22989; asc      ) ;;
 3: len 1; hex 36; asc 6;;
 4: len 6; hex 526564486174; asc RedHat;;
 5: len 1; hex 38; asc 8;;
 6: SQL NULL;
 7: len 8; hex 80001255fc19db0d; asc    U    ;;
 8: len 8; hex 80001255fc1a2f0d; asc    U  / ;;
 9: len 0; hex ; asc ;;
 10: len 6; hex 526564686174; asc Redhat;;
 11: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;
 12: len 4; hex 8000000a; asc     ;;
 13: len 4; hex 80000001; asc     ;;
 14: len 6; hex 534841353132; asc SHA512;;
 15: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;
*** (2) TRANSACTION:
TRANSACTION 1F47CB59, ACTIVE 3 sec, process no 1941, OS thread id 140408185693952 starting index read
mysql tables in use 1, locked 1
7 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 2
MySQL thread id 33799, query id 304629513 172.31.110.154 foreman Updating
UPDATE `operatingsystems` SET `hosts_count` = COALESCE(`hosts_count`, 0) + 1 WHERE `operatingsystems`.`id` = 16

*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 507 page no 3 n bits 88 index `PRIMARY` of table `foreman`.`operatingsystems` trx id 1F47CB59 lock mode S locks rec but not gap
Record lock, heap no 15 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80000010; asc     ;;
 1: len 6; hex 00001f477be1; asc    G{ ;;
 2: len 7; hex 00000002c22989; asc      ) ;;
 3: len 1; hex 36; asc 6;;
 4: len 6; hex 526564486174; asc RedHat;;
 5: len 1; hex 38; asc 8;;
 6: SQL NULL;
 7: len 8; hex 80001255fc19db0d; asc    U    ;;
 8: len 8; hex 80001255fc1a2f0d; asc    U  / ;;
 9: len 0; hex ; asc ;;
 10: len 6; hex 526564686174; asc Redhat;;
 11: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;
 12: len 4; hex 8000000a; asc     ;;
 13: len 4; hex 80000001; asc     ;;
 14: len 6; hex 534841353132; asc SHA512;;
 15: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 507 page no 3 n bits 88 index `PRIMARY` of table `foreman`.`operatingsystems` trx id 1F47CB59 lock_mode X locks rec but not gap waiting
Record lock, heap no 15 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
 0: len 4; hex 80000010; asc     ;;
 1: len 6; hex 00001f477be1; asc    G{ ;;
 2: len 7; hex 00000002c22989; asc      ) ;;
 3: len 1; hex 36; asc 6;;
 4: len 6; hex 526564486174; asc RedHat;;
 5: len 1; hex 38; asc 8;;
 6: SQL NULL;
 7: len 8; hex 80001255fc19db0d; asc    U    ;;
 8: len 8; hex 80001255fc1a2f0d; asc    U  / ;;
 9: len 0; hex ; asc ;;
 10: len 6; hex 526564686174; asc Redhat;;
 11: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;
 12: len 4; hex 8000000a; asc     ;;
 13: len 4; hex 80000001; asc     ;;
 14: len 6; hex 534841353132; asc SHA512;;
 15: len 15; hex 5248454c2053657276657220362e38; asc RHEL Server 6.8;;

*** WE ROLL BACK TRANSACTION (2)