[ZBX-8152] missing explanation in server log of optional DB patching Created: 2014 Apr 25  Updated: 2017 May 30  Resolved: 2014 May 14

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 2.2.3
Fix Version/s: 2.2.4rc1, 2.3.0

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


 Description   

See first comment.



 Comments   
Comment by Oleksii Zagorskyi [ 2014 Apr 25 ]

When start zabbix server 2.2.3 first time after 2.2.1-2 we can see these lines:

42771:20140422:145007.735 Starting Zabbix Server. Zabbix 2.2.3 (revision 44105).
42771:20140422:145007.735 ****** Enabled features ******
42771:20140422:145007.735 SNMP monitoring:           YES
42771:20140422:145007.735 IPMI monitoring:           YES
42771:20140422:145007.735 WEB monitoring:            YES
42771:20140422:145007.735 VMware monitoring:         YES
42771:20140422:145007.735 Jabber notifications:      YES
42771:20140422:145007.735 Ez Texting notifications:  YES
42771:20140422:145007.735 ODBC:                       NO
42771:20140422:145007.735 SSH2 support:              YES
42771:20140422:145007.736 IPv6 support:               NO
42771:20140422:145007.736 ******************************
42771:20140422:145007.736 using configuration file: /etc/zabbix/zabbix_server.conf
42771:20140422:145007.748 current database version (mandatory/optional): 02020000/02020000
42771:20140422:145007.748 required mandatory version: 02020000
42771:20140422:145007.748 starting automatic database upgrade
42771:20140422:145007.762 completed 100% of database upgrade
42771:20140422:145007.762 database upgrade fully completed

Next 2.2.3 runs will show:

42973:20140422:145138.315 Starting Zabbix Server. Zabbix 2.2.3 (revision 44105).
42973:20140422:145138.315 ****** Enabled features ******
42973:20140422:145138.316 SNMP monitoring:           YES
42973:20140422:145138.316 IPMI monitoring:           YES
42973:20140422:145138.316 WEB monitoring:            YES
42973:20140422:145138.316 VMware monitoring:         YES
42973:20140422:145138.316 Jabber notifications:      YES
42973:20140422:145138.316 Ez Texting notifications:  YES
42973:20140422:145138.316 ODBC:                       NO
42973:20140422:145138.316 SSH2 support:              YES
42973:20140422:145138.316 IPv6 support:               NO
42973:20140422:145138.316 ******************************
42973:20140422:145138.316 using configuration file: /etc/zabbix/zabbix_server.conf
42973:20140422:145138.347 current database version (mandatory/optional): 02020000/02020001
42973:20140422:145138.347 required mandatory version: 02020000

It's not clear why required mandatory version matches with current DB version but some automatic DB upgrade being performed.
If investigate it appear to be an optional 2020001 patch.

Suggestion: to be more user friendly would be good to mention that there available optional patch(es). Log something like:

required mandatory version: 02020000
available optional version: 02020001

p.s. the patch introduced in ZBX-7849 for 2.2.3

Comment by Juris Miščenko (Inactive) [ 2014 May 13 ]

Fixes implemented in svn://svn.zabbix.com/branches/dev/ZBX-8152-2_2 for 2.2 and svn://svn.zabbix.com/branches/dev/ZBX-8152 for trunk.

Comment by Oleksii Zagorskyi [ 2014 May 13 ]

I see new log message:
"%d optional patch(es) were found"

Just wanted to say that I'd replace it with:
"%d optional patches were found"

sasha I think it is not important how many patches are found. I vote for:

"optional patches were found" without number of patches.

42771:20140422:145007.748 current database version (mandatory/optional): 02020000/02020000
42771:20140422:145007.748 required mandatory version: 02020000
42771:20140422:145007.748 optional patches were found                      <-- new line
42771:20140422:145007.748 starting automatic database upgrade
42771:20140422:145007.762 completed 100% of database upgrade
42771:20140422:145007.762 database upgrade fully completed
Comment by Juris Miščenko (Inactive) [ 2014 May 14 ]

Implemented in 2.2.4rc1 r45505, 2.3.0 (trunk) r45511

Generated at Sat Apr 20 00:11:44 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.