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:

  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

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


Welcome!

Sign in to your Railway account to join the conversation.

Loading...