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

Stop processing data if failed to update local proxy configuration copy: database error happens

    XMLWordPrintable

Details

    • Incident report
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 5.0.17
    • None
    • None
    • None

    Description

      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.

      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

      Attachments

        1. master server db.PNG
          master server db.PNG
          27 kB
        2. zabbix_proxy.PNG
          zabbix_proxy.PNG
          27 kB
        3. zabbix_proxy2.PNG
          zabbix_proxy2.PNG
          5 kB

        Activity

          People

            zabbix.dev Zabbix Development Team
            staybox Andrey Vanik
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: