daily pastebin goal
20%
SHARE
TWEET

Untitled

a guest Mar 25th, 2019 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top