DM做数据迁移上游数据表必须要设置主键吗？已设置如下配置
session:
sql_require_primary_key: OFF
任务开始会有如下报错：
{
"result": false,
"msg": "[code=46014:class=scheduler:scope=internal:level=medium], Message: subtasks with name mysql-syc-task for sources [dm-source-1] already exist, Workaround: Please use `query-status` command to see tasks.",
"sources": [
],
"checkResult": "fail to check synchronization configuration with type: no errors but some warnings
detail: {
"results": [
{
"id": 12,
"name": "table structure compatibility check",
"desc": "check compatibility of table structure",
"state": "warn",
"errors": [
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_employee_org_rel` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_employee_role_rel` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_employee_org_position_rel` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_role_resource_rel` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_dict` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_operation_log_ext` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_position_role_rel` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_employee` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_parameter` primary/unique key does not exist"
},
{
"severity": "warn",
"short_error": "table `badc_base_1`.`base_role` primary/unique key does not exist"
}
],
"instruction": "You need to set primary/unique keys for the table. Otherwise replication efficiency might become very low and exactly-once replication cannot be guaranteed."
}
],
"summary": {
"passed": true,
"total": 13,
"successful": 12,
"failed": 0,
"warning": 1
}
}"
}
