Hello!
I have a main Zabbix server (with a dedicated DB server) and a few proxies.
And I see an error in the Zabbix proxy (below).
I've tried adding the values I want to the regexps table. After that, the initial synchronization goes well, but then again an error.
As I understand it, old data comes from the main zabbix server to the proxy, which is no longer in the web interface.
Please help me.
I have a main Zabbix server (with a dedicated DB server) and a few proxies.
And I see an error in the Zabbix proxy (below).
I've tried adding the values I want to the regexps table. After that, the initial synchronization goes well, but then again an error.
As I understand it, old data comes from the main zabbix server to the proxy, which is no longer in the web interface.
Please help me.
1547:20211202:131102.148 received configuration data from server at "zbbxsrv", datalen 4980259
1547:20211202:131102.798 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "expressions" violates foreign key constraint "c_expressions_1"
DETAIL: Key (regexpid)=(20) is not present in table "regexps".
[insert into expressions (expressionid,regexpid,expression,expression_type, exp_delimiter,case_sensitive) values (41,20,'^Interface Microsoft 6to4 Adapter|Interface Microsoft IP-HTTPS Platform Adapter$',3,',',0),(43,21,'^Interface Microsoft 6to4 Adapter|Interface Microsoft IP-HTTPS Platform Adapter|ISATAP$',4,',',0);
]
1547:20211202:131102.798 failed to update local proxy configuration copy: database error
1547:20211202:131102.798 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "expressions" violates foreign key constraint "c_expressions_1"
DETAIL: Key (regexpid)=(20) is not present in table "regexps".
[insert into expressions (expressionid,regexpid,expression,expression_type, exp_delimiter,case_sensitive) values (41,20,'^Interface Microsoft 6to4 Adapter|Interface Microsoft IP-HTTPS Platform Adapter$',3,',',0),(43,21,'^Interface Microsoft 6to4 Adapter|Interface Microsoft IP-HTTPS Platform Adapter|ISATAP$',4,',',0);
]
1547:20211202:131102.798 failed to update local proxy configuration copy: database error