The number of worker nodes is inconsistent between zk and mysql（worker节点数量 zk和mysql中不一致）

[wangfann]

As shown in the figure above, three worker nodes are registered in the configuration file, three are displayed in zk, and only one is displayed in mysql. Use version is 1.0.3

---

如上图所示，配置文件中注册了3个worker节点，zk中显示三个，mysql中只显示一个。使用版本为1.0.3

[qiaozhanwei]

This is caused by the abnormal stopping of the master and the worker, without the hook function. We will fix this in version 1.1.0

---

这个是由于非正常停止master和worker，不走钩子函数引起的。我们将在1.1.0版本中修复这个问题

[wangfann]

Is there a temporary solution?

---

请问有没有临时解决办法？

[qiaozhanwei]

This is obtained from mysql, can be obtained directly from zk is the most accurate, there is a way to see mysql last_heartbeat_time time to judge, if there is no heartbeat update for a long time, it is lost.

---

这个是从mysql中获取的，可以直接从zk中获取就是最准的，还有一种方法可以看mysql last_heartbeat_time时间来判断，如果长时间没有心跳更新，那就是掉了。

[wangfann]

Well, this is the idea of fixing the problem. I mean, I want to solve the problem on my side temporarily. Is there any good advice, such as restarting the project? Or rebuild the database? Thank you

---

嗯嗯，这是修复问题的思路，我的意思是我想先临时解决我这边的问题，有没有好的建议，比如重启项目？或者重建数据库？谢谢

[lenboo]

Well, this is the idea of fixing the problem. I mean, I want to solve the problem on my side temporarily. Is there any good advice, such as restarting the project? Or rebuild the database? Thank you

Sorry, we need more environment and log support to see the problem.
The normal registration process is
Master/worker startup -> Register zk directory -> Add mysql record.

Your problem is that adding mysql is not successful, you can try to restart the worker service.

---

嗯嗯，这是修复问题的思路，我的意思是我想先临时解决我这边的问题，有没有好的建议，比如重启项目？或者重建数据库？谢谢

很抱歉，这个问题我们需要更多环境和日志的支持，才能看到问题所在。
正常注册流程是
master/worker启动 -> 注册zk目录 -> 添加mysql记录。

你这个问题感觉是添加mysql没有成功，可以重启一下worker服务试试。

[wangfann]

Thanks to everyone upstairs, my problem has been located, because the worker node access mysql account permissions are insufficient, has been resolved, thank you.

---

感谢楼上各位，我这边的问题已经定位到了，是因为worker节点访问mysql的账号权限不足导致的，已经解决了，谢谢。