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
