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

Fresh Zabbix-proxy database error when received configuration

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 6.2.5
    • 6.2.6rc1, 6.4 (plan)
    • Proxy (P)
    • None
    • Ubuntu 22.04
      postgresql-14 (14.6-1.pgdg22.04+1)
      zabbix-proxy-pgsql (1:6.2.5-1+ubuntu22.0)
    • Team A
    • Sprint 95 (Dec 2022)
    • 0.25

    Description

      Steps to reproduce:

      1. Create new database
      2. insert proxy.sql
        cat /usr/share/zabbix-sql-scripts/postgresql/proxy.sql | sudo -u zabbix psql zabbix_proxy
        
      3. Add proxy to Zabbix
      4. Add host to proxy

      Result:

      1048931:20221129:121044.399 received configuration data from server at "xxx.xx.xx.xx", datalen 23160
      1048931:20221129:121044.438 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "regexpid" of relation "hstgrp" does not exist
      LINE 1: update hstgrp set regexpid='#'||groupid where groupid=5
                                ^
       [update hstgrp set regexpid='#'||groupid where groupid=5]
      1048931:20221129:121044.438 failed to update local proxy configuration copy: database error

      Expected:
      Host added to proxy (database) without error

      Attachments

        Issue Links

          Activity

            People

              wiper Andris Zeila
              Homeserv Robbert Vercammen
              Votes:
              4 Vote for this issue
              Watchers:
              17 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: