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

zabbix-proxy-sqlite3 failing to create database due to out of memory

XMLWordPrintable

    • S24-W50/51/52
    • 1

      Steps to reproduce:

      1. proxy was running 7.0.6r1 without any issues
      2. did an rpm upgrade

      Result:

      seeing this in the logs:

       

       24463:20241210:192937.080 using configuration file: /etc/zabbix/zabbix_proxy.conf
       24463:20241210:192937.089 The proxy does not match Zabbix database. Current database version (mandatory/optional): 07000000/07000015. Required mandatory version: 07020000.
       24463:20241210:192937.089 Zabbix does not support SQLite3 database upgrade.
       24463:20241210:192937.089 removing database file: "/ebs/var/lib/sqlite/zabbix.db"
       24463:20241210:192937.090 === Backtrace: ===
       24463:20241210:192937.091 8: /usr/sbin/zabbix_proxy(zbx_backtrace+0x41) [0x5608c643e461]
       24463:20241210:192937.091 7: /usr/sbin/zabbix_proxy(zbx_db_close+0x4e) [0x5608c643342e]
       24463:20241210:192937.091 6: /usr/sbin/zabbix_proxy(+0x9b0c2) [0x5608c624d0c2]
       24463:20241210:192937.091 5: /usr/sbin/zabbix_proxy(MAIN_ZABBIX_ENTRY+0xb2a) [0x5608c624dd1a]
       24463:20241210:192937.091 4: /usr/sbin/zabbix_proxy(zbx_daemon_start+0x13f) [0x5608c644094f]
       24463:20241210:192937.091 3: /usr/sbin/zabbix_proxy(main+0x3d8) [0x5608c623f6d8]
       24463:20241210:192937.091 2: /lib64/libc.so.6(+0x3feb0) [0x7eff42a3feb0]
       24463:20241210:192937.091 1: /lib64/libc.so.6(__libc_start_main+0x80) [0x7eff42a3ff60]
       24463:20241210:192937.091 0: /usr/sbin/zabbix_proxy(_start+0x25) [0x5608c6246a75]
      zabbix_proxy [24463]: ERROR [file and function: <dbconn_compat.c,zbx_db_close>, revision:626558708cc, line:64] Something unexpected has just happened.
       24463:20241210:192937.091 cannot open database file "/ebs/var/lib/sqlite/zabbix.db": [2] No such file or directory
       24463:20241210:192937.091 creating database ...
       24463:20241210:192937.091 [Z3001] connection to database '/ebs/var/lib/sqlite/zabbix.db' failed: [0] unable to open database file
       24463:20241210:192937.091 [Z3002] cannot create database '/ebs/var/lib/sqlite/zabbix.db': [0] out of memory
       24463:20241210:192937.091 cannot initialize database: cannot open database
       24526:20241210:192949.234 Starting Zabbix Proxy (active) [hostname_redactred]. Zabbix 7.2.0 (revision 626558708cc).
       24526:20241210:192949.234 **** Enabled features ****
       24526:20241210:192949.234 SNMP monitoring:       YES
       24526:20241210:192949.234 IPMI monitoring:        NO
       24526:20241210:192949.234 Web monitoring:        YES
       24526:20241210:192949.234 VMware monitoring:     YES
       24526:20241210:192949.234 ODBC:                  YES
       24526:20241210:192949.234 SSH support:           YES
       24526:20241210:192949.234 IPv6 support:          YES
       24526:20241210:192949.234 TLS support:           YES
       24526:20241210:192949.234 **************************
       24526:20241210:192949.234 using configuration file: /etc/zabbix/zabbix_proxy.conf
       24526:20241210:192949.235 cannot open database file "/ebs/var/lib/sqlite/zabbix.db": [2] No such file or directory
       24526:20241210:192949.235 creating database ...
       24526:20241210:192949.235 [Z3001] connection to database '/ebs/var/lib/sqlite/zabbix.db' failed: [0] unable to open database file
       24526:20241210:192949.235 [Z3002] cannot create database '/ebs/var/lib/sqlite/zabbix.db': [0] out of memory
       24526:20241210:192949.235 cannot initialize database: cannot open database

       

      config file:

       

      Server=server_redacted
      Hostname=hostname_redacted
      LogFile=/var/log/zabbix/zabbix_proxy.log
      LogFileSize=0
      PidFile=/var/run/zabbix/zabbix_proxy.pid
      SocketDir=/var/run/zabbix
      DBName=/ebs/var/lib/sqlite/zabbix.db
      DBUser=
      DBPassword=
      StartPollers=12
      StartIPMIPollers=0
      StartPreprocessors=3
      StartPollersUnreachable=10
      StartTrappers=5
      StartPingers=20
      StartDiscoverers=1
      StartHTTPPollers=12
      JavaGateway=127.0.0.1
      JavaGatewayPort=10052
      StartJavaPollers=5
      SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
      HistoryCacheSize=8M
      Timeout=15
      ExternalScripts=/usr/lib/zabbix/externalscripts
      LogSlowQueries=3000
      TLSConnect=unencrypted

       

       

      See log file...
      See memory dump...
      Expected:
      See screenshot....
      See attached patch file...

            dgoloscapov Dmitrijs Goloscapovs
            bunkzilla bunkzilla
            Team B
            Votes:
            3 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 4h
                4h