2010-02-20 11:01:16,093 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner] - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetecto[email protected] -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2010-02-20 11:01:16,109 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner] - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetecto[email protected] -- APPARENT DEADLOCK!!! Complete Status: [num_managed_threads: 3, num_active: 3; activeTasks: [email protected] (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0), [email protected] (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2), [email protected] (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1); pendingTasks: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected][email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected][email protected], [email protected], [email protected], [email protected], [email protected]]
2010-02-20 11:02:04,781 WARN [com.mchange.v2.resourcepool.BasicResourcePool] - BasicResourcePool: An idle resource is broken and will be purged.
java.sql.SQLException: Connection is invalid
?at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:196)
?at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:136)
?at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1394)
?at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)
?
C3P0的这个问题一直没有解决，我最后使用了proxool，完美解决了此问题，所以在此推荐大家使用proxool，稳定运行3个月了，没有出现问题