取消Hikari池连接，并打开新池

Question

我有一个spring boot（2.4）应用程序，在长时间运行的jpa事务下，我看到很多连接超过了我的最大池大小，当我检查日志时，我看到连接被省略了，在新的HikariPools 2-3-4等之后。。。都打开了。我试过hikari 4.0。2个版本，但仍然是相同的问题。在这个场景中，给出最大池大小的含义是什么（每个池看起来都是我的最大池大小，但总连接数超过了我的限制）。是否有限制期初池数的配置？我用代码创建这样的数据源

HikariDataSource dataSource = new HikariDataSource();
dataSource.setJdbcUrl(myuri);
 dataSource.setUsername(myuser);
 dataSource.setPassword(mypasswprd);
 dataSource.setMinimumIdle(10);
 dataSource.setMaximumPoolSize(10);
 dataSource.setIdleTimeout(100000);
 dataSource.setMaxLifetime(200000);
 return dataSource;

当做

HikariPool-1 - Add connection elided, waiting 3, queue 5

17:54:56.894 [restartedMain] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@4c6d3cfb
17:54:56.999 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=1, active=0, idle=1, waiting=0)
17:54:57.669 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@190a0b35
17:54:58.314 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@69a59932
17:54:58.314 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=3, active=0, idle=3, waiting=0)
17:56:57.005 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=5, active=0, idle=5, waiting=0)
17:56:57.005 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
17:57:27.006 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=5, active=0, idle=5, waiting=0)
17:57:27.006 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
18:15:03.114 [http-nio-8085-exec-2] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 4, queue 5
18:15:03.126 [http-nio-8085-exec-17] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 4, queue 5
18:15:03.130 [http-nio-8085-exec-18] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 3, queue 5
18:15:03.248 [http-nio-8085-exec-11] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 3, queue 5
18:15:03.254 [http-nio-8085-exec-8] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 3, queue 5
18:15:03.288 [http-nio-8085-exec-17] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 3, queue 5
18:15:03.289 [http-nio-8085-exec-8] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 2, queue 5
18:15:03.291 [http-nio-8085-exec-11] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection elided, waiting 3, queue 5
18:15:03.326 [http-nio-8085-exec-8] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Add connection
18:15:03.391 [http-nio-8085-exec-12] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Added connection oracle.jdbc.driver.T4CConnection@4f5ab95d
18:15:03.538 [HikariPool-2 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Pool stats (total=1, active=1, idle=0, waiting=1)
18:15:03.938 [http-nio-8085-exec-6] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Added connection oracle.jdbc.driver.T4CConnection@4e5ee0cc
18:15:04.040 [HikariPool-3 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-3 - Pool stats (total=1, active=1, idle=0, waiting=1)
18:15:04.167 [HikariPool-2 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-2 - Added connection oracle.jdbc.driver.T4CConnection@317680ec
18:15:04.225 [http-nio-8085-exec-5] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-4 - Added connection oracle.jdbc.driver.T4CConnection@79d11005

Answer 1

在我的代码中有一个泄漏，我不止一次地创建数据源，因为我看到了多个数据源