sync `CREATE VIEW AS SELECT FROM` ddl failed
Open
Nobody has claimed this yet.
contribution
ga-optional
type/bug
- Dominant language
- Go
- Stars
- 56
- Forks
- 63
- Avg merge
- 2d 20h
- Merged PRs (30d)
- 34
Description
What did you do?
lag abnormal
What did you expect to see?
No response
What did you see instead?
[2025/09/09 14:06:48.578 +08:00] [ERROR] [backoff.go:157] ["changefeed maintainer report an error"] [changefeed=default/cdc-sync-tidb-ddl-dml-d2nhrr1n7m53u3tl3ks0] [checkpointTs=460691340872384826] [node=upstream-ticdc-1.upstream-ticdc-peer.testbed-cdc-new-arch-kafka74ckk.svc.cluster.local:8301] [code=CDC:ErrChangefeedRetryable] [state=warning] [error="time:\"2025-09-09 14:06:43.481148117 +0800 CST m=+8797.938151963\" node:\"upstream-ticdc-1.upstream-ticdc-peer.testbed-cdc-new-arch-kafka74ckk.svc.cluster.local:8301\" code:\"CDC:ErrChangefeedRetryable\" message:\"[CDC:ErrMySQLTxnError]MySQL txn error: Execute DDL failed, Query info: CREATE ALGORITHM = UNDEFINED DEFINER = CURRENT_USER SQL SECURITY DEFINER VIEW `868db29b` AS SELECT `col532b` FROM `t3f7aeb5d`; : Error 1146 (42S02): Table 'test.t3f7aeb5d' doesn't exist\" "]
[2025/09/09 14:06:48.578 +08:00] [WARN] [backoff.go:220] ["changefeed meets an error, will be stopped"] [changefeed=default/cdc-sync-tidb-ddl-dml-d2nhrr1n7m53u3tl3ks0] [checkpointTs=460691340872384826] [nextRetryTime=2025/09/09 14:06:58.306 +08:00] [error="[{\"time\":\"2025-09-09 14:06:43.481148117 +0800 CST m=+8797.938151963\",\"node\":\"upstream-ticdc-1.upstream-ticdc-peer.testbed-cdc-new-arch-kafka74ckk.svc.cluster.local:8301\",\"code\":\"CDC:ErrChangefeedRetryable\",\"message\":\"[CDC:ErrMySQLTxnError]MySQL txn error: Execute DDL failed, Query info: CREATE ALGORITHM = UNDEFINED DEFINER = CURRENT_USER SQL SECURITY DEFINER VIEW `868db29b` AS SELECT `col532b` FROM `t3f7aeb5d`; : Error 1146 (42S02): Table 'test.t3f7aeb5d' doesn't exist\"}]"]
[2025/09/09 14:06:48.578 +08:00] [INFO] [controller.go:425] ["changefeed status changed"] [changefeed=default/cdc-sync-tidb-ddl-dml-d2nhrr1n7m53u3tl3ks0] [state=warning] [error="time:\"2025-09-09 14:06:43.481148117 +0800 CST m=+8797.938151963\" node:\"upstream-ticdc-1.upstream-ticdc-peer.testbed-cdc-new-arch-kafka74ckk.svc.cluster.local:8301\" code:\"CDC:ErrChangefeedRetryable\" message:\"[CDC:ErrMySQLTxnError]MySQL txn error: Execute DDL failed, Query info: CREATE ALGORITHM = UNDEFINED DEFINER = CURRENT_USER SQL SECURITY DEFINER VIEW `868db29b` AS SELECT `col532b` FROM `t3f7aeb5d`; : Error 1146 (42S02): Table 'test.t3f7aeb5d' doesn't exist\" "]
t3f7aeb5d-cdc-0.log
t3f7aeb5d-cdc-1.log
mysql> select * from ddl_jobs where TABLE_NAME = 't3f7aeb5d';
+--------+---------+------------+---------------------------------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME | START_TIME | END_TIME | STATE | QUERY |
+--------+---------+------------+---------------------------------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2459 | test | t3f7aeb5d | add index | none | 112 | 1994 | 0 | 2025-09-09 14:14:31.173000 | 2025-09-09 14:14:31.473000 | 2025-09-09 14:14:31.473000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `47a816ca` (`col532b`) |
| 2457 | test | t3f7aeb5d | set default value | none | 112 | 1994 | 0 | 2025-09-09 14:14:31.173000 | 2025-09-09 14:14:31.423000 | 2025-09-09 14:14:31.423000 | cancelled | ALTER TABLE `t3f7aeb5d` ALTER `col1066` SET DEFAULT '2012-07-13 07:44:29' |
| 2447 | test | t3f7aeb5d | drop column | public | 112 | 1994 | 0 | 2025-09-09 14:14:31.123000 | 2025-09-09 14:14:31.423000 | 2025-09-09 14:14:31.423000 | cancelled | ALTER TABLE `t3f7aeb5d` DROP COLUMN `col532b` |
| 2446 | test | t3f7aeb5d | drop table | none | 112 | 1994 | 0 | 2025-09-09 14:14:31.123000 | 2025-09-09 14:14:31.123000 | 2025-09-09 14:14:31.373000 | synced | DROP TABLE `t3f7aeb5d` |
| 2230 | test | t3f7aeb5d | add index | public | 112 | 1994 | 166 | 2025-09-09 14:13:26.673000 | 2025-09-09 14:13:54.673000 | 2025-09-09 14:13:59.073000 | synced | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `98888ba1` (`col009d`) |
| 2229 | test | t3f7aeb5d | add index | public | 112 | 1994 | 218 | 2025-09-09 14:13:26.673000 | 2025-09-09 14:13:47.173000 | 2025-09-09 14:13:54.573000 | synced | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `b0ecdbc0` (`col5653`, `col32f3`) |
| 2226 | test | t3f7aeb5d | modify column | none | 112 | 1994 | 0 | 2025-09-09 14:13:26.623000 | 2025-09-09 14:13:42.723000 | 2025-09-09 14:13:43.123000 | rollback done | alter table `t3f7aeb5d` change column `col009d` `8cc78c3f` DATETIME NULL DEFAULT '1485-01-25 12:04:36' FIRST |
| 2218 | test | t3f7aeb5d | alter table multi-schema change | none | 112 | 1994 | 0 | 2025-09-09 14:13:26.573000 | 2025-09-09 14:13:35.173000 | 2025-09-09 14:13:37.773000 | synced | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `ff1dea85` (`col009d`), RENAME INDEX `a469dc31` to `8ff8b7f3` |
| 2218 | test | t3f7aeb5d | add index /* subjob */ | public | 112 | 1994 | 96 | 2025-09-09 14:13:26.573000 | 2025-09-09 14:13:35.173000 | 2025-09-09 14:13:37.773000 | done | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `ff1dea85` (`col009d`), RENAME INDEX `a469dc31` to `8ff8b7f3` |
| 2218 | test | t3f7aeb5d | rename index /* subjob */ | public | 112 | 1994 | 0 | 2025-09-09 14:13:26.573000 | 2025-09-09 14:13:37.723000 | 2025-09-09 14:13:37.773000 | done | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `ff1dea85` (`col009d`), RENAME INDEX `a469dc31` to `8ff8b7f3` |
| 1997 | test | t3f7aeb5d | truncate table | none | 112 | 1286 | 0 | 2025-09-09 14:12:08.123000 | 2025-09-09 14:12:08.523000 | 2025-09-09 14:12:08.523000 | cancelled | TRUNCATE TABLE `t3f7aeb5d` |
| 1995 | test | t3f7aeb5d | truncate table | public | 112 | 1286 | 0 | 2025-09-09 14:12:08.123000 | 2025-09-09 14:12:08.173000 | 2025-09-09 14:12:08.423000 | synced | TRUNCATE TABLE `t3f7aeb5d` |
| 1665 | test | t3f7aeb5d | add index | public | 112 | 1286 | 120 | 2025-09-09 14:10:30.473000 | 2025-09-09 14:11:30.773000 | 2025-09-09 14:11:34.873000 | synced | ALTER TABLE `t3f7aeb5d` ADD INDEX `6534a158` (`col5653`) |
| 1661 | test | t3f7aeb5d | add index | public | 112 | 1286 | 114 | 2025-09-09 14:10:30.423000 | 2025-09-09 14:11:23.373000 | 2025-09-09 14:11:27.673000 | synced | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `894e19a0` (`col5653`) |
| 1658 | test | t3f7aeb5d | modify column | public | 112 | 1286 | 4 | 2025-09-09 14:10:30.423000 | 2025-09-09 14:11:22.723000 | 2025-09-09 14:11:23.323000 | synced | alter table `t3f7aeb5d` modify column `col009d` SMALLINT NULL DEFAULT '-21336' FIRST |
| 1653 | test | t3f7aeb5d | rebase auto_increment ID | public | 112 | 1286 | 0 | 2025-09-09 14:10:30.423000 | 2025-09-09 14:11:21.873000 | 2025-09-09 14:11:21.973000 | synced | alter table `t3f7aeb5d` auto_increment=5041831310539941499 |
| 1645 | test | t3f7aeb5d | drop index | none | 112 | 1286 | 0 | 2025-09-09 14:10:30.373000 | 2025-09-09 14:11:21.423000 | 2025-09-09 14:11:21.623000 | synced | ALTER TABLE `t3f7aeb5d` DROP INDEX `07f66031` |
| 1644 | test | t3f7aeb5d | add index | public | 112 | 1286 | 433 | 2025-09-09 14:10:30.373000 | 2025-09-09 14:11:14.173000 | 2025-09-09 14:11:20.973000 | synced | ALTER TABLE `t3f7aeb5d` ADD INDEX `32c9024d` (`col1066`, `col5653`, `col009d`) |
| 1288 | test | t3f7aeb5d | add column | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.473000 | 2025-09-09 14:09:57.723000 | 2025-09-09 14:09:57.723000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD COLUMN `colb60b` ENUM("83b", "h5yx1", "a2t1", "wtf5g", "m04s", "z8h", "dw", "mf", "ih", "2", "d") NULL DEFAULT 'mf' FIRST |
| 1287 | test | t3f7aeb5d | truncate table | public | 112 | 1050 | 0 | 2025-09-09 14:09:07.473000 | 2025-09-09 14:09:57.473000 | 2025-09-09 14:09:57.523000 | synced | TRUNCATE TABLE `t3f7aeb5d` |
| 1283 | test | t3f7aeb5d | add column | public | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:57.273000 | 2025-09-09 14:09:57.473000 | synced | ALTER TABLE `t3f7aeb5d` ADD COLUMN `col5653` DOUBLE NULL DEFAULT '1.9170892828214796' |
| 1282 | test | t3f7aeb5d | add index | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:52.173000 | 2025-09-09 14:09:57.273000 | rollback done | ALTER TABLE `t3f7aeb5d` ADD INDEX `d73964eb` (`col009d`) |
| 1281 | test | t3f7aeb5d | drop index | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:51.723000 | 2025-09-09 14:09:51.873000 | synced | ALTER TABLE `t3f7aeb5d` DROP INDEX `6542f9f5` |
| 1280 | test | t3f7aeb5d | add index | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:51.673000 | 2025-09-09 14:09:51.673000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `95ba6b38` (`col1066`) |
| 1279 | test | t3f7aeb5d | add index | public | 112 | 1050 | 566 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:45.973000 | 2025-09-09 14:09:50.623000 | synced | ALTER TABLE `t3f7aeb5d` ADD INDEX `a469dc31` (`col1066`, `col009d`, `col32f3`) |
| 1278 | test | t3f7aeb5d | modify column | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:45.623000 | 2025-09-09 14:09:45.923000 | rollback done | alter table `t3f7aeb5d` modify column `col32f3` SMALLINT NULL DEFAULT '378' FIRST |
| 1277 | test | t3f7aeb5d | add index | none | 112 | 1050 | 42 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:37.423000 | 2025-09-09 14:09:45.573000 | rollback done | ALTER TABLE `t3f7aeb5d` ADD INDEX `beff2fcf` (`col32f3`, `col1066`, `col009d`, `col532b`) |
| 1276 | test | t3f7aeb5d | add index | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:32.273000 | 2025-09-09 14:09:36.973000 | rollback done | ALTER TABLE `t3f7aeb5d` ADD INDEX `5842bb7f` (`col1066`) |
| 1275 | test | t3f7aeb5d | modify column | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.423000 | 2025-09-09 14:09:31.273000 | 2025-09-09 14:09:31.273000 | cancelled | alter table `t3f7aeb5d` change column `col32f3` `e1e6b95b` VARCHAR(6) NULL DEFAULT 'rn' AFTER `col1066` |
| 1274 | test | t3f7aeb5d | add index | public | 112 | 1050 | 714 | 2025-09-09 14:09:07.373000 | 2025-09-09 14:09:24.773000 | 2025-09-09 14:09:27.973000 | synced | ALTER TABLE `t3f7aeb5d` ADD INDEX `d251c71e` (`col1066`) |
| 1273 | test | t3f7aeb5d | shard row ID | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.373000 | 2025-09-09 14:09:23.423000 | 2025-09-09 14:09:23.423000 | cancelled | ALTER TABLE `t3f7aeb5d` SHARD_ROW_ID_BITS = 2 |
| 1270 | test | t3f7aeb5d | set default value | public | 112 | 1050 | 0 | 2025-09-09 14:09:07.373000 | 2025-09-09 14:09:23.223000 | 2025-09-09 14:09:23.273000 | synced | ALTER TABLE `t3f7aeb5d` ALTER `col1066` SET DEFAULT '2031-03-31 15:22:23' |
| 1269 | test | t3f7aeb5d | add index | none | 112 | 1050 | 0 | 2025-09-09 14:09:07.373000 | 2025-09-09 14:09:17.273000 | 2025-09-09 14:09:23.173000 | rollback done | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `76f90ae1` (`col009d`) |
| 1091 | test | t3f7aeb5d | add index | none | 112 | 838 | 0 | 2025-09-09 14:06:37.023000 | 2025-09-09 14:08:36.223000 | 2025-09-09 14:08:36.223000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD INDEX `7c904e8c` (`colb3a5`, `col32f3`, `col009d`, `col532b`) |
| 1082 | test | t3f7aeb5d | modify column | none | 112 | 838 | 0 | 2025-09-09 14:06:37.023000 | 2025-09-09 14:08:36.123000 | 2025-09-09 14:08:36.123000 | cancelled | alter table `t3f7aeb5d` modify column `col32f3` BLOB(235) NULL AFTER `col532b` |
| 1051 | test | t3f7aeb5d | truncate table | public | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:32.423000 | 2025-09-09 14:08:32.473000 | synced | TRUNCATE TABLE `t3f7aeb5d` |
| 1047 | test | t3f7aeb5d | add index | public | 112 | 838 | 70 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:28.373000 | 2025-09-09 14:08:32.373000 | synced | ALTER TABLE `t3f7aeb5d` ADD INDEX `07f66031` (`col532b`) |
| 1029 | test | t3f7aeb5d | drop column | public | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:05.423000 | 2025-09-09 14:08:05.423000 | cancelled | ALTER TABLE `t3f7aeb5d` DROP COLUMN `colb3a5` |
| 1028 | test | t3f7aeb5d | add column | public | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:04.223000 | 2025-09-09 14:08:04.473000 | synced | ALTER TABLE `t3f7aeb5d` ADD COLUMN `col1066` TIMESTAMP NULL DEFAULT '2038-01-13 13:14:07' AFTER `col532b` |
| 1000 | test | t3f7aeb5d | add index | none | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:04.223000 | 2025-09-09 14:08:04.223000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD INDEX `620b0cce` (`colb3a5`) |
| 986 | test | t3f7aeb5d | add index | public | 112 | 838 | 20 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:03.323000 | 2025-09-09 14:08:03.773000 | synced | ALTER TABLE `t3f7aeb5d` ADD unique INDEX `6542f9f5` (`col532b`) |
| 981 | test | t3f7aeb5d | add index | none | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:08:03.273000 | 2025-09-09 14:08:03.273000 | cancelled | ALTER TABLE `t3f7aeb5d` ADD INDEX `0b4a5ecb` (`col32f3`, `colb3a5`, `col532b`) |
| 904 | test | t3f7aeb5d | drop column | none | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:06:46.873000 | 2025-09-09 14:06:47.023000 | synced | ALTER TABLE `t3f7aeb5d` DROP COLUMN `col443e` |
| 867 | test | t3f7aeb5d | add index | none | 112 | 838 | 0 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:06:43.223000 | 2025-09-09 14:06:46.873000 | rollback done | ALTER TABLE `t3f7aeb5d` ADD INDEX `8f7da649` (`col532b`) |
| 861 | test | t3f7aeb5d | drop column | none | 112 | 838 | 0 | 2025-09-09 14:06:36.173000 | 2025-09-09 14:06:36.877000 | 2025-09-09 14:06:38.523000 | synced | ALTER TABLE `t3f7aeb5d` DROP COLUMN `colb3a5` |
| 839 | test | t3f7aeb5d | create table | public | 112 | 838 | 0 | 2025-09-09 14:06:34.023000 | 2025-09-09 14:06:34.173000 | 2025-09-09 14:06:34.223000 | synced | CREATE TABLE `t3f7aeb5d` (`colb3a5` TIMESTAMP NULL DEFAULT '2017-05-25 17:51:58', `col443e` TEXT(117) NULL, `col009d` YEAR NULL DEFAULT '1975', `col32f3` DATETIME NULL DEFAULT '9876-04-20 06:46:10', `col532b` DATETIME NULL DEFAULT '7630-06-11 15:53:49')COMMENT '25f45804' CHARACTER SET 'gb18030' COLLATE 'gb18030_chinese_ci' |
+--------+---------+------------+---------------------------------+--------------+-----------+----------+-----------+----------------------------+----------------------------+----------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
46 rows in set (1.07 sec)
mysql>
| 2446 | test | t3f7aeb5d | drop table | none | 112 | 1994 | 0 | 2025-09-09 14:14:31.123000 | 2025-09-09 14:14:31.123000 | 2025-09-09 14:14:31.373000 | synced | DROP TABLE `t3f7aeb5d` |
| 839 | test | t3f7aeb5d | create table | public | 112 | 838 | 0 | 2025-09-09 14:06:34.023000 | 2025-09-09 14:06:34.173000 | 2025-09-09 14:06:34.223000 | synced | CREATE TABLE `t3f7aeb5d` (`colb3a5` TIMESTAMP NULL DEFAULT '2017-05-25 17:51:58', `col443e` TEXT(117) NULL, `col009d` YEAR NULL DEFAULT '1975', `col32f3` DATETIME NULL DEFAULT '9876-04-20 06:46:10', `col532b` DATETIME NULL DEFAULT '7630-06-11 15:53:49')COMMENT '25f45804' CHARACTER SET 'gb18030' COLLATE 'gb18030_chinese_ci' |
Versions of the cluster
Upstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):
(paste TiDB cluster version here)
Upstream TiKV version (execute tikv-server --version):
(paste TiKV version here)
TiCDC version (execute cdc version):
(paste TiCDC version here)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.