Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Available connections in HikariPool occassionaly drop to zero #2187

Open
pxy0601 opened this issue Mar 7, 2024 · 0 comments
Open

Available connections in HikariPool occassionaly drop to zero #2187

pxy0601 opened this issue Mar 7, 2024 · 0 comments

Comments

@pxy0601
Copy link

pxy0601 commented Mar 7, 2024

environment

hikari: 4.0.3
java: jdk1.8
database: mariadb 5.7.27-1-log
hibernate-core: 5.4.32.Final

hikari config

spring.datasource.driverClassName=org.mariadb.jdbc.Driver
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=HikariCP
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.connection-test-query=SELECT 1

mariadb config

wait_timeout=28800s
interactive_time=28800s

logs:

total=5, active=1, idle=4, waiting=0
total=4, active=1, idle=3, waiting=0
total=4, active=1, idle=3, waiting=0
total=3, active=1, idle=2, waiting=0
total=2, active=1, idle=1, waiting=0
total=1, active=1, idle=0, waiting=0
total=0, active=0, idle=0, waiting=0
total=0, active=0, idle=0, waiting=0
total=0, active=0, idle=0, waiting=0
total=5, active=0, idle=5, waiting=0

exception:

 [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [ERROR] - [HikariCP - Connection is not available, request timed out after 30711ms.]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant