[ZBX-10669] proxy sqlite db upgrade is actually not supported Created: 2016 Apr 15  Updated: 2022 Aug 17  Resolved: 2016 May 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Documentation (D)
Affects Version/s: 3.0.0
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Oleksii Zagorskyi Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: dbpatches, sqlite, upgrade
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates ZBXNEXT-6181 Zabbix Proxy should drop SQLite Datab... Closed

 Description   

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.

 Comments   
Comment by Oleksii Zagorskyi [ 2016 Apr 15 ]

The sentence has been replaced to:

Note that with SQLite database on proxies, history data from proxies before the upgrade will be lost, because SQLite database upgrade is not supported and SQLite database file has to be manually removed. When proxy is started first time and SQLite database file is missing, proxy creates it automatically.

Order of other sentences was changed a bit, for better structure.
After review should be replicated to 3.2
RESOLVED.

martins-v Reviewed and replicated to 3.2.

zalex_ua Great, CLOSED.

Comment by Oleksii Zagorskyi [ 2016 Apr 15 ]

(1)
also, I don't like "Note that database upgrade to version 3.0 may take a long time." part, because actually it's not true.
Upgrade from 2.2 and 2.4 usually takes 2-10 minutes in production, which is not long time.
Such sentence would be good and technically correct for 3.2 upgrade.

Consider to rewrite it please.

martins-v I've removed this sentence for 3.0 version. It remains with 3.2 documentation. RESOLVED

zalex_ua Thanks, CLOSED.

Generated at Sat Apr 20 16:59:02 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.