Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.19-galera, 10.1.5
-
Fix Version/s: 10.0.20-galera
-
Component/s: wsrep
-
Labels: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 | +-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Set affected version to 10.0.19-galera according to the discussion with Nirbhay on IRC.