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.
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?