mysql重连,连接丢失:The last packet successfully received from the server
来源:互联网 发布:mac怎么解压缩文件 编辑:程序博客网 时间:2024/06/06 01:20
1.1 错误信息:
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 20,820,001 milliseconds ago. The last packet sent successfully to the server was 20,820,002 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.at sun.reflect.GeneratedConstructorAccessor29.newInstance(Unknown Source) ~[na:na]at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_51]at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_51]at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3988) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2598) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828) ~[mysql-connector-java-5.1.29.jar:na]at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5372) ~[mysql-connector-java-5.1.29.jar:na]at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:881) ~[c3p0-0.9.1.1.jar:0.9.1.1]at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.setAutoCommit(AttributeRestoringConnectionInvocationHandler.java:98) ~[quartz-2.2.1.jar:na]
1.2 解决方法
- 如果使用的是JDBC,在JDBC URL上添加?autoReconnect=true,如:
jdbc:mysql://10.10.10.10:3306/mydb?autoReconnect=true
- 如果是在Spring中使用DBCP连接池,在定义datasource增加属性validationQuery和testOnBorrow,如:
<bean id="vrsRankDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}" /> <property name="url" value="${countNew.jdbc.url}" /> <property name="username" value="${countNew.jdbc.user}" /> <property name="password" value="${countNew.jdbc.pwd}" /> <property name="validationQuery" value="SELECT 1" /> <property name="testOnBorrow" value="true"/></bean>
- 如果是在Spring中使用c3p0连接池,则在定义datasource的时候,添加属性testConnectionOnCheckin和testConnectionOnCheckout,如:
<bean name="cacheCloudDB" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driver}"/> <property name="jdbcUrl" value="${cache.url}"/> <property name="user" value="${cache.user}"/> <property name="password" value="${cache.password}"/> <property name="initialPoolSize" value="10"/> <property name="maxPoolSize" value="${cache.maxPoolSize}"/> <property name="testConnectionOnCheckin" value="false"/> <property name="testConnectionOnCheckout" value="true"/> <property name="preferredTestQuery" value="SELECT 1"/></bean>
阅读全文
0 0
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received
- MySQL之——重连,连接丢失:The last packet successfully received from the serve
- 【转】mysql重连,连接丢失:The last packet successfully received
- (2)Mysql ----- The last packet successfully received from the server was *** millisecond ago.The
- Spring连接mysql长时间空闲报错:The last packet successfully received from the server was xx millisecond ago...
- mysql The last packet successfully received from the server was XXX seconds ago
- MySQL: Communications link failure,The last packet successfully received from the server
- MYSQL Communications link failure,The last packet successfully received from the server was
- mysql超时:The last packet successfully received from the server was 172,848,658 milliseconds ago.
- 应用机器学习(九):主成分分析
- sql语句多条件查询
- java基本类型和引用类型
- 【转载】【Unity规则】【模型】Unity3D模型制作规范
- PCM音频数据音量大小调节
- mysql重连,连接丢失:The last packet successfully received from the server
- 如何实现程序长时间未操作退出
- php配置参数 linux搭建
- jpa级联操作详解1-级联保存(CascadeType.PERSIST)
- 贺倩的第一周js总结
- vue开发中在页面代码中一律不能使用this
- Java事务(3)——丑陋的案例
- 华东理工大学校园网自动登录——安卓——Windows
- CSDN博客中Markdown语法帮助