Re: Fulltext creation on 4.1: ERROR 1034

[Kurt Haegeman]

Hi Eli,

Eli Hen wrote:

"Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
 

Sergei Golubchik wrote:

   

Hi!

On Jan 13, Kurt Haegeman wrote:

     

Hi,

When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table

       

Hi Sergei,

alter table articles
add fulltext( text );
After several hours of processing, the error below is generated.

Regards,
Kurt.
   

Did you try to check the table using myisamcheck or "CHECK TABLE articles;"
???
It might be that your table is corrupted..
 

mysql> alter table articles
   -> add fulltext( text );
ERROR 1034 (HY000): 121 when fixing table
mysql> check table articles;
+---------------+-------+----------+----------+
| Table         | Op    | Msg_type | Msg_text |
+---------------+-------+----------+----------+
| test.articles | check | status   | OK       |
+---------------+-------+----------+----------+
1 row in set (8 min 33.00 sec)
That's not it, at first sight.

Regards,
Kurt.