且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

HikariPool-1-连接不可用,对于极小的负载服务器,请求在30000ms后超时

更新时间:2022-01-29 17:44:48

由于网络延迟或某些查询执行时间过长,您的数据库未在(30000毫秒,这是默认的connectionTimeout属性)之内获得连接.超过30000毫秒).

Your database is not obtaining connection within (30000 milliseconds that is default connectionTimeout property) because of network latency or some of the queries which are taking too long to execute(more than 30000 milliseconds).

请尝试增加属性connectionTimeout的值.

YML配置示例:

spring:
  datasource:
    hikari:
      minimumIdle: 2
      maximumPoolSize: 10
      idleTimeout: 120000
      connectionTimeout: 300000
      leakDetectionThreshold: 300000

Java Config示例:

Java Config example:

HikariConfig config = new HikariConfig();
        config.setMaximumPoolSize(20);
        config.setConnectionTimeout(300000);
        config.setConnectionTimeout(120000);
        config.setLeakDetectionThreshold(300000);