Ticdc Error: [CDC:ErrStartTsBeforeGC] Failed to create or maintain changefeed because start-ts

Translated
1

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

Original topic: ticdc Error: [CDC:ErrStartTsBeforeGC]fail to create or maintain changefeed because start-ts

| username: Vincent_Wang

[TiDB Usage Environment] Production Environment
[TiDB Version]
v6.5.5
[Reproduction Path]
Backup and restore data takes too long, then CDC startup reports an error
[Encountered Problem: Problem Phenomenon and Impact]
tiup cdc cli changefeed create --disable-gc-check --server=XXXXXXX:8300 --sink-uri="" --changefeed-id=“*****” --config=.toml --start-ts=445877655844946213

Error: [CDC:ErrStartTsBeforeGC] fail to create or maintain changefeed because start-ts 445877655844946213 is earlier than or equal to GC safepoint at 445903616122552320

The time corresponding to 445877655844946213 is: system: 2023-11-25 12:57:54.555 +0800 CST
The time corresponding to 445903616122552320 is: system: 2023-11-26 16:28:25.155 +0800 CST
My GC time is 6 days, it hasn’t passed yet, why is this error reported, how to skip it, --disable-gc-check parameter is added but still reports an error

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

image
image1234×680 38.1 KB

image
image1210×584 54 KB

2
| username: TiDBer_小阿飞 | Original post link

This number is smaller than the safe point value.

3
| username: Vincent_Wang | Original post link

However, the actual gc_safe_point of my system is this 445833796689592320, which is on the 23rd, 20231123-14:29:25.155 +0800.

4
| username: 小龙虾爱大龙虾 | Original post link

It is indeed a bit strange :joy:

5
| username: h5n1 | Original post link

Was this executed today at 14:XX?

6
| username: Vincent_Wang | Original post link

Yes, it was just executed.
He used the time above, not the one below.
My system’s actual gc_safe_point is this 445834111262392320, which corresponds to 2023-11-23 14:49:25.155 +0800 CST. bold text

image
image1352×590 54.8 KB

7
| username: h5n1 | Original post link

Check if there are any long-running uncommitted transactions.

8
| username: Vincent_Wang | Original post link

There is no long-term thing.

9
| username: dba远航 | Original post link

–start-ts should have an issue