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

Errors in posgresql log: duplicate key value violates unique constraint "hosts_groups_1"

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 4.4 (plan)
    • Component/s: Server (S)
    • Labels:
    • Team:
      Team A
    • Sprint:
      Sprint 51 (Apr 2019)
    • Story Points:
      1

      Description

      errors in postgresql log of our zabbix infrastructure:

      ERROR:  duplicate key value violates unique constraint "hosts_groups_1"
      DETAIL:  Key (hostid, groupid)=(12541, 416) already exists.
      STATEMENT:  insert into hosts_groups (hostgroupid,hostid,groupid) values (28267,12541,416),(28268,12542,416),(28269,12543,416);
      

      the groupid 416 is a simple group used for esxi. hostid 12541, 12542 and 12543 are hosts discovered by the vmware template.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              vso Vladislavs Sokurenko
              Reporter:
              edmunds.vesmanis Edmunds Vesmanis
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: