已解决:使用ADMIN CANCEL DDL卡住cancelling

【TiDB 使用环境】生产环境
【TiDB 版本】8.5.2
【操作系统】rocky10
【部署方式】机器部署,跟性能关系不大,表就3000行
【集群数据量】
【集群节点数】
【问题复现路径】向表的int类型字段添加了单列索引,添加过程中卡住。使用 ADMIN CANCEL DDL 取消了一次,取消成功,见任务1003。重试添加索引的操作,再次卡住,使用 ADMIN CANCEL DDL取消,则卡在了cancelling,见任务1004。表没有同时在写或者读,而且表很小,只有65列4000行。

1004	fuckstock	fs_sim_task	add index	write reorganization	122	1001	3840	2025-08-22 09:29:24.0	2025-08-22 09:29:24.0		**cancelling**	ingest, DXF
1003	fuckstock	fs_sim_task	add index	none	122	1001	3840	2025-08-22 09:27:44.0	2025-08-22 09:27:44.0	2025-08-22 09:29:03.0	**rollback done**	ingest, DXF

数据不多。应该是等待元数据锁。。查看一下锁信息

感谢大佬。我不知道该怎样看,做了这两个尝试。

使用

SELECT * FROM INFORMATION_SCHEMA.TIDB_TRX

结果

460279782258245650	2025-08-22 10:00:26.803000	fe753a57d92e31ccca44c8f269493f58ccc49ee6e67e2b4cf7164361efee6712		Idle		0	0	3850371086	root	fuckstock	["fe753a57d92e31ccca44c8f269493f58ccc49ee6e67e2b4cf7164361efee6712"]		

这个我看不懂是不是卡住的原因。

使用

SELECT * FROM INFORMATION_SCHEMA.CLUSTER_PROCESSLIST WHERE DB = 'fuckstock' AND INFO LIKE '%fs_sim_task%';

结果

