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

Threads are always in 'cleaning up' state in innodb status

    XMLWordPrintable

    Details

      Description

      Threads are always in "cleaning up" state in innodb status while in show processlist we can see "sleep". There was already bug opened and seem fixed but newer versions still have this issue.
      MDEV-9747

      MariaDB [test]> show processlist;
      +----+------+-----------+-------+---------+------+-------+------------------+----------+
      | Id | User | Host      | db    | Command | Time | State | Info             | Progress |
      +----+------+-----------+-------+---------+------+-------+------------------+----------+
      |  2 | root | localhost | test  | Query   |    0 | init  | show processlist |    0.000 |
      |  3 | root | localhost | mysql | Sleep   |    4 |       | NULL             |    0.000 |
      |  4 | root | localhost | test  | Sleep   |   10 |       | NULL             |    0.000 |
      +----+------+-----------+-------+---------+------+-------+------------------+----------+
      

      ------------
      TRANSACTIONS
      ------------
      Trx id counter 2822
      Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
      History list length 0
      LIST OF TRANSACTIONS FOR EACH SESSION:
      ---TRANSACTION 0, not started
      MySQL thread id 3, OS thread handle 0x7f5a704ca700, query id 56 localhost root cleaning up
      ---TRANSACTION 0, not started
      MySQL thread id 4, OS thread handle 0x7f5a70481700, query id 22 localhost root cleaning up
      ---TRANSACTION 2821, not started
      MySQL thread id 2, OS thread handle 0x7f5a70513700, query id 58 localhost root init
      show engine innodb status
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration