TiDB stuck during analyze table

[fubinzh]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. Run sysbench oltp_insert workload with 10 tables, 500000 records each

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

1. TiDB should works normally.

3. What did you see instead (Required)

analyze table seems stuck, and I am not able to connect mysql cli.

/ # grep expensivequery.go /var/lib/tidb/log/tidb.log | head -n3
[2022/12/30 03:35:43.489 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=60.015435935s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]
[2022/12/30 03:36:43.489 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=120.015578973s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]
[2022/12/30 03:37:43.589 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=180.115062225s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]
/ # grep expensivequery.go /var/lib/tidb/log/tidb.log | tail -n3
[2022/12/30 06:21:54.489 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=10031.014959535s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]
[2022/12/30 06:22:54.489 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=10091.015379688s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]
[2022/12/30 06:23:54.588 +00:00] [WARN] [expensivequery.go:118] [expensive_query] [cost_time=10151.114798166s] [conn_id=9140029055469355011] [txn_start_ts=0] [mem_max="124141468 Bytes (118.4 MB)"] [sql="analyze table `workload`.`sbtest5`"]

4. What is your TiDB version? (Required)

Release Version: v6.6.0-alpha
Edition: Community
Git Commit Hash: 1a7b395
Git Branch: heads/refs/tags/v6.6.0-alpha
UTC Build Time: 2022-12-29 11:49:16
GoVersion: go1.19.3
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore

[fubinzh]

[xuyifangreeneyes]

tidb_debug_20221230070602.zip

[xuyifangreeneyes]

ANALYZE seems stuck at gp.(*Pool).Go. @tiancaiamao could you please help take a look?