Postgres volume FATAL: could not write to file pg_wal/xlogtemp.30: No space left on device.
quantintellect
PROOP

19 days ago

My Postgres volume (postgres-volume, ID: a075837d-829d-4e06-84b6-0fb00027d64d) was at ~460MB/500MB when a large DELETE operation generated WAL files that filled the remaining space. Postgres crashed and cannot recover.                        

I resized the volume from 500MB to 5GB via the dashboard, and redeployed multiple times, but Postgres still fails with the same error:                                                                                                                                    

FATAL: could not write to file "pg_wal/xlogtemp.30": No space left on device     railway volume list shows 460MB/5000MB (5GB allocated, only 460MB used), so there should be plenty of free space. It appears the ext4 filesystem inside the volume was not expanded to match the new 5GB block device size.

I also tried detaching and reattaching the volume, then redeploying — same result.

  Project: polycopy-backend

  Environment: production

  Volume ID: a075837d-829d-4e06-84b6-0fb00027d64d

  Service: Postgres (ghcr.io/railwayapp-templates/postgres-ssl:17.7)

  Region: europe-west4-drams3a

Could you please run resize2fs (or equivalent) on the volume's block device so the filesystem expands to the full 5GB? This is blocking all database operations.

Solved

3 Replies

19 days ago

Hey. Does a redeploy work?


Status changed to Awaiting User Response Railway 19 days ago


ray-chen

Hey. Does a redeploy work?

quantintellect
PROOP

16 days ago

Hi

No a redeploy doesn’t change the volume and once again my database crashed because the resize didn’t happen at all I don’t actually know how can I resize as nothing changes it says resized but nothing resizes !!


Status changed to Awaiting Railway Response Railway 16 days ago


16 days ago

We've expanded the volume filesystem, and your database is back online.

Going forward, please keep an eye on disk usage and resize before hitting the volume limit.


Status changed to Awaiting User Response Railway 16 days ago


Status changed to Solved jake 7 days ago


Loading...