[#ZBX-25816] Proxy 7.2 fails to open a SQLite3 file

I've just upgraded a Zabbix Proxy instance from 7.0 to 7.2 on a OS Oracle Linux 9.5.

The application upgrade was successful, but when I tried to start the Proxy, it failed because it won't start the SQLite3 database file.

Here's the error:

SystemCTL:

$ sudo systemctl start zabbix-proxy.service
Job for zabbix-proxy.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-proxy.service" and "journalctl -xeu zabbix-proxy.service" for details.

Zabbix Proxy log:

42656:20241231:121203.761 Starting Zabbix Proxy (active) [pxl1sgs00021]. Zabbix 7.2.1 (revision 67f3c838b2a).
 42656:20241231:121203.761 **** Enabled features ****
 42656:20241231:121203.761 SNMP monitoring:       YES
 42656:20241231:121203.761 IPMI monitoring:       YES
 42656:20241231:121203.761 Web monitoring:        YES
 42656:20241231:121203.761 VMware monitoring:     YES
 42656:20241231:121203.761 ODBC:                  YES
 42656:20241231:121203.761 SSH support:           YES
 42656:20241231:121203.761 IPv6 support:          YES
 42656:20241231:121203.761 TLS support:           YES
 42656:20241231:121203.761 **************************
 42656:20241231:121203.761 using configuration file: /etc/zabbix/zabbix_proxy.conf
 42656:20241231:121203.762 cannot open database file "/var/lib/zabbix/zabbix_proxy.db": [2] No such file or directory
 42656:20241231:121203.762 creating database ...
 42656:20241231:121203.762 [Z3001] connection to database '/var/lib/zabbix/zabbix_proxy.db' failed: [0] unable to open database file
 42656:20241231:121203.762 cannot initialize database: cannot open database

JournalCTL:

 The job identifier is 2174.
Dec 31 12:06:58 [HOST] systemd[1]: zabbix-proxy.service: Can't open PID file /run/zabbix/zabbix_proxy.pid (yet?) after start: Operation not permitted
Dec 31 12:06:58 [HOST] systemd[1]: zabbix-proxy.service: Failed with result 'protocol'.
 Subject: Unit failed
 Defined-By: systemd
 The unit zabbix-proxy.service has entered the 'failed' state with result 'protocol'.
Dec 31 12:06:58 [HOST] systemd[1]: Failed to start Zabbix Proxy.
 Subject: A start job for unit zabbix-proxy.service has failed

Here's the main Zabbix Proxy configuration file:

Server=[ZABBIX SERVER]
Hostname=[HOSTNAME]
LogFile=/var/log/zabbix/zabbix_proxy.log
LogFileSize=10
PidFile=/run/zabbix/zabbix_proxy.pid
SocketDir=/run/zabbix
DBName=/var/lib/zabbix/zabbix_proxy.db
DBUser=zabbix
ProxyOfflineBuffer=720
ProxyBufferMode=hybrid
ProxyMemoryBufferSize=16M
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
Timeout=4
LogSlowQueries=3000
Include=/etc/zabbix/zabbix_proxy.conf.d/*.conf
Include=/etc/zabbix/zabbix_proxy.d/*.conf
StatsAllowedIP=127.0.0.1

The "/var/lib/zabbix" directory is owned by the Zabbix user and should be writable by the Proxy.

$ ls -lahd /var/lib/zabbix
drwxr-xr-x 2 zabbix zabbix 6 Dec 31 11:49 /var/lib/zabbix

I've enable debug log, but it didn't show anything meaningful.
So, I'm not sure why the Proxy won't start the SQLite3 file.

I've also tried a fresh install of the Proxy 7.2, but it also failed.

Version 7.0 works, but not 7.2

Please, any thoughts?

[ZBX-25816] Proxy 7.2 fails to open a SQLite3 file Created: 2024 Dec 31 Updated: 2025 Jan 01 Resolved: 2025 Jan 01
Status:	Closed
Project:	ZABBIX BUGS AND ISSUES
Component/s:	Proxy (P)
Affects Version/s:	7.2.0, 7.2.1
Fix Version/s:	None

[ZBX-25816] Proxy 7.2 fails to open a SQLite3 file Created: 2024 Dec 31 Updated: 2025 Jan 01 Resolved: 2025 Jan 01

SystemCTL:

Zabbix Proxy log: