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

Dublicate entries in events table

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.8.4
    • Fix Version/s: 1.8.4
    • Component/s: Server (S)
    • Labels:
      None

      Description

      6018:20100421:101501.007 [Z3005] Query failed: [-1] ORA-00001: unique constraint (ZABBIX_TEST.EVENTS_PK) violated
      ORA-06512: at line 8
      [begin
      update items set status=3,lastclock=1271823286,error='OID [.1.3.6.1.4.2.1.2.4] value has unknown type [0x81]' where itemid=542086;
      update triggers set value=2,lastchange=1271823286,error='OID [.1.3.6.1.4.2.1.2.4] value has unknown type [0x81]' where triggerid=219168;
      update triggers set value=2,lastchange=1271823286,error='OID [.1.3.6.1.4.2.1.2.4] value has unknown type [0x81]' where triggerid=219168;
      update triggers set value=2,lastchange=1271823286,error='OID [.1.3.6.1.4.2.1.2.4] value has unknown type [0x81]' where triggerid=219168;
      update triggers set value=2,lastchange=1271823286,error='OID [.1.3.6.1.4.2.1.2.4] value has unknown type [0x81]' where triggerid=219168;
      insert into events (eventid,source,object,objectid,clock,value) values (12212363,0,0,219168,1271823286,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212364,0,0,219168,1271823286,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212365,0,0,219168,1271823286,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212366,0,0,219168,1271823286,2);
      end;
      ]
      6028:20100421:101502.922 [Z3005] Query failed: [-1] ORA-00001: unique constraint (ZABBIX_TEST.EVENTS_PK) violated
      ORA-06512: at line 8
      [begin
      update items set status=3,lastclock=1271823298,error='OID [.1.3.6.1.4.2.1.2.12] value has unknown type [0x81]' where itemid=542096;
      update triggers set value=2,lastchange=1271823298,error='OID [.1.3.6.1.4.2.1.2.12] value has unknown type [0x81]' where triggerid=219171;
      update triggers set value=2,lastchange=1271823298,error='OID [.1.3.6.1.4.2.1.2.12] value has unknown type [0x81]' where triggerid=219171;
      update triggers set value=2,lastchange=1271823298,error='OID [.1.3.6.1.4.2.1.2.12] value has unknown type [0x81]' where triggerid=219171;
      update triggers set value=2,lastchange=1271823298,error='OID [.1.3.6.1.4.2.1.2.12] value has unknown type [0x81]' where triggerid=219171;
      insert into events (eventid,source,object,objectid,clock,value) values (12212367,0,0,219171,1271823298,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212368,0,0,219171,1271823298,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212369,0,0,219171,1271823298,2);
      insert into events (eventid,source,object,objectid,clock,value) values (12212370,0,0,219171,1271823298,2);
      end;
      ]
      6332:20100421:101503.086 [Z3005] Query failed: [-1] ORA-00001: unique constraint (ZABBIX_TEST.EVENTS_PK) violated
      [insert into events (eventid,source,object,objectid,clock,value) values (12212369,1,2,317555,1271823303,0)]
      6064:20100421:101503.157 Item [BBR04:Port_10104_OutBits] error: OID [.1.3.6.1.2.1.31.1.1.1.10.10104] value has unknown type [0x81]
      6335:20100421:101503.293 [Z3005] Query failed: [-1] ORA-00001: unique constraint (ZABBIX_TEST.EVENTS_PK) violated
      [insert into events (eventid,source,object,objectid,clock,value) values (12212370,1,2,120,1271823303,0)]
      6335:20100421:101503.390 [Z3005] Query failed: [-1] ORA-00001: unique constraint (ZABBIX_TEST.EVENTS_PK) violated
      [insert into events (eventid,source,object,objectid,clock,value) values (12212371,1,2,23695,1271823303,0)]

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: