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

[PGSQL] failed to update local proxy configuration copy: database error

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unsupported version
    • Icon: Trivial Trivial
    • None
    • 4.0.25
    • Proxy (P)

      Steps to reproduce:

      Install PostgreSQL

      Install Zabbix Proxy for PostgreSQL

      Create Zabbix Proxy Database:

      zcat /usr/share/zabbix-proxy-pgsql/schema.sql.gz | psql -U zabbix -d zabbixproxy
      

      Result:

      1523:20201020:132317.737 received configuration data from server at "10.111.4.134", datalen 3569
       1523:20201020:132317.743 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "expressions" violates foreign key constraint "c_expressions_1"
      DETAIL: Key (regexpid)=(6) is not present in table "regexps".
       [insert into expressions (expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive) values (1,1,'^(btrfs|ext2|ext3|ext4|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|apfs|refs|ntfs|fat32|zfs)$',3,',',0),(3,3,'^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$',4,',',1),(5,4,'^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$',4,',',1),(6,5,'^(automatic|automatic delayed)$',3,',',1),(7,2,'^Software Loopback Interface',4,',',1),(8,2,'^(In)?[Ll]oop[Bb]ack[0-9._]*$',4,',',1),(9,2,'^NULL[0-9.]*$',4,',',1),(10,2,'^[Ll]o[0-9.]*$',4,',',1),(11,2,'^[Ss]ystem$',4,',',1),(12,2,'^Nu[0-9.]*$',4,',',1),(13,2,'^\<pppoe',4,',',0),(14,6,'([\d+])',0,',',0);
      ]
       1523:20201020:132317.744 failed to update local proxy configuration copy: database error
      

      Expected:
      Normal sync

            aigars.kadikis Aigars Kadikis
            livreacesso.pro LivreAcesso.Pro
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: