日志文件：/home/ygf/ch10.log 内容 2024年12月28日 星期六 06:24:53

2024-10-21T20:46:35.602+08:00 INFO 8221 --- [ch10] [io-8081-exec-10] cn.ygf.controller.EmpController : 分页査询，参数:45
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@791b5ffd] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.9743589743589743
JDBC Connection [HikariProxyConnection@179148451 wrapping com.mysql.cj.jdbc.ConnectionImpl@170f9040] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_ygf
==> Parameters:
<== Columns: count(0)
<== Row: 17
<== Total: 1
==> Preparing: select * from emp_ygf LIMIT ? ?
==> Parameters: 15(Long) 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 19 yanguofeng 123456 闫国锋 1 http://tlias.itheima.com/1.jpg 1 2015-09-18 1 2024-09-19 09:46:21 2024-09-19 09:46:21
<== Row: 20 黄渤 123456 黄渤 1 https://web-ygf.oss-cn-beijing.aliyuncs.com/c3f4d52a-1274-4bcc-9ce6-3382e5832dcf_黄渤.jpg 3 2024-10-05 1 2024-10-21 19:42:36 2024-10-21 19:42:36
<== Total: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@791b5ffd]
2024-10-23T17:56:17.016+08:00 INFO 8221 --- [ch10] [io-8081-exec-10] cn.ygf.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@695530dc] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@254520283 wrapping com.mysql.cj.jdbc.ConnectionImpl@2f40a7aa] will not be managed by Spring
==> Preparing: select * from dept_ygf
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 闫姓学工部 2024-09-13 16:15:04 2024-09-13 16:15:04
<== Row: 2 闫氏教研部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 3 闫氏咨询部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 4 闫氏就业部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 6 闫家就业部 2024-09-13 16:09:44 2024-09-13 16:09:44
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@695530dc]
2024-10-23T17:56:18.401+08:00 INFO 8221 --- [ch10] [nio-8081-exec-9] cn.ygf.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2011b689] was not registered for synchronization because synchronization is not active
2024-10-23T17:56:18.405+08:00 INFO 8221 --- [ch10] [nio-8081-exec-1] cn.ygf.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a69e981] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.975
JDBC Connection [HikariProxyConnection@1026748570 wrapping com.mysql.cj.jdbc.ConnectionImpl@2f40a7aa] will not be managed by Spring
==> Preparing: select * from dept_ygf
==> Parameters:
JDBC Connection [HikariProxyConnection@1462854959 wrapping com.mysql.cj.jdbc.ConnectionImpl@2c866f88] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_ygf
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 闫姓学工部 2024-09-13 16:15:04 2024-09-13 16:15:04
<== Row: 2 闫氏教研部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 3 闫氏咨询部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 4 闫氏就业部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 6 闫家就业部 2024-09-13 16:09:44 2024-09-13 16:09:44
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2011b689]
<== Columns: count(0)
<== Row: 17
<== Total: 1
==> Preparing: select * from emp_ygf LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 ygf 123456 闫国锋 1 1.jpg 4 2000-01-01 2 2024-09-13 13:55:18 2024-09-13 13:55:18
<== Row: 2 jinyong 123456 金庸先生 1 1.jpg 4 2000-01-02 2 2024-09-13 13:55:18 2024-09-13 13:55:18
<== Row: 3 zhangwuji 123456 张无忌 1 2.jpg 2 2015-01-01 2 2024-09-13 13:55:18 2024-09-13 13:55:18
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-13 13:55:18 2024-09-13 13:55:18
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-13 13:55:18 2024-09-13 13:55:18
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7a69e981]
2024-10-23T17:58:25.556+08:00 INFO 8221 --- [ch10] [nio-8081-exec-2] cn.ygf.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@519e5de0] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1254695834 wrapping com.mysql.cj.jdbc.ConnectionImpl@2f40a7aa] will not be managed by Spring
==> Preparing: select * from dept_ygf
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 闫姓学工部 2024-09-13 16:15:04 2024-09-13 16:15:04
<== Row: 2 闫氏教研部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 3 闫氏咨询部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 4 闫氏就业部 2024-09-13 13:55:09 2024-09-13 13:55:09
<== Row: 6 闫家就业部 2024-09-13 16:09:44 2024-09-13 16:09:44
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@519e5de0]
2024-11-15T07:39:51.062+08:00 ERROR 8221 --- [ch10] [onnection adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Error thrown while acquiring connection from data source

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 40212 milliseconds ago. The last packet sent successfully to the server was 45102 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1364) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1349) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:404) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:724) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:703) ~[HikariCP-5.1.0.jar!/:na]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na]
at java.base/java.lang.Thread.run(Thread.java:842) ~[na:na]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 40212 milliseconds ago. The last packet sent successfully to the server was 45102 milliseconds ago.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[na:na]
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[na:na]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:104) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:157) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:593) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1356) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
... 11 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:288) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:314) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808) ~[na:na]
at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70) ~[na:na]
at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1461) ~[na:na]
at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1065) ~[na:na]
at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) ~[na:na]
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
... 16 common frames omitted

2024-11-15T07:43:28.569+08:00 ERROR 8221 --- [ch10] [onnection adder] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Error thrown while acquiring connection from data source

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 15092 milliseconds ago. The last packet sent successfully to the server was 20190 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1364) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1349) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:404) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:724) ~[HikariCP-5.1.0.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:703) ~[HikariCP-5.1.0.jar!/:na]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na]
at java.base/java.lang.Thread.run(Thread.java:842) ~[na:na]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 15092 milliseconds ago. The last packet sent successfully to the server was 20190 milliseconds ago.
at jdk.internal.reflect.GeneratedConstructorAccessor78.newInstance(Unknown Source) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[na:na]
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480) ~[na:na]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:104) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:157) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:593) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1356) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
... 11 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.base/sun.nio.ch.NioSocketImpl.timedRead(NioSocketImpl.java:288) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:314) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355) ~[na:na]
at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808) ~[na:na]
at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478) ~[na:na]
at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70) ~[na:na]
at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1461) ~[na:na]
at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1065) ~[na:na]
at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) ~[na:na]
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576) ~[mysql-connector-j-8.3.0.jar!/:8.3.0]
... 16 common frames omitted