I upgraded zabbix to v6.0.4, zabbix upgrade the DB also, i was previously using zabbix 5.4.12.
I have not yet done the "database upgrade to primary keys"
Checking mysql -> SHOW FULL PROCESSLIST;
i see high number of the same queries that the process list is extremely high.
"SELECT a.alertid,a.clock,a.sendto,a.subject,a.message,a.s tatus,a.retries,a.error,a.userid,a.actionid,a.medi atypeid,a.alerttype FROM alerts a WHERE EXISTS (SELECT NULL FROM events e,functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=16 WHERE a.eventid=e.eventid AND e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND (a.userid IS NULL OR EXISTS (SELECT NULL FROM users_groups ug WHERE ug.userid=a.userid AND ug.usrgrpid=16)) ORDER BY a.clock DESC LIMIT 25"
after a couples hours, the processlist is so high, the web gui is no longer accessible. a server reboot fixes it. i believe the above query is run for the frontend request. i have serveral Web GUI open at the same times showing different views.
How can i solve this? never had this issues before upgrading.
I have not yet done the "database upgrade to primary keys"
Checking mysql -> SHOW FULL PROCESSLIST;
i see high number of the same queries that the process list is extremely high.
"SELECT a.alertid,a.clock,a.sendto,a.subject,a.message,a.s tatus,a.retries,a.error,a.userid,a.actionid,a.medi atypeid,a.alerttype FROM alerts a WHERE EXISTS (SELECT NULL FROM events e,functions f,items i,hosts_groups hgg JOIN rights r ON r.id=hgg.groupid AND r.groupid=16 WHERE a.eventid=e.eventid AND e.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY f.triggerid HAVING MIN(r.permission)>0 AND MAX(r.permission)>='2') AND EXISTS (SELECT NULL FROM actions aa WHERE a.actionid=aa.actionid AND aa.eventsource='0') AND (a.userid IS NULL OR EXISTS (SELECT NULL FROM users_groups ug WHERE ug.userid=a.userid AND ug.usrgrpid=16)) ORDER BY a.clock DESC LIMIT 25"
after a couples hours, the processlist is so high, the web gui is no longer accessible. a server reboot fixes it. i believe the above query is run for the frontend request. i have serveral Web GUI open at the same times showing different views.
How can i solve this? never had this issues before upgrading.