【 TiDB 版本】: 5.7.25-TiDB-v5.4.0
【K8s 版本】:v1.20.15
【TiDB Operator 版本】:1.3.2
【遇到的问题】:
执行一个create table命令后一直卡死,也不能用kill tidb sessionid 杀掉:
CREATE TABLE `test` (
`orderId` varchar(50) NOT NULL COMMENT '生产计划单号',
`state` tinyint(3) NULL DEFAULT 10 COMMENT '状态10未裁床20部分裁床50已裁床',
`data` json NULL COMMENT '扩展数据',
PRIMARY KEY (`orderId`)
) COMMENT = '裁床列表';
使用SELECT ID, USER, INSTANCE, INFO FROM INFORMATION_SCHEMA.CLUSTER_PROCESSLIST order by info desc 查看进程
通过 admin show ddl jobs 查看DDL job 如下 :
state状态一直是none, 上图几个cancelling的状态是被我取消的
查看tidb日志,出现很多下面的报错,每隔十秒报一次 :
[2022/07/06 07:36:03.170 +00:00] [ERROR] [terror.go:307] ["encountered error"] [error=EOF] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:516"]
[2022/07/06 07:36:13.171 +00:00] [ERROR] [terror.go:307] ["encountered error"] [error=EOF] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:516"]
[2022/07/06 07:36:23.171 +00:00] [ERROR] [terror.go:307] ["encountered error"] [error=EOF] [stack="github.com/pingcap/tidb/parser/terror.Log\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:307\
github.com/pingcap/tidb/server.(*Server).onConn\
\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:516"]
为什么执行DDL命令会卡死,怎么查看是哪里的问题呢 :
集群节点信息: