tidb节点的日志,一直报如下错误,有2台重启后,该报错消失, 另一台则反复出现,请问这个问题怎么处理,因为是生产环境,所以不能试,谢谢。
[2021/06/29 12:40:26.054 +08:00] [ERROR] [analyze.go:172] [“analyze worker panicked”] [stack=“goroutine 4804628 [running]:\ngithub.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWorker.func1(0xc00e4eac60, 0xc0019cded8, 0xc00fcb5b00, 0x1)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:170 +0xff\
panic(0x3169660, 0xc0115fc480)\
\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/util/collate.decodeRune(0xc00c737752, 0x8, 0x7, 0x6ce, 0x7)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/collate/unicode_ci.go:53 +0x111\ngithub.com/pingcap/tidb/util/collate.(*generalCICollator).Compare(0x54fb878, 0xc00c737752, 0x8, 0xc00c737672, 0x8, 0xffffffffffffffff)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/util/collate/general_ci.go:39 +0xdb\ngithub.com/pingcap/tidb/types.CompareString(0xc00c737752, 0x8, 0xc00c737672, 0x8, 0xc001c7cc80, 0x12, 0xffffffffffffffff)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/compare.go:118 +0x71\ngithub.com/pingcap/tidb/types.(*Datum).compareString(0xc009c099e0, 0xc0116ea900, 0xc00c737672, 0x8, 0xc001c7cc80, 0x12, 0xffffffffffffffff, 0x0, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/datum.go:665 +0x112\ngithub.com/pingcap/tidb/types.(*Datum).CompareDatum(0xc009c099e0, 0xc0116ea900, 0xc009c090e0, 0xffffffffffffffff, 0x0, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/types/datum.go:565 +0x28c\ngithub.com/pingcap/tidb/statistics.(*sampleItemSorter).Less(0xc00911a150, 0x16, 0x15, 0x1)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/sample.go:67 +0x68\
sort.insertionSort(0x38b0f00, 0xc00911a150, 0x14, 0x28)\
\t/usr/local/go/src/sort/sort.go:27 +0xc4\
sort.stable(0x38b0f00, 0xc00911a150, 0x3e8)\
\t/usr/local/go/src/sort/sort.go:364 +0x51\
sort.Stable(0x38b0f00, 0xc00911a150)\
\t/usr/local/go/src/sort/sort.go:357 +0x53\ngithub.com/pingcap/tidb/statistics.SortSampleItems(...)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/sample.go:51\
github.com/pingcap/tidb/statistics.BuildColumnHist(0x39090e0, 0xc0021907e0, 0x100, 0x3, 0xc00e4eb140, 0xc000e4a6e8, 0x3f9, 0x182, 0x0, 0x4, …)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/builder.go:113 +0x1b8\ngithub.com/pingcap/tidb/statistics.BuildColumn(0x39090e0, 0xc0021907e0, 0x100, 0x3, 0xc00e4eb140, 0xc000e4a6e8, 0xc001c7cc80, 0x12, 0x0)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/statistics/builder.go:185 +0xa3\ngithub.com/pingcap/tidb/executor.(*AnalyzeColumnsExec).buildStats(0xc0057780e0, 0xc00ac1e010, 0x1, 0x1, 0xc007ffa1f0, 0x2, 0x2, 0xc007ffa200, 0x2, 0x2, …)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:527 +0xa5f\ngithub.com/pingcap/tidb/executor.analyzeColumnsPushdown(0xc0057780e0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, …)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:379 +0xab\ngithub.com/pingcap/tidb/executor.(*AnalyzeExec).analyzeWorker(0xc00fcb5b00, 0xc00e4eac00, 0xc00e4eac60, 0x1)\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:195 +0x1ce\
created by github.com/pingcap/tidb/executor.(*AnalyzeExec).Next\
\t/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/analyze.go:87 +0x147\
”]
[2021/06/29 12:40:26.054 +08:00] [INFO] [tidb.go:219] [“rollbackTxn for ddl/autocommit failed”]
[2021/06/29 12:40:26.054 +08:00] [WARN] [session.go:1383] [“run statement failed”] [schemaVersion=6409] [error=“analyze worker panic”] [session="{\
“currDBName”: “”,\
“id”: 0,\
“status”: 2,\
“strictMode”: true,\
“user”: null\
}"]
[2021/06/29 12:40:26.054 +08:00] [ERROR] [update.go:796] ["[stats] auto analyze failed"] [sql=“analyze table %n.%n”] [cost_time=16.335944ms] [error=“analyze worker panic”]