MySQL Problem: Loosing MYD Files

[Michael Loftis]

Filesystem (ext3, reiser)?  Hardware (SMP, Athlon, Itanium, IDE, SCSI, RAID 
controller)?   Kernel version (uname -a)?

--On Wednesday, February 26, 2003 11:53 AM +0100 Daniel Geske 
<daniel.geske at yoc.de> wrote:

> 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




-------------------------------------------------------
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