*** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3 page no 4 n bits 80 index PRIMARY of table `employees`.`departments` trx id 51039 lock mode S locks rec but not gap MySQL thread id 9, OS thread handle 140298597062400, query id 181 localhost instadm updating LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s) TRANSACTION 51039, ACTIVE 28 sec starting index read *** (1) WAITING FOR THIS LOCK TO BE GRANTED: Record lock, heap no 13 PHYSICAL RECORD: n_fields 4 compact format info bits 0ģ: len 736561726368202620446576656c6f706d656e74 asc Research & Development RECORD LOCKS space id 3 page no 4 n bits 80 index PRIMARY of table `employees`.`departments` trx id 51038 lock_mode X locks rec but not gap waiting MySQL thread id 11, OS thread handle 140298596771584, query id 180 localhost instadm updating LOCK WAIT 2 lock struct(s), heap size 1136, 2 row lock(s) TRANSACTION 51038, ACTIVE 13 sec starting index read Spin rounds per wait: 1.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx Srv_master_thread log flush and writes: 0 Srv_master_thread loops: 5 srv_active, 0 srv_shutdown, 4498 srv_idle Per second averages calculated from the last 56 seconds SHOW ENGINE INNODB STATUS \G mysql> SHOW ENGINE INNODB STATUS \G Transaction 1 (deadlock) UPDATE departmentsĮxecute the command below in MySQL/MariaDB. SELECT * FROM departments WHERE dept_no = 'd008' LOCK IN SHARE MODE Each process, while holding its own resources, attempts to access a resource that is locked by the other process. A deadlock is a special blocking scenario when two or more competing transactions are waiting for each other to free locks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |