2023-05-22 10:24:02.481 INFO 27448 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 27448 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 10:24:02.488 DEBUG 27448 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 10:24:02.488 INFO 27448 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 10:24:04.522 INFO 27448 --- [main] com.casic.CasicApplication : Started CasicApplication in 2.309 seconds (JVM running for 2.972)
2023-05-22 10:42:17.789 INFO 36296 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 36296 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 10:42:17.789 DEBUG 36296 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 10:42:17.789 INFO 36296 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 10:42:19.497 INFO 36296 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.928 seconds (JVM running for 2.439)
2023-05-22 10:43:08.766 ERROR 36296 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'ID' at row 1
### The error may exist in com/casic/dao/WellLocalDataMapper.java (best guess)
### The error may involve com.casic.dao.WellLocalDataMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO data_wellcover_loca ( ID, well_code, devcode, lng, lat, logtime ) VALUES ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'ID' at row 1
; Data truncation: Out of range value for column 'ID' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'ID' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar:2.0.6]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.sun.proxy.$Proxy52.insert(Unknown Source) ~[na:na]
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.sun.proxy.$Proxy56.insert(Unknown Source) ~[na:na]
at com.casic.service.impl.DayDataProvider.CreateWellDataLocal(DayDataProvider.java:149) ~[classes/:na]
at com.casic.service.impl.DayDataProvider.wellLocalData(DayDataProvider.java:37) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$1.run(TaskConfigurer.java:40) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'ID' at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:372) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.5.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_91]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.7.jar:3.5.7]
at com.sun.proxy.$Proxy82.execute(Unknown Source) ~[na:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) ~[mybatis-3.5.7.jar:3.5.7]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_91]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_91]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar:2.0.6]
... 19 common frames omitted
2023-05-22 10:43:28.152 INFO 3336 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 3336 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 10:43:28.152 DEBUG 3336 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 10:43:28.152 INFO 3336 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 10:43:29.901 INFO 3336 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.966 seconds (JVM running for 2.522)
2023-05-22 10:44:51.380 INFO 30368 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 30368 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 10:44:51.380 DEBUG 30368 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 10:44:51.380 INFO 30368 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 10:44:53.196 INFO 30368 --- [main] com.casic.CasicApplication : Started CasicApplication in 2.029 seconds (JVM running for 2.612)
2023-05-22 11:04:46.785 INFO 28380 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 28380 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:04:46.786 DEBUG 28380 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:04:46.786 INFO 28380 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:04:48.553 INFO 28380 --- [main] com.casic.CasicApplication : Started CasicApplication in 2.027 seconds (JVM running for 2.581)
2023-05-22 11:05:40.413 INFO 23448 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 23448 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:05:40.413 DEBUG 23448 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:05:40.414 INFO 23448 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:05:42.150 INFO 23448 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.954 seconds (JVM running for 2.561)
2023-05-22 11:06:01.861 ERROR 23448 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.String
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:62) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:07:01.006 ERROR 23448 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.String
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:62) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:07:35.629 INFO 25360 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 25360 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:07:35.629 DEBUG 25360 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:07:35.630 INFO 25360 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:07:37.308 INFO 25360 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.892 seconds (JVM running for 2.504)
2023-05-22 11:08:35.866 ERROR 25360 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.String
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:62) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:08:39.136 INFO 11484 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 11484 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:08:39.137 DEBUG 11484 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:08:39.137 INFO 11484 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:08:40.893 INFO 11484 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.973 seconds (JVM running for 2.66)
2023-05-22 11:09:02.294 ERROR 11484 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.String
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:62) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:10:01.097 ERROR 11484 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.String
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:62) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:10:44.207 INFO 4408 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 4408 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:10:44.208 DEBUG 4408 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:10:44.208 INFO 4408 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:10:45.892 INFO 4408 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.908 seconds (JVM running for 2.438)
2023-05-22 11:11:01.919 ERROR 4408 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.NumberFormatException: For input string: "null"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043) ~[na:1.8.0_91]
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122) ~[na:1.8.0_91]
at java.lang.Float.parseFloat(Float.java:451) ~[na:1.8.0_91]
at java.lang.Float.valueOf(Float.java:416) ~[na:1.8.0_91]
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:63) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:13:25.639 ERROR 4408 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
java.lang.NumberFormatException: For input string: "null"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043) ~[na:1.8.0_91]
at sun.misc.FloatingDecimal.parseFloat(FloatingDecimal.java:122) ~[na:1.8.0_91]
at java.lang.Float.parseFloat(Float.java:451) ~[na:1.8.0_91]
at java.lang.Float.valueOf(Float.java:416) ~[na:1.8.0_91]
at com.casic.service.impl.DayDataProvider.liquidData(DayDataProvider.java:63) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$2.run(TaskConfigurer.java:49) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
2023-05-22 11:13:29.892 INFO 25508 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 25508 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:13:29.892 DEBUG 25508 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:13:29.892 INFO 25508 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:13:31.835 INFO 25508 --- [main] com.casic.CasicApplication : Started CasicApplication in 2.17 seconds (JVM running for 2.68)
2023-05-22 11:22:16.450 INFO 18024 --- [main] com.casic.CasicApplication : Starting CasicApplication using Java 1.8.0_91 on yishengpingan with PID 18024 (D:\cz\203\管网\升级\mysql\device-data-creator\target\classes started by 77042 in D:\cz\203\管网\升级\mysql\device-data-creator)
2023-05-22 11:22:16.451 DEBUG 18024 --- [main] com.casic.CasicApplication : Running with Spring Boot v2.4.5, Spring v5.3.6
2023-05-22 11:22:16.451 INFO 18024 --- [main] com.casic.CasicApplication : The following profiles are active: dev
2023-05-22 11:22:18.162 INFO 18024 --- [main] com.casic.CasicApplication : Started CasicApplication in 1.931 seconds (JVM running for 2.514)
2023-05-22 14:00:30.259 ERROR 18024 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
org.springframework.dao.RecoverableDataAccessException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.
### The error may exist in com/casic/dao/WellInfoDao.java (best guess)
### The error may involve com.casic.dao.WellInfoDao.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO data_wellcover ( ID, well_code, devcode, descn, status, logtime ) VALUES ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.
; Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar:2.0.6]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.sun.proxy.$Proxy52.insert(Unknown Source) ~[na:na]
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.sun.proxy.$Proxy57.insert(Unknown Source) ~[na:na]
at com.casic.service.impl.DayDataProvider.wellDataCreator(DayDataProvider.java:94) ~[classes/:na]
at com.casic.service.impl.DayDataProvider.wellCoverData(DayDataProvider.java:49) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$3.run(TaskConfigurer.java:58) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:372) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.5.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.7.jar:3.5.7]
at com.sun.proxy.$Proxy82.execute(Unknown Source) ~[na:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) ~[mybatis-3.5.7.jar:3.5.7]
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar:2.0.6]
... 19 common frames omitted
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet successfully received from the server was 5,648,386 milliseconds ago. The last packet sent successfully to the server was 5,648,386 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_91]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_91]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_91]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_91]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1168) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:932) ~[mysql-connector-java-8.0.16.jar:8.0.16]
... 38 common frames omitted
Caused by: java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_91]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[na:1.8.0_91]
at java.net.SocketInputStream.read(SocketInputStream.java:170) ~[na:1.8.0_91]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_91]
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) ~[na:1.8.0_91]
at sun.security.ssl.InputRecord.read(InputRecord.java:503) ~[na:1.8.0_91]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973) ~[na:1.8.0_91]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930) ~[na:1.8.0_91]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[na:1.8.0_91]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_91]
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) ~[mysql-connector-java-8.0.16.jar:8.0.16]
... 43 common frames omitted
2023-05-22 14:06:54.871 ERROR 18024 --- [pool-1-thread-1] o.s.s.s.TaskUtils$LoggingErrorHandler : Unexpected error occurred in scheduled task
org.springframework.dao.RecoverableDataAccessException:
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.
### The error may exist in com/casic/dao/WellLocalDataMapper.java (best guess)
### The error may involve com.casic.dao.WellLocalDataMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO data_wellcover_loca ( ID, well_code, devcode, lng, lat, logtime ) VALUES ( ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.
; Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-5.3.6.jar:5.3.6]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar:2.0.6]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.sun.proxy.$Proxy52.insert(Unknown Source) ~[na:na]
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.6.jar:2.0.6]
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.3.jar:3.4.3]
at com.sun.proxy.$Proxy56.insert(Unknown Source) ~[na:na]
at com.casic.service.impl.DayDataProvider.CreateWellDataLocal(DayDataProvider.java:149) ~[classes/:na]
at com.casic.service.impl.DayDataProvider.wellLocalData(DayDataProvider.java:37) ~[classes/:na]
at com.casic.config.task.TaskConfigurer$1.run(TaskConfigurer.java:40) ~[classes/:na]
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.6.jar:5.3.6]
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) [spring-context-5.3.6.jar:5.3.6]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) [na:1.8.0_91]
at java.util.concurrent.FutureTask.run(FutureTask.java) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [na:1.8.0_91]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1429) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1408) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.checkReadOnlySafeStatement(ClientPreparedStatement.java:309) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:319) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.5.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.5.7.jar:3.5.7]
at com.sun.proxy.$Proxy82.execute(Unknown Source) ~[na:na]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) ~[mybatis-3.5.7.jar:3.5.7]
at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar:2.0.6]
... 19 common frames omitted
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet successfully received from the server was 52 milliseconds ago. The last packet sent successfully to the server was 99 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_91]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_91]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_91]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_91]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:132) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.NativeSession.sendCommand(NativeSession.java:321) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:1090) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1416) ~[mysql-connector-java-8.0.16.jar:8.0.16]
... 40 common frames omitted
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_91]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[na:1.8.0_91]
at java.net.SocketInputStream.read(SocketInputStream.java:170) ~[na:1.8.0_91]
at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_91]
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) ~[na:1.8.0_91]
at sun.security.ssl.InputRecord.read(InputRecord.java:503) ~[na:1.8.0_91]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973) ~[na:1.8.0_91]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930) ~[na:1.8.0_91]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[na:1.8.0_91]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_91]
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-java-8.0.16.jar:8.0.16]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556) ~[mysql-connector-java-8.0.16.jar:8.0.16]
... 46 common frames omitted
