Hello, i have Zabbix 5.0.23 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 weeks im getting some strange behavior, PHP pool is dynamic and is starting to grow the amount of php processes. For what I saw, happens when frontend try to check for Problems in problem page or from Problem widget. What happens from Problems page is that sometimes users get 502 http error or from widget Problem the loading weal keeps spinning
If i check the DB current processes im seeing queries that could be running for more than 4000 sec, same query for what i can see.
These 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. No sure what these queries are trying to look...
Nothing has been changed, maybe more users are using the tool but not more than that. Strange that only happens with users with User or Admin privileges, SuperAdmin looks good.
Actually this problem started to happen some weeks ago with version 5.0.7, investigating i found a thread (similar to my issue) that was fixed in v 5.0.15 https://support.zabbix.com/browse/ZBX-16822
For that reason ive upgraded into latest 5.0.23 but issue is still there.
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.