analyze the same table concurrency may raise illegal bucket order error

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. create a partition table
2. analyze partition table (job1)
3. wait for job1 in merge global stats, analyze the same table (job2)

2. What did you expect to see? (Required)

job1 and job2 can running success

3. What did you see instead (Required)

after job2 collect stats, job1 and job2 in merge global stats phase, meget stats return illegal bucket order error

4. What is your TiDB version? (Required)

[10:19:32]TiDB root:db0ios> select tidb_version();
+-----------------------------------------------------------+
| tidb_version()                                            |
+-----------------------------------------------------------+
| Release Version: v7.5.0                                   |
| Edition: Community                                        |
| Git Commit Hash: 069631e2ecfedc000ffb92c67207bea81380f020 |
| Git Branch: heads/refs/tags/v7.5.0                        |
| UTC Build Time: 2023-11-24 08:50:14                       |
| GoVersion: go1.21.3                                       |
| Race Enabled: false                                       |
| Check Table Before Drop: false                            |
| Store: tikv                                               |
+-----------------------------------------------------------+

[elsa0520]

/label duplicate

[aytrack]

analyze 8192 partitions table with single session job also encountered this error

mysql> analyze table table8192;
Query OK, 0 rows affected, 16384 warnings (4 days 7 hours 40 min 16.44 sec)

-- analyze job info
| 128193 | 2023-12-02 08:02:57 | db0ios       | table8192  |                | merge global stats for db0ios.table8192 columns         | 0              | 2023-11-29 20:26:06 | 2023-12-02 08:02:57 | failed   | illegal bucket order | tc-tidb-0.tc-tidb-peer.partition-analyze-test-10w-tps-4620753-1-86.svc:4000 | <null>     |
| 128194 | 2023-12-03 06:11:48 | db0ios       | table8192  |                | merge global stats for db0ios.table8192's index col1ios | 0              | 2023-12-02 08:02:57 | 2023-12-03 06:11:48 | failed   | illegal bucket order | tc-tidb-0.tc-tidb-peer.partition-analyze-test-10w-tps-4620753-1-86.svc:4000 | <null>     |
| 128195 | 2023-12-04 02:30:37 | db0ios       | table8192  |                | merge global stats for db0ios.table8192's index primary | 0              | 2023-12-03 06:11:48 | 2023-12-04 02:30:37 | failed   | illegal bucket order | tc-tidb-0.tc-tidb-peer.partition-analyze-test-10w-tps-4620753-1-86.svc:4000 | <null>     |

[seiya-annie]

/found community