-
Notifications
You must be signed in to change notification settings - Fork 6k
Closed
Labels
affects-7.1This bug affects the 7.1.x(LTS) versions.This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.component/statisticsimpact/panicseverity/majorsig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
A bug observed in our customer's environment.
Their disk is about to full, and we find mysql.stats_history
takes a lot of space, 500GB+
They changed tidb_auto_analyze_ratio to 0.0001 during test (and now changed it back to 0.5)
The root cause that mysql.stats_history
cannot be freed is that the updateStatsWorker goroutine panic.
This is found from their log:
2. What did you expect to see? (Required)
statistics history data been cleanup correctly.
3. What did you see instead (Required)
Their disk is about to full, there is no way to clean the largest garbage, that is, mysql.stats_history table.
Note, it's on the cloud and the user has no privilege to execute 'truncate mysql.stats_history'
4. What is your TiDB version? (Required)
v7.1.1
AndreMouche
Metadata
Metadata
Assignees
Labels
affects-7.1This bug affects the 7.1.x(LTS) versions.This bug affects the 7.1.x(LTS) versions.affects-7.5This bug affects the 7.5.x(LTS) versions.This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.This bug affects the 8.1.x(LTS) versions.affects-8.5This bug affects the 8.5.x(LTS) versions.This bug affects the 8.5.x(LTS) versions.component/statisticsimpact/panicseverity/majorsig/plannerSIG: PlannerSIG: Plannertype/bugThe issue is confirmed as a bug.The issue is confirmed as a bug.