[MDEV-26802] ANALYZE TABLE in processlist with State NULL Created: 2021-10-11  Updated: 2021-10-13

Status: Open
Project: MariaDB Server
Component/s: Optimizer, Server
Affects Version/s: 10.6.3
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Oli Sennhauser Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: analyze-stmt, processlist
Environment:

Linux, n.a.


 Description   

When you run the following command:

ANALYZE TABLE test.test PERSISTENT FOR ALL;

SHOW PROCESSLIST in another connections shows always State NULL which is obviously not true:

+-----+------+-----------+-------+---------+-------+----------+--------------------------------------------+
 
| Id  | User | Host      | db    | Command | Time  | State    | Info                                       |
 
+-----+------+-----------+-------+---------+-------+----------+--------------------------------------------+
 
| 846 | root | localhost | mysql | Query   |    23 | NULL     | ANALYZE TABLE test.test PERSISTENT FOR ALL |
 
| 851 | root | localhost | NULL  | Query   |     0 | starting | show processlist                           |
 
+-----+------+-----------+-------+---------+-------+----------+--------------------------------------------+

Something like "Sending data" would be more appropriate.
Generated at Thu Feb 08 09:48:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.