Error with ListOpenWorkflowExecutions operation on Airbyte deployed on GKE with self-deployed Postgres

Summary

Error message ‘ListOpenWorkflowExecutions operation failed. Select failed: pq: unnamed prepared statement does not exist’ when using self-deployed Postgres on Airbyte deployed on GKE. Issue persists even after providing the URL of Postgres instead of pg_bouncer. How to resolve?


Question

Hi, I have deployed Airbyte on GKE with self-deployed Postgres instead of using Postgres of Airbyte. I am getting the following error frequently-
ListOpenWorkflowExecutions operation failed. Select failed: pq: unnamed prepared statement does not exist
I have tried giving airbyte, URL of postgres instead of pg_bouncer and still getting the same issue. How can I resolve this?



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.

Join the conversation on Slack

["error", "listopenworkflowexecutions", "airbyte", "gke", "self-deployed-postgres", "pq-unnamed-prepared-statement"]