event.get may generate huge SQL query which never is finished.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Duplicate
    • Priority: Critical
    • None
    • Affects Version/s: 2.4.8
    • Component/s: API (A)

      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
      ....................
      ...........
      
      

            Assignee:
            Zabbix Development Team
            Reporter:
            Andrei Gushchin (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: