System stuck in a loop trying to recover but can’t because no space.
There are tables I could drop to give the space but I can connect to do that.
Hi,
You can try drop some logs or not needed files from the filesystem which can give you some free space. Then you can:
- clean up not needed tables
- or increase the partition size
- or move the database to another server with more space
I got lucky and identified a large table in a different database that wasn’t being used. I moved the datafiles and that gave enough space for recovery to complete.
I am now running vacuum full which has freed up a lot of space.