[ZBX-5240] server shuts down if housekeeper can not access the db Created: 2012 Jun 25  Updated: 2017 May 30  Resolved: 2012 Aug 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 2.0.0
Fix Version/s: 2.0.3rc1, 2.1.0

Type: Incident report Priority: Major
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: crash, database, housekeeper
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

when a db disappears, server works for a while, trying to survive. that succeeds, but then housekeeper starts, can not connect to the db & dies

5148:20120619:104339.372 server #16 started housekeeper #1
5131:20120619:104339.377 server #0 started [main process]
...
5157:20120625:125317.955 Sending configuration data to proxy 'proxy.company.local'. Datalen 28616
5134:20120625:125413.663 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5134:20120625:125413.663 watchdog: database is down
5134:20120625:125527.660 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5134:20120625:125527.660 watchdog: database is down
5134:20120625:125641.658 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5134:20120625:125641.658 watchdog: database is down
5134:20120625:125755.655 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5134:20120625:125755.655 watchdog: database is down
5157:20120625:125817.433 Sending configuration data to proxy 'proxy.company.local'. Datalen 28616
5134:20120625:125909.653 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5134:20120625:125909.653 watchdog: database is down
5148:20120625:125932.691 executing housekeeper
5148:20120625:125946.652 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5148:20120625:125946.652 Cannot connect to the database. Exiting...
5131:20120625:125946.653 One child process died (PID:5148,exitcode/signal:255). Exiting ...
5131:20120625:130002.651 [Z3001] connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'mysql.company.local' (1)
5131:20120625:130002.651 Cannot connect to the database. Exiting...

related question : how does proxy data sending work in this case ? is it present in server config cache ?
is it the same for active and passive proxies (this one is passive) ?

 Comments   
Comment by Andris Mednis [ 2012 Aug 23 ]

Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-5240

Comment by dimir [ 2012 Aug 28 ]

Successfully tested. The MySQL error

[2005] Unknown MySQL server host

is handled properly. Please review my small logging and code formatting changes in proxy housekeeper (r29911).

<Andris>Thanks for testing! I reviewed your changes and agree.

Comment by Andris Mednis [ 2012 Aug 29 ]

Fixed in versions pre-2.0.3 rev. 29915 and pre-2.1.0 rev.29916.

Generated at Tue Apr 23 12:07:54 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.