Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------
- LATEST DETECTED DEADLOCK
- ------------------------
- 2019-04-08 09:53:59 7f32d1ded700
- *** (1) TRANSACTION:
- TRANSACTION 24288587448, ACTIVE 0 sec fetching rows
- mysql tables in use 1, locked 1
- LOCK WAIT 4 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 1
- MySQL thread id 37661467, OS thread handle 0x7f32d16d1700, query id 1227500628 static.123.206.4.46.clients.your-server.de 46.4.206.123 space_local updating
- UPDATE `ih_sponsors` SET `deleted`=1 WHERE `user_id`=1137143
- *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 783548 page no 83 n bits 456 index `PRIMARY` of table `qplead`.`ih_sponsors` trx id 24288587448 lock_mode X locks rec but not gap waiting
- *** (2) TRANSACTION:
- TRANSACTION 24288587284, ACTIVE 0 sec fetching rows
- mysql tables in use 1, locked 1
- 235 lock struct(s), heap size 46632, 89676 row lock(s)
- MySQL thread id 37659323, OS thread handle 0x7f32d1ded700, query id 1227500466 static.123.206.4.46.clients.your-server.de 46.4.206.123 space_local updating
- UPDATE `ih_sponsors` SET `redis_bucket`=NULL WHERE `redis_bucket`='2'
- *** (2) HOLDS THE LOCK(S):
- RECORD LOCKS space id 783548 page no 83 n bits 456 index `PRIMARY` of table `qplead`.`ih_sponsors` trx id 24288587284 lock_mode X
- *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 783548 page no 267 n bits 464 index `PRIMARY` of table `qplead`.`ih_sponsors` trx id 24288587284 lock_mode X waiting
- *** WE ROLL BACK TRANSACTION (1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement