Just received PostgresDB shared memory problem "No space left on device"
jimin-genie
PROOP

2 years ago

The actual error message was

could not resize shared memory segment "/PostgreSQL.502371020" to 4194304 bytes: No space left on device

Looking at the charts, it did hit the max 3 GB at one point. Is there a way to increase the size?

13 Replies

jimin-genie
PROOP

2 years ago

3747f720-8c9c-4d81-9b13-1e420ceabd6c


passos
MODERATOR

2 years ago

You can increase it by upgrading to the Pro plan


jimin-genie
PROOP

2 years ago

Yes and my company is already paying for the Pro plan. So how do I upgrade it?


jimin-genie
PROOP

2 years ago

Hmm this error seems to be related to PostgresDB Service's docker container shm_size limit issue. I wonder what the default value of that is as I didn't add any environment variable to that service. As the error message suggests, we went over like 4MB.


passos
MODERATOR

2 years ago

Hmm this error seems to be related to PostgresDB Service's docker container shm_size limit issue. I wonder what the default value of that is as I didn't add any environment variable to that service. As the error message suggests, we went over like 4MB.

damn i need some sleep, i read "storage" in your screenshot for some reason.
unfortunately Railway doesnt support docker cli flags so changing the shm_size is not supported on Railway.


brody
EMPLOYEE

2 years ago

you are on the Pro plan, so you can indeed increase the shm size.

for context the default shim size is 64MB.

set a service variable RAILWAY_SHM_SIZE_BYTES to 134217728 to increase the shared memory to 128MB


brody
EMPLOYEE

2 years ago

@Kurdiez @ThallesComH for visibility


passos
MODERATOR

2 years ago

oh didnt know Railway included that variable


brody
EMPLOYEE

2 years ago

neither did i, until they told me


brody
EMPLOYEE

2 years ago

but even though you both are Pro, its best to be conservative with the value


passos
MODERATOR

2 years ago

well they should document it


brody
EMPLOYEE

2 years ago

we talked about this, and we think its best to keep it on the down low for now


brody
EMPLOYEE

2 years ago

you are welcome to dm me if you want to know why


Loading...