Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.16
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