List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 17 2002 9:00pm
Subject:Re: Unable to add index
View as plain text  
Don't run myisamchk while the server is running.

Mike Lucente wrote:

>Isn't that what 'myisamchk -o' does?
>
>On Tue, 17 Sep 2002, Victor Pendleton wrote:
>
>>Mike,
>>	Erro 127 means that the table is marked as crashed. You should run a
>>check and repair if necessary.
>>	Error code 127:  Unknown error
>>	127 = Record-file is crashed
>>
>>I hope this helps.
>>
>>
>>
>>-----Original Message-----
>>From: Mike Lucente [mailto:ml@stripped]
>>Sent: Tuesday, September 17, 2002 9:00 AM
>>To: mysql@stripped
>>Subject: Unable to add index
>>
>>
>>Hello,
>>
>>I cannot add an index to one of my tables. I get the following message:
>>
>>mysql> alter table devlog add index (dt_status);
>>ERROR 1030: Got error 127 from table handler
>>
>>I've run 'myisamchk -o <table>' on the table in question.
>>
>>What should I try next?
>>
>>Version: Server version          3.23.29a-gamma
>>OS: RedHat Linux 7.2
>>
>>
>>
>>


Thread
Unable to add indexMike Lucente17 Sep
RE: Unable to add indexVictor Pendleton17 Sep
  • RE: Unable to add indexMike Lucente17 Sep
    • Re: Unable to add indexGerald Clark18 Sep