Re: about creation error of full text index

[Koh Woojong]

I think that it is not a OS problem or mysql built.
I tested it in many version of mysql and I created the records from web by 
crawling.

so whenever I test, the records are NEW. but the same error must occur to.
I think it is so curious that it makes no error in small scale tables.
I think  there is a specific problem-make record. but I can't distinguish 
it from a gigabytes table.

http://bugs.mysql.com/bug.php?id=5141
in this page, I write the url which can download the sample table. thanks 
for your answering.

Woojong Koh

From: Egor Egorov <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: about creation error of full text index
Date: Mon, 23 Aug 2004 14:57:43 +0300
고 우종 <[EMAIL PROTECTED]> wrote:
> 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
>          |
> 
+---------------+--------+----------+-------------------------------------------------+

[EMAIL PROTECTED] egor]$ perror 9
Error code   9:  Bad file descriptor
Are you sure this is not a problem with your OS and/or MySQL build?
This may be a MySQL error in which case I will ask you to prepare a 
testcase
for us to fix the bug.


--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
상큼한 만남과 따뜻한 공동체 생활...  지금 MSN 커뮤니티에서 시작하세요!   
http://groups.msn.com/?pgmarket=ko-kr  

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