------------
TRANSACTIONS
------------
Trx id counter 1575497
Purge done for trx's n:o < 1575490 undo n:o < 0 state: running but idle
History list length 3691
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 1570169, not started
MySQL thread id 1, OS thread handle 0x700000a3f000, query id 1714576 localhost root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 1575496, ACTIVE 15 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 123109, OS thread handle 0x700000b0b000, query id 1714575 localhost root updating
update `users` set `num_turns_taken` = `num_turns_taken` + 1, `updated_at` = ? where `users`.`deleted_at` is null and `users`.`user_id` = ?
------- TRX HAS BEEN WAITING 15 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 363 page no 8 n bits 144 index `PRIMARY` of table `d12_user`.`users` trx id 1575496 lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 35; compact format; info bits 0
 0: len 4; hex 00000001; asc     ;;
 1: len 6; hex 000000180a40; asc      @;;
 2: len 7; hex 66000001b51d6c; asc f     l;;
 3: len 5; hex 61646d696e; asc admin;;
 4: len 23; hex 57616c7465722e46656c697065407961686f6f2e636f6d; asc [email protected];;
 5: len 30; hex 243279243130246161774a37534c4b69315265527a4e385737644b4c7555; asc $2y$10$aawJ7SLKi1ReRzN8W7dKLuU; (total 60 bytes);
 6: len 30; hex 3554456c796f785778437749346e574451596e3479413867546878755535; asc 5TElyoxWxCwI4nWDQYn4yA8gThxuU5; (total 60 bytes);
 7: len 4; hex 56093209; asc V 2 ;;
 8: len 4; hex 562e3b6c; asc V.;l;;
 9: SQL NULL;
 10: len 4; hex 562f7bcb; asc V/{ ;;
 11: len 4; hex 562f8037; asc V/ 7;;
 12: SQL NULL;
 13: SQL NULL;
 14: SQL NULL;
 15: len 4; hex 00000001; asc     ;;
 16: len 5; hex 4261736963; asc Basic;;
 17: SQL NULL;
 18: len 4; hex 8001872b; asc    +;;
 19: len 2; hex 83c0; asc   ;;
 20: len 2; hex 8000; asc   ;;
 21: SQL NULL;
 22: len 4; hex 00000000; asc     ;;
 23: len 4; hex 00000000; asc     ;;
 24: len 4; hex 00000000; asc     ;;
 25: len 4; hex 00000000; asc     ;;
 26: len 4; hex 00000000; asc     ;;
 27: len 4; hex 00000000; asc     ;;
 28: len 4; hex 00000000; asc     ;;
 29: len 1; hex 64; asc d;;
 30: len 1; hex 64; asc d;;
 31: len 1; hex 64; asc d;;
 32: len 0; hex ; asc ;;
 33: len 0; hex ; asc ;;
 34: len 4; hex 00000000; asc     ;;

------------------
---TRANSACTION 1575495, ACTIVE 15 sec
7 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 2
MySQL thread id 123110, OS thread handle 0x700000a83000, query id 1714573 localhost root cleaning up
Trx read view will not see trx with id >= 1575496, sees < 1575496