MySQL Problem: Loosing MYD Files

[Michael Loftis]

I'd suspect your kernel, 2.4.10 was in the middle of the VM subsystem 
changeover crap and not exactly stable.  Get a recent kernel as possible 
(2.4.18 or later, atleast 2.4.12).

>From your description the rest of the hardware looks fine and shouldn't 
have any problems.  I'd also go snag a copy of memtest86 3.0 and run that 
on it for a pass or so and see if it crops up any bad RAM.

I seem to remember something about some VIA chipset or another but at 
nearly 4AM here the details totally escape me.

You sure though there wasn't any user error, no crashes? (prior to noticing 
the problems that is)  -- try the kernel upgrade and a quick check of the 
memory.

--On Wednesday, February 26, 2003 12:35 PM +0100 Daniel Geske 
<daniel.geske at yoc.de> wrote:

> fs: ext2
> Intel MultiProcessor Specification v1.4, I/O APIC #2 v. 17
> 1 Processor: Intel P3/1.2GHz
> IDE: VIA vt82c686b rev. 40
> hda (disk where error occured): WDC WD200EB
> SCSI: Promise FastTrak 1X2 Miror/RAID1 rev. 1.10
> linux kernel: 2.4.10-4GB i686
>
> -----Original Message-----
> From: Michael Loftis [mailto:mloftis at wgops.com]
> Sent: Wednesday, February 26, 2003 12:23 PM
> To: Daniel Geske; nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] MySQL Problem: Loosing MYD Files
>
>
> 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