网站建设杭州哪家好,如何做汽车的创意视频网站,wordpress微信文章采集,网站设计宽屏本帖最后由 mark_huang 于 2018-5-22 16:45 编辑mysql从5.7.17迁移到5.7.22后#xff0c;业务半个月报错2次(报错时间毫无规律) 以下是业务报错日志#xff0c;truncate表后重启执行程序业务恢复正常。 原库和新库的 wait_timeout都是8个小时2018-05-20 06:30:30.020 [schedu…本帖最后由 mark_huang 于 2018-5-22 16:45 编辑mysql从5.7.17迁移到5.7.22后业务半个月报错2次(报错时间毫无规律) 以下是业务报错日志truncate表后重启执行程序业务恢复正常。 原库和新库的 wait_timeout都是8个小时2018-05-20 06:30:30.020 [schedulerFactoryBean_Worker-3] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]2018-05-20 06:30:30.127 [schedulerFactoryBean_Worker-3] INFO org.springframework.jdbc.support.SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]2018-05-20 06:30:30.178 [schedulerFactoryBean_Worker-3] INFO com.mark.stat.sync.service.impl.ReportTripCoServiceImpl - [LOGGERID: 1526769000010-541] 表重算捕获异常org.springframework.dao.RecoverableDataAccessException:### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 624 milliseconds ago. The last packet sent successfully to the server was 624 milliseconds ago.### The error may involve defaultParameterMap### The error occurred while setting parameters### SQL: delete from mark_report### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 624 milliseconds ago. The last packet sent successfully to the server was 624 milliseconds ago.; SQL []; Communications link failureThe last packet successfully received from the server was 624 milliseconds ago. The last packet sent successfully to the server was 624 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 624 milliseconds ago. The last packet sent successfully to the server was 624 milliseconds ago.2018-05-20 06:30:30.179 [schedulerFactoryBean_Worker-3] INFO com.mark.stat.sync.service.impl.JobExecuteServiceImpl - [LOGGERID: 1526769000010-541] 重算任务释放锁2018-05-20 06:40:00.009 [schedulerFactoryBean_Worker-4] INFO com.mark.stat.sync.service.impl.JobExecuteServiceImpl - [LOGGERID: 1526769600009-702] 重算任务开始获取锁2018-05-20 06:40:00.009 [schedulerFactoryBean_Worker-4] INFO com.mark.stat.sync.service.impl.JobExecuteServiceImpl - [LOGGERID: 1526769600009-702] 重算任务获取锁成功2018-05-20 06:40:00.019 [schedulerFactoryBean_Worker-4] INFO com.mark.stat.sync.service.impl.JobExecuteServiceImpl - [LOGGERID: 1526769600009-702] 表重算任务开始-------- start --------2018-05-20 06:40:00.145 [schedulerFactoryBean_Worker-4] INFO com.mark.stat.sync.service.impl.ReportTripCoServiceImpl - [LOGGERID: 1526769600009-702] [timecost(ms): 136] 查询需要重算的记录2018-05-20 06:40:20.682 [schedulerFactoryBean_Worker-4] INFO com.mark.stat.sync.service.impl.ReportTripCoServiceImpl - [LOGGERID: 1526769600009-702] 表重算捕获异常org.springframework.dao.RecoverableDataAccessException:### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 136 milliseconds ago. The last packet sent successfully to the server was 136 milliseconds ago.### The error may involve defaultParameterMap### The error occurred while setting parameters### SQL: delete from mark_report### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 136 milliseconds ago. The last packet sent successfully to the server was 136 milliseconds ago.; SQL []; Communications link failureThe last packet successfully received from the server was 136 milliseconds ago. The last packet sent successfully to the server was 136 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
