Storage Size limit problem
I've reached the quota of the storage on free tier. I cleared up the storage bucket and its empty, but it still shows 1,37/1 GB for 24hrs already. This leads to restriction of services. How and when would the quota update and show that the bucket is actually empty now and withing the quota?
8 Replies
It may be worth waiting for a couple more hours for the quota to refresh. Also check if their any hidden storage objects by running:
select * from storage.objectsHow did you clear up the bucket? You have to use the UI or API and not do SQL to delete from storage.objects.
Well since the storage bucket was not even loading during the restrictions and the API was restricted as well, I used SQL to delete the files in the bucket...
If you directly deleted from storage.objects with sql then that file data is now orphaned in s3 taking up space and you can't remove it.
You will need to contact support and see if they get clear those orphaned files out of s3.
Actually I found easier solution... After the SQL deletion, i moved the project to another organization and it showed up properly and started working fine
Interesting. Not sure I've seen that tried before. Sort of assumed the s3 "bucket" would move with the project.
Yeah, it moved up created but empty as supposed to after the sql deletion, so it was a cool and easy workaround. Thanks for you help anyway!
Make sure you check your sizes in 24 hours or so in case it is is just a reporting delay.