supabase / supavisor

A cloud-native, multi-tenant Postgres connection pooler.

https://supabase.github.io/supavisor/

Apache License 2.0

1.66k stars 55 forks source link

LISTEN / NOTIFY appears to be broken after March 26th #332

Open Dkendal opened 3 months ago

Dkendal commented 3 months ago

Bug report

LISTEN / NOTIFY appears to be broken after March 26th

[x] I confirm this is a bug with Supabase, not with my own application.
[x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

We have an Elixir application that uses Oban for job processing that connects to a supabase postgresql instance via transaction pooling.

Oban makes extensive use of LISTEN/NOTIFY, which has been working without issue for 2 months.

As of March 26th all most listen/notify requests started to fail.

w3b6x9 commented 1 month ago

@Dkendal and you've been using session mode correct?