by abaldiotti
Hey folks, has anyone run into this issue with Supabase?
Our database is currently unreachable. Any SQL query (even DELETE or TRUNCATE) fails with:
“Connection terminated due to connection timeout”
What happened
Our Realtime Messages quota exceeded ~980%
This was caused by an unintended postgres_changes subscription on a high-volume table (whatsapp_messages)
We’ve already removed all Realtime subscriptions from the code, so the root cause is fixed
Current problem
Even after fixing the code, we can’t run any queries to clean up the table or stabilize the database — every connection times out.
Questions
Is there a way to reset or unblock the database connection?
Can the Realtime quota be manually cleared or reset once the code issue is resolved?
Has anyone fixed this without recreating the project?
Any help or pointers would be hugely appreciated 🙏 Thanks!
The user is experiencing a database connection timeout after exceeding the Realtime Messages quota due to a high-volume table subscription. Despite removing the subscriptions, they are unable to execute any SQL queries to stabilize the database. They seek advice on resetting or unblocking the database connection and clearing the Realtime quota without recreating the project.