Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.19-galera, 10.1.5
-
None
Description
Threads idling in "closing tables" state gives a false impression that they are
stuck while closing tables.
MariaDB [(none)]> show processlist;
|
+-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+
|
| 1 | system user | | NULL | Sleep | 1740 | closing tables | NULL | 0.000 |
|
| 2 | system user | | NULL | Sleep | 59052 | wsrep aborter idle | NULL | 0.000 |
|
| 4 | system user | | NULL | Sleep | 7931 | closing tables | NULL | 0.000 |
|
| 5 | system user | | NULL | Sleep | 7931 | closing tables | NULL | 0.000 |
|
| 6 | system user | | NULL | Sleep | 7931 | closing tables | NULL | 0.000 |
|
| 7 | system user | | NULL | Sleep | 7931 | closing tables | NULL | 0.000 |
|
| 8 | system user | | NULL | Sleep | 6842 | closing tables | NULL | 0.000 |
|
| 9 | system user | | NULL | Sleep | 6842 | closing tables | NULL | 0.000 |
|
| 11 | system user | | NULL | Sleep | 1737 | closing tables | NULL | 0.000 |
|
| 36 | slave_user | 100.65.2.47:38295 | NULL | Binlog Dump | 58994 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 |
|
| 22107 | slave_user | 100.65.2.43:59048 | NULL | Binlog Dump | 3944 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 |
|
| 23685 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
|
+-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+
|