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

Garbage characters in show processlist with ANALYZE TABLE on slave

    XMLWordPrintable

Details

    Description

      Hi,

      From time to time, on a slave server, I notice the replicated ANALYZE TABLE statement is displayed with garbage in the State column during a SHOW PROCESSLIST :

      e.g. :

      MariaDB [(none)]> show processlist;
      +------+-------------+-----------+------+---------+-------+----------------------------------+-------------------------------------------+----------+
      | Id   | User        | Host      | db   | Command | Time  | State                            | Info                                      | Progress |
      +------+-------------+-----------+------+---------+-------+----------------------------------+-------------------------------------------+----------+
      |   37 | system user |           | NULL | Connect | 48841 | Waiting for master to send event | NULL                                      |    0.000 |
      | 1191 | root        | localhost | sc_2 | Sleep   |  2789 |                                  | NULL                                      |    0.000 |
      | 1246 | system user |           | sc_2 | Connect |     3 | @R
      ??                             | ANALYZE TABLE `sc_stat_product_type_user` |    0.000 |
      | 1336 | root        | localhost | NULL | Query   |     0 | init                             | show processlist                          |    0.000 |
      +------+-------------+-----------+------+---------+-------+----------------------------------+-------------------------------------------+----------+
      4 rows in set (0.00 sec)
      [...]
       
      | 49 | system user |           | sc_2 | Connect |    5 | ???T?                               | ANALYZE TABLE `sc_stat_product_type_user` |    0.000 |
      

      Note sc_stat_product_type_user is a TokuDB table (so perhaps the bug is upstream ?)

      Thanks and regards,
      Jocelyn Fournier

      Attachments

        Activity

          People

            Unassigned Unassigned
            joce jocelyn fournier
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.