Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- *** (1) TRANSACTION:
- TRANSACTION 5 212967856, ACTIVE 0 sec, process no 14999, OS thread id 1305057600 fetching rows
- mysql tables in use 2, locked 2
- LOCK WAIT 5 lock struct(s), heap size 1216, 11 row lock(s), undo log entries 10
- MySQL thread id 6100, query id 121776856 pr03.ourworld.com 10.0.100.103 flowdata Sending data
- INSERT INTO outfit_items (owner_id, slot, item_id) (SELECT owner_id, 99, item_id FROM dyn_inventory2_52 WHERE owner_id=515823 AND status='w')
- *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 3805 page no 603 n bits 896 index `dyn_inventory2_52_o_s_i` of table `userdata2`.`dyn_inventory2_52` trx id 5 212967856 lock mode S waiting
- Record lock, heap no 812 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
- 0: len 4; hex 8007deef; asc ;; 1: len 1; hex 77; asc w;; 2: len 4; hex 800007d3; asc ;; 3: len 4; hex 8006ea4e; asc N;;
- *** (2) TRANSACTION:
- TRANSACTION 5 212967846, ACTIVE 0 sec, process no 14999, OS thread id 1239562560 updating or deleting, thread declared inside InnoDB 499
- mysql tables in use 1, locked 1
- 5 lock struct(s), heap size 1216, 4 row lock(s), undo log entries 2
- MySQL thread id 772, query id 121776838 pr03.ourworld.com 10.0.100.103 flowdata Updating
- UPDATE dyn_inventory2_52 SET status='c', added = NOW() WHERE rank=452150 AND item_id=951 AND owner_id=515823
- *** (2) HOLDS THE LOCK(S):
- RECORD LOCKS space id 3805 page no 603 n bits 896 index `dyn_inventory2_52_o_s_i` of table `userdata2`.`dyn_inventory2_52` trx id 5 212967846 lock_mode X locks rec but not gap
- Record lock, heap no 812 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
- 0: len 4; hex 8007deef; asc ;; 1: len 1; hex 77; asc w;; 2: len 4; hex 800007d3; asc ;; 3: len 4; hex 8006ea4e; asc N;;
- *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 3805 page no 603 n bits 896 index `dyn_inventory2_52_o_s_i` of table `userdata2`.`dyn_inventory2_52` trx id 5 212967846 lock_mode X locks rec but not gap waiting
- Record lock, heap no 814 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
- 0: len 4; hex 8007deef; asc ;; 1: len 1; hex 77; asc w;; 2: len 4; hex 800003b7; asc ;; 3: len 4; hex 8006e636; asc 6;;
Add Comment
Please, Sign In to add comment