I am using a Postgres database. I have configured it to support multi-tenancy with a different schema for each tenant. Overnight, my Spring Boot application runs several processes in parallel (around ...

I’m facing an issue where INSERT queries on a MySQL table get stuck in “waiting for lock”, and even after innodb_lock_wait_timeout (50s), the connections are not released back to HikariCP, eventually ...

We have configured Hikari with a maximum of 24 connections. However, in our Oracle DB we are observing more than 100 active connections per pod. Our setup is Spring Boot with Kafka (Confluent) using a ...

I’m trying to stream a large query result from Oracle using Spring Boot and JdbcTemplate, but the connection breaks when processing big rows containing concatenated strings and CLOBs. The query works ...

I have to increase the DB connection pool limit for my DB (Aurora) and I want to set my maximumPoolSize for Hikari to be higher than the default value (default = 10) but the maximumPoolSize still does ...

Our large legacy Spring Boot app has several "main" modules which are built into running services (such as API Tomcat servers, and Kafka feed consumers). Each of them requires 7 database ...

I am using a HikariCP with a SpringBoot application to run queries on Snowflake. I have configured the pool to have 20 connections. Does context carry over between two connections? For example, if I ...

I have a Spring Boot application that connects to an Amazon Aurora MySQL-compatible database. The setup uses the MariaDB JDBC driver, the AWS JDBC wrapper, and HikariCP for connection pooling. My code ...

I'm using Spring Boot with HikariCP as my connection pool, and recently I’ve been getting this error: HikariPool-1 - Connection is not available, request timed out after 30001ms (total=10, active=10, ...

When a timeout occurs in the database, HikariCP does not rollback, but commits and terminates abnormally. @Transactional(rollbackFor = Exception.class) method{ 1.delete table11 2.delete tablel2 -\...

java.lang.Exception: Apparent connection leak detected at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-5.0.1.jar:na] at org.hibernate.engine.jdbc....

I'm using a Spring Boot application that connects to two MariaDB databases. When I run the app, I notice that there are about 10 connections per database shown in the SHOW PROCESSLIST; output — all in ...

When i am running the code on uat or locally did not facing this issue but this issue occurred on production. I have performed load test as well but never getting the mentioned issue. Application is ...

I just switched from AWS RDS MySQL Writer instance to a Reader instance. Now, I am getting below exception: 2025-03-28 05:33:56.412 trace_id= span_id= trace_flags= INFO 1 --- [ main] com....

I have some questions about how HikariCP’s maxLifetime configuration interacts with PostgreSQL’s idle_in_transaction_session_timeout. From my understanding: maxLifetime determines how long a ...