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

[Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: column "name_upper" of relation "items" does not exist

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • None
    • 6.2.6
    • Proxy (P)
    • Linux 5.14.21-150400.24.38-default #1 SMP PREEMPT_DYNAMIC Fri Dec 9 09:29:22 UTC 2022 (e9c5676) x86_64 x86_64 x86_64 GNU/Linux, cpe:/o:suse:sles:15:sp4, zabbix-proxy-pgsql-6.2.6-release1.sles15, postgresql14-server-14.6-150200.5.20.2
    • Sprint 96 (Jan 2023)

      Steps to reproduce / Result:

      After Zabbix server and all Zabbix proxies has been updated from 6.2.4 to 6.2.6, we get the following error message on all Zabbix proxies.

      Surprisingly, this only occurs with newly created hosts. Existing hosts still seem to work. As long as they are apparently still kept in the local proxy database. However, as soon as a new host is created via autoregistration, this error occurs and the new host cannot be monitored.

      Restarting Zabbix server and Zabbix proxy did not help. All components are running on 6.2.6 and have been restarted.

        7994:20230105:123623.345 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "name_upper" of relation "hosts" does not exist
      LINE 1: update hosts set name_upper=upper(name)
                               ^
      QUERY:  update hosts set name_upper=upper(name)
      where hostid=new.hostid
      CONTEXT:  PL/pgSQL function hosts_name_upper_upper() line 3 at SQL statement
       [insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk) values (13520,'aaa.example.com',0,-1,2,'','','AAA',2,2,'','','foobar','ffffffff'),(13521,'bbb.example.com',0,-1,2,'','','BBB',2,2,'','','foobar','ffffffff');
      ]
        7994:20230105:123623.346 failed to update local proxy configuration copy: database error
        8001:20230105:123629.656 cannot send list of active checks to "10.0.0.1": host [aaa.example.com] not found
        7998:20230105:123929.487 cannot send list of active checks to "10.0.0.2": host [bbb.example.com] not found
       

        1. zabbix_proxy.log
          6 kB
        2. postgresql.log
          274 kB
        3. describe_hosts.txt
          8 kB
        4. describe_all.txt
          1020 kB

            dgoloscapov Dmitrijs Goloscapovs
            Taikocuya Marcel Renner
            Team A
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: