1. 问题背景

数据批量入库时，报错：HikariPool-1 - Connection is not available, request timed out after 30040ms.

2. 问题处理

yml配置文件中加入hikari配置：

datasource:driver-class-name: org.postgresql.Driverurl: jdbc:postgresql://ip:port/dbNameusername: aaapassword: bbbhikari:connection-timeout: 60000maximum-pool-size: 500max-lifetime: 180000minimum-idle: 20validation-timeout: 3000idle-timeout: 30000