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

EventID rolled over in DB for no reason

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 2.4.5
    • None
    • Server (S)
    • Centos 6

    Description

      Not sure if we have a known bug as seems fixed in 2.4.7 but might be coincidence so wanted to report this:

      Our 2.4.1 system suddenly rolled over the eventID in the database for no reason. As far as we can tell, it uses the max(eventid) + 1, but this is clearly not working as it went from 15,161,039 to 393 - here are the events in the event table, sorted by clock:

      '15161039','2','3','200','1448276685','1','0',NULL,NULL,'0','0'
      '393','3','4','1446589','1448276693','1','0',NULL,NULL,'0','578612635'

      This makes no sense at all, nor do we understand how this continues to work as the source code seems to cache a few of these at a time, always MAX(eventiid)+1, but that should be 15,161,040 but it continues to work on the lower numbers one by one, which should be impossible.

      We worry this is hiding some underlying problem that is not clear, and could happen with other IDs, and of course eventually we will have collisions, which then can't be fixed.

      We saw this because we use this ID for integration into our ticket system and we had some DB reports that show us how fast we ACK things, average problem duration, etc. and they all started failing.

      Checking this now, we see that it suddenly started working fine again using the max eventid at 2015-12-03 10:31:23 - when we upgraded the server binary to 2.4.7

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              steve.mushero Steve Mushero
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: