After the CDC task fails, tikv_gc_safe_point does not update

Translated
1

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

Original topic: cdc任务失败之后，tikv_gc_safe_point一直不更新

| username: TiDBer_7E0yINhK

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.1.1
[Encountered Problem] After the CDC task fails, manually removing the task causes tikv_gc_safe_point to not update.
[Reproduction Path]
Start CDC, encounter ErrGCTTLExceeded error
Manually remove the task, find that it cannot be removed (known issue: changefeed can't be removed when meeting ErrGCTTLExceeded error · Issue #2391 · pingcap/tiflow · GitHub)
[Problem Phenomenon and Impact]
The tikv_gc_safe_point remains at that time point. Will this cause any issues for the cluster?
[Attachment]
Observing the monitoring gc_worker_actions, there is data every 10 minutes.

2
| username: Billmay表妹 | Original post link

Have you considered upgrading the version?

3
| username: Billmay表妹 | Original post link

Refer to this article: 专栏 - TiDB集群的GC不回收案例（案情二） | TiDB 社区

4
| username: TiDBer_7E0yINhK | Original post link

Okay, thank you. I checked that mysql.tidb tikv_gc_last_run_time is updating normally, and gc_speed is also not zero. Can I understand that GC is running normally?
So what method should I use to let tikv_gc_safe_point continue to advance, or is there any way to remove the failed CDC task?

5
| username: asddongmen | Original post link

It is recommended to upgrade the CDC version to solve the problem.

6
| username: TiDBer_CEVsub | Original post link

It might be because the data volume hasn’t changed, leading to no changes in RocksDB’s compaction.

7
| username: system | Original post link

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