Здравствуйте.
При выполнении запроса:
delete from b_iblock_element where IBLOCK_ID=3;
Показывает ошибку:
Lock wait timeout exceeded; try restarting transaction
Я перерыл весь гугл, show proccess нет никаких блокировок.
SHOW ENGINE INNODB STATUS показывает:
------------
TRANSACTIONS
------------
Trx id counter 2112222751
Purge done for trx's n:o < 2112222726 undo n:o < 0 state: running but idle
History list length 50
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421161214013192, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421161214009808, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 2108546214, ACTIVE 1795 sec recovered trx
ROLLING BACK 12 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2065894
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
1 RW transactions active inside InnoDB
---OLDEST VIEW---
Read view low limit trx n:o 2112222725
Trx read view will not see trx with id >= 2112222725, sees < 2108546214
Read view individually stored trx ids:
Read view trx id 2108546214
-----------------
Process ID=9667, Main thread ID=139664243152640, state: sleeping
Number of rows inserted 613834, updated 72657, deleted 209, read 1974963576
423.40 inserts/s, 36.61 updates/s, 0.00 deletes/s, 565458.31 reads/s
Ни где нет никакой информации, что таблица заблокирована.
Куда копать???
