Database crashed
petern1011
PROOP

10 days 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:

  1. PostgreSQL starts and successfully replays WAL (redo done at 0/3DFFFF28)

  2. Fails when trying to write checkpoint: FATAL: could not write to file "pg_wal/xlogtemp.30": No space left on device

  3. 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!!

Solved

1 Replies

sam-a
EMPLOYEE

10 days 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 10 days ago


Status changed to Solved sam-a 10 days ago


Loading...