jdbc异常 the last packet sent successfully to the server was 0 milliseconds ago

待我称王封你为后i 2024-03-25 22:47 98阅读 0赞

the last packet sent successfully to the server was 0 milliseconds ago

navicat可以正常访问，jdbc访问就会报错(springboot，dbeaver等会出现这种情况)。

大部分原因是由于数据库回收了连接，而服务(springboot、tomcat等)的缓冲池(dbcp、c3p0、druid等)不知道，继续使用被回收的连接所致。

有效方法：

服务：

使用druid，或者hikari，并且修改连接池配置。

数据库：

修改mysql的配置，最大连接数调到500。

[解决异常：“The last packet sent successfully to the server was 0 milliseconds ago. ”的办法][The last packet sent successfully to the server was 0 milliseconds ago.]

[\[已解决\]踩过的坑之mysql连接报“Communications link failure”错误][mysql_Communications link failure]

[The last packet sent successfully to the server was 0 milliseconds ago. 解决办法记录][The last packet sent successfully to the server was 0 milliseconds ago. 1]

[项目启动报 The last packet sent successfully to the server was 0 milliseconds，神奇错误总结][The last packet sent successfully to the server was 0 milliseconds]

[\[转\]阿里巴巴数据库连接池 druid配置详解 ][druid_]

[解决Java程序连接mysql数据库出现CommunicationsException: Communications link failure错误的问题][Java_mysql_CommunicationsException_ Communications link failure]

[Druid无效链接回收策略(源码分析)(mysql 8小时连接失效问题)][Druid_mysql 8]

[低版本Druid连接池+MySQL驱动8.0，在高并发下出现线程阻塞、性能受限问题][Druid_MySQL_8.0]

[springboot——高并发之配置连接池druid][springboot_druid]

[高并发场景下的数据库连接池应该如何进行优化（面试）][Link 1]

[解决数据库高并发访问瓶颈问题][Link 2]

[Mysql高并发解决方案][Mysql]

[MySQL 高并发配置优化][MySQL]

[MySQL提高并发数][MySQL 1]

[The last packet sent successfully to the server was 0 milliseconds ago.]: https://www.cnblogs.com/zhangyongjian/p/3655107.html
[mysql_Communications link failure]: https://blog.csdn.net/qq_27471405/article/details/80921846
[The last packet sent successfully to the server was 0 milliseconds ago. 1]: https://blog.csdn.net/apachesolr/article/details/113766949
[The last packet sent successfully to the server was 0 milliseconds]: https://blog.51cto.com/u_15101587/2623361
[druid_]: https://www.cnblogs.com/hafiz/p/5879356.html
[Java_mysql_CommunicationsException_ Communications link failure]: https://www.cnblogs.com/hafiz/p/5879432.html
[Druid_mysql 8]: https://blog.csdn.net/shangmingtao/article/details/106269729
[Druid_MySQL_8.0]: https://blog.csdn.net/qq_40378034/article/details/117851207
[springboot_druid]: https://blog.csdn.net/zhaolulu916/article/details/98885840
[Link 1]: https://blog.csdn.net/qq_37286668/article/details/107342114
[Link 2]: https://www.cnblogs.com/mengchunchen/p/9733770.html
[Mysql]: https://juejin.cn/post/6941268421073960968
[MySQL]: https://blog.csdn.net/cuker919/article/details/80610314
[MySQL 1]: https://www.jianshu.com/p/1ff6d8ac3511