Summary
The user is facing issues with a Postgres to Snowflake connection in Airbyte open source edition. The connection fails after running for a while, and the Postgres connection disappears from Airbyte. When trying to reconfigure, strange errors occur. The user has resorted to creating a new EC2 host in Amazon to start over, but the issue persists.
Question
Hi Community - I’m working with Airbyte open source edition. I’m able to create a Postgres to Snowflake connection for CDC. However, it fails after running for quite a while, and then my Postgres connection ‘disappears’ from Airbyte. When i try to go back in to reconfigure it, i get strange errors when trying to save / test the connection. So far, the only way I’ve been able to ‘start over’ has been to create a completely new EC2 host in Amazon. Even in doing that, once I get the connection up and running again it ultimately fails/disappears/can’t be re-created. Anybody else dealing with this?
{}```
```{
"url": "<http://localhost:8000/workspaces/967a19f3-0095-4d19-9946-5c6547109ca8/source/new-source/decd338e-5647-4c0b-adf4-da0e75f5a750>",
"airbyteVersion": "0.58.1",
"errorType": "TypeError",
"errorConstructor": "TypeError",
"error": {},
"stacktrace": "TypeError: Cannot read properties of undefined (reading 'toLowerCase')\n at Kze (<http://localhost:8000/assets/WorkspaceAccessManagementSection-d0GDnGG6.js:109:79733>)\n at renderFooter (<http://localhost:8000/assets/ConnectorCard-XMp7MsQ7.js:1:8249>)\n at Hy (<http://localhost:8000/assets/ConnectorForm-2BVuUdXj.js:6:256302>)\n at ec (<http://localhost:8000/assets/index-WZJAPYia.js:38:19519>)\n at es (<http://localhost:8000/assets/index-WZJAPYia.js:40:3139>)\n at nh (<http://localhost:8000/assets/index-WZJAPYia.js:40:44737>)\n at Jv (<http://localhost:8000/assets/index-WZJAPYia.js:40:39727>)\n at k_ (<http://localhost:8000/assets/index-WZJAPYia.js:40:39655>)\n at Ya (<http://localhost:8000/assets/index-WZJAPYia.js:40:39508>)\n at fs (<http://localhost:8000/assets/index-WZJAPYia.js:40:35875>)",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
"featureFlags": {}
}```
<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/p1715359078578399) if you want to access the original thread.
[Join the conversation on Slack](https://slack.airbyte.com)
<sub>
["postgres", "snowflake", "cdc", "connection-issue", "error", "airbyte-open-source", "ec2", "amazon"]
</sub>