Hello,

Since I migrate my database from PGSQL13 to PGSQL16 (and from Debian 11 to Rocky 9), I got some slow queries on my Zabbix server logs. They are followed by a complete freeze of my Zabbix server that is unable to collect data (interruption time is random between 5 to 30min).

On my DB server "Duplicate key value breaks unique constraint" on 'history_pkey' and 'history_uint_pkey' tables like you can see in attached picture.

In Zabbix server logs there is nothing except this (that you can see in the other attached picture.) :
"Got signal [signal:15(SIGTERM),sender_pid:10090,sender_uid:0,reason:0]. Exiting ..."

I tried to clean all history and trend tables but it keeps happening every hour.
I tried to disable housekeeping, so I don't think it's linked. I can't find the problem source.