Re: frecvent table corruption

2004-08-25 Thread Egor Egorov 
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? 





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

RE: frecvent table corruption

2004-08-25 Thread adam 

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

frecvent table corruption

2004-08-24 Thread adam 
Hello.

 

My company is using mysql as a backed to Bugzilla.

 

However, recently, as the number of users that are logging bugs increased we
are experiencing frequent table corruption and loss of data. 

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. 

 

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.

 

Is this a bug? How exactly do we fix this, with a patch?

 

Regards,Alex