-
Incident report
-
Resolution: Won't fix
-
Blocker
-
None
-
6.2.6
-
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
