数据源 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager

Question

03:16:32.281 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-AdminTaskTimer] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Refurbishing idle resources - Sun Sep 29 03:16:32 CST 2019 [com.mchange.v2.resourcepool.BasicResourcePool@44cceaee]
03:16:32.281 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#0] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@8574266] on IDLE CHECK.
03:16:32.281 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#2] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@3fbc46ac] on IDLE CHECK.
03:16:32.281 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@2bdef838] on IDLE CHECK.
03:16:32.282 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#0] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@8574266] on IDLE CHECK has SUCCEEDED.
03:16:32.282 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@2bdef838] on IDLE CHECK has SUCCEEDED.
03:16:32.282 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#2] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@3fbc46ac] on IDLE CHECK has SUCCEEDED.
03:16:32.282 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#0] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@6d165f36] on IDLE CHECK.
03:16:32.282 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Testing PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@73dcd74b] on IDLE CHECK.
03:16:32.283 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-AdminTaskTimer] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Sun Sep 29 03:16:32 CST 2019 [com.mchange.v2.resourcepool.BasicResourcePool@44cceaee]
03:16:32.284 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-AdminTaskTimer] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - BEGIN check for expired resources.  [com.mchange.v2.resourcepool.BasicResourcePool@44cceaee]
03:16:32.284 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#0] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@6d165f36] on IDLE CHECK has SUCCEEDED.
03:16:32.284 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-AdminTaskTimer] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - FINISHED check for expired resources.  [com.mchange.v2.resourcepool.BasicResourcePool@44cceaee]
03:16:32.284 [C3P0PooledConnectionPoolManager[identityToken->1hge0yta5xnjgfbz7t7s7|4fdf9832]-HelperThread-#1] DEBUG com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool - Test of PooledConnection [com.mchange.v2.c3p0.impl.NewPooledConnection@73dcd74b] on IDLE CHECK has SUCCEEDED.
03:16:33.400 [http-apr-8081-exec-4] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
03:16:33.400 [http-apr-8081-exec-4] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f6566b7] was not registered for synchronization because synchronization is not active
03:16:33.401 [http-apr-8081-exec-4] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@259d0dc7 [wrapping: com.mysql.jdbc.JDBC4Connection@62000e36]] will not be managed by Spring
03:16:33.401 [http-apr-8081-exec-4] DEBUG org.imooc.dao.AdDao.selectByPage - ==>  Preparing: select count(*) from(select id,title,img_file_name,link,weight from ad order by weight desc,id)t 
03:16:33.402 [http-apr-8081-exec-4] DEBUG org.imooc.dao.AdDao.selectByPage - ==> Parameters: 
03:16:33.406 [http-apr-8081-exec-4] DEBUG org.imooc.dao.AdDao.selectByPage - ==>  Preparing: select id,title,img_file_name,link,weight from ad order by weight desc,id limit 0,5 
03:16:33.407 [http-apr-8081-exec-4] DEBUG org.imooc.dao.AdDao.selectByPage - ==> Parameters: 
03:16:33.409 [http-apr-8081-exec-4] DEBUG org.imooc.dao.AdDao.selectByPage - <==      Total: 5
03:16:33.409 [http-apr-8081-exec-4] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f6566b7]

Answer 1

源生活 2019-09-29 19:34:50

想问什么？

• 提问者 cjozGV #1

  连接池 有问题

• 源生活 回复 提问者 cjozGV #2

  什么问题？我看查询的结果打印出来了

• 提问者 cjozGV 回复 源生活 #3

  com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager 信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 3, acquireRetryDelay -> 1000, autoCo

点开查看后面3条评论

Answer 2

提问者 cjozGV 2019-09-29 03:23:08

 DEBUG com.mchange.v2.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool@58d703f8 config: [start -> 5; min -> 5; max -> 10; inc -> 3; num_acq_attempts -> 3; acq_attempt_delay -> 1000; check_idle_resources_delay -> 60000; max_resource_age -> 0; max_idle_time -> 60000; excess_max_idle_time -> 0; destroy_unreturned_resc_time -> 0; expiration_enforcement_delay -> 15000; break_on_acquisition_failure -> false; debug_store_checkout_exceptions -> false; force_synchronous_checkins -> false]