gistfile1.txt

LATEST DETECTED DEADLOCK
------------------------
2019-02-12 12:39:08 0x2b705d3d2700
*** (1) TRANSACTION:
TRANSACTION 6032621, ACTIVE 1 sec fetching rows
mysql tables in use 4, locked 4
LOCK WAIT 1865 lock struct(s), heap size 237776, 883 row lock(s)
MySQL thread id 1029023, OS thread handle 47762743035648, query id 31514533 172.31.35.187 forseti updating
UPDATE `favor_reminder` SET `plant_id` = 14540 WHERE (`favor_reminder`.`deactivated_at` IS NULL AND `favor_reminder`.`account_id` = 13147 AND        `favor_reminder`.`content_type_id` = 30 AND `favor_reminder`.`object_id` = 125)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1420 page no 3468 n bits 232 index PRIMARY of table `forseti`.`favor_reminder` trx id 6032621 lock_mode X locks rec but not gap waiting
Record lock, heap no 129 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 4; hex 80033e1e; asc   > ;;
 1: len 6; hex 0000003104d1; asc    1  ;;
 2: len 7; hex 220000078c2227; asc "    "';;
 3: len 30; hex 646661396637393238663638343035346236636239393535356238393635; asc dfa9f7928f684054b6cb99555b8965; (total 32 bytes);
 4: len 8; hex 99a224b23b0e05a8; asc   $ ;   ;;
 5: len 8; hex 99a22600050d720b; asc   &   r ;;
 6: SQL NULL;
 7: len 5; hex 706c616e74; asc plant;;
 8: len 7; hex 80000000000529; asc       );;
 9: SQL NULL;
 10: len 4; hex 80002d29; asc   -);;
 11: SQL NULL;
 12: len 4; hex 80001b3b; asc    ;;;
 13: len 4; hex 8000001e; asc     ;;
 14: len 4; hex 000000a4; asc     ;;

*** (2) TRANSACTION:
TRANSACTION 6032622, ACTIVE 1 sec fetching rows
mysql tables in use 4, locked 4
1916 lock struct(s), heap size 237776, 1258 row lock(s)
MySQL thread id 1029020, OS thread handle 47761600620288, query id 31514534 172.31.35.187 forseti updating
UPDATE `favor_reminder` SET `plant_id` = 3913 WHERE (`favor_reminder`.`account_id` = 11561 AND        `favor_reminder`.`content_type_id` = 30 AND `favor_reminder`.`object_id` = 32 and        `favor_reminder`.`deactivated_at` IS NULL)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 1420 page no 3468 n bits 232 index PRIMARY of table `forseti`.`favor_reminder` trx id 6032622 lock_mode X locks rec but not gap
Record lock, heap no 129 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 4; hex 80033e1e; asc   > ;;
 1: len 6; hex 0000003104d1; asc    1  ;;
 2: len 7; hex 220000078c2227; asc "    "';;
 3: len 30; hex 646661396637393238663638343035346236636239393535356238393635; asc dfa9f7928f684054b6cb99555b8965; (total 32 bytes);
 4: len 8; hex 99a224b23b0e05a8; asc   $ ;   ;;
 5: len 8; hex 99a22600050d720b; asc   &   r ;;
 6: SQL NULL;
 7: len 5; hex 706c616e74; asc plant;;
 8: len 7; hex 80000000000529; asc       );;
 9: SQL NULL;
 10: len 4; hex 80002d29; asc   -);;
 11: SQL NULL;
 12: len 4; hex 80001b3b; asc    ;;;
 13: len 4; hex 8000001e; asc     ;;
 14: len 4; hex 000000a4; asc     ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 1420 page no 2268 n bits 1192 index favor_reminder_content_type_id_036c5bc2_fk_django_co of table `forseti`.`favor_reminder` trx id 6032622 lock_mode X locks rec but not gap waiting
Record lock, heap no 720 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 8000001e; asc     ;;
 1: len 4; hex 800217bf; asc     ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 6034404
Purge done for trx's n:o < 6034403 undo n:o < 0 state: running but idle
History list length 39
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 329235715612968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715615728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715612048, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715596408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715595488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715593648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715592728, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715611128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715618488, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715617568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715614808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715613888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715609288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715610208, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715607448, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715606528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715603768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715601928, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715598248, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715597328, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715594568, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715608368, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715604688, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715602848, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715601008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715600088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715599168, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715591808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715590888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 329235715589968, not started
0 lock struct(s), heap size 1136, 0 row lock(s)