about creation error of full text index

고 우종 Sun, 22 Aug 2004 20:41:13 -0700

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;
+---------------+--------+----------+-------------------------------------------------+

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

about creation error of full text index

Reply via email to