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