-
Incident report
-
Resolution: Duplicate
-
Minor
-
None
-
1.8.13
-
None
-
freeBSD 8.2
After update zabbix(server, agent, frontend) to 1.8.13 version i can't open zabbix admin page via http. Browser waiting for server and MySQL log write:
11 Query SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
11 Query SELECT s.* FROM sessions s WHERE s.sessionid='c2a43d7d3460b641ef88311c3a76cd8e' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query begin
11 Query DELETE FROM sessions WHERE status=1 AND userid='2'
11 Query UPDATE sessions SET status=1 WHERE sessionid='c2a43d7d3460b641ef88311c3a76cd8e'
11 Query SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('26298f63aec8a3eb0431fbdc1ceba241',2,1338274572,0)
11 Query SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
11 Query SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
11 Query SELECT s.* FROM sessions s WHERE s.sessionid='26298f63aec8a3eb0431fbdc1ceba241' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query DELETE FROM sessions WHERE status=1 AND userid='2'
11 Query UPDATE sessions SET status=1 WHERE sessionid='26298f63aec8a3eb0431fbdc1ceba241'
11 Query SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('961d48a3d2d04a086f5d0827ec88a300',2,1338274572,0)
11 Query SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
11 Query SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
11 Query SELECT s.* FROM sessions s WHERE s.sessionid='961d48a3d2d04a086f5d0827ec88a300' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query DELETE FROM sessions WHERE status=1 AND userid='2'
11 Query UPDATE sessions SET status=1 WHERE sessionid='961d48a3d2d04a086f5d0827ec88a300'
11 Query SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('65a223f1d3119078f4fd3a521e3c16be',2,1338274572,0)
11 Query SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
11 Query SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
11 Query SELECT s.* FROM sessions s WHERE s.sessionid='65a223f1d3119078f4fd3a521e3c16be' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query DELETE FROM sessions WHERE status=1 AND userid='2'
11 Query UPDATE sessions SET status=1 WHERE sessionid='65a223f1d3119078f4fd3a521e3c16be'
11 Query SELECT u.* FROM users u WHERE u.alias='guest' AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query INSERT INTO sessions (sessionid,userid,lastaccess,status) VALUES ('2473825d198ddb5fb4b8eaf74e37e2ea',2,1338274572,0)
11 Query SELECT MAX(g.gui_access) as gui_access FROM usrgrp g, users_groups ug WHERE ug.userid=2 AND g.usrgrpid=ug.usrgrpid
11 Query SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.users_status = 1 LIMIT 1 OFFSET 0
11 Query SELECT s.* FROM sessions s WHERE s.sessionid='2473825d198ddb5fb4b8eaf74e37e2ea' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))
11 Query DELETE FROM sessions WHERE status=1 AND userid='2'
11 Query UPDATE sessions SET status=1 WHERE sessionid='2473825d198ddb5fb4b8eaf74e37e2ea'
...this continues until the end of the memory in PHP.
Finally browser shows empty page.
- duplicates
-
ZBX-5006 PHP Fatal error: Allowed memory size after 1.8.13 upgrade
- Closed