[Limitation] TiCDC can't not handle DDL as alter table xx add column xx datetime default current_timestamp
properly
#11368
Labels
affects-5.4
affects-6.1
affects-6.5
affects-7.1
affects-7.5
affects-8.1
area/ticdc
Issues or PRs related to TiCDC.
report/customer
Customers have encountered this bug.
severity/major
This is a major bug.
type/bug
This is a bug.
What did you do?
Reproduction Steps
Create a table t1
Create a changefeed to replicate this table
Insert some data into t1
Pause changefeed (the purpose is to manually create synchronization delay), assuming the current time is time1.
Add a new column to t1
Resume the changefeed and wait for the changefeed to replicate the above DDL downstream. Assume the current time is time2.
When comparing the upstream and downstream data, it will be found that the values of the newly added column updatetime upstream and downstream inconsistent. The difference in this column upstream and downstream is
time2 - time1
.Reason: This is because cdc only synchronizes the DDL itself when synchronizing DDLs that will cause destructive changes like add column, and does not synchronize the row changes caused by the DDL. The reason for doing this is to reduce synchronization latency.
Currently, these inconsistent data can only be manually fixed.
What did you expect to see?
No response
What did you see instead?
As described above.
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
):All version.
The text was updated successfully, but these errors were encountered: