[FAQ] (mydumper:8655): CRITICAL There are queries in PROCESSLIST running longer use --long-query-guard to change the guard value

🌌 运维指南 TiDB 常见 FAQ
1

[问题澄清]

mydumper 导出时报错：

错误：** (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

[原因分析]

如报错提示，在 processlist 中有一些长查询查过了 60s

[解决方案]

参考文档设置参数 -l 7200 尝试.

image
image1487×194 32.5 KB

https://pingcap.com/docs-cn/v3.0/mydumper-overview/

[参考案例]