【 TiDB 使用环境】测试
【 TiDB 版本】v7.5.0
【复现路径】使用 DM 从 MySQL 8.0.33 全量同步数据到 TiDB v7.5.0
【遇到的问题:问题现象及影响】
全量同步过程中遇到报错:
"subTaskStatus": [
{
"name": "mes",
"stage": "Paused",
"unit": "Load",
"result": {
"isCanceled": false,
"errors": [
{
"ErrCode": 34019,
"ErrClass": "load-unit",
"ErrScope": "internal",
"ErrLevel": "high",
"Message": "",
"RawCause": "[Lightning:Restore:ErrRestoreTable]restore table `_mes_wafer_package`.`_ori_atw_new` failed: [`_mes_wafer_package`.`_ori_atw_new`] batch write rows reach max retry 3 and still failed: dial tcp 10.207.69.77:4000: connect: connection refused",
"Workaround": ""
}
目前参考下面这个问答在上游 MySQL 设置了参数 max_allowed_packet 为 1G
## 在 MySQL 上游执行
SET GLOBAL max_allowed_packet = 1073741824;
mysql> show global variables like 'max_allowed_packet';
+--------------------+------------+
| Variable_name | Value |
+--------------------+------------+
| max_allowed_packet | 1073741824 |
+--------------------+------------+
1 row in set (0.00 sec)
resume-task 或者 stop-task && start-task 依然报错,这个是什么原因?