-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
5.0.8
-
None
-
CentOS 7
PostgreSQL 10.15
Dell R715
CPUs: 2x12C AMD Opteron 6168 @1.9GHz
Memory: 256GB
Steps to reproduce:
- Create a user of type "Zabbix Admin" or "Zabbix User"
- Assign user to user group with read-write permissions on a number of hosts, or all hosts, and the ability to edit some or all templates. The number does not seem to matter; I've tried several different permutations to see if I can isolate the issue, but altering the permissions of the user's user group does not make a difference.
- Attempt to load a page like the Monitoring -> Latest Data, Monitoring -> Hosts, Configuration -> Hosts, Configuration -> Templates etc. and it takes between twelve to eighteen seconds for the page to load, if it loads at all. Frequently we were getting a Gateway Timeout response until I upped the timeout limit. I have monitored the Zabbix server logs during this and I do not see any notifications of slow queries or errors. postgresql.conf and zabbix_server.conf files are attached.
Result:
See screenshot...
See log file...
See memory dump...
Expected:
See screenshot....
See attached patch file...
- duplicates
-
ZBX-7706 Slow queries when checking permissions
- Closed