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

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

      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

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

              Created:
              Updated:
              Resolved: