------------------------
LATEST DETECTED DEADLOCK
------------------------
2020-11-06 00:00:01 0x7f4bbc636700
*** (1) TRANSACTION:
TRANSACTION 140244, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s)
MySQL thread id 118525, OS thread handle 139963260827392, query id 2105696 accounts-appserver5.account-creation-assistance.eqiad1.wikim 172.16.0.107 production Updating
UPDATE request
SET ip = '127.0.0.1', forwardedip = null, email = 'acc@toolserver.org', useragent = ''
WHERE date < DATE_SUB(curdate(), INTERVAL 15 DAY)
AND status = 'Closed'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 543 page no 11 n bits 224 index PRIMARY of table `production`.`request` trx id 140244 lock_mode X waiting
Record lock, heap no 3 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 4; hex 80000005; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 18; hex 61636340746f6f6c7365727665722e6f7267; asc acc@toolserver.org;;
 4: len 9; hex 3132372e302e302e31; asc 127.0.0.1;;
 5: len 8; hex 546573745f74776f; asc Test_two;;
 6: len 12; hex 5365636f6e64207465737421; asc Second test!;;
 7: len 6; hex 436c6f736564; asc Closed;;
 8: len 4; hex 00000000; asc     ;;
 9: len 0; hex ; asc ;;
 10: len 0; hex ; asc ;;
 11: SQL NULL;
 12: len 0; hex ; asc ;;
 13: SQL NULL;
 14: len 4; hex 80000000; asc     ;;

*** (2) TRANSACTION:
TRANSACTION 140243, ACTIVE 0 sec fetching rows
mysql tables in use 2, locked 2
100 lock struct(s), heap size 24696, 3697 row lock(s), undo log entries 3
MySQL thread id 118524, OS thread handle 139963259905792, query id 2105689 accounts-appserver5.account-creation-assistance.eqiad1.wikim 172.16.0.107 production Sending data
DELETE FROM request
            WHERE
                request.date < DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL '7' DAY)
                AND request.emailconfirm != 'Confirmed'
                AND request.emailconfirm != ''
                AND NOT exists (SELECT 1 FROM comment c WHERE c.request = request.id)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 543 page no 11 n bits 224 index PRIMARY of table `production`.`request` trx id 140243 lock_mode X locks rec but not gap
Record lock, heap no 3 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 4; hex 80000005; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 18; hex 61636340746f6f6c7365727665722e6f7267; asc acc@toolserver.org;;
 4: len 9; hex 3132372e302e302e31; asc 127.0.0.1;;
 5: len 8; hex 546573745f74776f; asc Test_two;;
 6: len 12; hex 5365636f6e64207465737421; asc Second test!;;
 7: len 6; hex 436c6f736564; asc Closed;;
 8: len 4; hex 00000000; asc     ;;
 9: len 0; hex ; asc ;;
 10: len 0; hex ; asc ;;
 11: SQL NULL;
 12: len 0; hex ; asc ;;
 13: SQL NULL;
 14: len 4; hex 80000000; asc     ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 543 page no 11 n bits 224 index PRIMARY of table `production`.`request` trx id 140243 lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 15; compact format; info bits 0
 0: len 4; hex 80000004; asc     ;;
 1: len 6; hex 000000000000; asc       ;;
 2: len 7; hex 80000000000000; asc        ;;
 3: len 18; hex 61636340746f6f6c7365727665722e6f7267; asc acc@toolserver.org;;
 4: len 9; hex 3132372e302e302e31; asc 127.0.0.1;;
 5: len 6; hex 53514c446232; asc SQLDb2;;
 6: len 5; hex 546573743f; asc Test?;;
 7: len 6; hex 436c6f736564; asc Closed;;
 8: len 4; hex 4853bc4d; asc HS M;;
 9: len 1; hex 31; asc 1;;
 10: len 9; hex 436f6e6669726d6564; asc Confirmed;;
 11: SQL NULL;
 12: len 0; hex ; asc ;;
 13: SQL NULL;
 14: len 4; hex 80000000; asc     ;;

*** WE ROLL BACK TRANSACTION (1)