How to Modify the Checkpoint_tso of a Running TiCDC Synchronization Task?

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

Original topic: 怎么修改TiCDC正在运行的同步任务的checkpoint_tso,求解

| username: TiDBer_QTS3Dbbw

How to modify the checkpoint_tso of a TiCDC synchronization task, please help.

| username: cassblanca | Original post link

Specify a TSO. Refer to this TiCDC FAQ | PingCAP Documentation Center

| username: 昵称想不起来了 | Original post link

Did an exception occur midway and you want to modify it? Check out the reference Add the ignore-txn-start-ts parameter to skip the transaction corresponding to the specified start-ts.

| username: Fly-bird | Original post link

Choose a TSO, then stop the task and restart the task.

| username: TiDBer_QTS3Dbbw | Original post link

I see that API v1 does not have this feature. My scenario is like this: I first create a synchronization task, and now I want to perform a drill. I don’t want the data during the drill period, so I need to pause the task first, then modify the checkpoint_tso to the time when the drill ends.

| username: TiDBer_QTS3Dbbw | Original post link

How do I choose, boss? I see that the API doesn’t have this feature.

| username: redgame | Original post link

When starting the task, it will go to PD to get the current TSO and start synchronization from that TSO with start-ts=