tidb的统计信息报错:
1、表的字段非常多,大概2500个字段
2、表存在分区,128个分区
报错信息如下:
*************************** 30. row ***************************
Table_schema: ffffffff
Table_name: xxxxxxxxxx
Partition_name:
Job_info: merge global stats for fffffffff.xxxxxxxxxxxx index idx_master
Processed_rows: 0
Start_time: 2023-10-16 15:48:10
End_time: 2023-10-16 15:48:10
State: failed
Fail_reason: [types:8244]Build global-level stats failed due to missing partition-level column stats: table custom_forms_user_detail
partition p109
index idx_master
, please run analyze table to refresh columns of all partitions
Instance: 10.0.47.4:4000
Process_ID: NULL
重新执行:analyze table xxxxxxxxxxxx; 最后也执行不成功。