[FAQ] DM 同步报错 Could not read data from xxx.xxx: Query execution was interrupted, maximum statement execution time exceeded

🌌 运维指南 TiDB 常见 FAQ
1

[问题澄清]

DM 同步报错：

[ERROR] [mydumper.go:164] [“Could not read data from vccx.t_business_register_info: Query execution was interrupted, maximum statement execution time exceeded”]

[原因分析]

导出数据超过集群最大时间限制

[解决方案]

  1. 查看当前参数 max_execution_time 值

image

  1. 修改参数值为 0

set global max_execution_time=0;

  1. 注意需要新开 session 查看生效值。

注意： max_execution_time 目前对所有类型的 statement 生效，并非只对 SELECT 语句生效。实际精度在 100ms 级别，而非更准确的毫秒级别

[参考案例]