5.1.2 proxy节点卡死,无法登录,重启后恢复

方便更快捷的说明问题,可以按需填写(可删除)

使用环境:

版本:5.1.2
系统:Centos7.4
proxy数据源配置:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
url: mysql://xx.com.cn/mysql?serverTimezone=UTC&useSSL=false
分片场景:无
业务场景:
我们部署3个proxy节点,配置一致,除了通过proxy访问后端DB外,还有应用直连后端DB操作

场景、问题:

其中一个proxy节点突然卡死,无法登录链接,重启之后问题恢复,另外两个proxy正常,应用直接访问后端DB的也正常。
日志里主要报了以下错误
[ERROR] 2025-05-12 19:41:09.378 [ShardingSphere-Command-274478] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.NullPointerException: null
[ERROR] 2025-05-12 19:42:02.441 [ShardingSphere-Command-274485] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.NullPointerException: null
[ERROR] 2025-05-12 19:43:14.439 [ShardingSphere-Command-274490] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLException: Operation not allowed after ResultSet closed
[ERROR] 2025-05-12 19:44:17.673 [ShardingSphere-Command-274490] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.NullPointerException: null
[ERROR] 2025-05-12 19:47:34.765 [ShardingSphere-Command-274496] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLException: Operation not allowed after ResultSet closed
[ERROR] 2025-05-12 19:53:49.903 [ShardingSphere-Command-274505] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLTransientConnectionException: HikariPool-4 - Connection is not available, request timed out after 30095ms.

已进行操作:

重启服务

现状:

重启后恢复

京ICP备2021015875号