List:General Discussion« Previous MessageNext Message »
From:ฐํ ฟ์มพ Date:August 23 2004 3:38am
Subject:about creation error of full text index
View as plain text  
hi, I have some problem with full text search of mysql.

I have the same problem as below articles.

http://lists.mysql.com/mysql/157526

I'm using UTF-8 encoding for CJK.

I want to know solution about this error. In my case, 

============================================================================================


mysql> use search2;
Database changed
mysql> select count(*) from pages;
+----------+
| count(*) |
+----------+
|   100498 |
+----------+
1 row in set (0.04 sec)

mysql> repair tables pages;
+---------------+--------+----------+----------+
| Table         | Op     | Msg_type | Msg_text |
+---------------+--------+----------+----------+
| search2.pages | repair | status   | OK       |
+---------------+--------+----------+----------+
1 row in set (40.27 sec)

mysql> create fulltext index index2 on pages (title,body);
Query OK, 100498 rows affected (8 min 31.49 sec)
Records: 100498  Duplicates: 0  Warnings: 0

mysql> select count(*) from pages;
ERROR 1016 (HY000): Can't open file: 'pages.MYI' (errno: 144)
mysql> repair tables pages;
+---------------+--------+----------+-------------------------------------------------+

| Table         | Op     | Msg_type | Msg_text                              
          |
+---------------+--------+----------+-------------------------------------------------+

| search2.pages | repair | error    | 121 when fixing table                 
          |
| search2.pages | repair | error    | Can't copy datafile-header to 
tempfile, error 9 |
| search2.pages | repair | status   | Operation failed                      
          |
+---------------+--------+----------+-------------------------------------------------+

3 rows in set (8 min 40.99 sec)

============================================================================================


I have tested it with mysql 4.1.3 , 5.0.0 and 5.0.1 snapshot.

I can't solve this problem.

and I report it to mysql bug report. more details. 
http://bugs.mysql.com/bug.php?id=5141

I want to know whether it is a bug or not. please help me. thanks.

Woojong Koh.

_________________________________________________________________
ํ™•์ธํ•˜์ž. ์˜ค๋Š˜์˜ ์šด์„ธ ๋ฌด๋ฃŒ ์‚ฌ์ฃผ, ๊ถํ•ฉ, ์ž‘๋ช…, ์ „์ƒ ๊ฐ€์ด๋“œ   
http://www.msn.co.kr/fortune/default.asp  

Thread
about creation error of full text indexฐํ ฟ์มพ23 Aug
  • Re: about creation error of full text indexEgor Egorov23 Aug
Re: about creation error of full text indexKoh Woojong23 Aug