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

Is it safe to change "status" column in "items" table from sql query?

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.2.4
    • Server (S)

      Hi,

      I have group of items which pulls data using external script.
      It is very inefficient to leave them on when destination host is down.
      Every host contains icmpping item. So I've made script which for my host group checks status of icmpping.
      It is launched every 5min and scans history_uint table to qualify host for external script item enable/disable.

      BTW, I think that ability to on/off items related to other item as an automatic process might be great feature request.

      My question is:
      Is it safe to toggle status column in items table using user script executed from crond?

      After v2.0 to v2.2 migration I think that Zabbix needs some sort of poke to catch new item status.
      Some items stays in in Zabbix queue for 10 or more days. These items are enabled according to database but Zabbix ignores them for some reason.
      Only items enabled/disabled by my script are affected. Wild guess: it might be some sort of strange race condition inside zabbix_server logic.

      Restarting zabbix_server service solves queue problem - all enabled items are processed now.
      That was first restart after Zabbix upgrade but I think that queue might be filled again by items after few days.

      Regards,
      Rob

        1. asd1.png
          asd1.png
          83 kB
        2. asd2.png
          asd2.png
          54 kB
        3. dbconfig.c_50627-50628.patch
          0.9 kB

            Unassigned Unassigned
            robnorthen Rob Northen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: