Error installing abctl on EC2 instance with external RDS Airbyte v.1.1

Slack Knowledge Base Q&A Platform Questions
, , , ,
1

Summary

Failed to verify database connection while installing abctl on an EC2 instance with an external RDS. Errors include SQLTransientConnectionException, UnknownHostException, and connection timeout.


Question

abctl install on a ec2 instance with external rds airbyte v.1.1:

  ERROR   airbyte-bootloader: org.jooq.exception.DataAccessException: Error getting connection from data source HikariDataSource (HikariPool-1)
  ERROR   airbyte-bootloader: Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms (total=0, active=0, idle=0, waiting=1)
  ERROR   airbyte-bootloader: Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
  ERROR   airbyte-bootloader: Caused by: java.net.UnknownHostException: database-host
  ERROR   airbyte-bootloader: i.m.m.h.i.HealthResult$Builder(exception):123 - Health indicator [database-host:5432/airbyte] reported exception: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms (total=0, active=0, idle=0, waiting=1)```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1729909837930939) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["abctl", "ec2-instance", "external-rds", "airbyte-v1.1", "database-connection-error"]
</sub>
2

Caused by: java.net.UnknownHostException: database-host

it looks like dns resolution issue
how can airbyte-bootloader know about database-host?
I’m not sure if it’s redacted value or not

3

in the values.yaml and the secrets.yaml I have the database host written out, not using a variable; and I’m able to psql to the host from the ec2 instance without issue. Is there somewhere else where the host is passed?

4

my guess is something wrong with values.yaml
please provide content of the file with redacted sensitive values

5

commenting out secretsmanager fixed it - still trying to figure out the configuration to inherit permissions using the role from ec2

6

check this thread https://airbytehq.slack.com/archives/C021JANJ6TY/p1728082396338529?thread_ts=1727868326.601819&amp;cid=C021JANJ6TY
Mark found a solution for it