You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Riju Trivedi (Jira)" <ji...@apache.org> on 2026/03/18 17:26:00 UTC
[jira] [Created] (HIVE-29513) Increase HikariCP connection timeout default from 30s to 60s
Riju Trivedi created HIVE-29513:
-----------------------------------
Summary: Increase HikariCP connection timeout default from 30s to 60s
Key: HIVE-29513
URL: https://issues.apache.org/jira/browse/HIVE-29513
Project: Hive
Issue Type: Improvement
Components: Metastore
Affects Versions: 4.2.0
Reporter: Riju Trivedi
Assignee: Riju Trivedi
When the Metastore experiences high load or temporary spikes in database connection demand, HMS client requests fail with connection timeout errors.
The current default connection timeout of 30 seconds is insufficient for scenarios where:
* The connection pool is exhausted due to temporary load spikes
* Database response times are elevated
{code:java}
MetaException(message:HikariPool-1 - Connection is not available, request timed out after 30000ms.)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:602)
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:195){code}
To have enough tolerance on temporary surges on HMS side we should increase the timeout to 60 seconds.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)