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
> |
>
+---------------+--------+----------+-------------------------------------------------+
testcase
[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
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]