Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

数据库长时间断开再重连的异常 #97

Open
Arc-zlz opened this issue May 6, 2024 · 2 comments
Open

数据库长时间断开再重连的异常 #97

Arc-zlz opened this issue May 6, 2024 · 2 comments

Comments

@Arc-zlz
Copy link

Arc-zlz commented May 6, 2024

我发现个bug 长时间数据库断线 再重启就会保这个错误 而且是无限写这段日志 就算数据库重连也没用 要重新打开新的目录 拉取新代码才不会报这个错
SHOW FULL COLUMNS FROM hg_sys_serve_log\nError: dial tcp 192.168.101.30:3306: connectex: A socket operation was attempted to an unreachable network.
8ef0b56ae6b4ecb5c9d933fb4546cf38
85fed2dbe228c7f96a21316c9b1163e4
af69bac918c76b08b4848cbb8224be56
image

@bufanyun
Copy link
Owner

bufanyun commented May 6, 2024

2.7.0版本应该里serve_log队列应该不会出现这个问题,Handle方法遇到错误只会打印,不会往上抛错。你再排查一下

@Arc-zlz
Copy link
Author

Arc-zlz commented Jun 18, 2024

这个bug 我终于知道怎么复现了 就是数据库长时间断开 定时任务每隔定时时间会记录一条错误 但是没办法存数据库 等一段时间(比如3个小时在重连),在重连连接数据库时,之前的定时任务就会开始将错误这条记录写入server_log表中 造成刚连数据库会长时间的自动写入数据

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants