Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.72 KB | None | 0 0
  1. ------------------------
  2. LATEST DETECTED DEADLOCK
  3. ------------------------
  4. 160929 17:48:25
  5. *** (1) TRANSACTION:
  6. TRANSACTION 30B77FFBD, ACTIVE 0 sec fetching rows
  7. mysql tables in use 3, locked 3
  8. LOCK WAIT 6 lock struct(s), heap size 1248, 36 row lock(s)
  9. MySQL thread id 606996, OS thread handle 0x7f5ba83fb700, query id 32964625 localhost mydb Searching rows for update
  10. UPDATE queue SET daemon='9' WHERE daemon IS NULL AND dateTime<'2016-09-29 17:47:25' AND processed='0' LIMIT 50
  11. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  12. RECORD LOCKS space id 0 page no 51471 n bits 136 index `PRIMARY` of table `mydb`.`queue` trx id 30B77FFBD lock_mode X locks rec but not gap waiting
  13. Record lock, heap no 68 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
  14. 0: len 8; hex 000000000422ab80; asc " ;;
  15. 1: len 6; hex 00030b77ffbe; asc w ;;
  16. 2: len 7; hex 070000402516bc; asc @% ;;
  17. 3: len 8; hex 80001256150594c4; asc V ;;
  18. 4: len 30; hex 636662616531386664616265346231643337653132313862396164373964; asc cfbae18fdabe4b1d37e1218b9ad79d; (total 32 bytes);
  19. 5: len 30; hex 613a363a7b733a313a2270223b733a353a223735313235223b733a313a22; asc a:6:{s:1:"p";s:5:"75125";s:1:"; (total 165 bytes);
  20. 6: len 1; hex d8; asc ;;
  21. 7: len 1; hex 81; asc ;;
  22.  
  23. *** (2) TRANSACTION:
  24. TRANSACTION 30B77FFBE, ACTIVE 0 sec updating or deleting
  25. mysql tables in use 1, locked 1
  26. 3 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
  27. MySQL thread id 607297, OS thread handle 0x7f5bbf33a700, query id 32964626 localhost mydb Updating
  28. UPDATE queue SET processed='1' WHERE id='69380992'
  29. *** (2) HOLDS THE LOCK(S):
  30. RECORD LOCKS space id 0 page no 51471 n bits 136 index `PRIMARY` of table `mydb`.`queue` trx id 30B77FFBE lock_mode X locks rec but not gap
  31. Record lock, heap no 68 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
  32. 0: len 8; hex 000000000422ab80; asc " ;;
  33. 1: len 6; hex 00030b77ffbe; asc w ;;
  34. 2: len 7; hex 070000402516bc; asc @% ;;
  35. 3: len 8; hex 80001256150594c4; asc V ;;
  36. 4: len 30; hex 636662616531386664616265346231643337653132313862396164373964; asc cfbae18fdabe4b1d37e1218b9ad79d; (total 32 bytes);
  37. 5: len 30; hex 613a363a7b733a313a2270223b733a353a223735313235223b733a313a22; asc a:6:{s:1:"p";s:5:"75125";s:1:"; (total 165 bytes);
  38. 6: len 1; hex d8; asc ;;
  39. 7: len 1; hex 81; asc ;;
  40.  
  41. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  42. RECORD LOCKS space id 0 page no 50294 n bits 1184 index `processed` of table `mydb`.`queue` trx id 30B77FFBE lock_mode X locks rec but not gap waiting
  43. Record lock, heap no 494 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  44. 0: len 1; hex 80; asc ;;
  45. 1: len 8; hex 000000000422ab80; asc " ;;
  46.  
  47. *** WE ROLL BACK TRANSACTION (2)
  48. ------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement