[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. |
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: 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. |