Hello everyone.
I've got Zabbix 6.2.2 on docker with postgresql 13.8-alpine (earlier zabbix 6.0.4) and this setup was working well for quite some time.
Recently I discovered that postgres container consumes everything.
I logged into database and found query which consumes -
"select distinct itemid from trends_uint where clock>=1662364800 and itemid in (29180,38420,38961,38964,38974,38975,38976,38977,3 8978,38979,39920,39980,40040,40400)"
I can't kill it with pg_terminate_backend(<pid>) - nothing is happening.
Restart machine - works for 10 minutes and problem is back.
What can I do with it?
Any help appreciated.
I've got Zabbix 6.2.2 on docker with postgresql 13.8-alpine (earlier zabbix 6.0.4) and this setup was working well for quite some time.
Recently I discovered that postgres container consumes everything.
I logged into database and found query which consumes -
"select distinct itemid from trends_uint where clock>=1662364800 and itemid in (29180,38420,38961,38964,38974,38975,38976,38977,3 8978,38979,39920,39980,40040,40400)"
I can't kill it with pg_terminate_backend(<pid>) - nothing is happening.
Restart machine - works for 10 minutes and problem is back.
What can I do with it?
Any help appreciated.
Comment