tiflow icon indicating copy to clipboard operation
tiflow copied to clipboard

CDC should handles unreenterable DDLs correctly

Open hicqu opened this issue 1 year ago • 2 comments

Is your feature request related to a problem?

Seems all ALTER TABLEs are unreenterable:

[2023/03/24 12:22:38.220 +08:00] [WARN] [mysql_ddl_sink.go:126] ["Execute DDL with error, retry later"] [startTs=440288719245410374] [ddl="ALTER TABLE `partition360`.`partition360_6` REORGANIZE PARTITION `p20210516`,`p20210517` INTO (PARTITION `p20210517` VALUES LESS THAN (_UTF8MB4'20210518'))"] [namespace=] [changefeed=] [error="Error 1567 (HY000): Incorrect partition name"]
[2023/03/24 12:23:02.989 +08:00] [WARN] [mysql_ddl_sink.go:126] ["Execute DDL with error, retry later"] [startTs=440288719245410374] [ddl="ALTER TABLE `partition360`.`partition360_6` REORGANIZE PARTITION `p20210516`,`p20210517` INTO (PARTITION `p20210517` VALUES LESS THAN (_UTF8MB4'20210518'))"] [namespace=] [changefeed=] [error="Error 1567 (HY000): Incorrect partition name"]

Describe the feature you'd like

[ ] - ALTER TABLE REORGNIZE PARTITION

Describe alternatives you've considered

No response

Teachability, Documentation, Adoption, Migration Strategy

No response

hicqu avatar Mar 24 '23 04:03 hicqu