My database and authentication table has been down intermittently throughout the day.
My database and authentication table has been down intermittently throughout the day.
why is this happening? im not seeing as exceeding limits.
23 Replies
im also well within limits for the compute
Is this just the dashboard?
Any errors in the logs?
only timeout errors in the logs
Not seeing anyone else reporting it.
Have you tried a different device?
Does it impact your app?
it says i am about to deplete my disk i/o budget but i seem to be consuming only a little bit disk i/o
OK that is not good.
yes i tried multiple devices, my auth table and database tables doesnt load at all
it's working now, but this is the 2nd time today this happened. and i have pro plan with upgraded micro compute
If you can't find a query causing it ( check query reports for long running queries) or your API gateway is not showing a large number of hits the support would be the contact to get someone to look at it.
Without others reporting seems related to your instance having an issue or application load.
Without others reporting seems related to your instance having an issue or application load.
yes i reported to support
it took down my whole db and my system was down for several hours, and unable to do any work
I gave you two suggestions for something to look for heavy load. I don't have any other suggestions for anything you can look at. But user exceeding IO comes up here rarely so not something I've seen other users come back with useful info... that I can remember.
i do have some slower queries
could having some slow queries bring down my whole db?
If they use up disk io budget or resource. What time period is that over?
Not very many calls and not really that long of queries.
this is under query performance tab, it seems like the "contact_leads" table is troublesome
it doesnt state specific time period, i think it's overall
Yeah it would be from when it was last reset.
I'm skeptical that few calls and average 3 seconds would even bother a Free instance.
You only have made 1300 queries total?
i think 1300 queries total since my last reset? i upgraded my db from nano to micro and it reset my whole db. i thought it would solve the disk io budget issue and the downed DB, but i still had an issue
When did you upgrade? Even if that was a few hours still not a whole lot.
Here is the guide on it, if you had not seen that: https://supabase.com/docs/guides/troubleshooting/exhaust-disk-io
Supabase Docs | Troubleshooting | High Disk I/O
Supabase is the Postgres development platform providing all the backend features you need to build a product.
i upgraded about 7 hours ago. and since then, my db has gone down (but is up now). still trying to figure out why it went down, and im super scared of it going down again
I've got nothing else. You might add IO budget being exceeding in case another user looks at first post. Your current first posts look more like a generic dashboard issue versus IO limits being hit for some reason.
ok im waiting for a response from support, hopefully i hear back soon
thank you @garyaustin