Type: Incident report
Resolution: Won't fix
Affects Version/s: 2.4.5
Fix Version/s: None
Component/s: Server (S)
For some time my company is using zabbix. We have a few hundred servers that we monitor with zabbix with a postgresql database. The database is ~50 GB.
The problem is happening when zabbix server is restarted for some reason and some cache from zabbix have to be flushed to the database. I see active queries in the database similar to this:
When this happens, on the postgresql server (which is different server) the full amount of RAM + swap starts to be taken until the whole memory is full and the queries crashes with "out of memory" error.
After a while (~10-20min) all queries like this are over and the server load is back to normal.
The problem is that the updates them-self are not so consuming at all, and I have no idea why it is consuming so much memory. Also in the other time the server is not loaded at all for weeks.
I am attaching my server conf