【 TiDB 使用环境】生产环境
【 TiDB 版本】v7.5.5
【遇到的问题:问题现象及影响】
[2025/02/13 11:28:55.526 +08:00] [WARN] [handle_hist.go:127] ["SyncWaitStatsLoad meets error"] [errors="[\"sync load took too long to return\"]"]
[2025/02/13 11:28:55.526 +08:00] [WARN] [handle_hist.go:127] ["SyncWaitStatsLoad meets error"] [errors="[\"sync load took too long to return\"]"]
[2025/02/13 11:28:55.526 +08:00] [WARN] [plan_stats.go:200] ["SyncWaitStatsLoad failed"] [error="sync load stats timeout"]
[2025/02/13 11:28:55.526 +08:00] [WARN] [handle_hist.go:127] ["SyncWaitStatsLoad meets error"] [errors="[\"sync load took too long to return\"]"]
[2025/02/13 11:28:55.526 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.526 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.526 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.526 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.526 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code]
[2025/02/13 11:28:55.527 +08:00] [WARN] [column.go:170] ["Hist for column should already be loaded as sync but not found."] [16=error_code
日志除了警报对sql执行无影响,但过多的日志导致占用了大量的存储空间(相互sql执行的频率较高)
字段类型是bit(32),简略的表结构如下
create table t_answer_card
(
answer_card_id bigint auto_increment comment '答题卡' primary key,
error_code bit(32) null
) comment '答题卡' charset = utf8mb4;