-
Is this your first time deploying Airbyte?: No (nearly my first)
-
OS Version / Instance: Docker compose on MacOS (amd64)
-
Memory / Disk: you can use something like 4Gb / 1 Tb
-
Deployment: Docker (Compose)
-
Airbyte Version: 0.36.8-alpha
-
Source name/version: Postgres/0.4.12
-
Destination name/version: Postgres/0.3.19
-
Step:
Sync fails during the normalization phase withSSL SYSCALL error: EOF detected
. -
Description:
This is a timeout related to network connection resets on idles connections in an AWS RDS environment. The resolution is TCP keepalive. This is typically configured client-side. I see no option in the UI, how can I provide the JDBC connection URL option in an Airbyte destination?
[EDIT: I just realized that the error I’m getting is coming from dbt
(“normalization phase”, derp!), hence Python, not from JDBC. So, same question, but now it’s about modifying the dbt
connection options for TCP keepalive.]