Zabbix 1.5.2 - Zabbix server dies when DB goes down

[ataylo13]

I have been working on the database (tuning) and each time I shutdown the database the zabbix_server process dies. Is there anyway to keep that from happening?

[Alexei]

What database do you use?

[ataylo13]

mysql 4.1.20-2 for RHEL 4

[BenP]

What database do you use?

Hi,

I've got same problem with stable 1.4.5 version.
Running mysql 5.0.51a-3ubuntu5 on another server, when it crash, after a couple time zabbix-server follow.

I'm obliged to restart manually zabbix-server when my BD goes up again.

I'm able to make some tests if asked.

Regards

--
Ben

[Clubbavich]

Same problem here. Do you think there might be an easy way to start a script when zabbix is about to go offline, that tries to start the service back up once every 30 seconds or so, until the DB comes back up?

Here's what I get in my logfile...

3866:20090210:114500 Executing housekeeper
3869:20090210:114602 [Z3001] Connection to database 'zabbix' failed: [2005] Unknown MySQL server host 'thesqlserver' (2)
3852:20090210:114602 One child process died. Exiting ...
3852:20090210:114619 ZABBIX Server stopped. ZABBIX 1.6.2.

I replaced my sql server's name with 'thesqlserver', but other than that, my system works fine as it is configured (We lost IP connectivity to the SQL server earlier today...which caused this)

[BenP]

Hi Clubbavich,

Do you think there might be an easy way to start a script when zabbix is about to go offline, that tries to start the service back up once every 30 seconds or so, until the DB comes back up?

zabbix 1.4.6 use that command line to check itself :
(exec("ps -ef|grep zabbix_server|grep -v grep|wc -l")>0) || (exec("ps -ax|grep zabbix_server|grep -v grep|wc -l")>0)

That will be enough for a cron script!

Regards