[ Problems solved by upgrading firefox3.0 to firefox3.6 ]
Hi Folks,
I'm currently running 1.8.1 and getting problems when trying to add to my configuration. Adding triggers is flakey sometimes they work, most of the time I get an unauthorized request error. I also get a consistant unauthorized request error when trying to configure cells in a screen. I have my own account and the admin account setup as super-admins with permissions on everything. This installation has been running and upgraded since 1.6, skipping the 1.7 branch. I upgraded to 1.8.1 from 1.8 hoping these problems would be fixed.
It's getting to the point where for me zabbix is getting un-usable. We've got quite a large installation, and I don't want to have to move away.
I've looked at the debug output in the gui and it gives the following when adding a cell to a screen for example:
******************* Stats for script *************************
Total time: 0.315346
Memory limit : 256M
Memory usage : 1024K - 8.75M
Memory leak : 7.75M
SQL selects count: 9
SQL executes count: 5
SQL requests count: 14
Time:0.000162 SQL: SET NAMES utf8
Time:0.000111 SQL: SET CHARACTER SET utf8
Time:0.000223 SQL: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
Time:0.001008 SQL: SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='3aa3d29cb464747b8fbdd04884eaeb6a' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1266488922) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000245 SQL: SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid
Time:0.00016 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 3 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
Time:0.009951 SQL: UPDATE sessions SET lastaccess=1266488922 WHERE sessionid='3aa3d29cb464747b8fbdd04884eaeb6a'
Time:0.000228 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 3 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0
Time:0.007858 SQL: SELECT * FROM profiles WHERE userid=3 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC
Time:0.000759 SQL: UPDATE profiles SET value_id=0, value_int=0, value_str='screenconf.php', type=3, source='' WHERE userid=3 AND idx='web.menu.config.last' AND ((profileid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000298 SQL: SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000788 SQL: SELECT title1, url1, title2, url2, title3, url3, title4, url4, title5, url5 FROM user_history WHERE userid=3
Time:0.000676 SQL: SELECT title5, url5 FROM user_history WHERE userid=3
Time:0.001449 SQL: UPDATE user_history SET title1=title2, url1=url2, title2=title3, url2=url3, title3=title4, url3=url4, title4=title5, url4=url5, title5='S_CONFIGURATION_OF_SCREENS', url5='screenedit.php' WHERE userid=3
Total time spent on SQL: 0.023916
******************** End of script ***************************
What can I do?
-Cheers Max
Number of hosts 98
Number of items 13292
Number of triggers 5506
Hi Folks,
I'm currently running 1.8.1 and getting problems when trying to add to my configuration. Adding triggers is flakey sometimes they work, most of the time I get an unauthorized request error. I also get a consistant unauthorized request error when trying to configure cells in a screen. I have my own account and the admin account setup as super-admins with permissions on everything. This installation has been running and upgraded since 1.6, skipping the 1.7 branch. I upgraded to 1.8.1 from 1.8 hoping these problems would be fixed.
It's getting to the point where for me zabbix is getting un-usable. We've got quite a large installation, and I don't want to have to move away.
I've looked at the debug output in the gui and it gives the following when adding a cell to a screen for example:
******************* Stats for script *************************
Total time: 0.315346
Memory limit : 256M
Memory usage : 1024K - 8.75M
Memory leak : 7.75M
SQL selects count: 9
SQL executes count: 5
SQL requests count: 14
Time:0.000162 SQL: SET NAMES utf8
Time:0.000111 SQL: SET CHARACTER SET utf8
Time:0.000223 SQL: SELECT * FROM nodes WHERE nodetype=1 ORDER BY nodeid
Time:0.001008 SQL: SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='3aa3d29cb464747b8fbdd04884eaeb6a' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1266488922) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000245 SQL: SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=3 AND g.usrgrpid=ug.usrgrpid
Time:0.00016 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 3 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
Time:0.009951 SQL: UPDATE sessions SET lastaccess=1266488922 WHERE sessionid='3aa3d29cb464747b8fbdd04884eaeb6a'
Time:0.000228 SQL: SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 3 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0
Time:0.007858 SQL: SELECT * FROM profiles WHERE userid=3 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC
Time:0.000759 SQL: UPDATE profiles SET value_id=0, value_int=0, value_str='screenconf.php', type=3, source='' WHERE userid=3 AND idx='web.menu.config.last' AND ((profileid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000298 SQL: SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))
Time:0.000788 SQL: SELECT title1, url1, title2, url2, title3, url3, title4, url4, title5, url5 FROM user_history WHERE userid=3
Time:0.000676 SQL: SELECT title5, url5 FROM user_history WHERE userid=3
Time:0.001449 SQL: UPDATE user_history SET title1=title2, url1=url2, title2=title3, url2=url3, title3=title4, url3=url4, title4=title5, url4=url5, title5='S_CONFIGURATION_OF_SCREENS', url5='screenedit.php' WHERE userid=3
Total time spent on SQL: 0.023916
******************** End of script ***************************
What can I do?
-Cheers Max
Number of hosts 98
Number of items 13292
Number of triggers 5506
Comment