日志文件：/home/hzq/ch10.log 内容 2025年01月05日 星期日 15:23:37
:: Spring Boot :: (v3.3.4)
2024-09-27T17:15:27.713+08:00 INFO 658822 --- [ch10] [ main] cn.hzq.Ch10Application : Starting Ch10Application v0.0.1-SNAPSHOT using Java 17.0.12 with PID 658822 (/home/hzq/ch10.jar started by root in /home/hzq)
2024-09-27T17:15:27.730+08:00 INFO 658822 --- [ch10] [ main] cn.hzq.Ch10Application : No active profile set falling back to 1 default profile: "default"
2024-09-27T17:15:29.180+08:00 INFO 658822 --- [ch10] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8081 (http)
2024-09-27T17:15:29.203+08:00 INFO 658822 --- [ch10] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2024-09-27T17:15:29.204+08:00 INFO 658822 --- [ch10] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.30]
2024-09-27T17:15:29.256+08:00 INFO 658822 --- [ch10] [ main] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2024-09-27T17:15:29.257+08:00 INFO 658822 --- [ch10] [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1416 ms
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
------. --. --. --.
| .--. ' ----. ---. ---. | '--' | ---. | | ---. ---. --.--.
| '--' | ' -. | | .-. | | .-. : | .--. | | .-. : | | | .-. | | .-. : | .--'
| | --' \ '-' | ' '-' ' \ --. | | | | \ --. | | | '-' ' \ --. | |
`--' `--`--' .`- / `----' `--' `--' `----' `--' | |-' `----' `--'
`---' `--' is intercepting.
2024-09-27T17:15:30.189+08:00 INFO 658822 --- [ch10] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8081 (http) with context path '/'
2024-09-27T17:15:30.212+08:00 INFO 658822 --- [ch10] [ main] cn.hzq.Ch10Application : Started Ch10Application in 3.163 seconds (process running for 3.764)
2024-09-27T17:15:44.797+08:00 INFO 658822 --- [ch10] [nio-8081-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2024-09-27T17:15:44.798+08:00 INFO 658822 --- [ch10] [nio-8081-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2024-09-27T17:15:44.799+08:00 INFO 658822 --- [ch10] [nio-8081-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms
2024-09-27T22:35:06.417+08:00 INFO 658822 --- [ch10] [nio-8081-exec-7] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@33fc280d] was not registered for synchronization because synchronization is not active
2024-09-27T22:35:06.457+08:00 INFO 658822 --- [ch10] [nio-8081-exec-7] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2024-09-27T22:35:06.988+08:00 INFO 658822 --- [ch10] [nio-8081-exec-7] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3
2024-09-27T22:35:06.990+08:00 INFO 658822 --- [ch10] [nio-8081-exec-7] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@1549281377 wrapping com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@33fc280d]
2024-09-27T22:35:08.884+08:00 INFO 658822 --- [ch10] [io-8081-exec-10] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@381acbd2] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@920461985 wrapping com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
2024-09-27T22:35:08.890+08:00 INFO 658822 --- [ch10] [nio-8081-exec-9] cn.hzq.controller.EmpController : 分页査询，参数:15
<== Columns: id name create_time update_time
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7216593f] was not registered for synchronization because synchronization is not active
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@381acbd2]
Cache Hit Ratio [SQL_CACHE]: 0.0
JDBC Connection [HikariProxyConnection@1121364976 wrapping com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_hzq
==> Parameters:
<== Columns: count(0)
<== Row: 18
<== Total: 1
==> Preparing: select * from emp_hzq LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 hzq 123456 侯子茜 1 1.jpg 4 2000-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 2 jin 123456 金庸先生 1 1.jpg 4 2000-01-02 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 3 zhangwuji 123456 张无忌 1 2.jpg 2 2015-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7216593f]
2024-09-27T22:35:28.475+08:00 INFO 658822 --- [ch10] [nio-8081-exec-2] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@525b9c34] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1634318240 wrapping com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@525b9c34]
2024-09-27T22:35:30.859+08:00 INFO 658822 --- [ch10] [nio-8081-exec-3] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@21ff25e] was not registered for synchronization because synchronization is not active
2024-09-27T22:35:30.861+08:00 INFO 658822 --- [ch10] [nio-8081-exec-4] cn.hzq.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7349fcc4] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.5
JDBC Connection [HikariProxyConnection@215489645 wrapping com.mysql.cj.jdbc.ConnectionImpl@1d9ff1f3] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
JDBC Connection [HikariProxyConnection@2106465501 wrapping com.mysql.cj.jdbc.ConnectionImpl@79b197b4] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Columns: count(0)
<== Row: 18
<== Total: 1
==> Preparing: select * from emp_hzq LIMIT ?
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@21ff25e]
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 hzq 123456 侯子茜 1 1.jpg 4 2000-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 2 jin 123456 金庸先生 1 1.jpg 4 2000-01-02 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 3 zhangwuji 123456 张无忌 1 2.jpg 2 2015-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7349fcc4]
2024-09-28T09:07:56.598+08:00 INFO 658822 --- [ch10] [nio-8081-exec-5] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c432495] was not registered for synchronization because synchronization is not active
2024-09-28T09:07:56.599+08:00 INFO 658822 --- [ch10] [nio-8081-exec-6] cn.hzq.controller.EmpController : 分页査询，参数:15
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@76416ce4] was not registered for synchronization because synchronization is not active
Cache Hit Ratio [SQL_CACHE]: 0.6666666666666666
JDBC Connection [HikariProxyConnection@42261357 wrapping com.mysql.cj.jdbc.ConnectionImpl@6bb4fe5] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
JDBC Connection [HikariProxyConnection@1669261280 wrapping com.mysql.cj.jdbc.ConnectionImpl@56660740] will not be managed by Spring
==> Preparing: SELECT count(0) FROM emp_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@c432495]
<== Columns: count(0)
<== Row: 18
<== Total: 1
==> Preparing: select * from emp_hzq LIMIT ?
==> Parameters: 5(Integer)
<== Columns: id username password name gender image job entrydate dept_id create_time update_time
<== Row: 1 hzq 123456 侯子茜 1 1.jpg 4 2000-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 2 jin 123456 金庸先生 1 1.jpg 4 2000-01-02 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 3 zhangwuji 123456 张无忌 1 2.jpg 2 2015-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 4 yangxiao 123456 杨逍 1 3.jpg 2 2008-05-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Row: 5 weiyixiao 123456 韦一笑 1 4.jpg 2 2007-01-01 2 2024-09-06 15:41:25 2024-09-06 15:41:25
<== Total: 5
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@76416ce4]
2024-09-28T09:21:18.011+08:00 INFO 658822 --- [ch10] [nio-8081-exec-7] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@65322c83] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@250815157 wrapping com.mysql.cj.jdbc.ConnectionImpl@6bb4fe5] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 2 侯氏教研部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-06 17:08:44 2024-09-06 17:08:44
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@65322c83]
2024-10-04T01:54:47.334+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=45s209ms484µs719ns).
2024-10-04T02:04:24.137+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=39m54s404ms186µs116ns).
2024-10-04T02:23:00.042+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=18m17s243ms748µs470ns).
2024-10-04T02:43:05.251+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=20m38s270ms672µs764ns).
2024-10-11T14:47:52.309+08:00 INFO 658822 --- [ch10] [nio-8081-exec-1] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@769d8fb7] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1743817008 wrapping com.mysql.cj.jdbc.ConnectionImpl@e88d765] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-28 16:29:58 2024-09-28 16:29:58
<== Row: 17 教研部 2024-10-10 10:35:56 2024-10-10 10:35:56
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@769d8fb7]
2024-10-11T15:04:50.779+08:00 INFO 658822 --- [ch10] [nio-8081-exec-2] cn.hzq.controller.DeptController : 查询全部部门数据
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47ebcea9] was not registered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@1230983260 wrapping com.mysql.cj.jdbc.ConnectionImpl@65272a60] will not be managed by Spring
==> Preparing: select * from dept_hzq
==> Parameters:
<== Columns: id name create_time update_time
<== Row: 1 侯家学工部 2024-09-06 19:33:05 2024-09-06 19:33:05
<== Row: 3 侯氏咨询部 2024-09-06 15:40:33 2024-09-06 15:40:33
<== Row: 6 侯家就业部 2024-09-28 16:29:58 2024-09-28 16:29:58
<== Row: 17 教研部 2024-10-10 10:35:56 2024-10-10 10:35:56
<== Total: 4
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@47ebcea9]
2024-10-26T13:08:25.402+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=52s781ms946µs399ns).
2024-10-26T13:08:55.609+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=4m40s931ms665µs527ns).
2024-10-29T17:25:52.945+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=53s602ms948µs940ns).
2024-10-29T17:27:41.160+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=1m47s715ms354µs563ns).
2024-10-29T17:28:41.461+08:00 WARN 658822 --- [ch10] [l-1 housekeeper] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=1m901ms202µs30ns).