lightning 恢复数据时报错 There are queries in PROCESSLIST running longer than 60s

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

出现这个错误后我执行备份命令也报错:./bin/mydumper -h 127.0.0.1 -P 4000 -u root -p root -t 32 -F 256 -B zsl --skip-tz-utc -o /home/tidb-tools/out/zsl

错误:** (mydumper:8655): CRITICAL **: 17:19:35.667: There are queries in PROCESSLIST running longer than 60s, aborting dump, use --long-query-guard to change the guard value, kill queries (–kill-long-queries) or use different server for dump

  1. 是否有设置连接的参数,导致被很快中断session,比如防火墙,

或者设置了 max_execution_time

  1. 可以尝试参考文档设置时间长一些 https://pingcap.com/docs-cn/v3.0/reference/tools/mydumper/#如何设置-mydumper-的参数--l---long-query-guard-

第一个问题参数都没有设置过,后续使用断点续传./bin/tidb-lightning-ctl --checkpoint-error-destroy=all --config=./config/tidb-lightning.toml 后执行正常; 第二个问题,设置了-l 7200后执行正常

感谢反馈