文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
首页
学习
活动
专区
圈层
工具
MCP广场
返回腾讯云官网
社区首页 >问答首页 >为什么“添加连接省略，等待0，队列n"？

问为什么“添加连接省略，等待0，队列n"？
EN

Stack Overflow用户
提问于 2021-01-12 10:11:37
回答 1查看 1.7K关注 0票数 0

我在这个社区上看到过an answer，但我想，我的问题不是这样的。

我每天早上8点有一份工作。两分钟内我的工作就完成了。但我正面临着一个问题。关闭连接后(因为maxLifetime通过了)，有时添加新连接将被省略。然后，我得到了添加连接的。但过了一些时候，它在Hikari池中增加了新的连接。我给出了一些这些情景的日志：

代码语言：javascript
运行
复制
2021-01-09 05:07:59.606 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=10, active=0, idle=10, waiting=0)
2021-01-09 05:07:59.606 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 05:08:12.535 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@2f5f578e: (connection has passed maxLifetime)
2021-01-09 05:08:12.606 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@65d1a1ad: (connection has passed maxLifetime)
2021-01-09 05:08:12.606 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 1
2021-01-09 05:08:12.624 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@4f0ee473
2021-01-09 05:08:12.708 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@41c903e2
2021-01-09 05:08:12.708 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After adding stats (total=10, active=0, idle=10, waiting=0)
2021-01-09 05:08:17.504 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@6b165367: (connection has passed maxLifetime)
2021-01-09 05:08:17.578 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@45f68f03
2021-01-09 05:08:29.606 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=10, active=0, idle=10, waiting=0)
.
.
2021-01-09 11:42:59.907 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=10, active=0, idle=10, waiting=0)
2021-01-09 11:42:59.907 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 11:43:04.584 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@3b711873: (connection has passed maxLifetime)
2021-01-09 11:43:04.587 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@35b6e0b5: (connection has passed maxLifetime)
2021-01-09 11:43:04.587 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 1
2021-01-09 11:43:04.644 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@4ac53bd7
2021-01-09 11:43:04.733 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@4402dcff
2021-01-09 11:43:04.733 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After adding stats (total=10, active=0, idle=10, waiting=0)
.
.
2021-01-09 14:50:30.056 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=10, active=0, idle=10, waiting=0)
2021-01-09 14:50:30.056 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 14:50:37.520 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@4e009619: (connection has passed maxLifetime)
2021-01-09 14:50:37.608 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@66c98217
2021-01-09 14:50:52.216 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@3e0aefb: (connection has passed maxLifetime)
2021-01-09 14:50:52.220 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@d2740f7: (connection has passed maxLifetime)
2021-01-09 14:50:52.220 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 1
2021-01-09 14:50:52.284 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@5a94a52b
2021-01-09 14:50:52.375 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@54535009
2021-01-09 14:50:52.375 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After adding stats (total=10, active=0, idle=10, waiting=0)

但在那一天，从17:45到18:03，除了一个连接之外，所有连接加法都被删除，因此hikari池中的总连接变为0。被添加的那个在传递maxLifetime后被移除，并且无法被添加( 17:53:27.091)。我正在分享那段时间的日志：

代码语言：javascript
运行
复制
2021-01-09 17:45:37.135 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After adding stats (total=10, active=0, idle=10, waiting=0)
2021-01-09 17:45:47.379 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@3e7ef8f0: (connection has passed maxLifetime)
2021-01-09 17:46:00.208 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:46:00.208 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:46:00.208 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:46:30.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:46:30.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:46:30.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:47:00.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:47:00.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:47:00.209 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
.(same stat)
.(same stat)
2021-01-09 17:51:30.212 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:51:30.212 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:51:30.212 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:52:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:52:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=9, active=0, idle=9, waiting=0)
2021-01-09 17:52:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:52:21.449 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 1
2021-01-09 17:52:21.450 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@6588afc6: (connection has passed maxLifetime)
2021-01-09 17:52:30.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:52:30.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:52:30.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:52:37.340 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 2
2021-01-09 17:52:37.340 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@6b4f5d07: (connection has passed maxLifetime)
2021-01-09 17:53:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=7, active=0, idle=7, waiting=0)
2021-01-09 17:53:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=7, active=0, idle=7, waiting=0)
2021-01-09 17:53:00.213 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:53:27.091 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@7a0cfa05
2021-01-09 17:53:30.214 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:53:30.214 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:53:30.214 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
.(same stat)
.(same stat)
2021-01-09 17:55:00.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:55:00.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=8, active=0, idle=8, waiting=0)
2021-01-09 17:55:00.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:55:21.807 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 2
2021-01-09 17:55:21.808 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@2a72573c: (connection has passed maxLifetime)
2021-01-09 17:55:24.141 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 3
2021-01-09 17:55:24.141 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@6f70c4b6: (connection has passed maxLifetime)
2021-01-09 17:55:24.463 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@aa42b2b: (connection has passed maxLifetime)
2021-01-09 17:55:24.463 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 4
2021-01-09 17:55:25.278 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 5
2021-01-09 17:55:25.278 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@72aedaad: (connection has passed maxLifetime)
2021-01-09 17:55:25.549 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 6
2021-01-09 17:55:25.549 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@1b92f81d: (connection has passed maxLifetime)
2021-01-09 17:55:26.077 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@610b2f60: (connection has passed maxLifetime)
2021-01-09 17:55:26.077 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 7
2021-01-09 17:55:30.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=2, active=0, idle=2, waiting=0)
2021-01-09 17:55:30.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=2, active=0, idle=2, waiting=0)
2021-01-09 17:55:30.215 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 17:55:30.696 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@4a5da873: (connection has passed maxLifetime)
2021-01-09 17:55:30.696 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 8
2021-01-09 17:56:00.216 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 17:56:00.216 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 17:56:00.216 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
.(same stat)
.(same stat)
2021-01-09 18:02:30.220 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:02:30.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:02:30.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 18:03:00.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:03:00.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:03:00.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 18:03:26.669 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 9
2021-01-09 18:03:26.669 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@7a0cfa05: (connection has passed maxLifetime)
2021-01-09 18:03:30.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=0, active=0, idle=0, waiting=0)
2021-01-09 18:03:30.221 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=0, active=0, idle=0, waiting=0)

