-
Incident report
-
Resolution: Duplicate
-
Critical
-
None
-
2.4.8
Not sure how reproduce that.
Just found that DB execute about 1000 similar queries which listed for 50+ pages in processlist:
ID: 28006 USER: zabbix HOST: X.X.X.X:60838 DB: zabbix COMMAND: Query TIME: 12316 STATE: Sending data INFO: SELECT e.eventid,i.hostid FROM events e,functions f,items i WHERE (e.eve ntid BETWEEN '30295710' AND '30295714' OR e.eventid BETWEEN '30342776' AND '30342 781' OR e.eventid BETWEEN '30367772' AND '30367778' OR e.eventid BETWEEN '3036824 3' AND '30368248' OR e.eventid BETWEEN '30368310' AND '30368317' OR e.eventid BET WEEN '30368364' AND '30368368' OR e.eventid BETWEEN '30368745' AND '30368749' OR e.eventid BETWEEN '30368953' AND '30368958' OR e.eventid BETWEEN '30369155' AND ' 30369159' OR e.eventid BETWEEN '30369734' AND '30369741' OR e.eventid BETWEEN '30 372212' AND '30372218' OR e.even .................... ...........