-
Problem report
-
Resolution: Unsupported version
-
Trivial
-
None
-
4.0.25
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