服务器数据库间断性的会出现数据库连接异常的报错,报错异常为
### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 34,101 milliseconds ago. The last packet sent s
uccessfully to the server was 34,103 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before us
e in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
my.ini
--增加如下配置
wait_timeout=144000
interactive_timeout=144000
-- 保存后重启mysql服务
更多推荐
You should consider either expiring and/or testing connection validity before us
发布评论