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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.0.25
    • Fix Version/s: None
    • Component/s: Proxy (P)
    • Environment:

      Description

      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

        Attachments

        1. schema.sql.gz
          12 kB
          LivreAcesso.Pro
        2. zabbix_proxy.log
          27 kB
          LivreAcesso.Pro

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: