为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【 TiDB 使用环境】
TIDB 4.0.4
【 DM 使用环境】
v2.0.6
【概述】
alertmessage提示worker处于下线状态。使用命令拉起worker,提示启动成功,但是集群信息仍显示offline。
在执行缩容扩容后,worker正常,但是绑定数据源开启同步后,仍然出现此异常。
从日志中获取错误信息:Message: database driver error, RawCause: Error 1129: Host ‘192.168.3.31’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’, Workaround: Please check the database connection and the database config in configuration file."
【背景】 /
【现象】 /
grafana监控图片:
日志错误信息:
[2022/01/21 13:43:24.606 +08:00] [ERROR] [worker.go:512] [“can’t open a connection to get master status”] [component=“worker controller”] [error=“[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: Error 1129: Host ‘192.168.3.31’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’, Workaround: Please check the database connection and the database config in configuration file.”] [errorVerbose="[code=10001:class=database:scope=not-set:level=high], Message: database driver error, RawCause: Error 1129: Host ‘192.168.3.31’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’, Workaround: Please check the database connection and the database config in configuration file.
【问题】
日志中提示要执行flush hosts;目前在tidb端已经执行flush host,但是没有效果,目前该如何解决此问题。
【业务影响】 /
【附件】
附上在缩容扩容后的错误日志
dm-worker.log (647.8 KB)