The primary cluster synchronizes to the downstream cluster, both with the same version number: v6.5.0. The count(*) is the same, but after running for a while, the number remains the same on both sides, yet some record fields have turned into null values

Translated
1

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

Original topic: 主库集群同步到下游集群，版本号相同，均为：v6.5.0，count(*)一样，运行一段时间后，发现两边数量还是一样，但是，部分记录的字段内容变成了空值

| username: vcdog

[TiDB Usage Environment] Production Environment
[TiDB Version] v6.5.0
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Phenomenon and Impact]

  1. The primary cluster is synchronized to the downstream cluster, both versions are the same: v6.5.0
  2. The count(*) of a certain business table is the same on both sides. After running for a period of time, it was found that the count remained the same, but some field contents of certain records became null values.
  3. The task status of ticdc corresponding to this table shows normal

[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

2
| username: TiDBer_oHSwKxOH | Original post link

It’s best to take a screenshot.

3
| username: TiDBer_嘎嘣脆 | Original post link

You can check the conditions for synchronizing tables.

4
| username: vcdog | Original post link

The TiCDC task configuration for this table is as above.