springboot报错Connection is not available, request timed out after 30001ms.

Question

这个报错我看网上没有明确的答案啊
环境springboot2.0 jdk1.8 数据库连接spring.datasource

Answer 1

这个异常不会经常出现 只需要在配置文件里面添加相应的配置就可以
spring.datasource.hikari.read-only=false
spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.idle-timeout=60000
spring.datasource.hikari.validation-timeout=3000
spring.datasource.hikari.max-lifetime=60000
spring.datasource.hikari.login-timeout=5
spring.datasource.hikari.maximum-pool-size=60
spring.datasource.hikari.minimum-idle=10