[ZBX-25757] Cannot create SQLite3 database in Zabbix Proxy 7.2: out of memory Created: 2024 Dec 17  Updated: 2024 Dec 17  Resolved: 2024 Dec 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Martin Alstrup Assignee: Zabbix Development Team
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Docker


Issue Links:
Duplicate
duplicates ZBX-25722 zabbix-proxy-sqlite3 failing to creat... Closed

 Description   

I switched my lab proxy from using MySQL to using SQLite3, and it now fails to start the proxy:

Starting Zabbix Proxy (active) [xepcoss01]. Zabbix 7.2.0 (revision 6265587).
Press Ctrl+C to exit.     1:20241217:165504.851 Starting Zabbix Proxy (active) [xepcoss01]. Zabbix 7.2.0 (revision 6265587).
     1:20241217:165504.851 **** Enabled features ****
     1:20241217:165504.851 SNMP monitoring:       YES
     1:20241217:165504.851 IPMI monitoring:       YES
     1:20241217:165504.851 Web monitoring:        YES
     1:20241217:165504.851 VMware monitoring:     YES
     1:20241217:165504.851 ODBC:                  YES
     1:20241217:165504.851 SSH support:           YES
     1:20241217:165504.851 IPv6 support:          YES
     1:20241217:165504.851 TLS support:           YES
     1:20241217:165504.851 **************************
     1:20241217:165504.851 using configuration file: /etc/zabbix/zabbix_proxy.conf     1:20241217:165504.851 cannot open database file "/var/lib/zabbix/db_data/xepcoss01.sqlite": [2] No such file or directory
     1:20241217:165504.851 creating database ...
     1:20241217:165504.851 [Z3001] connection to database '/var/lib/zabbix/db_data/xepcoss01.sqlite' failed: [0] unable to open database file
     1:20241217:165504.851 [Z3002] cannot create database '/var/lib/zabbix/db_data/xepcoss01.sqlite': [0] out of memory
     1:20241217:165504.851 cannot initialize database: cannot open database 

I'm running the proxy with this configuration:

ZBX_PROXYBUFFERMODE=hybrid
ZBX_PROXYMEMORYBUFFERSIZE=512M

I tried running a lot of different settings, but nothing seems to work. The VM this runs on has plenty of resources (8GB RAM) and uses barely 300MB.

I tried mounting a volume to `/var/lib/zabbix/db_data` ensuring it has write access

When Googling I found some issues on this board, but they seem to have been moved.

What can I do?



 Comments   
Comment by Alexander Vladishev [ 2024 Dec 17 ]

Closed as duplicate of ZBX-25722. Please follow updates there.

Generated at Sun Dec 14 00:07:14 EET 2025 using Jira 10.3.13#10030013-sha1:56dd970ae30ebfeda3a697d25be1f6388b68a422.