Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8293

Idle threads post-execution end up in closing tables state

    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

            Hide
            elenst Elena Stepanova added a comment -

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

            Show
            elenst Elena Stepanova added a comment - Set affected version to 10.0.19-galera according to the discussion with Nirbhay on IRC.
            Show
            nirbhay_c Nirbhay Choubey added a comment - https://github.com/MariaDB/server/commit/8c44fd63ac61161e92e7feb55d693d72aebac68d

              People

              • Assignee:
                nirbhay_c Nirbhay Choubey
                Reporter:
                nirbhay_c Nirbhay Choubey
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: