-
Problem report
-
Resolution: Fixed
-
Trivial
-
None
-
7.2.3, 7.2.4
-
None
Steps to reproduce:
- Use big enough Zabbix instance with many (10+) clients who use multiple tabs on their browser to watch on graphs / dashboards.
- Change request to get renewed graphs. Could be zoom on graphs. Browser zoom affects pretty well.
Result:
Some graphs are not opened. Looks like chart2.php returns empty text request instead of png.
Also there are many sessions errors on nginx:
2025/02/27 15:45:27 [error] 15892#15892: *3955029 FastCGI sent in stderr: "PHP message: PHP Warning: Error in query [UPDATE sessions SET lastaccess='1740631527' WHERE sessionid='17ed072e5a3c6c3ef1cf4ba2407a48f5'] [Record has changed since last read in table 'sessions'] in /usr/share/zabbix/ui/include/db.inc.php on line 249" while reading response header from upstream, client: 10.1.30.5, server: zabbix.in.urnet.com.au, request: "POST /zabbix.php?action=widget.map.view HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/zabbix.sock:", host: "zabbix.in.urnet.com.au", referrer: "https://zabbix.in.urnet.com.au/zabbix.php?action=dashboard.view&dashboardid=1770&from=now-1d&to=now" 2025/02/27 15:45:27 [error] 15892#15892: *3955029 FastCGI sent in stderr: "PHP message: PHP Warning: Error in query [UPDATE sessions SET lastaccess='1740631527' WHERE sessionid='17ed072e5a3c6c3ef1cf4ba2407a48f5'] [Record has changed since last read in table 'sessions'] in /usr/share/zabbix/ui/include/db.inc.php on line 249" while reading response header from upstream, client: 10.1.30.5, server: zabbix.in.urnet.com.au, request: "POST /map.php?sysmapid=19&severity_min=0&unique_id=U000001 HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/zabbix.sock:", host: "zabbix.in.urnet.com.au", referrer: "https://zabbix.in.urnet.com.au/zabbix.php?action=dashboard.view&dashboardid=1683&from=now-1d&to=now" 2025/02/27 15:45:31 [error] 15890#15890: *3950046 FastCGI sent in stderr: "PHP message: PHP Warning: Error in query [UPDATE sessions SET lastaccess='1740631531' WHERE sessionid='d20eaaf12392155744d30415bd2da35f'] [Record has changed since last read in table 'sessions'] in /usr/share/zabbix/ui/include/db.inc.php on line 249" while reading response header from upstream, client: 10.1.30.1, server: zabbix.in.urnet.com.au, request: "POST /zabbix.php?action=dashboard.config.hash HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/zabbix.sock:", host: "zabbix.in.urnet.com.au", referrer: "https://zabbix.in.urnet.com.au/zabbix.php?action=dashboard.view&dashboardid=66&from=now-24h&to=now"
Expected:
All graphs should be opened quickly and reliable.
If you need any more data - let me know. I will try to get it quickly.
Thanks.
