Database crashed
petern1011
PROOP
4 months ago
Our PostgreSQL database ran out of disk space during a bulk UPDATE operation (updating ~2,700 rows with JSONB data). The database crashed mid-checkpoint and is now stuck in a crash-recovery loop:
- PostgreSQL starts and successfully replays WAL (
redo done at 0/3DFFFF28) - Fails when trying to write checkpoint:
FATAL: could not write to file "pg_wal/xlogtemp.30": No space left on device - Shuts down and restarts, repeating the cycle
We increased the volume size via the Railway dashboard, but the change doesn't seem to be taking effect - still getting "No space left on device" after redeploy.
Solutions greatly appreciated!!
1 Replies
sam-a
EMPLOYEE
4 months ago
Hi - we are already addressing your volume resize issue in the private thread you created. I will close this thread.
Status changed to Awaiting User Response Railway • 4 months ago
Status changed to Solved sam-a • 4 months ago