I use postgres.js (latest version 3.4.4
I use postgres.js (latest version 3.4.4), hyperdrive and supabase. Every now and then a query fails due to
CONNECTION_CLOSED Disabling the hyperdrive cache didn't help and I can't find any open issue on that topic in the postgres.js repo. Am I the only one?5 Replies
Are you connecting via the supabase connection pooler as well?
yes, just double checked:
aws-0-eu-central-1.pooler.supabase.com That's the one I'm connected to via hyperdrive
aws-0-eu-central-1.pooler.supabase.com That's the one I'm connected to via hyperdrive
Do you experience the same issues when connecting without the supabase pooler?
I'm also using the supabase connection pooler and seeing a few errors but I don't have much context on the errors. I just see a 500 on the logs.
How can I get more context on the errors reported here ? 🙏
I'll try it without the pooler, thanks. I haven't had a "CONNECTION_CLOSED" in the last 20 hours (since I deactivated the cache). The queries still fail, but without any specific error. Could be a supabase issue and related to https://github.com/supabase/supavisor/issues/344
@Huxwell | WalletConnect I use the baselime integration for backend logging. It's easy to setup and they're part of cloudflare now, so a good bet in my opinion.
@thomasgauvin haven't had a single error since I switched to direct connection, with and without the hyperdrive cache. So I guess it's a supabase problem. Just sent them a support ticket. Thanks for the help/direction! 🙏