192.168.193.95:10080	3850371086	root	192.168.193.27:60095	fuckstock	Query	1618	autocommit	CREATE TABLE `fs_sim_task_copy1` (
  `id` int NOT NULL AUTO_INCREMENT,
  `profile` json DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30001;	fe753a57d92e31ccca44c8f269493f58ccc49ee6e67e2b4cf7164361efee6712	0	0		default		0	0	0

后面这个是因为我考虑复制一个卡住的表,然后把数据挪过去。结果因为1004卡住了,这个也跟着卡住了。

感谢大佬,使用如下命令查询

select * from information_schema.data_lock_waits

返回0行。似乎没有锁

select * from mysql.tidb_mdl_view
这个是看元数据锁的

感谢大佬指点,执行

select * from mysql.tidb_mdl_view

返回也是0行

你先把你那个复制的表的连接kill掉看看呢

试过了,kill不掉

使用

show processlist;

得到返回

3850371076	root	192.168.193.27:59768		Sleep	4625	autocommit	
3850371086	root	192.168.193.27:60095	fuckstock	Query	3336	autocommit	CREATE TABLE `fs_sim_task_copy1` (
  `id` int NOT NULL AUTO_INCREMENT,
  `profile` json DEFAULT NULL
3850371078	root	192.168.193.27:59769		Sleep	576	autocommit	
3850371080	root	192.168.193.27:59771		Query	0	autocommit	/* ApplicationName=DBeaver 25.1.5 - SQLEditor <Script-8.sql> */ show processlist

使用

SET GLOBAL tidb_multi_statement_mode='ON';
kill tidb 3850371086;
kill 3850371086;

执行后,3850371086仍在。

先看看ddl 的owner在哪个节点上,然后看看那个节点的tidb的日志

Z.zip (4.0 MB)
感谢大佬。不太确定哪个有用,最后的日志打包了。

感觉可能相关的就这部分,没有其他报错。看内容跟重启的两次DB对上了。

[2025/08/22 09:34:52.825 +08:00] [INFO] [printer.go:52] ["Welcome to TiDB."] ["Release Version"=v8.5.2] [Edition=Community] ["Git Commit Hash"=f43a13324440f92209e2a9f04c0bbe9cf763978d] ["Git Branch"=HEAD] ["UTC Build Time"="2025-05-29 03:30:55"] [GoVersion=go1.23.8] ["Race Enabled"=false] ["Check Table Before Drop"=false]
[2025/08/22 09:34:52.826 +08:00] [WARN] [cgmon.go:90] ["failed to get cgroup cpu quota"] [error="error when read cpu quota from cgroup v2 at /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: open /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: no such file or directory"]
[2025/08/22 09:34:52.826 +08:00] [INFO] [cgmon.go:154] ["set the memory limit"] [memLimit=16095866880]
[2025/08/22 09:34:52.827 +08:00] [INFO] [printer.go:57] ["loaded config"] [config="{\"host\":\"0.0.0.0\",\"advertise-address\":\"192.168.193.95\",\"port\":4000,\"cors\":\"\",\"store\":\"tikv\",\"path\":\"192.168.193.92:2379,192.168.193.93:2379\",\"socket\":\"/tmp/tidb-4000.sock\",\"lease\":\"45s\",\"split-table\":true,\"token-limit\":1000,\"temp-dir\":\"/tmp/tidb\",\"tmp-storage-path\":\"/tmp/1000_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage\",\"tmp-storage-quota\":-1,\"server-version\":\"\",\"version-comment\":\"\",\"tidb-edition\":\"\",\"tidb-release-version\":\"\",\"keyspace-name\":\"\",\"log\":{\"level\":\"error\",\"format\":\"text\",\"disable-timestamp\":null,\"enable-timestamp\":null,\"disable-error-stack\":null,\"enable-error-stack\":null,\"file\":{\"filename\":\"/tidb-deploy/tidb-4000/log/tidb.log\",\"max-size\":30,\"max-days\":3,\"max-backups\":3,\"compression\":\"\"},\"slow-query-file\":\"/tidb-deploy/tidb-4000/log/tidb_slow_query.log\",\"expensive-threshold\":10000,\"general-log-file\":\"\",\"query-log-max-len\":4096,\"enable-slow-log\":true,\"slow-threshold\":300,\"record-plan-in-slow-log\":1,\"timeout\":0},\"instance\":{\"tidb_general_log\":false,\"tidb_pprof_sql_cpu\":false,\"ddl_slow_threshold\":300,\"tidb_expensive_query_time_threshold\":60,\"tidb_expensive_txn_time_threshold\":600,\"tidb_stmt_summary_enable_persistent\":false,\"tidb_stmt_summary_filename\":\"tidb-statements.log\",\"tidb_stmt_summary_file_max_days\":3,\"tidb_stmt_summary_file_max_size\":64,\"tidb_stmt_summary_file_max_backups\":0,\"tidb_enable_slow_log\":true,\"tidb_slow_log_threshold\":300,\"tidb_record_plan_in_slow_log\":1,\"tidb_check_mb4_value_in_utf8\":true,\"tidb_force_priority\":\"NO_PRIORITY\",\"tidb_memory_usage_alarm_ratio\":0.8,\"tidb_enable_collect_execution_info\":true,\"plugin_dir\":\"/data/deploy/plugin\",\"plugin_load\":\"\",\"max_connections\":0,\"tidb_enable_ddl\":true,\"tidb_enable_stats_owner\":true,\"tidb_rc_read_check_ts\":false,\"tidb_service_scope\":\"\"},\"security\":{\"skip-grant-table\":false,\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\",\"cluster-ssl-ca\":\"\",\"cluster-ssl-cert\":\"\",\"cluster-ssl-key\":\"\",\"cluster-verify-cn\":null,\"session-token-signing-cert\":\"/tidb-deploy/tidb-4000/tls/tiproxy-session.crt\",\"session-token-signing-key\":\"/tidb-deploy/tidb-4000/tls/tiproxy-session.key\",\"spilled-file-encryption-method\":\"plaintext\",\"enable-sem\":false,\"auto-tls\":false,\"tls-version\":\"\",\"rsa-key-size\":4096,\"secure-bootstrap\":false,\"auth-token-jwks\":\"\",\"auth-token-refresh-interval\":\"1h0m0s\",\"disconnect-on-expired-password\":true},\"status\":{\"status-host\":\"0.0.0.0\",\"metrics-addr\":\"\",\"status-port\":10080,\"metrics-interval\":15,\"report-status\":true,\"record-db-qps\":false,\"record-db-label\":false,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-concurrent-streams\":1024,\"grpc-initial-window-size\":2097152,\"grpc-max-send-msg-size\":2147483647},\"performance\":{\"max-procs\":0,\"max-memory\":0,\"server-memory-quota\":0,\"stats-lease\":\"3s\",\"stmt-count-limit\":5000,\"pseudo-estimate-ratio\":0.8,\"bind-info-lease\":\"3s\",\"txn-entry-size-limit\":6291456,\"txn-total-size-limit\":104857600,\"tcp-keep-alive\":true,\"tcp-no-delay\":true,\"cross-join\":true,\"distinct-agg-push-down\":false,\"max-txn-ttl\":3600000,\"index-usage-sync-lease\":\"\",\"plan-replayer-gc-lease\":\"10m\",\"gogc\":100,\"enforce-mpp\":false,\"stats-load-concurrency\":0,\"stats-load-queue-size\":1000,\"analyze-partition-concurrency-quota\":16,\"plan-replayer-dump-worker-concurrency\":1,\"enable-stats-cache-mem-quota\":true,\"committer-concurrency\":128,\"run-auto-analyze\":true,\"force-priority\":\"NO_PRIORITY\",\"memory-usage-alarm-ratio\":0.8,\"enable-load-fmsketch\":false,\"lite-init-stats\":true,\"force-init-stats\":true,\"concurrently-init-stats\":true,\"projection-push-down\":true},\"prepared-plan-cache\":{\"enabled\":true,\"capacity\":100,\"memory-guard-ratio\":0.1},\"opentracing\":{\"enable\":false,\"rpc-metrics\":false,\"sampler\":{\"type\":\"const\",\"param\":1,\"sampling-server-url\":\"\",\"max-operations\":0,\"sampling-refresh-interval\":0},\"reporter\":{\"queue-size\":0,\"buffer-flush-interval\":0,\"log-spans\":false,\"local-agent-host-port\":\"\"}},\"proxy-protocol\":{\"networks\":\"\",\"header-timeout\":5,\"fallbackable\":false},\"pd-client\":{\"pd-server-timeout\":3},\"tikv-client\":{\"grpc-connection-count\":4,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-compression-type\":\"none\",\"grpc-shared-buffer-pool\":false,\"grpc-initial-window-size\":134217728,\"grpc-initial-conn-window-size\":134217728,\"commit-timeout\":\"41s\",\"async-commit\":{\"keys-limit\":256,\"total-key-size-limit\":4096,\"safe-window\":2000000000,\"allowed-clock-drift\":500000000},\"batch-policy\":\"standard\",\"max-batch-size\":128,\"overload-threshold\":200,\"max-batch-wait-time\":0,\"batch-wait-size\":8,\"enable-chunk-rpc\":true,\"region-cache-ttl\":600,\"store-limit\":0,\"store-liveness-timeout\":\"1s\",\"copr-cache\":{\"capacity-mb\":1000},\"copr-req-timeout\":60000000000,\"ttl-refreshed-txn-size\":33554432,\"resolve-lock-lite-threshold\":16,\"max-concurrency-request-limit\":9223372036854775807,\"enable-replica-selector-v2\":true},\"compatible-kill-query\":false,\"pessimistic-txn\":{\"max-retry-count\":256,\"deadlock-history-capacity\":10,\"deadlock-history-collect-retryable\":false,\"pessimistic-auto-commit\":false,\"constraint-check-in-place-pessimistic\":true},\"max-index-length\":3072,\"index-limit\":64,\"table-column-count-limit\":1017,\"graceful-wait-before-shutdown\":0,\"alter-primary-key\":false,\"treat-old-version-utf8-as-utf8mb4\":true,\"enable-table-lock\":false,\"delay-clean-table-lock\":0,\"split-region-max-num\":1000,\"top-sql\":{\"receiver-address\":\"\"},\"repair-mode\":false,\"repair-table-list\":[],\"isolation-read\":{\"engines\":[\"tikv\",\"tiflash\",\"tidb\"]},\"new_collations_enabled_on_first_bootstrap\":true,\"experimental\":{\"allow-expression-index\":false},\"skip-register-to-dashboard\":false,\"enable-telemetry\":false,\"labels\":{},\"enable-global-index\":false,\"deprecate-integer-display-length\":true,\"enable-enum-length-limit\":true,\"stores-refresh-interval\":60,\"enable-tcp4-only\":false,\"enable-forwarding\":false,\"max-ballast-object-size\":0,\"ballast-object-size\":0,\"transaction-summary\":{\"transaction-summary-capacity\":500,\"transaction-id-digest-min-duration\":2147483647},\"enable-global-kill\":true,\"enable-32bits-connection-id\":true,\"initialize-sql-file\":\"\",\"enable-batch-dml\":false,\"mem-quota-query\":1073741824,\"oom-action\":\"cancel\",\"oom-use-tmp-storage\":true,\"check-mb4-value-in-utf8\":true,\"enable-collect-execution-info\":true,\"plugin\":{\"dir\":\"/data/deploy/plugin\",\"load\":\"\"},\"max-server-connections\":0,\"run-ddl\":true,\"disaggregated-tiflash\":false,\"autoscaler-type\":\"aws\",\"autoscaler-addr\":\"tiflash-autoscale-lb.tiflash-autoscale.svc.cluster.local:8081\",\"is-tiflashcompute-fixed-pool\":false,\"autoscaler-cluster-id\":\"\",\"use-autoscaler\":false,\"tidb-max-reuse-chunk\":64,\"tidb-max-reuse-column\":256,\"tidb-enable-exit-check\":false,\"in-mem-slow-query-topn-num\":30,\"in-mem-slow-query-recent-num\":500}"]
[2025/08/22 09:34:52.828 +08:00] [ERROR] [cpu.go:67] [GetCgroupCPU] [error="error when read cpu quota from cgroup v2 at /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: open /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: no such file or directory"]
[2025/08/22 09:34:55.120 +08:00] [ERROR] [tso_client.go:366] ["[tso] update connection contexts failed"] [dc=global] [error="rpc error: code = Canceled desc = context canceled"]
[2025/08/22 11:08:15.373 +08:00] [INFO] [printer.go:52] ["Welcome to TiDB."] ["Release Version"=v8.5.2] [Edition=Community] ["Git Commit Hash"=f43a13324440f92209e2a9f04c0bbe9cf763978d] ["Git Branch"=HEAD] ["UTC Build Time"="2025-05-29 03:30:55"] [GoVersion=go1.23.8] ["Race Enabled"=false] ["Check Table Before Drop"=false]
[2025/08/22 11:08:15.374 +08:00] [WARN] [cgmon.go:90] ["failed to get cgroup cpu quota"] [error="error when read cpu quota from cgroup v2 at /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: open /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: no such file or directory"]
[2025/08/22 11:08:15.374 +08:00] [INFO] [cgmon.go:154] ["set the memory limit"] [memLimit=16095866880]
[2025/08/22 11:08:15.375 +08:00] [INFO] [printer.go:57] ["loaded config"] [config="{\"host\":\"0.0.0.0\",\"advertise-address\":\"192.168.193.95\",\"port\":4000,\"cors\":\"\",\"store\":\"tikv\",\"path\":\"192.168.193.92:2379,192.168.193.93:2379\",\"socket\":\"/tmp/tidb-4000.sock\",\"lease\":\"45s\",\"split-table\":true,\"token-limit\":1000,\"temp-dir\":\"/tmp/tidb\",\"tmp-storage-path\":\"/tmp/1000_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage\",\"tmp-storage-quota\":-1,\"server-version\":\"\",\"version-comment\":\"\",\"tidb-edition\":\"\",\"tidb-release-version\":\"\",\"keyspace-name\":\"\",\"log\":{\"level\":\"error\",\"format\":\"text\",\"disable-timestamp\":null,\"enable-timestamp\":null,\"disable-error-stack\":null,\"enable-error-stack\":null,\"file\":{\"filename\":\"/tidb-deploy/tidb-4000/log/tidb.log\",\"max-size\":30,\"max-days\":3,\"max-backups\":3,\"compression\":\"\"},\"slow-query-file\":\"/tidb-deploy/tidb-4000/log/tidb_slow_query.log\",\"expensive-threshold\":10000,\"general-log-file\":\"\",\"query-log-max-len\":4096,\"enable-slow-log\":true,\"slow-threshold\":300,\"record-plan-in-slow-log\":1,\"timeout\":0},\"instance\":{\"tidb_general_log\":false,\"tidb_pprof_sql_cpu\":false,\"ddl_slow_threshold\":300,\"tidb_expensive_query_time_threshold\":60,\"tidb_expensive_txn_time_threshold\":600,\"tidb_stmt_summary_enable_persistent\":false,\"tidb_stmt_summary_filename\":\"tidb-statements.log\",\"tidb_stmt_summary_file_max_days\":3,\"tidb_stmt_summary_file_max_size\":64,\"tidb_stmt_summary_file_max_backups\":0,\"tidb_enable_slow_log\":true,\"tidb_slow_log_threshold\":300,\"tidb_record_plan_in_slow_log\":1,\"tidb_check_mb4_value_in_utf8\":true,\"tidb_force_priority\":\"NO_PRIORITY\",\"tidb_memory_usage_alarm_ratio\":0.8,\"tidb_enable_collect_execution_info\":true,\"plugin_dir\":\"/data/deploy/plugin\",\"plugin_load\":\"\",\"max_connections\":0,\"tidb_enable_ddl\":true,\"tidb_enable_stats_owner\":true,\"tidb_rc_read_check_ts\":false,\"tidb_service_scope\":\"\"},\"security\":{\"skip-grant-table\":false,\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\",\"cluster-ssl-ca\":\"\",\"cluster-ssl-cert\":\"\",\"cluster-ssl-key\":\"\",\"cluster-verify-cn\":null,\"session-token-signing-cert\":\"/tidb-deploy/tidb-4000/tls/tiproxy-session.crt\",\"session-token-signing-key\":\"/tidb-deploy/tidb-4000/tls/tiproxy-session.key\",\"spilled-file-encryption-method\":\"plaintext\",\"enable-sem\":false,\"auto-tls\":false,\"tls-version\":\"\",\"rsa-key-size\":4096,\"secure-bootstrap\":false,\"auth-token-jwks\":\"\",\"auth-token-refresh-interval\":\"1h0m0s\",\"disconnect-on-expired-password\":true},\"status\":{\"status-host\":\"0.0.0.0\",\"metrics-addr\":\"\",\"status-port\":10080,\"metrics-interval\":15,\"report-status\":true,\"record-db-qps\":false,\"record-db-label\":false,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-concurrent-streams\":1024,\"grpc-initial-window-size\":2097152,\"grpc-max-send-msg-size\":2147483647},\"performance\":{\"max-procs\":0,\"max-memory\":0,\"server-memory-quota\":0,\"stats-lease\":\"3s\",\"stmt-count-limit\":5000,\"pseudo-estimate-ratio\":0.8,\"bind-info-lease\":\"3s\",\"txn-entry-size-limit\":6291456,\"txn-total-size-limit\":104857600,\"tcp-keep-alive\":true,\"tcp-no-delay\":true,\"cross-join\":true,\"distinct-agg-push-down\":false,\"max-txn-ttl\":3600000,\"index-usage-sync-lease\":\"\",\"plan-replayer-gc-lease\":\"10m\",\"gogc\":100,\"enforce-mpp\":false,\"stats-load-concurrency\":0,\"stats-load-queue-size\":1000,\"analyze-partition-concurrency-quota\":16,\"plan-replayer-dump-worker-concurrency\":1,\"enable-stats-cache-mem-quota\":true,\"committer-concurrency\":128,\"run-auto-analyze\":true,\"force-priority\":\"NO_PRIORITY\",\"memory-usage-alarm-ratio\":0.8,\"enable-load-fmsketch\":false,\"lite-init-stats\":true,\"force-init-stats\":true,\"concurrently-init-stats\":true,\"projection-push-down\":true},\"prepared-plan-cache\":{\"enabled\":true,\"capacity\":100,\"memory-guard-ratio\":0.1},\"opentracing\":{\"enable\":false,\"rpc-metrics\":false,\"sampler\":{\"type\":\"const\",\"param\":1,\"sampling-server-url\":\"\",\"max-operations\":0,\"sampling-refresh-interval\":0},\"reporter\":{\"queue-size\":0,\"buffer-flush-interval\":0,\"log-spans\":false,\"local-agent-host-port\":\"\"}},\"proxy-protocol\":{\"networks\":\"\",\"header-timeout\":5,\"fallbackable\":false},\"pd-client\":{\"pd-server-timeout\":3},\"tikv-client\":{\"grpc-connection-count\":4,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-compression-type\":\"none\",\"grpc-shared-buffer-pool\":false,\"grpc-initial-window-size\":134217728,\"grpc-initial-conn-window-size\":134217728,\"commit-timeout\":\"41s\",\"async-commit\":{\"keys-limit\":256,\"total-key-size-limit\":4096,\"safe-window\":2000000000,\"allowed-clock-drift\":500000000},\"batch-policy\":\"standard\",\"max-batch-size\":128,\"overload-threshold\":200,\"max-batch-wait-time\":0,\"batch-wait-size\":8,\"enable-chunk-rpc\":true,\"region-cache-ttl\":600,\"store-limit\":0,\"store-liveness-timeout\":\"1s\",\"copr-cache\":{\"capacity-mb\":1000},\"copr-req-timeout\":60000000000,\"ttl-refreshed-txn-size\":33554432,\"resolve-lock-lite-threshold\":16,\"max-concurrency-request-limit\":9223372036854775807,\"enable-replica-selector-v2\":true},\"compatible-kill-query\":false,\"pessimistic-txn\":{\"max-retry-count\":256,\"deadlock-history-capacity\":10,\"deadlock-history-collect-retryable\":false,\"pessimistic-auto-commit\":false,\"constraint-check-in-place-pessimistic\":true},\"max-index-length\":3072,\"index-limit\":64,\"table-column-count-limit\":1017,\"graceful-wait-before-shutdown\":0,\"alter-primary-key\":false,\"treat-old-version-utf8-as-utf8mb4\":true,\"enable-table-lock\":false,\"delay-clean-table-lock\":0,\"split-region-max-num\":1000,\"top-sql\":{\"receiver-address\":\"\"},\"repair-mode\":false,\"repair-table-list\":[],\"isolation-read\":{\"engines\":[\"tikv\",\"tiflash\",\"tidb\"]},\"new_collations_enabled_on_first_bootstrap\":true,\"experimental\":{\"allow-expression-index\":false},\"skip-register-to-dashboard\":false,\"enable-telemetry\":false,\"labels\":{},\"enable-global-index\":false,\"deprecate-integer-display-length\":true,\"enable-enum-length-limit\":true,\"stores-refresh-interval\":60,\"enable-tcp4-only\":false,\"enable-forwarding\":false,\"max-ballast-object-size\":0,\"ballast-object-size\":0,\"transaction-summary\":{\"transaction-summary-capacity\":500,\"transaction-id-digest-min-duration\":2147483647},\"enable-global-kill\":true,\"enable-32bits-connection-id\":true,\"initialize-sql-file\":\"\",\"enable-batch-dml\":false,\"mem-quota-query\":1073741824,\"oom-action\":\"cancel\",\"oom-use-tmp-storage\":true,\"check-mb4-value-in-utf8\":true,\"enable-collect-execution-info\":true,\"plugin\":{\"dir\":\"/data/deploy/plugin\",\"load\":\"\"},\"max-server-connections\":0,\"run-ddl\":true,\"disaggregated-tiflash\":false,\"autoscaler-type\":\"aws\",\"autoscaler-addr\":\"tiflash-autoscale-lb.tiflash-autoscale.svc.cluster.local:8081\",\"is-tiflashcompute-fixed-pool\":false,\"autoscaler-cluster-id\":\"\",\"use-autoscaler\":false,\"tidb-max-reuse-chunk\":64,\"tidb-max-reuse-column\":256,\"tidb-enable-exit-check\":false,\"in-mem-slow-query-topn-num\":30,\"in-mem-slow-query-recent-num\":500}"]
[2025/08/22 11:08:15.376 +08:00] [ERROR] [cpu.go:67] [GetCgroupCPU] [error="error when read cpu quota from cgroup v2 at /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: open /sys/fs/cgroup/system.slice/tidb-4000.service/cpu.max: no such file or directory"]
[2025/08/22 11:08:17.652 +08:00] [ERROR] [tso_client.go:366] ["[tso] update connection contexts failed"] [dc=global] [error="rpc error: code = Canceled desc = context canceled"]
[2025/08/22 11:08:17.652 +08:00] [ERROR] [pd_service_discovery.go:561] ["[pd] failed to update member"] [urls="[http://192.168.193.87:2379,http://192.168.193.92:2379,http://192.168.193.93:2379]"] [error="context canceled"]

9点多跟11点的重启是手动重启的吗?有几个tidb实例?

3个db实例,有1个在物理维修,只开了2个。重启的2次都是重启的ddl的owner。

滚动重启全部节点后。问题解决 :joy:
只重启ddl owner不行 :joy:

感谢 @Miracle @TiDBer_HErMeXDz 的帮助。

1 个赞

学习了

遇到了同样的问题,怎么都取消不掉,连接都kill不掉。真觉得是bug

1 个赞

我觉得这是TiDB的BUG, 遇到这种问题太尴尬了,只能重启解决

此话题已在最后回复的 7 天后被自动关闭。不再允许新回复。