Postgres service is showing the volume as full

gmonie22

HOBBYOP

3 months ago

Hi team,

I need help with my project. My Postgres service is showing the volume as full and my Worker service keeps failing deployments due to Out of Memory errors. Nothing has been changed in over five months, so I am not sure what is causing the sudden failures.

Could you please check what is filling the Postgres volume and advise how to safely clear or expand it?

Also, can you confirm why the Worker is running out of memory and what allocation or configuration changes you recommend?

Project ID: fcd516d8

Environment: production

Thanks in advance for your help.

$10 Bounty

5 Replies

Railway

BOT

3 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

ray-chen

EMPLOYEE

3 months ago

If your Postgres volume is full, you'll have to increase its size.

I'm pushing this to our community so they can help you with the worker memory issue as that is application-specific.

Status changed to Awaiting User Response Railway • 3 months ago

gmonie22

HOBBYOP

3 months ago

I don't know what is causing the volume to 100% because I haven't touched it in 5 months and im not familiar with the setup. Ideally, I'd like to clean the volume and pause any ongoing executable tasks in the workflows since they should not have ever been turned on outside of testing the workflow about 5 months ago...

Thanks in advance for your continued help with this

uxuz

MODERATOR

3 months ago

Hey, please check your Postgres volume and grow it. You should be able to grow your volume to 5GB on the hobby plan. You will have to upgrade to the pro plan if you need more than 5GB.

Attachments

image.png

gmonie22

I don't know what is causing the volume to 100% because I haven't touched it in 5 months and im not familiar with the setup. Ideally, I'd like to clean the volume and pause any ongoing executable tasks in the workflows since they should not have ever been turned on outside of testing the workflow about 5 months ago...Thanks in advance for your continued help with this

mykal

PRO

3 months ago

I'd try SSHing into the PostgreSQL service and poking around in the volume mount.

I've seen a few issues with WAL archives exhibiting unbounded growth (basically they just grow forever).

If you find a bunch of big WAL files in there you should be able to flush them.