MySQL Problem: Loosing MYD Files

[Daniel Geske]

Hi all,

Last night I lost three tables of my nagios MySQL database.
To be more specific, I am missing the .MYD and .MYI files of these tables:
hostretention
programmretention
programstatus
As far as I can tell, the rest of the filesystem is OK - no other files are
missing.
There are no errors logged in either the system log nor the mysql error log.
Only the nagios log file shows that it couldn't insert into one of the
tables. It filled 2 GB of diskspace by repeating this one line

Error: Could not insert retention data for host 'GWbrodos' in table
'hostretention'

for 2 hours. That started at 18:01.
Then, the log suddenly ends at 20:13. Nagios' pid file still exists, so I
guess it crashed for some reason.
My other monitoring server reported that the root partition of the
problematic nagios server got filled up with some data at a rate of
350MB/min. The hard drive should have been totally full around 19:00. At
19:50, however, the huge file was gone, the hard drive space reported OK.
Then, at 20:13, The nagios log ends in the middle of an entry, looks like
this:

Error: Could not insert retention data for host '

That's all I know.
I'm running nagios 1.0 and MySQl 3.23.44-Max on a SuSE 7.3 Pro Linux.

If anybody had similar problems, like loosing certain files belonging to
nagios tables, or has ideas about what's going on or how to fix the problem,
I'd be happy to hear from you.

Thank you!

Sincerely

Daniel Geske



-------------------------------------------------------
This SF.net email is sponsored by: Scholarships for Techies!
Can't afford IT training? All 2003 ictp students receive scholarships.
Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
www.ictp.com/training/sourceforge.asp
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null