-
Type:
Problem report
-
Resolution: Won't fix
-
Priority:
Blocker
-
None
-
Affects Version/s: 6.4.3
-
Component/s: Proxy (P), Server (S)
-
None
-
Environment:Rocky Linux 9.1
Zabbix 6.4.3
1 App VM - 2 CPU, 4GB RAM
1 Proxy VM - 1 CPU, 4GB RAM - Active Proxy
2 Web VM - 2 CPU, 4GB RAM
3 DB VM - PostgreSQL 15, TimescaleDB 2.11
-
Support backlog
Background
We recently migrated from MySQL 8.x to PostgreSQL 15 + TimescaleDB 2.11, everything appears to have gone as planned with the migration. We also upgraded from Zabbix 6.2.9 to Zabbix 6.4.3. I have tried with HA cluster enabled as well and the problem exists under HA and standalone.
Steps to reproduce:
- Create a new host via Zabbix ansible collection using Zabbix API
- Observe that new host is visible in Zabbix UI
- Watch proxy log to make sure configuration data was received from the server, datalen is very small
- Observe errors in the logs on the proxy about not being able to find the PSK
- Log in to the sqlite3 db on the proxy, query hosts table and observe that the new host is not present
- Restart zabbix-server process
- Watch proxy log to make sure new configuration is updated, datalen is very big
- Log in to sqlite3 db on the proxy, query hosts table, observe new host is now present
Expected:
Expected that new hosts will be pushed to proxies without having to restart zabbix-server
Server Configuration
AlertScriptsPath=/usr/lib/zabbix/alertscripts
AllowRoot=0
AllowUnsupportedDBVersions=0
CacheSize=128M
CacheUpdateFrequency=60
DBHost=192.168.4.131
DBName=zabbix
DBPassword=<password>
DBPort=5000
DBUser=zabbix
DebugLevel=3
ExportFileSize=1G
ExternalScripts=/usr/lib/zabbix/externalscripts
Fping6Location=/usr/sbin/fping6
FpingLocation=/usr/sbin/fping
HistoryStorageDateIndex=0
HistoryStorageTypes=uint,dbl,str,log,text
HousekeepingFrequency=1
Include=/etc/zabbix/zabbix_server.conf.d
JavaGatewayPort=10052
ListenPort=10051
LoadModulePath=${libdir}/modules
LogFile=/var/log/zabbix/zabbix_server.log
LogFileSize=10
LogSlowQueries=0
LogType=file
MaxHousekeeperDelete=500
PidFile=/var/run/zabbix/zabbix_server.pid
ProxyConfigFrequency=300
ProxyDataFrequency=1
SNMPTrapperFile=/tmp/zabbix_traps.tmp
SocketDir=/var/run/zabbix
SSLCertLocation=${datadir}/zabbix/ssl/certs
SSLKeyLocation=${datadir}/zabbix/ssl/keys
StartDBSyncers=4
StartDiscoverers=1
StartEscalators=1
StartHistoryPollers=5
StartHTTPPollers=1
StartIPMIPollers=0
StartJavaPollers=0
StartLLDProcessors=2
StartODBCPollers=1
StartPingers=1
StartPollers=5
StartPollersUnreachable=1
StartPreprocessors=3
StartProxyPollers=1
StartReportWriters=0
StartSNMPTrapper=0
StartTimers=1
StartTrappers=5
StartVMwareCollectors=0
Timeout=3
TmpDir=/tmp
TrapperTimeout=300
UnavailableDelay=60
UnreachableDelay=15
UnreachablePeriod=45
User=zabbix
ValueCacheSize=128M
VaultURL=https://127.0.0.1:8200
VMwareFrequency=60
VMwarePerfFrequency=60
VMwareTimeout=10
Proxy Configuration
AllowRoot=0 AllowUnsupportedDBVersions=0 CacheSize=128M ConfigFrequency=60 DataSenderFrequency=1 DBHost=localhost DBName=/var/lib/zabbix/zabbix_proxy.db DBPassword=zabbix_proxy DBUser=zabbix_proxy DebugLevel=3 EnableRemoteCommands=1 ExternalScripts=/usr/lib/zabbix/externalscripts Fping6Location=/usr/sbin/fping6 FpingLocation=/usr/sbin/fping HistoryCacheSize=8M HistoryIndexCacheSize=4M Hostname=dev-zabbix-proxy-1.dev.internal HousekeepingFrequency=1 Include=/etc/zabbix/zabbix_proxy.conf.d JavaGatewayPort=10052 ListenPort=10051 LoadModulePath=/usr/lib/zabbix/modules LogFile=/var/log/zabbix/zabbix_proxy.log LogFileSize=10 LogRemoteCommands=1 LogType=file PidFile=/var/run/zabbix/zabbix_proxy.pid ProxyLocalBuffer=0 ProxyOfflineBuffer=96 Server=192.168.5.13 SNMPTrapperFile=/var/lib/zabbix/snmptraps/snmptraps.log SocketDir=/var/run/zabbix StartDBSyncers=4 StartDiscoverers=1 StartHTTPPollers=1 StartIPMIPollers=1 StartODBCPollers=1 StartPingers=1 StartPollers=20 StartPollersUnreachable=3 StartPreprocessors=3 StartSNMPTrapper=1 StartTrappers=10 StatsAllowedIP=127.0.0.1 Timeout=10 TLSConnect=psk TLSPSKFile=/etc/zabbix/tls_psk_proxy.secret TLSPSKIdentity=PSK : dev-zabbix-proxy-1 TmpDir=/tmp TrapperTimeout=300 UnreachablePeriod=45 VaultURL=https://127.0.0.1:8200 VMwareCacheSize=8M VMwareFrequency=60
Possible related ticket: ZBX-22657
