Duplicate key value violates unique constraint "events_pkey"

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Critical
    • None
    • Affects Version/s: 2.2.1
    • Component/s: Server (S)
    • None
    • Environment:
      Postgres 9.3, SLES11-SP3, Master with 4 child nodes

      I rebuild my Master server, running Postgres 9.3 and SLES11-SP3, but after duplicating the DMs etc on the Master, I'm getting this error. I did truncate the ids table as suggested, but still getting this
      29506:20140120:105108.216 NODE 999: Received configuration changes from slave node 268 for node 268 datalen 1910
      29501:20140120:105108.739 NODE 999: received events from node 263 for node 263 datalen 3238
      29507:20140120:105108.926 NODE 999: received events from node 266 for node 266 datalen 648252
      29502:20140120:105109.648 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "events_pkey"
      DETAIL: Key (eventid)=(26326300001400713) already exists.
      [insert into events (eventid,source,object,objectid,clock,ns,value) values (26326300001400713,0,0,26326300000013589,1390207380,880454343,1),(26326300001400714,0,0,26326300000013778,1390207380,880457597,1),(26326300001400715,0,0,26326300000013780,1390207380,880458819,1),(26326300001400716,0,0,26326300000013782,1390207380,880460271,1),(26326300001400717,0,0,26326300000013784,1390207380,880461760,1),(26326300001400718,0,0,26326300000013786,1390207380,880463780,1),(26326300001400719,0,0,26326300000013790,1390207380,880465325,1),(26326300001400720,0,0,26326300000013792,1390207380,880466798,1),(26326300001400721,0,0,26326300000013794,1390207380,880468464,1),(26326300001400722,0,0,26326300000013796,1390207380,880469864,1),(26326300001400723,0,0,26326300000013802,1390207380,880471

      I cannot see any latest data for any of the child nodes in the Master GUI either. I am getting the child node updates through to the master from the server log file

      29504:20140120:105037.168 NODE 999: received history from node 268 for node 268 datalen 1122
      29496:20140120:105040.004 resuming Zabbix agent checks on host "xxxxxxxx": connection restored
      29437:20140120:105040.581 Zabbix agent item "net.if.out[bond0]" on host "xxxxxxxxx" failed: first network error, wait for 15 seconds
      29498:20140120:105042.095 resuming Zabbix agent checks on host "xxxxxxxxxxx": connection restored
      29467:20140120:105042.753 Zabbix agent item "vfs.fs.size[/boot,used]" on host "xxxxxxxxxx" failed: first network error, wait for 15 seconds
      29495:20140120:105042.975 resuming Zabbix agent checks on host "xxxxxxxxx": connection restored
      29496:20140120:105043.010 temporarily disabling Zabbix agent checks on host "xxxxxxxxxxxx": host unavailable
      29498:20140120:105043.574 resuming Zabbix agent checks on host "xxxxxxxxxx": connection restored
      29469:20140120:105043.688 Zabbix agent item "net.if.in[bond1]" on host "xxxxxxxxx" failed: first network error, wait for 15 seconds
      29504:20140120:105044.440 NODE 999: received history_uint from node 268 for node 268 datalen 453
      29498:20140120:105044.699 resuming Zabbix agent checks on host "xxxxxxxxx": connection restored
      29507:20140120:105044.836 NODE 999: received events from node 268 for node 268 datalen 36076
      29433:20140120:105044.908 Zabbix agent item "vfs.fs.inode[/dev,pused]" on host "xxxxxxxxx" failed: first network error, wait for 15 seconds
      29440:20140120:105045.022 Zabbix agent item "system.cpu.load[percpu,avg5]" on host "xxxxxxxxxx" failed: first network error, wait for 15 seconds
      29464:20140120:105045.474 Zabbix agent item "system.users.num" on host "xxxxxxxx" failed: first network error, wait for 15 seconds
      29496:20140120:105046.845 resuming Zabbix agent checks on host "xxxxxxxx": connection restored
      29506:20140120:105047.758 NODE 999: received history_uint from node 265 for node 265 datalen 456977
      29487:20140120:105048.700 resuming Zabbix agent checks on host "xxxxxxxxxxx": connection restored
      29435:20140120:105048.848 Zabbix agent item "vfs.fs.size[/pgtablespace,used]" on host "xxxxxxxxx" failed: first network error, wait for 15 seconds
      29477:20140120:105052.884 Zabbix agent item "vfs.fs.size[/,free]" on host "xxxxxxxxxx" failed: first network error, wait for 15 seconds

      Any ideas on what I can try?

            Assignee:
            Unassigned
            Reporter:
            Wynand Jansen van Vuuren
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: