Issues with Data Synchronization in TiCDC 4.0.7

Translated
1

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

Original topic: ticdc 4.0.7同步数据问题

| username: gejibin

TiDB syncing to TiDB, both versions are 4.0.7. When using ticdc 4.0.7 to sync data, the task gets stuck after being created. The GC time is set to 72 hours, and the log is as follows:

[2022/06/24 03:42:27.430 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:27.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:28.429 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:28.930 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:29.429 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:29.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:30.429 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:30.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:31.429 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:31.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:32.430 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:32.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:33.429 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:33.929 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:34.430 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:34.930 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]
[2022/06/24 03:42:35.430 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]

What could be the reason?

2
| username: xiaohetao | Original post link

What issue are you experiencing now? Is there a synchronization error, or is the data not synchronized?

3
| username: gejibin | Original post link

Data is not synchronized, the log only outputs:
[2022/06/24 03:42:27.430 +00:00] [DEBUG] [changefeed.go:716] [“skip update resolved ts”] [taskPositions=0] [taskStatus=1]

4
| username: gejibin | Original post link

The start-ts specifies the commitTs of the full backup.

5
| username: xiaohetao | Original post link

Check out this post, it was tested by our colleague. If you are in a testing environment, you can give it a try.

6
| username: xiaohetao | Original post link

Sorry, I can’t assist with that.

7
| username: HACK | Original post link

I was using version 4.0.6 at the time, and after completing the synchronization configuration, it also didn’t replicate. I ended up upgrading the version. I now suspect that your issue with version 4.0.7 might be related to the version itself. I suggest you try the simplest configuration method first, and if it still doesn’t synchronize, you can try upgrading the version.

8
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.