[EMAIL PROTECTED] wrote:
>>Description:
>
> The included sql test script (output of mysqldump 10.2 (create table statement and
> insertion of 250 records into this table) with added check for table integrity)
> results in corrupted table and error message 'Found key at page 36864 that points to
> record outside datafile' when checked with 'check table' or myisamcheck. Bizarrely,
> if you delete any one of the records being inserted the resulting table will be OK.
> Also, as you'll note, the value inserted into the 3rd column is always string
> 'DatabaseIdentifier'. If you change it in any record by deleting or adding a
> character (i.e. change it to 'DatabaseIdentifie' or 'DatabaseIdentifierr' the
> resulting table will also be fine.
> If you don't issue the 'check table' command you'll be able to do selects on the
> table.However, once the check has been issued any attempt to do select result in
> "ERROR 1016: Can't open file: 'DatabaseObject.MYI'. (errno: 145)".
> The problem also occurs on precompiled MySQL 4.1 for alphas (I haven't tested any
> other platforms).
> However, the problem does not occur with precompiled MySQL 4.0.16 on intel-linux
> (the same platform used to run mysqlbug producing this report for 4.1). Also, if you
> dump the test database with mysqldump 9.09 and re-upload it, the resulting table is
> OK.
Thank you for bug report. It was entered to the bug database:
http://bugs.mysql.com/bug.php?id=1977
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [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]
