Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 KB | None | 0 0
  1. LATEST DETECTED DEADLOCK
  2. ------------------------
  3. 2019-03-25 15:50:06 0x7fe1b4250700
  4. *** (1) TRANSACTION:
  5. TRANSACTION 1486783, ACTIVE 0 sec starting index read
  6. mysql tables in use 1, locked 1
  7. LOCK WAIT 11 lock struct(s), heap size 1136, 6 row lock(s), undo log entries 3
  8. MySQL thread id 40161, OS thread handle 140607127504640, query id 6917573 95.183.13.136 smmbro updating
  9. DELETE FROM stage_status WHERE `stage_id` IN ('▒͎[X▒㺧▒▒▒▒j') AND `follower_id` = '▒▒q▒d▒Q▒6▒▒
  10. ▒'
  11. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  12. RECORD LOCKS space id 966 page no 68743 n bits 248 index fk_stage_status_stage1_idx of table `smmbro`.`stage_status` trx id 1486783 lock_mode X waiting
  13. Record lock, heap no 91 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  14. 0: len 16; hex abcd8e5b58e515e3baa798d0d51eb36a; asc [X j;;
  15. 1: len 16; hex 9616005714bd658049471d06d4187f08; asc W e IG ;;
  16.  
  17. *** (2) TRANSACTION:
  18. TRANSACTION 1486782, ACTIVE 0 sec inserting
  19. mysql tables in use 1, locked 1
  20. 17 lock struct(s), heap size 1136, 14 row lock(s), undo log entries 4
  21. MySQL thread id 40154, OS thread handle 140607366694656, query id 6917577 95.183.13.136 smmbro update
  22. INSERT INTO stage_status (id, club_id, follower_id, stage_id, status, updated_at, is_waiting_condition, condition_wait_expire_at, is_delayed_send, send_delay_expire_at, is_clicked, is_read, is_reposted, is_keyword_replied, is_goal_completed, is_started, last_action) VALUES ('▒▒_▒▒U_{▒\r▒▒GY', 'd▒
  23. 8▒▒▒▒▒▒mMQ▒', 'b▒Nx▒▒Oj▒▒`Pe', '▒͎[X▒㺧▒▒▒▒j', 'isWaitingCondition', '2019-03-25 15:50:06', '1', '2019-03-25 15:51:06', '0', NULL, '0', '0', '0', '0', '0', '0', 'isWaitingCondition')
  24. *** (2) HOLDS THE LOCK(S):
  25. RECORD LOCKS space id 966 page no 68743 n bits 248 index fk_stage_status_stage1_idx of table `smmbro`.`stage_status` trx id 1486782 lock_mode X
  26. Record lock, heap no 91 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  27. 0: len 16; hex abcd8e5b58e515e3baa798d0d51eb36a; asc [X j;;
  28. 1: len 16; hex 9616005714bd658049471d06d4187f08; asc W e IG ;;
  29.  
  30. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  31. RECORD LOCKS space id 966 page no 68743 n bits 248 index fk_stage_status_stage1_idx of table `smmbro`.`stage_status` trx id 1486782 lock_mode X locks gap before rec insert intention waiting
  32. Record lock, heap no 91 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  33. 0: len 16; hex abcd8e5b58e515e3baa798d0d51eb36a; asc [X j;;
  34. 1: len 16; hex 9616005714bd658049471d06d4187f08; asc W e IG ;;
  35.  
  36. *** WE ROLL BACK TRANSACTION (1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement