Ad Widget

Collapse

Zabbix repeating eventids - 3.2.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Pedro.Almeida
    Junior Member
    • Sep 2014
    • 22

    #1

    Zabbix repeating eventids - 3.2.3

    From time to time we get this:

    Code:
      6649:20170118:102500.261 [Z3005] query failed: [1062] Duplicate entry '49' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value) values (49,3,0,16899,1484735100,74906971,0),(50,3,0,24486,1484735100,75280013,0),(51,3,0,26586,1484735100,75515360,0),(52,3,0,26901,1484735100,75670624,0),(53,3,0,27019,1484735100,75735364,1);
      6656:20170118:102522.347 [Z3005] query failed: [1062] Duplicate entry '54' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value) values (54,3,4,158421,1484735121,647834844,0);
      6658:20170118:102526.345 [Z3005] query failed: [1062] Duplicate entry '55' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value) values (55,3,4,156775,1484735125,906272616,0),(56,3,0,26851,1484735125,906272616,0);
      6656:20170118:102532.358 [Z3005] query failed: [1062] Duplicate entry '57' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value) values (57,0,0,16848,1484735127,792412698,0);
      6656:20170118:102540.374 [Z3005] query failed: [1062] Duplicate entry '74' for key 'PRIMARY' [insert into events (eventid,source,object,objectid,clock,ns,value) values (74,0,0,26027,1484735138,165951634,0);
    As if events restarte inserting at 1. This also occured on 3.0.x on this same instalattion.
    If I restart the server process (sometimes a couple times) the problem disappears.
    Where does zabbix gets its next eventid from? (it's not on the 'ids' table).
  • beyondldf
    Junior Member
    • Jan 2017
    • 5

    #2
    I have the same issue ,Have you resolved this issue?

    Comment

    Working...