[MDEV-8293] Idle threads post-execution end up in closing tables state Created: 2015-06-10  Updated: 2015-06-19  Resolved: 2015-06-19

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 10.0.19-galera, 10.1.5
Fix Version/s: 10.0.20-galera

Type: Bug Priority: Minor
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
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 |
+-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+



 Comments   
Comment by Elena Stepanova [ 2015-06-10 ]

Set affected version to 10.0.19-galera according to the discussion with Nirbhay on IRC.

Comment by Nirbhay Choubey (Inactive) [ 2015-06-19 ]

https://github.com/MariaDB/server/commit/8c44fd63ac61161e92e7feb55d693d72aebac68d

Generated at Thu Feb 08 07:26:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.