Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------
- LATEST DETECTED DEADLOCK
- ------------------------
- 160929 17:48:25
- *** (1) TRANSACTION:
- TRANSACTION 30B77FFBD, ACTIVE 0 sec fetching rows
- mysql tables in use 3, locked 3
- LOCK WAIT 6 lock struct(s), heap size 1248, 36 row lock(s)
- MySQL thread id 606996, OS thread handle 0x7f5ba83fb700, query id 32964625 localhost mydb Searching rows for update
- UPDATE queue SET daemon='9' WHERE daemon IS NULL AND dateTime<'2016-09-29 17:47:25' AND processed='0' LIMIT 50
- *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
- 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
- Record lock, heap no 68 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
- 0: len 8; hex 000000000422ab80; asc " ;;
- 1: len 6; hex 00030b77ffbe; asc w ;;
- 2: len 7; hex 070000402516bc; asc @% ;;
- 3: len 8; hex 80001256150594c4; asc V ;;
- 4: len 30; hex 636662616531386664616265346231643337653132313862396164373964; asc cfbae18fdabe4b1d37e1218b9ad79d; (total 32 bytes);
- 5: len 30; hex 613a363a7b733a313a2270223b733a353a223735313235223b733a313a22; asc a:6:{s:1:"p";s:5:"75125";s:1:"; (total 165 bytes);
- 6: len 1; hex d8; asc ;;
- 7: len 1; hex 81; asc ;;
- *** (2) TRANSACTION:
- TRANSACTION 30B77FFBE, ACTIVE 0 sec updating or deleting
- mysql tables in use 1, locked 1
- 3 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
- MySQL thread id 607297, OS thread handle 0x7f5bbf33a700, query id 32964626 localhost mydb Updating
- UPDATE queue SET processed='1' WHERE id='69380992'
- *** (2) HOLDS THE LOCK(S):
- 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
- Record lock, heap no 68 PHYSICAL RECORD: n_fields 8; compact format; info bits 0
- 0: len 8; hex 000000000422ab80; asc " ;;
- 1: len 6; hex 00030b77ffbe; asc w ;;
- 2: len 7; hex 070000402516bc; asc @% ;;
- 3: len 8; hex 80001256150594c4; asc V ;;
- 4: len 30; hex 636662616531386664616265346231643337653132313862396164373964; asc cfbae18fdabe4b1d37e1218b9ad79d; (total 32 bytes);
- 5: len 30; hex 613a363a7b733a313a2270223b733a353a223735313235223b733a313a22; asc a:6:{s:1:"p";s:5:"75125";s:1:"; (total 165 bytes);
- 6: len 1; hex d8; asc ;;
- 7: len 1; hex 81; asc ;;
- *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
- 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
- Record lock, heap no 494 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
- 0: len 1; hex 80; asc ;;
- 1: len 8; hex 000000000422ab80; asc " ;;
- *** WE ROLL BACK TRANSACTION (2)
- ------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement