How big is the index file. and what type of filesystem is it stored on? Could this be a 2G filesize limit problem?
[EMAIL PROTECTED] wrote:
Hi,
I have a mysql installed ona RedHat 7.3 machine. The problem is that I am
getting the error 127 many times. Each time I repair the table and after
some time (1-2 hours) it happens again. Any comments?
I am using the RPM shipped with Redhat 7.3.
Bellow are the logs:
Thanks in advance,
Hamid
PHPmyAdmin Error message:
Got error 127 from table handler
[root@localhost mysql]# mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.49
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 13 hours 38 min 18 sec
mysql> check table radacct;
+----------------+-------+----------+--------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------+-------+----------+--------------------------------+
| radius.radacct | check | error | Wrong bytesec: 0-0-0 at |
| | | | linkstart: 31642532 |
| radius.radacct | check | error | Corrupt |
+----------------+-------+----------+--------------------------------+
2 rows in set (10.17 sec)
mysql> repair table radacct;
+----------------+-------+----------+--------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------+-------+----------+--------------------------------+
| radius.radacct | repair| info | Wrong bytesec: 0-0-0 at |
| | | | 31642532; Skipped |
| | | | |
| radius.radacct | repair| warning |Number of rows changed from |
| | | |270419 to 270416 |
| | | | |
| radius.radacct | repair| status | OK |
+----------------+-------+----------+--------------------------------+
3 rows in set (44.40 sec)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
