通过重启tidb server后,再次执行ddl 还是会卡住~我这问题好像是必现了
查看了下日志,好像有很多这种错误,不知道我这卡DDL跟这有什么关系?
还有auto analyze 这个能关了吗
[2025/04/03 09:56:10.208 +08:00] [INFO] [server.go:855] [kill] [conn=991431833788874755] [query=true]
[2025/04/03 09:56:10.308 +08:00] [WARN] [expensivequery.go:77] ["auto analyze timeout, kill it"] [costTime=12h0m31.144393171s] [maxAutoAnalyzeTime=12h0m0s] [processInfo="{id:991431833788874755, user:, host:
, db:<nil>, command:Sleep, time:43231, state:autocommit, info:analyze table `bsppr`.`xpost`}"]
[2025/04/03 09:56:10.308 +08:00] [INFO] [server.go:855] [kill] [conn=991431833788874755] [query=true]
[2025/04/03 09:56:10.385 +08:00] [WARN] [coprocessor.go:431] ["buildCopTasks takes too much time"] [elapsed=1.192837679s] ["range len"=1] ["task len"=8508]
[2025/04/03 09:56:10.386 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[tikv:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.389 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze columns"] ["start time"=2025/04/02 21:55:39.284 +08:00] ["end tim
e"=2025/04/03 09:56:10.386 +08:00] [cost=12h0m31.10162098s] ["sample rate reason"=]
[2025/04/03 09:56:10.389 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.393 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_fid_url"] ["start time"=2025/04/03 09:55:40.040 +08:00]
["end time"=2025/04/03 09:56:10.389 +08:00] [cost=30.349265636s] ["sample rate reason"=]
[2025/04/03 09:56:10.393 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.396 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index postid"] ["start time"=2025/04/03 09:55:41.434 +08:00] ["en
d time"=2025/04/03 09:56:10.393 +08:00] [cost=28.958920873s] ["sample rate reason"=]
[2025/04/03 09:56:10.396 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.399 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_url"] ["start time"=2025/04/03 09:55:43.087 +08:0
0] ["end time"=2025/04/03 09:56:10.396 +08:00] [cost=27.308783492s] ["sample rate reason"=]
[2025/04/03 09:56:10.399 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.402 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_entryid"] ["start time"=2025/04/03 09:55:44.918 +
08:00] ["end time"=2025/04/03 09:56:10.399 +08:00] [cost=25.480690474s] ["sample rate reason"=]
[2025/04/03 09:56:10.402 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.406 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_type"] ["start time"=2025/04/03 09:55:46.431 +08:
00] ["end time"=2025/04/03 09:56:10.402 +08:00] [cost=23.970762222s] ["sample rate reason"=]
[2025/04/03 09:56:10.406 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.408 +08:00] [WARN] [expensivequery.go:77] ["auto analyze timeout, kill it"] [costTime=12h0m31.244495254s] [maxAutoAnalyzeTime=12h0m0s] [processInfo="{id:991431833788874755, user:, host:
, db:<nil>, command:Sleep, time:43231, state:autocommit, info:analyze table `bsppr`.`xpost`}"]
[2025/04/03 09:56:10.408 +08:00] [INFO] [server.go:855] [kill] [conn=991431833788874755] [query=true]
[2025/04/03 09:56:10.409 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_sourcetype"] ["start time"=2025/04/03 09:55:47.99
5 +08:00] ["end time"=2025/04/03 09:56:10.406 +08:00] [cost=22.411129064s] ["sample rate reason"=]
[2025/04/03 09:56:10.409 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.413 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_pt"] ["start time"=2025/04/03 09:55:49.459 +08:00
] ["end time"=2025/04/03 09:56:10.409 +08:00] [cost=20.950650292s] ["sample rate reason"=]
[2025/04/03 09:56:10.413 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.417 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_source"] ["start time"=2025/04/03 09:55:51.200 +0
8:00] ["end time"=2025/04/03 09:56:10.413 +08:00] [cost=19.213033367s] ["sample rate reason"=]
[2025/04/03 09:56:10.417 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.420 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_fid"] ["start time"=2025/04/03 09:55:52.666 +08:00] ["e
nd time"=2025/04/03 09:56:10.417 +08:00] [cost=17.750374293s] ["sample rate reason"=]
[2025/04/03 09:56:10.420 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.423 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_xpost_hidden"] ["start time"=2025/04/03 09:55:54.034 +0
8:00] ["end time"=2025/04/03 09:56:10.420 +08:00] [cost=16.38608797s] ["sample rate reason"=]
[2025/04/03 09:56:10.423 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.427 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_tidb_in_time_posttime"] ["start time"=2025/04/03 09:55:
55.606 +08:00] ["end time"=2025/04/03 09:56:10.423 +08:00] [cost=14.817462958s] ["sample rate reason"=]
[2025/04/03 09:56:10.427 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.430 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_search_by_includetime"] ["start time"=2025/04/03 09:55:
57.166 +08:00] ["end time"=2025/04/03 09:56:10.427 +08:00] [cost=13.261317422s] ["sample rate reason"=]
[2025/04/03 09:56:10.430 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.434 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_search_by_posttime"] ["start time"=2025/04/03 09:55:58.
488 +08:00] ["end time"=2025/04/03 09:56:10.430 +08:00] [cost=11.941732149s] ["sample rate reason"=]
[2025/04/03 09:56:10.434 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.437 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_url_parent_url"] ["start time"=2025/04/03 09:55:59.734
+08:00] ["end time"=2025/04/03 09:56:10.434 +08:00] [cost=10.69930269s] ["sample rate reason"=]
[2025/04/03 09:56:10.437 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.441 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_update_time"] ["start time"=2025/04/03 09:56:01.535 +08
:00] ["end time"=2025/04/03 09:56:10.437 +08:00] [cost=8.901658118s] ["sample rate reason"=]
[2025/04/03 09:56:10.441 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.444 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_facetid_update_time"] ["start time"=2025/04/03 09:56:04
.542 +08:00] ["end time"=2025/04/03 09:56:10.441 +08:00] [cost=5.898334456s] ["sample rate reason"=]
[2025/04/03 09:56:10.444 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.448 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_search_personal_by_posttime"] ["start time"=2025/04/03
09:56:06.703 +08:00] ["end time"=2025/04/03 09:56:10.444 +08:00] [cost=3.74148036s] ["sample rate reason"=]
[2025/04/03 09:56:10.448 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.451 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_personal_domain"] ["start time"=2025/04/03 09:56:07.854
+08:00] ["end time"=2025/04/03 09:56:10.448 +08:00] [cost=2.593572507s] ["sample rate reason"=]
[2025/04/03 09:56:10.451 +08:00] [ERROR] [analyze.go:321] ["analyze failed"] [error="[executor:1317]Query execution was interrupted"]
[2025/04/03 09:56:10.455 +08:00] [INFO] [analyze.go:600] ["analyze table `bsppr`.`xpost` has failed"] [partition=] ["job info"="auto analyze index idx_search_personal_by_includetime"] ["start time"=2025/04/
03 09:56:09.188 +08:00] ["end time"=2025/04/03 09:56:10.451 +08:00] [cost=1.262966601s] ["sample rate reason"=]
[2025/04/03 09:56:10.455 +08:00] [INFO] [tidb.go:285] ["rollbackTxn called due to ddl/autocommit failure"]
[2025/04/03 09:56:10.455 +08:00] [WARN] [session.go:2283] ["run statement failed"] [schemaVersion=3372] [error="[executor:1317]Query execution was interrupted"] [session="{\n \"currDBName\": \"\",\n \"id\
": 991431833788874755,\n \"status\": 2,\n \"strictMode\": true,\n \"user\": null\n}"]
[2025/04/03 09:56:10.455 +08:00] [ERROR] [update.go:1307] ["[stats] auto analyze failed"] [sql="analyze table `bsppr`.`xpost`"] [cost_time=12h0m31.291076475s] [error="[executor:1317]Query execution was inte
rrupted"]
[2025/04/03 09:56:10.457 +08:00] [INFO] [update.go:1181] ["[stats] auto analyze triggered"] [sql="analyze table `bsppr`.`xpost`"] [reason="too many modifications(23304517196/7.347925096e+09>0.5)"]
[2025/04/03 09:56:28.555 +08:00] [INFO] [region_request.go:1467] ["send request meet region error without retry"] [req-ts=457086176714293285] [req-type=Prewrite] [region="{ region id: 24404086, ver: 113236,
confVer: 203776 }"] [region-is-valid=false] [retry-times=0] [replica-read-type=leader] [replica-selector-state=accessKnownLeader] [stale-read=false] [replica-status="peer: 32192895, store: 2, isEpochStale:
false, attempts: 0, replica-epoch: 1, store-epoch: 1, store-state: resolved, store-liveness-state: reachable; peer: 32192956, store: 2949399, isEpochStale: false, attempts: 0, replica-epoch: 1, store-epoch
: 1, store-state: resolved, store-liveness-state: reachable; peer: 32193037, store: 6124709, isEpochStale: false, attempts: 1, replica-epoch: 0, store-epoch: 0, store-state: resolved, store-liveness-state:
reachable"] [total-backoff-ms=0] [total-backoff-times=0] [total-region-errors=region_not_found:1]