Postgresql OOM Errors?

Support
1

It seems that about every 30 minutes or so I am getting this error:

ActiveRecord::ConnectionNotEstablished : connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: FATAL: the database system is in recovery mode

I have found it corresponds to dips in memory and the postgresql logs suggest an OOM error.

image
image1588×446 32.9 KB

free -h

total used free shared buff/cache available
Mem: 7.8Gi 4.0Gi 142Mi 3.4Gi 3.7Gi 156Mi
Swap: 2.0Gi 1.4Gi 659Mi

But I am having a difficult time trying to pinpoint where the memory is going.
I have the following setup: 8 GB Memory / 4 AMD vCPUs / 160 GB Disk

I did recently DOWNGRADE this from a beefier machine, which could be the issue. But I have updated my app.yml and rebuilt Discourse since then so I don’t know where the problem would be coming from.

app.yml:

UNICORN_WORKERS: 4
UNICORN_SIDEKIQ_MAX_RSS: 1000

Any advice?

2

Annnnd while writing this I think I found the issue

I needed to adjust this in my app.yml from 4GB to 2GB

db_shared_buffers: “2048MB”

I’ll check back in about 30 mins to see if it works. And I’ll keep the topic up in case others come across the same issue in the future.

1 Like
3

It looks like the issue may be persisting. But I only did a ./launcher restart app. Does this change require a full rebuild?