Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.0.30, 10.1.23
-
None
Description
Threads are always in "cleaning up" state in innodb status while in show processlist we can see "sleep". There was already bug opened and seem fixed but newer versions still have this issue.
MDEV-9747
MariaDB [test]> show processlist;
|
+----+------+-----------+-------+---------+------+-------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------+-------+---------+------+-------+------------------+----------+
|
| 2 | root | localhost | test | Query | 0 | init | show processlist | 0.000 |
|
| 3 | root | localhost | mysql | Sleep | 4 | | NULL | 0.000 |
|
| 4 | root | localhost | test | Sleep | 10 | | NULL | 0.000 |
|
+----+------+-----------+-------+---------+------+-------+------------------+----------+
|
------------
|
TRANSACTIONS
|
------------
|
Trx id counter 2822
|
Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
|
History list length 0
|
LIST OF TRANSACTIONS FOR EACH SESSION:
|
---TRANSACTION 0, not started
|
MySQL thread id 3, OS thread handle 0x7f5a704ca700, query id 56 localhost root cleaning up
|
---TRANSACTION 0, not started
|
MySQL thread id 4, OS thread handle 0x7f5a70481700, query id 22 localhost root cleaning up
|
---TRANSACTION 2821, not started
|
MySQL thread id 2, OS thread handle 0x7f5a70513700, query id 58 localhost root init
|
show engine innodb status
|
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Sergei Golubchik [ serg ] |
| Fix Version/s | 10.0 [ 16000 ] |
| Description |
Threads are always in "cleaning up" state in innodb status while in show processlist we can see "sleep". There was already bug opened and seem fixed but newer versions still have this issue.
https://jira.mariadb.org/browse/MDEV-9747 {code} MariaDB [test]> show processlist; +----+------+-----------+-------+---------+------+-------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+------+-----------+-------+---------+------+-------+------------------+----------+ | 2 | root | localhost | test | Query | 0 | init | show processlist | 0.000 | | 3 | root | localhost | mysql | Sleep | 4 | | NULL | 0.000 | | 4 | root | localhost | test | Sleep | 10 | | NULL | 0.000 | +----+------+-----------+-------+---------+------+-------+------------------+----------+ {code} {code} ------------ TRANSACTIONS ------------ Trx id counter 2822 Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 3, OS thread handle 0x7f5a704ca700, query id 56 localhost root cleaning up ---TRANSACTION 0, not started MySQL thread id 4, OS thread handle 0x7f5a70481700, query id 22 localhost root cleaning up ---TRANSACTION 2821, not started MySQL thread id 2, OS thread handle 0x7f5a70513700, query id 58 localhost root init show engine innodb status {code} |
Threads are always in "cleaning up" state in innodb status while in show processlist we can see "sleep". There was already bug opened and seem fixed but newer versions still have this issue.
{code} MariaDB [test]> show processlist; +----+------+-----------+-------+---------+------+-------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+------+-----------+-------+---------+------+-------+------------------+----------+ | 2 | root | localhost | test | Query | 0 | init | show processlist | 0.000 | | 3 | root | localhost | mysql | Sleep | 4 | | NULL | 0.000 | | 4 | root | localhost | test | Sleep | 10 | | NULL | 0.000 | +----+------+-----------+-------+---------+------+-------+------------------+----------+ {code} {code} ------------ TRANSACTIONS ------------ Trx id counter 2822 Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 3, OS thread handle 0x7f5a704ca700, query id 56 localhost root cleaning up ---TRANSACTION 0, not started MySQL thread id 4, OS thread handle 0x7f5a70481700, query id 22 localhost root cleaning up ---TRANSACTION 2821, not started MySQL thread id 2, OS thread handle 0x7f5a70513700, query id 58 localhost root init show engine innodb status {code} |
| Fix Version/s | 10.0.36 [ 22916 ] | |
| Fix Version/s | 10.3.8 [ 23113 ] | |
| Fix Version/s | 10.2.16 [ 23110 ] | |
| Fix Version/s | 10.1.34 [ 23100 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Resolution | Duplicate [ 3 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link |
This issue is duplicated by |
| Workflow | MariaDB v3 [ 80596 ] | MariaDB v4 [ 152086 ] |