pingcap / pingcap/tidb

auto analyze assert fail

Open
#63,677 1 comment 0 reactions 0 assignees View on GitHub
affects-8.5 component/test severity/moderate sig/planner type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

see https://do.pingcap.net/jenkins/blue/rest/organizations/jenkins/pipelines/pingcap/pipelines/tidb/pipelines/ghpr_check2/runs/41128/nodes/112/steps/669/log/?start=0
```
[2025/09/22 16:38:06.814 +00:00] [ERROR] [autoanalyze.go:330] ["HandleAutoAnalyze panicked"] [category=stats] [recover="assert failed, Column count should not be 0"] [stack="github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).handleAutoAnalyze.func1
pkg/statistics/handle/autoanalyze/autoanalyze.go:333
runtime.gopanic
GOROOT/src/runtime/panic.go:791
github.com/pingcap/tidb/pkg/util.Recover
pkg/util/misc.go:126
runtime.gopanic
GOROOT/src/runtime/panic.go:791
github.com/pingcap/tidb/pkg/util/intest.doPanic
pkg/util/intest/assert_common.go:58
github.com/pingcap/tidb/pkg/util/intest.doAssert
pkg/util/intest/assert_common.go:30
github.com/pingcap/tidb/pkg/util/intest.Assert
pkg/util/intest/assert.go:25
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisJobFactory).CalculateTableSize
pkg/statistics/handle/autoanalyze/priorityqueue/analysis_job_factory.go:190
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisJobFactory).CreateNonPartitionedTableAnalysisJob
pkg/statistics/handle/autoanalyze/priorityqueue/analysis_job_factory.go:68
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).fetchAllTablesAndBuildAnalysisJobs.func1
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:287
github.com/pingcap/tidb/pkg/statistics/handle/util.WrapTxn
pkg/statistics/handle/util/util.go:207
github.com/pingcap/tidb/pkg/statistics/handle/util.CallWithSCtx
pkg/statistics/handle/util/util.go:105
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).fetchAllTablesAndBuildAnalysisJobs
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:207
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).rebuildWithoutLock
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:194
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).Initialize
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:152
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/refresher.(*Refresher).AnalyzeHighestPriorityTables
pkg/statistics/handle/autoanalyze/refresher/refresher.go:106
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).handleAutoAnalyze
pkg/statistics/handle/autoanalyze/autoanalyze.go:343
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).HandleAutoAnalyze.func1
pkg/statistics/handle/autoanalyze/autoanalyze.go:298
github.com/pingcap/tidb/pkg/statistics/handle/util.CallWithSCtx
pkg/statistics/handle/util/util.go:107
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).HandleAutoAnalyze
pkg/statistics/handle/autoanalyze/autoanalyze.go:297
github.com/pingcap/tidb/pkg/domain.(*Domain).autoAnalyzeWorker
pkg/domain/domain.go:2309
github.com/pingcap/tidb/pkg/domain.(*Domain).UpdateTableStatsLoop.func3
pkg/domain/domain.go:1941
github.com/pingcap/tidb/pkg/domain.(*Domain).UpdateTableStatsLoop.func5
pkg/domain/domain.go:1954
github.com/pingcap/tidb/pkg/util.(*WaitGroupEnhancedWrapper).Run.func1
pkg/util/wait_group_wrapper.go:103"] [stack="github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).handleAutoAnalyze.func1
pkg/statistics/handle/autoanalyze/autoanalyze.go:330
runtime.gopanic
GOROOT/src/runtime/panic.go:791
github.com/pingcap/tidb/pkg/util.Recover
pkg/util/misc.go:126
runtime.gopanic
GOROOT/src/runtime/panic.go:791
github.com/pingcap/tidb/pkg/util/intest.doPanic
pkg/util/intest/assert_common.go:58
github.com/pingcap/tidb/pkg/util/intest.doAssert
pkg/util/intest/assert_common.go:30
github.com/pingcap/tidb/pkg/util/intest.Assert
pkg/util/intest/assert.go:25
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisJobFactory).CalculateTableSize
pkg/statistics/handle/autoanalyze/priorityqueue/analysis_job_factory.go:190
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisJobFactory).CreateNonPartitionedTableAnalysisJob
pkg/statistics/handle/autoanalyze/priorityqueue/analysis_job_factory.go:68
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).fetchAllTablesAndBuildAnalysisJobs.func1
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:287
github.com/pingcap/tidb/pkg/statistics/handle/util.WrapTxn
pkg/statistics/handle/util/util.go:207
github.com/pingcap/tidb/pkg/statistics/handle/util.CallWithSCtx
pkg/statistics/handle/util/util.go:105
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).fetchAllTablesAndBuildAnalysisJobs
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:207
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).rebuildWithoutLock
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:194
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/priorityqueue.(*AnalysisPriorityQueue).Initialize
pkg/statistics/handle/autoanalyze/priorityqueue/queue.go:152
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze/refresher.(*Refresher).AnalyzeHighestPriorityTables
pkg/statistics/handle/autoanalyze/refresher/refresher.go:106
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).handleAutoAnalyze
pkg/statistics/handle/autoanalyze/autoanalyze.go:343
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).HandleAutoAnalyze.func1
pkg/statistics/handle/autoanalyze/autoanalyze.go:298
github.com/pingcap/tidb/pkg/statistics/handle/util.CallWithSCtx
pkg/statistics/handle/util/util.go:107
github.com/pingcap/tidb/pkg/statistics/handle/autoanalyze.(*statsAnalyze).HandleAutoAnalyze
pkg/statistics/handle/autoanalyze/autoanalyze.go:297
github.com/pingcap/tidb/pkg/domain.(*Domain).autoAnalyzeWorker
pkg/domain/domain.go:2309
github.com/pingcap/tidb/pkg/domain.(*Domain).UpdateTableStatsLoop.func3
pkg/domain/domain.go:1941
github.com/pingcap/tidb/pkg/domain.(*Domain).UpdateTableStatsLoop.func5
pkg/domain/domain.go:1954
github.com/pingcap/tidb/pkg/util.(*WaitGroupEnhancedWrapper).Run.func1
pkg/util/wait_group_wrapper.go:103"]
```

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

### 3. What did you see instead (Required)

### 4. What is your TiDB version? (Required)
master

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.