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

proxy sqlite db upgrade is actually not supported

XMLWordPrintable

      See initial ZBX-8307 to get more technical details.

      At https://www.zabbix.com/documentation/3.0/manual/installation/upgrade?do=diff&rev2%5B0%5D=1457619117&rev2%5B1%5D=1457691699&difftype=sidebyside
      This sentence has been added:

      Note that with SQLite database on proxies, history data from proxies before the upgrade will be lost, because database is created anew.

      note that the last part of the sentence for me looks like that proxy itself will recreate a db file, which is not true at all:

      11278:20160415:173941.959 Starting Zabbix Proxy (active) [first_test_proxy]. Zabbix 3.0.2rc1 (revision 59377).
       11278:20160415:173941.959 **** Enabled features ****
       11278:20160415:173941.959 SNMP monitoring:        NO
       11278:20160415:173941.959 IPMI monitoring:        NO
       11278:20160415:173941.959 Web monitoring:         NO
       11278:20160415:173941.959 VMware monitoring:      NO
       11278:20160415:173941.959 ODBC:                   NO
       11278:20160415:173941.959 SSH2 support:           NO
       11278:20160415:173941.959 IPv6 support:           NO
       11278:20160415:173941.959 TLS support:            NO
       11278:20160415:173941.959 **************************
       11278:20160415:173941.959 using configuration file: /zab/bin/3.0/zabbix_proxy.conf
       11278:20160415:173941.965 The proxy does not match Zabbix database. Current database version (mandatory/optional): 02040000/02040000. Required mandatory version: 03000000.
       11278:20160415:173941.965 Zabbix does not support SQLite3 database upgrade.
      

      proxy exited here.

      Note for version 2.2 https://www.zabbix.com/documentation/2.2/manual/installation/upgrade_notes_220#new_upgrade_procedure we had:

      Automatic database upgrade for SQLite is not supported.

      but we hadn't for 2.4 doc ....

      The sentence in 3.0 must be rewritten to be technically correct.

            Unassigned Unassigned
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: