-----Original Message-----
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: frecvent table corruption
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT query FROM namedqueries WHERE userid = 4 AND name = '(Default
> query)': Got error 127 from table handler at globals.pl line 276. "
[EMAIL PROTECTED] egor]$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
> After repairing the table by using the mysql Control Center we lose lots
of
> data, even 60% of it.
>
>
>
> The mysql version is 4.0.18 installed on Red Hat.
Abnormal situation. What MySQL version is installed on Red Hat? The Red Hat
build or MySQL build or your own build?
It is the binary mysql build , from the following archive:
mysql-standard-4.0.18-pc-linux-i686.tar.gz
I have actually looked at some of the possible causes and eliminated the
following:
-the disk space is sufficient
-the mysql server never crased, it has been running for oover
100 days.
Also, I am using MyIsam table with the skip-locking option, because we only
have one mysld instance.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
