DATABASE Backend stop

[gfesj69]

Hi, we are running Nagios XI 2012 R2.9 VMWare downloaded from Nagios!

We use offloading MySQL, but we have some problems at ~ 2:00. Nagios restart mySQL but for some reason it stop and not return. I have to login at the machine and start mysql manualy.

Here is the MySQL log...

Code: Select all

140525  1:56:42 [Note] /usr/libexec/mysqld: Normal shutdown

140525  1:56:47 [Note] Event Scheduler: Purging the queue. 0 events
140525  1:58:31  InnoDB: Starting shutdown...
140525  1:59:48  InnoDB: Shutdown completed; log sequence number 0 44243
140525  1:59:48 [Note] /usr/libexec/mysqld: Shutdown complete

140525 01:59:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140525 02:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140525  2:46:30  InnoDB: Initializing buffer pool, size = 8.0M
140525  2:46:30  InnoDB: Completed initialization of buffer pool
140525  2:46:30  InnoDB: Started; log sequence number 0 44243
140525  2:46:30 [Note] Event Scheduler: Loaded 0 events
140525  2:46:30 [Note] /usr/libexec/mysqld: ready for connections.

Best Regards

Geraldo

[scottwilkerson]

this final line looks like mysqld returned

Code: Select all

/usr/libexec/mysqld: ready for connections.

What problems are you experiencing?

[gfesj69]

Nagios dont responde, when we call the URL the screen appears blank!

[scottwilkerson]

Can you give us the output of the following

Code: Select all

df -h
df -i
service postgresql status

thanks

[gfesj69]

I do not have this info. I will get this info next time that we have this problem.

Thank you

[slansing]

How did you resolve the problem? By just manually starting mysql as you mentioned in the first post? Has this occurred multiple times recently? You are not running mysql locally correct? This is happening on the server with the offloaded DB? It sounds like postgres/apache might be having issues as well, depending on what pages were blank, and what you were able to access (if anything at all) in the web interface.

Let us know if this happens again, and provide the output of those commands Scott mentioned, thanks!

[gfesj69]

I solve the problem just restart the mysqld at the remote machine

Code: Select all

service mysqld restart

Yes I am running Nagios XI / offload MySQL. It happens 2 times this month.

Thanks