Hello, i have Zabbix 5.0.7 version using Server and Proxies. Also im using two isolated hosts for the Frontend (httpd 2.4 and php-fpm 7.2).

MySQL version 8.0.15

Since a couple of days im getting some strange behavior, PHP pool is dynamic and is starting to grow the amount of php processes.

If i check the DB current processes im seeing queries that could be running for more than 4000 sec, same querie for what i can see.

Like:

SELECT a.alertid,a.alerttype,a.clock,a.error,a.eventid,a.mediatypeid,a.retries,a.status,a.userid 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 IN (22,23) 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 IN (22,23))) AND a.eventid IN (171549,194437,194454,194817,208536,208725,209682,209705,209724,209726,210026,213358,214582,214596,214872,217713,217740,217887,217904,217906,218302,219519,234691,235012,235013,235064,235077,235089,235102,235114,571682,571904,574575,574576,574865,574882,574908,574920,769019,1225248,1226534,1226554,1226578,1226595,1227052,1227053,1227420,1392400,1392412,1392433,1393034,1395466,1395484,1395504,1395522,1395596,1395597,1744261,1744265,1745075,1745088,1745105,1745123,1745158,1745160,1766651,1766673,1766691,1766708,1766748,1766749,5185522,5185992,5188826,5188973,5189014,5189118,5189317,5189318,5335130,5335132,5335146,5335149,5335153,5335155,6332586,6332852,6332967,6418691,6962830,6963514,6963754,6963756,6965597,6965666,6965705,6965751,6966198,6966200,6971792,6971796,7795968,7795970,7796210,7796698,7828035,7828036,7828743,7828828,7828854,7828919,7932716,10228697,10228699,10228701,11256798,11256805,11263503,11263505,11264675,11264711,11264747,11264775,11264801,11264873,12445280,12763819,14473153,14569966,14570385,14578805,14579527,16130617,16130622,16132529,16132575,16132610,16132643,16132685,16132716,16132759,16132787,16133016,16133058,16133092,16133130,16133165,16133196,16133233,16133271,16133351,16133352,16133353,16133355,16136920,16142130,16142526,16142565,16142599,16142638,16142672,16142706,17154501,17587540,17588232,17588418,17588596,17588775,17588919,17589108,17589357,17589670,17589846,17590024,17590204,17590363,18506404,18507662,18975552,19595605,19785996,19786005,19786020,19877162,19903154,19903355,19906174,19934364,19934365,19960815,19960844,19965490,19965744,19966165,19966645,19966814)

There queries come from the Frontend hosts, the workaround im doing is restarting httpd and php services, that will clear the queries but eventually the same situation will happen again.

Nothing has been changed, maybe more users are using the tool but not more than that.

Do you know what could be happening? attaching a screenshot from MySQL workbench, you can see there that is same query running from different PHP connections.

Thanks