Troubleshooting PostgreSQL database connection problem during Airbyte installation on Kubernetes
Help with PostgreSQL database connection issue during Airbyte installation on Kubernetes
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Hello everyone, I’m encountering an issue while trying to install Airbyte on Kubernetes using Helm. The error occurs during the PostgreSQL database availability check, and HikariPool is failing to obtain a connection from the database. Below is a snippet of the error log:
ERROR i.a.d.c.DatabaseAvailabilityCheck(lambda$IsDatabaseConnected$1):78 - Failed to verify database connection.
org.jooq.exception.DataAccessException: Error getting connection from data source HikariDataSource (HikariPool-1)
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms```
I’ve already checked the database status and network configurations, and everything seems to be in order. I’m using the following Helm command for installation:
```bash```
```helm upgrade --install airbyte airbyte/airbyte -f values.yaml -f secrets.yaml --version 1.1.0 --namespace airbyte --debug --timeout 900s```
Has anyone encountered this issue before or have any suggestions on how to resolve it? Any help would be greatly appreciated!
Thank you in advance!Hi <@U07KAKAH70Q>
I’m actually using GCP - GKE for this setup. I’ve attached the values.yaml file here for you to take a look at.
Hi <@U07BB9G9CVC> i think the airbyte-bootloader pod is not connecting to database, can you share your yaml files with duplicates values so that i can go through that once.
https://github.com/nikhilnicky1/Airbyte-kubernetes-helm.git
you can follow this guide if you are using AWS - EKS - RDS - S3