TiCDC Downstream Repeatedly Executing the Same DDL

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ticdc下游重复运行同样的DDL

| username: TiDBer_pkQ5q1l0

[Test Environment] TiDB
[TiDB Version] v6.5.2
[Reproduction Path] Operations performed that led to the issue
SQL executed upstream


SQL actually executed downstream

I want to know why the upstream only executed the DDL once, but ticdc synchronized 14 identical DDL operations downstream.

| username: TiDBer_pkQ5q1l0 | Original post link

Add the CDC configuration
image

| username: yilong | Original post link

Looking at the DDL job information, there is an add index on this table, which causes the add column to fail continuously. So TiCDC might repeatedly send the add column information. Once the add index is completed, one should execute successfully, and the others will be canceled, right?
You can check the ticdc.log to confirm the reason for the repeated sending.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.