为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:4.0.1
- 【问题描述】:
DM同步报错
“subTaskStatus”: [
{
“name”: “task_trade”,
“stage”: “Paused”,
“unit”: “Sync”,
“result”: {
“isCanceled”: false,
“errors”: [
{
“Type”: “ExecSQL”,
“msg”: “”,
“error”: {
“ErrCode”: 10006,
“ErrClass”: 1,
“ErrScope”: 0,
“ErrLevel”: 3,
“Message”: “execute statement failed: INSERT INTO 库名.表名(id
,op_id
,bu_id
,order_id
,op_no_pay
,op_order_id
,op_num_sys
,out_trade_no
,op_time
,inuse
,pay_type
,bulk_pay_type
,remark
,user_type
,order_type
,pay_amount
,pay_rate_fee
,shop_id
,create_time
,edit_time
) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?): Error 1062: Duplicate entry ‘494f9d65df89447d9f426ae3eda87bb0’ for key ‘uk_op_id’”,
“RawCause”: “Error 1062: Duplicate entry ‘494f9d65df89447d9f426ae3eda87bb0’ for key ‘uk_op_id’”
}
},
{
“Type”: “ExecSQL”,
“msg”: “”,
“error”: {
“ErrCode”: 10006,
“ErrClass”: 1,
“ErrScope”: 0,
“ErrLevel”: 3,
“Message”: “execute statement failed: begin: sql: connection is already closed”,
“RawCause”: “sql: connection is already closed”
}
},
{
“Type”: “ExecSQL”,
“msg”: “”,
“error”: {
“ErrCode”: 10006,
“ErrClass”: 1,
“ErrScope”: 0,
“ErrLevel”: 3,
“Message”: “execute statement failed: begin: sql: connection is already closed”,
“RawCause”: “sql: connection is already closed”
}
},
最近出现了好几次,重启后解决