Mysql connector - Java - 8.0.21. Jar
McHange - Commons - Java - 0.2.15. Jar
C3p0-0.9.5.2. Jar
Question:
MYSQL5.7 8.0.21 updated version, after the first operation no problem, to a certain time (about 1 day) c3p0 connection fails, the paper analyzes the reasons of less than a few days, suggesting the following
Thank you I had no points, a bit of
04 - Oct - 2020 18:20:53. 308 WARNING [pool - 96 - thread - 1] com. McHange. V2. Resourcepool. BasicResourcePool. Com. McHange. V2. Resourcepool. BasicResourcePool @ 31270 - a - an attempt to checkout a resource was interrupted, and the pool is still live: some other thread must have interrupted the thread attempting to checkout!
Java. Lang. InterruptedException
The at Java. Lang. Object. Wait (Native Method)
At com. McHange. V2. Resourcepool. BasicResourcePool. AwaitAvailable (BasicResourcePool. Java: 1465)
At com. McHange. V2. Resourcepool. BasicResourcePool. PrelimCheckoutResource (BasicResourcePool. Java: 644)
At com. McHange. V2. Resourcepool. BasicResourcePool. CheckoutResource (BasicResourcePool. Java: 554)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutAndMarkConnectionInUse (C3P0PooledConnectionPool. Java: 758)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutPooledConnection (C3P0PooledConnectionPool. Java: 685)
At com. McHange. V2. C3p0. Impl. AbstractPoolBackedDataSource. GetConnection (AbstractPoolBackedDataSource. Java: 140)
At com.Web.com, mon. ConnectionFactory. GetConnection (ConnectionFactory. Java: 71)
At Public. Dm. ProcExec_open (Dm) Java: 149)
At the Servlet. TopSft_WeiXin. DoPost_ (TopSft_WeiXin. Java: 140)
At the Servlet. The TopSft_WeiXin $1. The call (TopSft_WeiXin. Java: 56)
At the Servlet. The TopSft_WeiXin $1. The call (TopSft_WeiXin. Java: 1)
The at Java. Util. Concurrent. FutureTask. Run (FutureTask. Java: 266)
The at Java. Util. Concurrent. ThreadPoolExecutor. RunWorker (ThreadPoolExecutor. Java: 1149)
The at Java. Util. Concurrent. ThreadPoolExecutor $Worker. The run (ThreadPoolExecutor. Java: 624)
The at Java. Lang. Thread. The run (Thread. Java: 748)
Java. SQL. SQLException: An SQLException was provoked by the following failure: Java. Lang. InterruptedException
At com. McHange. V2. SQL. SqlUtils. ToSQLException (SqlUtils. Java: 118)
At com. McHange. V2. SQL. SqlUtils. ToSQLException (SqlUtils. Java: 77)
At com. McHange. V2. SQL. SqlUtils. ToSQLException (SqlUtils. Java: 74)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutPooledConnection (C3P0PooledConnectionPool. Java: 694)
At com. McHange. V2. C3p0. Impl. AbstractPoolBackedDataSource. GetConnection (AbstractPoolBackedDataSource. Java: 140)
At com.Web.com, mon. ConnectionFactory. GetConnection (ConnectionFactory. Java: 71)
At Public. Dm. ProcExec_open (Dm) Java: 149)
At the Servlet. TopSft_WeiXin. DoPost_ (TopSft_WeiXin. Java: 140)
At the Servlet. The TopSft_WeiXin $1. The call (TopSft_WeiXin. Java: 56)
At the Servlet. The TopSft_WeiXin $1. The call (TopSft_WeiXin. Java: 1)
The at Java. Util. Concurrent. FutureTask. Run (FutureTask. Java: 266)
The at Java. Util. Concurrent. ThreadPoolExecutor. RunWorker (ThreadPoolExecutor. Java: 1149)
The at Java. Util. Concurrent. ThreadPoolExecutor $Worker. The run (ThreadPoolExecutor. Java: 624)
The at Java. Lang. Thread. The run (Thread. Java: 748)
Under Caused by: Java. Lang. InterruptedException
The at Java. Lang. Object. Wait (Native Method)
At com. McHange. V2. Resourcepool. BasicResourcePool. AwaitAvailable (BasicResourcePool. Java: 1465)
At com. McHange. V2. Resourcepool. BasicResourcePool. PrelimCheckoutResource (BasicResourcePool. Java: 644)
At com. McHange. V2. Resourcepool. BasicResourcePool. CheckoutResource (BasicResourcePool. Java: 554)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutAndMarkConnectionInUse (C3P0PooledConnectionPool. Java: 758)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutPooledConnection (C3P0PooledConnectionPool. Java: 685)
CodePudding user response:
Pack drive upgrade, c is what upgrade