DM初始化数据库失败 code=32001 maximum statement execution time exceeded

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】: v1.0.5
  • 【问题描述】: 同一个DM下两个task,对应同一个实例的两个库,第一个task运行没问题同步正常,第二个task无法完成dump,不停自动重启。

发现ERROR都是以下形式的

[2020/06/08 23:35:57.280 +08:00] [INFO] [mydumper.go:158] [“Thread 1 shutting down”] [task=task_yhzx_vccx] [unit=dump] [2020/06/08 23:35:59.099 +08:00] [INFO] [mydumper.go:158] [“Thread 2 shutting down”] [task=task_yhzx_vccx] [unit=dump] [2020/06/08 23:35:59.585 +08:00] [ERROR] [mydumper.go:164] [“Could not read data from vccx.t_business_register_info: Query execution was interrupted, maximum statement execution time exceeded”] [task=task_yhzx_vccx] [unit=dump] [2020/06/08 23:35:59.585 +08:00] [INFO] [mydumper.go:158] [“Thread 4 shutting down”] [task=task_yhzx_vccx] [unit=dump] [2020/06/08 23:35:59.586 +08:00] [INFO] [mydumper.go:158] [“Finished dump at: 2020-06-08 23:35:59”] [task=task_yhzx_vccx] [unit=dump] [2020/06/08 23:35:59.588 +08:00] [INFO] [mydumper.go:114] [“dump data finished”] [task=task_yhzx_vccx] [unit=dump] [“cost time”=3m2.506006271s] [2020/06/08 23:35:59.588 +08:00] [INFO] [subtask.go:266] [“unit process returned”] [subtask=task_yhzx_vccx] [unit=Dump] [stage=Paused] [status={}] [2020/06/08 23:35:59.588 +08:00] [ERROR] [subtask.go:285] [“unit process error”] [subtask=task_yhzx_vccx] [unit=Dump] [“error information”="{“msg”:"[code=32001:class=dump-unit:scope=internal:level=high] mydumper runs with error: exit status 1. \n\n"}"]

问题已经解决 mysql设置了sql执行超时参数 show variables like ‘max_execution_time’; ±-------------------±-------+ | Variable_name | Value | ±-------------------±-------+ | max_execution_time | 180000 | ±-------------------±-------+

设置为0即可 set global max_execution_time=0;

:+1: 感谢反馈