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

Cannot create SQLite3 database in Zabbix Proxy 7.2: out of memory

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • None
    • Docker

      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?

            zabbix.dev Zabbix Development Team
            maals Martin Alstrup
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: