TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
deploy cluster Enable TLS between TiDB Components
drop table if exists t;
create table t(a char(10), b varchar(255), c text(30), d tinytext, e longtext, f mediumtext) charset utf8mb4 collate utf8mb4_unicode_ci;
insert into t values('AAAAAbbbbb', 'AAAAAbbbbb', 'AAAAAbbbbb', 'AAAAAbbbbb', 'AAAAAbbbbb', 'AAAAAbbbbb');
create index idx_a on t (a(5));
create index idx_c on t (c(5));
create index idx_f on t (f(5));
alter table t add index idx_b(b(5));
2. What did you expect to see? (Required)
All ddl execute success
3. What did you see instead (Required)
add index may failed with error 8214, 'Cancelled DDL job' without any cancel SQL
[15:13:18]TiDB root:test> alter table t add index idx_b(b(5));
(8214, 'Cancelled DDL job')
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
deploy cluster Enable TLS between TiDB Components
2. What did you expect to see? (Required)
All ddl execute success
3. What did you see instead (Required)
add index may failed with error
8214, 'Cancelled DDL job'
without any cancel SQLyou may need run many times to reproduce this.
tidb log
there are some tls handshake error in tikv log
4. What is your TiDB version? (Required)