在18:11，它设法添加了一个连接。但是在通过maxLifeTime之后，该连接也被移除，从那时起三天内没有新的连接进入hikari池，因此这3天的总连接为0。共享日志：

代码语言：javascript
运行
复制
2021-01-09 18:11:30.227 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=0, active=0, idle=0, waiting=0)
2021-01-09 18:11:30.228 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 18:11:42.352 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:728 - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@74cb0b34
2021-01-09 18:11:42.352 [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After adding stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:12:00.228 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:12:00.228 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)
.(same stat)
.(same stat)
2021-01-09 18:21:00.234 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:21:00.234 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - After cleanup  stats (total=1, active=0, idle=1, waiting=0)
2021-01-09 18:21:00.234 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:517 - HikariPool-1 - Fill pool skipped, pool is at sufficient level.
2021-01-09 18:21:29.887 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 9
2021-01-09 18:21:29.887 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@74cb0b34: (connection has passed maxLifetime)
2021-01-09 18:21:30.235 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:421 - HikariPool-1 - Before cleanup stats (total=0, active=0, idle=0, waiting=0)

在重新启动应用程序之后，hikari现在总共拥有10个连接。但我怀疑在任何时候，它都会创建前一个场景，并会为每个新的连接添加得到Add connection专用的，因为我现在有时也会这样做，而且有时它也会添加连接(就像以前的场景一样)。有什么办法解决这个问题吗？为什么会有这种奇怪的行为？

编辑：

按照要求，共享应用程序的hikari配置：

代码语言：javascript
运行
复制
spring.datasource.hikari.connection-timeout=5000
spring.datasource.hikari.maximumPoolSize=50
spring.datasource.hikari.minimumIdle=10
spring.datasource.hikari.idleTimeout=599000
spring.datasource.hikari.leak-detection-threshold=540000
spring-boot
hikaricp
EN

回答 1

Stack Overflow用户

发布于 2021-05-08 16:57:36

该消息来自以下代码：

代码语言：javascript
运行
复制
   public void addBagItem(final int waiting) {
      final boolean shouldAdd = waiting - addConnectionQueueReadOnlyView.size() >= 0; // Yes, >= is intentional.
      if (shouldAdd) {
         addConnectionExecutor.submit(poolEntryCreator);
      }
      else {
         logger.debug("{} - Add connection elided, waiting {}, queue {}", poolName, waiting, addConnectionQueueReadOnlyView.size());
      }
   }

其中一个被称为MaxLifetimeTask的地方是何时运行的。当两个连接在很短的时间内达到最大生命周期时，您将看到这种“被忽略的”行为。

基本上，第一个过期的连接将排队一个"PoolEntryCreator“。实际上，PoolEntryCreator将根据需要创建尽可能多的连接来维护池。因此，当第二个过期的连接导致调用上述方法时，池会意识到PoolEntryCreator已经排队。因此，排队的另一个是不必要的--并被删除。

在上面的日志中，我们可以在这里看到这一点，例如：

代码语言：javascript
运行
复制
2021-01-09 05:08:12.535 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@2f5f578e: (connection has passed maxLifetime)
2021-01-09 05:08:12.606 [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase:134 - HikariPool-1 - Closing connection org.postgresql.jdbc.PgConnection@65d1a1ad: (connection has passed maxLifetime)
2021-01-09 05:08:12.606 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool:342 - HikariPool-1 - Add connection elided, waiting 0, queue 1

我不确定这与你所看到的问题有什么特别的关系。我所看到的问题是，添加新连接的队列不断增加。

在17:52:21.449，队列深度为1，17:55:21.807为2，17:55:24.141为3，18:03:26.669为9。

添加一个新的(或几个)连接应该需要毫秒，或者最多几秒，但是队列仍在不断地堆积。这意味着在17:52:21.449创建的PoolEntryCreator从未完成(退出)。

在我看来，这似乎是你问题的核心。为什么没有建立新的连接？很可能他们是尝试，然后失败，并被重新尝试，而创造的尝试继续到无穷大。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/65681833

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 深公网安备号 44030502008569

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号 | 京公网安备号11010802020287

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档