Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-10762

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

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 2.4.8
    • 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
      ....................
      ...........
      
      

            zabbix.dev Zabbix Development Team
            neogan Andrei Gushchin (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: