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

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Major Major
    • 4.4 (plan)
    • None
    • Server (S)
    • Sprint 51 (Apr 2019)
    • 1

      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.

        1. postgresql-9.5-main.log
          323 kB
          Edmunds Vesmanis

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

              Created:
              Updated:
              Resolved: