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

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.2.4
    • Fix Version/s: None
    • Component/s: Server (S)

      Description

      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

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: