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

Idle threads post-execution end up in closing tables state

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • 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 |
      +-------+-------------+-------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+----------+

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.