https://supabase.com/ logo
Join Discord
Powered by
Hi, all my data has disappeared and there is a 503...
# off-topic
a
Hi, all my data has disappeared and there is a 503 error please help !
a
Hi, all my data has disappeared and there is a 503 error please help !
a
wait what ? disappeared ?
e
send your project details to beta@supabase.io
a
done
a 403 error (not 503)
e
oh a 403..that may not be a server issue then..that is saying you aren't authorised
a
403 Internal error from Supabase
a
my supabase space tells me there is more table, as a blank project
e
the data has not disappeared..you probably cant acccess it via the credentials you gave
can you pass me the exact API request / client code you are running? And which API key are you using - the anon key or the service key?
a
« error loading data unexpected token s in JSON at position 0 »
from app.supabase.io when entering my project
e
which page? can you send your project ref?
a
I think he meant this error
e
it is hard to debug when there isn't full information on the issue. Please provide details so that we can get down to the issue faster
Ah so this is when provisioning a new project?
a
It was in one of my old project before Supabase's second launch week
a
i’ve sent an email with the url
(complicated from my mobile)
and a print screen is uploading
a
Probably caused by the migration tools
e
Just saw your email..so this is when you are restoring a project I see..yup there was a bug which we fixed a few hours ago..will get deployed in another 8 hours so
in the meantime, I will ask my team members to manually restore your project
a
my project had already been restored last week and it was working ok
ok thanks 🙏
e
oh it was already restored..hmm then this is a different issue..chekcing your project
hmm i dont see anything wrong with your project @User
a
the history is : 1) last monday i found my project at « paused » status. I clicked « restore » 2) but after one day it was still « restoring » so i sent you an email 3) on wednesday your team fixed the restoration issue 4) wednesday evening it was ok and i could use it normally 5) the another issue occurred, don’t know what, and now there is no more data at all in my Supabase project
the problem is that there is no more data in my project !
e
can you see the tables in your table editor? our UI has changed recently..so you dont see your tables now when you land in the project
a
in the « table editor » there is no table
only a « create new table » button
and in the settings / database storage, 0.0MB !! as if there were no data anymore
so your system deleted my table
e
hmm did you run a recent migration or anything that might have caused this? It is highly unlikely that this was caused by a Supabase bug since we don't directly access your database except for upgrades and those are automated systems..I will still investigate though
a
no migration, nothing at all
on my first connection today on app.supabase.io i got a message in red saying that there was an issue with my data
i did not record the message
s
@User I think @User is investigating the issue at the moment, give it some time and I'm sure he will get back to you
a
ok if easier for you, you can restore my project at the same state as when it was paused - i’ll manage the gap
e
yup, we have internal backups till July 5, 2021, 07:10:03 (UTC+08:00)..so we can restore to any day during that period
do you know when this data disappeared? cos our daily backups show that the database has been empty since July 29, 2021, 13:08:00 (UTC+08:00)
the last backup before that seems to be on July 15, 2021, 19:23:01 (UTC+08:00) which has the data and I guess the project was paused then
there was a bug with our restore system which we patched a few hours ago..so if the database was empty since 29th July (right after the restore) that makes sense to me..but if the data appeared in the dashboard and disappeared after that, then this warrants more of an investigation cos that should never happen since none of our systems actively deletes data from an existing active project
a
after restoration last week i did update the data and it was ok during the following hours - i don’t remember exactly when but is was probably on 28 and 29th
and i’m absolutely sure i dis not wipe the data as my JS client app has no such http method implemented
well ok please restore the last dataset you have
but we need to understand what did happen exactly !
e
I just took a look and all schemas appear to be empty, i will start an internal investigation for this to see if we can track what happened
I have asked my team mate to restore the db, he will do it soon and get in touch with you
a
ok - the final explanation is important for confidence in supabase : the data is very important to me, and this issue must definitely not happen again
i’ve lost last week updates, that is enough
anyway thanks for your help
e
there is a shared responsibility model here Air16..for example, if your postgres password or service key is exposed, your database can be hacked too..but if this happened because of the security of our systems, that is something that we take very seriously..I have already alerted the core team members and we are doing an investigation into how this happened. Really sorry this happened and thank you for your patience. I will update you once we have more details.
Do you remember if you turned on row level security for your tables Air16?
a
i don’t remember, but i don’t think so as i’m the only user
and it is my first time with Postgresql, coming from Mysql world
e
I see your anon key is publicly exposed on your website and without row level security, any user with the anon key can delete your tables
I think this might be the reason, but give me some more time, I will do a full investigation and get back to you
a
in the log, do you see any http request for table deletion ?
anyway thanks for the information i’ll manage this
(actually the data has no value for anybody else than me)
Hi, do you know when the data will be restored ? thanks
PreviousNext
Powered by