_k1ngarthur

This is a user forum so we can't access your project. You can try going into observability and creating custom reports for the egress in each service

I mean you definitely should have RLS anyway , what are these bots even doing and how many are there? Are they overloading your users table

Ahh okay, infra/support has been quite busy recently due to https://status.supabase.com/ so tickets are taking longer than usual. If it has been placed for them then nothing more to suggest but waiting

What is your ticket number, i can try place you in an informal queue so that at least your ticket gets to infra. You'll still be behind pro and other free users

When branches open they use those migration files as a reference for recreating the Database

Yeah your migration history is probably messed up so you would need to baseline it, i would reccomend going into https://supabase.com/dashboard/project/_/editor/26291?schema=supabase_migrations and seeing what migrations you have in there? I would imagine you have no migration files or an empty migration?

so that might cover you on Data residency

I don't think you will find answers to this on Discord, maybe check out https://supabase.com/legal, https://supabase.com/legal/dpa and email support to see if they can redirect you to the right place. They do have india (mumbai) as a place you can store your data.

The best way for the database is Point In Time Recovery which supabase has which allows recovering a database to pretty much an exact moment in time. Anything less than that is going to be what duration of usage you are happy to not have on recovery from a backup. I would probably do at least a daily backup to be in line with standard Supabase and then increasingly shorter intervals if the application requires it (i.e fintech, HealthTech)

This thread suggests it is harmless https://discord.com/channels/839993398554656828/1519323429390647356 but you would have to reach out to support to get it fixed

Yeah those ones but it is not providing much info, maybe follow Silentworks suggestion and look for a UseEffect hook somewhere

I don't think the CLI has a command like what you are looking for. Could create a script to do it for you? I think `supabase db dump -s storage` is what you would want and then fetch all the lines that have a policy

If you check your auth logs can you open up the metadata to see where requests are coming from?

so you might have to file a support ticket

Any idea about the size of your database? There have been a few issues recently with projects getting stuck

after submitting your support ticket

Did you get a reply from support saying you will be raised to infra queue?

Did you get this resolved in the end?

Yeah something like that could definitely cause your instance to be unresponsive so i'd be careful about such operations

That is good news, i am going to share this doc https://supabase.com/docs/guides/troubleshooting/exhaust-disk-io which i think is what was causing your issue. Perhaps high memory or lots of requests but there is a chance that the issue may return if it happens again so feel free to consult that doc, it also has some remediations at the bottom

You should have the graph i pointed you to, in my one it is a few above the one that you shared

Are you in here https://supabase.com/dashboard/project/_/observability/database

do you have this graph under observability -> database

What do you logs say for errors https://supabase.com/dashboard/project/_/logs

There might be some things that are only done manually but hopefully that is a one time thing you might only occasionally change

Okay and what about https://supabase.com/dashboard/org/_/usage

So for 1, all projects in the pro organisation are billed as pro so each additional project you add will encur a cost. For 2, honestly the best approach that i have seen even though it's a bit tedious is having the satging environment be like a "reference environment" which duplicates your main project in most things and when it comes to RLS, Database Schema even other configurations using the `config.toml` you should be able to create a set of local files schemas/configthat you can push to each project from the CLI to keep configuration in sync

I'm not sure if that will help if you are exhausting resources due to high usage, you might just end up in the same position again

What do you see in this page https://supabase.com/dashboard/org/ypzclqyjloxzimzowgrx/usage and https://supabase.com/dashboard/project/_/observability/database

I assume the "unhealthy" in the dashboard home is because of your database

That doesn't look like data deleted, it looks like your database is not responding due to exhausting resourcs.

Could you provide more details about your data seemingly deleted, also you have status unhealthy, what is that showing?

Yeah i think that is not enough time, support has been very busy as of late and also the weekened is usually much slower, give it a few more days (which i appreciate isn't ideal if you are locked out of your account)

When did you email?

or emailing support@supabase.com

Hey there, this is a community forum so for issues like this which require access to your account this is not the best place, you would be better off filing a support ticket

but reach out to support@supabase.co anyhow

Hey there, you should reach out to support, it's worth mentioning that Support have told us in the past yhat there is no real way to recover from mfa lockout

You have already opened a thread, there is no need to post in multiple places

okay

or does it stop after a few minutes

By the way how many log entries do you have and does it carry on after it starts?

https://supabase.com/dashboard/support/new

By the way <@1116322643327602740> i think this is harmless and shouldn't be an issue during development.

I think file a support ticket if you haven't already. this looks like the type of operation only they can solve

When did you email support?

You too! maybe file a support ticket also but they are quite busy

Yeah leave it open, i (or someone else) can try and respond back with what the issue ended up being

I was able to reproduce it for eu-central-1 and flagged to someone on the team

I haven't checked recently but i don't this it has been an issue there