文章/答案/技术大牛

发布

社区首页 >问答首页 >mysql8.4不稳定，报错SQLSTATE(08S01), ErrorCode(1160)？

问mysql8.4不稳定，报错SQLSTATE(08S01), ErrorCode(1160)？

提问于 2026-03-03 09:33:17

回答 1关注 1查看 102

我部署了mysql8.4.* 到生产环境使用，发现应用出现了大量的HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@296e91c1 marked as broken because of SQLSTATE(08S01), ErrorCode(1160)

java.sql.SQLNonTransientConnectionException: Got an error writing communication packets

不止是应用，数据库连接工具等都会出现这的报错，非必然报错，偶然性高；

数据库配置相关信息：

max_allowed_packet 268435456

connect_timeout 10

delayed_insert_timeout 300

have_statement_timeout YES

innodb_flush_log_at_timeout 1

innodb_lock_wait_timeout 50

innodb_rollback_on_timeout OFF

interactive_timeout 1800

lock_wait_timeout 31536000

mysqlx_connect_timeout 30

mysqlx_idle_worker_thread_timeout 60

mysqlx_interactive_timeout 28800

mysqlx_port_open_timeout 0

mysqlx_read_timeout 30

mysqlx_wait_timeout 28800

mysqlx_write_timeout 60

net_read_timeout 30

net_write_timeout 60

replica_net_timeout 60

rpl_stop_replica_timeout 31536000

rpl_stop_slave_timeout 31536000

slave_net_timeout 60

ssl_session_cache_timeout 300

wait_timeout 1800

springboot微服务HikariCP 连接池配置信息

spring:

datasource:

db1:

maximum-pool-size: 30

minimum-idle: 3

connection-test-query: SELECT 1

max-lifetime: 900000

connection-timeout: 60000

validation-timeout: 5000

idle-timeout: 600000

keepalive-time: 300000

driver-class-name: com.mysql.cj.jdbc.Driver

jdbcUrl: jdbc:mysql://10.0.99.13:3306/numen_auth?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&allowMultiQueries=true&tcpKeepAlive=true&socketTimeout=180000&connectTimeout=10000

操作系统层面：

net.ipv4.tcp_keepalive_time = 60

net.ipv4.tcp_keepalive_intvl = 10

net.ipv4.tcp_keepalive_probes = 3

net.ipv4.tcp_fin_timeout = 60

mysql jdbc版本为8.4.0;

这个问题困扰很久了。尝试过各种参数的修改，依赖的升级。都没什么用；而且使用人越多，这种报错几率越频繁；

目前已经退回到8.0.45，就没有这样的报错问题了。8.4不能用于生产环境吗，就我一个人越到这种不稳定情况吗；

微服务报错日志为：

2026-03-01 19:00:24.411 [http-nio-9103-exec-5] [] WARN c.zaxxer.hikari.pool.ProxyConnection - checkException : HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@296e91c1 marked as broken because of SQLSTATE(08S01), ErrorCode(1160)

java.sql.SQLNonTransientConnectionException: Got an error writing communication packets

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:938)

at com.mysql.cj.jdbc.ClientPreparedStatement.$sw$original$execute$vllu0t2(ClientPreparedStatement.java:359)

at com.mysql.cj.jdbc.ClientPreparedStatement.$sw$original$execute$vllu0t2$accessor$$sw$2q6k991(ClientPreparedStatement.java)

at com.mysql.cj.jdbc.ClientPreparedStatement$$sw$auxiliary$bl3l0t3.call(Unknown Source)

at com.ccdc.numen.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:68)

at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java)

at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)

at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)

at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)

at com.sun.proxy.$Proxy914.execute(Unknown Source)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)

at sun.reflect.GeneratedMethodAccessor285.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)

at com.sun.proxy.$Proxy913.query(Unknown Source)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)

at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)

at com.sun.proxy.$Proxy912.query(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)

at sun.reflect.GeneratedMethodAccessor314.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)

at com.sun.proxy.$Proxy225.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at com.sun.proxy.$Proxy237.handingAlarmPage(Unknown Source)

at com.ccdc.numen.mcore.service.impl.MonAlarmAllServiceImpl.handingAlarmPage(MonAlarmAllServiceImpl.java:119)

at com.ccdc.numen.mcore.service.impl.MonAlarmAllServiceImpl$$FastClassBySpringCGLIB$$33a14f6b.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)

at com.ccdc.numen.mcore.service.impl.MonAlarmAllServiceImpl$$EnhancerBySpringCGLIB$$577eae2f.handingAlarmPage(<generated>)

at com.ccdc.numen.mcore.controller.MonAlarmAllController.handingAlarmPage(MonAlarmAllController.java:124)

at com.ccdc.numen.mcore.controller.MonAlarmAllController$$FastClassBySpringCGLIB$$5de20649.invoke(<generated>)