How to Modify Parameters When DM Pauses Tasks Due to Errors

Translated
1

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

Original topic: DM在出错暂停任务怎么修改参数

| username: TiDBer_hwEZA4rV

Encountered the following error during synchronization:

"subTaskStatus": [
    {
        "name": "test",
        "stage": "Paused",
        "unit": "Sync",
        "result": {
            "isCanceled": false,
            "errors": [
                {
                    "ErrCode": 10006,
                    "ErrClass": "database",
                    "ErrScope": "not-set",
                    "ErrLevel": "high",
                    "Message": "startLocation: [position: (mysql-bin.074231, 450418411), gtid-set: ], endLocation: [position: (mysql-bin.074231, 450418501), gtid-set: ]: execute statement failed: INSERT INTO `xxx`.``xxx` (``xxx`,``xxx`,``xxx`,`created_by`,`gmt_create`,`gmt_modify`) VALUES (?,?,?,?,?,?)",
                    "RawCause": "Error 1062: Duplicate entry '`xxx-41526' for key 'uk_user_role'",
                    "Workaround": ""
                }
            ]
        }
    }
]

I want to resolve the conflict by modifying the syncs’ safe-mode in the task, allowing for some performance loss, but I couldn’t find a way to modify the task configuration parameters or even delete the task…

2
| username: db_user | Original post link

Follow these steps:

  1. stop-task
  2. Modify the configuration file (the one you used to start previously)
  3. start-task. tiup dmctl --master-addr master_ip:8261 start-task ./task.yaml
3
| username: Hacker007 | Original post link

Can you modify the parameters like this now?

4
| username: db_user | Original post link

It’s always been possible, you can give it a try.

5
| username: system | Original post link

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