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 <egor.egorov@stripped>
>To: mysql@stripped
>Subject: Re: about creation error of full text index
>Date: Mon, 23 Aug 2004 14:57:43 +0300
>
>고 우종 <j_strane@stripped> 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
> > |
> >
+---------------+--------+----------+-------------------------------------------------+
>
>
>[egor@blend 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
> / /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
>/_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=1
>
_________________________________________________________________
상큼한 만남과 따뜻한 공동체 생활... 지금 MSN 커뮤니티에서
시작하세요!
http://groups.msn.com/?pgmarket=ko-kr
