Due to MySQL disk being full, CDC reports error CDC:ErrStartTsBeforeGC after restart

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

Original topic: 因mysql磁盘满了,cdc重启后报错CDC:ErrStartTsBeforeGC

| username: zxgaa

[TiDB Usage Environment] Production Environment
[TiDB Version] V6.1.0
[Reproduction Path] MySQL disk full, cleaned disk, restarted CDC
[Encountered Problem: Phenomenon and Impact] Due to MySQL disk being full, after restarting CDC, an error occurred: CDC: ErrStartTsBeforeGC: fail to create changefeed because start-ts 440503723573641227 is earlier than GC safepoint at 440504167986364494
[Attachment: Screenshot/Log/Monitoring]

| username: weixiaobing | Original post link

Because the MySQL disk was full, exporting TiCDC synchronized data failed, and the data needed by TiCDC was lost due to TiKV GC. Currently, the only solution is to redo the downstream MySQL. You can set the gc-ttl time for TiCDC, which is 24 hours by default. For more details, please refer to: TiCDC 常见问题解答 | PingCAP 文档中心

| username: TiDBer_pkQ5q1l0 | Original post link

It probably needs to be resynchronized.

| username: tidb菜鸟一只 | Original post link

You can only reinitialize it.

| username: liuis | Original post link

To ensure data security, we can only start over.

| username: zxgaa | Original post link


| username: system | Original post link

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