[ZBX-8902] No database recovery message at DebugLevel=2 Created: 2014 Oct 14  Updated: 2017 May 30  Resolved: 2015 Aug 19

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 2.4.1, 2.5.0
Fix Version/s: 2.5.0

Type: Incident report Priority: Trivial
Reporter: Filipp Sudanov (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: database, db, logging
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

If case of DebugLevel=3 each process writes something like this to the log:

  2671:20141014:142720.613 [Z3005] query failed: [2006] MySQL server has gone away [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_key_password,t.verify_peer,t.verify_host from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1413286040 and mod(t.httptestid,1)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  2671:20141014:142720.613 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  2671:20141014:142720.614 database is down: reconnecting in 10 seconds
  ...
  2671:20141014:142730.614 database connection re-established

So we see when it failed and when it recovered.

In case of DebugLevel=2 the outpus it the following:

  3426:20141014:152450.077 [Z3005] query failed: [2006] MySQL server has gone away [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=24900]
  3426:20141014:152450.077 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

and there is no messages that would inform about sucessfull reconnection.



 Comments   
Comment by Glebs Ivanovskis (Inactive) [ 2015 Jul 20 ]

Fixed for 2.5.0(trunk) in development branch svn://svn.zabbix.com/branches/dev/ZBX-8902 in revision 54461.
Messages 'database is down...' and 'database connection re-established' were elevated to the DebugLevel=2.

Comment by Glebs Ivanovskis (Inactive) [ 2015 Jul 20 ]

(1) Corresponding changes should be made in sections "What's new" and "Upgrade notes".

glebs.ivanovskis In What's new section added description in a separate subsection under Daemon improvements section:
https://www.zabbix.com/documentation/3.0/manual/introduction/whatsnew300#database_recovery_message_on_debuglevel_2#database_recovery_message_on_debuglevel_2
Added description to Upgrade notes:
https://www.zabbix.com/documentation/3.0/manual/installation/upgrade_notes_300
RESOLVED

wiper CLOSED

Comment by Andris Zeila [ 2015 Jul 29 ]

Successfully tested

Comment by Glebs Ivanovskis (Inactive) [ 2015 Aug 12 ]

Fixed in pre-2.5.0 (trunk) r54869.

Generated at Wed Apr 24 05:03:04 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.