We migrated lately from MySQL to MariaDB.
When executing this:
SHOW ENGINE INNODB STATUS
I get (shortened):
... ---TRANSACTION 279257007, ACTIVE 23981 sec 10 lock struct(s), heap size 2936, 18 row lock(s), undo log entries 903 MySQL thread id 119634, OS thread handle 0x7f62c96e0700, query id 48830504 XXX.XXX.XXX.X admin cleaning up Trx read view will not see trx with id >= 279257008, sees < 279256916 TABLE LOCK table `db1`.`table_a` trx id 279257007 lock mode IX TABLE LOCK table `db1`.`table_b` trx id 279257007 lock mode IX ...
I guess this means that this transaction was running for several hours. However, when executing
SHOW OPEN TABLES, all tables show no-lock. When doing
SHOW FULL PROCESSLIST, the result of the thread 119634 is:
Command: SLEEP, State: '', Info: Null, Progress: 0
I have no idea what to do. When running a script I get lock-timeouts. But just increasing the timeout, I suspect will not help either.
Question: How can I get resolve this issue? Or, how should I tackle this?