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

After reload server and/or Unavilable some host - Triggers in events - OK

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 1.6.6
    • Server (S)
    • None

      In case reload server and/or Host unavilable some time:

      1. Some triggers in events screen shown as - OK (But, this was always OK! And don't change status)
      2. Increased counters in "Most busy triggers top 100" for this triggers

      Temporally solution (In my case):

      UPDATE triggers SET value = DEFAULT WHERE triggerid IN (SELECT objectid FROM events WHERE eventid NOT IN (SELECT eventid FROM alerts));
      UPDATE triggers SET lastchange = DEFAULT WHERE triggerid IN (SELECT objectid FROM events WHERE eventid NOT IN (SELECT eventid FROM alerts));
      DELETE FROM events WHERE eventid NOT IN (SELECT eventid FROM alerts);
      DELETE FROM escalations WHERE eventid NOT IN (SELECT eventid FROM events);

            Unassigned Unassigned
            nselikhov Nikolay L Selikhov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: