Consistent, repeatable, table corruption on Mac OS X 10.2.2 with mysql 3.23.53

How-To-Repeat:

Take a freshly installed mysql 3.23.53 instance of mysql (see below for
my OS details, and the source of my binaries).

Grab ftp://support.mysql.com/pub/mysql/secret/threeiosys.tar.gz, which
I have uploaded.

Run the supplied binary log file against the database (I get the error
when creating the database and the threeiosys user as root, and then
running the rest of the commands as root, or when just running
everything as root, so I'd just do the latter).

Run the following query at the mysql prompt:

DELETE FROM PERSON WHERE USERNAME NOT IN ('danny', 'dan');

NOTE: I have sent you my tables as well, but you do not need to install
them, and in fact you'll mess up the replaying if you do. The binary
log file contains the create database and table statements, and
everything you need.

If you can't reproduce the bug, or have any probs, please let me know.

============================================================ ============
========================

Original message follows below ...


I have consistent and reproducible table corruption using mysql 3.23.51
and 3.23.53

I have three very simple tables, a handful of inserts (1-3 records per
table), and an update.

These are all very basic and simple SQL commands.

Attempting a delete then results in a corrupted table :-(

yaffle[1974] echo "DELETE FROM PERSON WHERE USERNAME NOT IN ('danny',
'dan');" | mysql
ERROR 1034 at line 1: Incorrect key file for table: 'PERSON'. Try to
repair it

I am using Mac OS X 10.2.2

My mysql installations were pre-built binaries, supplied by Marc
Liyanage (http://www.entropy.ch/software/macosx/welcome.html)

I have followed the test case procedure at
http://www.mysql.com/doc/en/Reproduceable_test_case.html, with version
3.23.53 (I upgraded to be sure that it wasn't already fixed).

I have left a tar of my data directory and the binary log file at:
ftp://support.mysql.com/pub/mysql/secret/threeiosys.tar.gz

If there is any further information that I can provide, please let me
know. I would be very grateful if you could advise me of any progress
by email ...

regards,
Martin


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13106@lists.mysql.com
To unsubscribe, e-mail

Re: Consistent, repeatable, table corruption on Mac OS X 10.2.2 with mysql 3.23.53

Martin Redington writes:
> How-To-Repeat:
>
> Take a freshly installed mysql 3.23.53 instance of mysql (see below for
> my OS details, and the source of my binaries).
>
> Grab ftp://support.mysql.com/pub/mysql/secret/threeiosys.tar.gz, which
> I have uploaded.
>
> Run the supplied binary log file against the database (I get the error
> when creating the database and the threeiosys user as root, and then
> running the rest of the commands as root, or when just running
> everything as root, so I'd just do the latter).
>
> Run the following query at the mysql prompt:
>
> DELETE FROM PERSON WHERE USERNAME NOT IN ('danny', 'dan');
>
>
> If there is any further information that I can provide, please let me
> know. I would be very grateful if you could advise me of any progress
> by email ...
>
> regards,
> Martin

Hi!

I have tested your test case thoroughly.

First of all I have built 3.23.54 (to be out soon) proprely, as per
instructions in the manual.

I have used your tables, repaired them and then started mysql
server. I ran the above DELETE command and after that I have checked a
table.

I have also run similar command on other tables.

All tables were checked and all are correct 100 %.

In short, I was not able to repeat a bug you are reporting.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13111@lists.mysql.com
To unsubscribe, e-mail

Re: Consistent, repeatable, table corruption on Mac OS X 10.2.2 with mysql 3.23.53

Hi Sinisa.

> I have used your tables, repaired them and then started mysql
> server. I ran the above DELETE command and after that I have checked a
> table.

Thanks for the prompt response.

If that's exactly what you did, perhaps I wasn't clear enough in my
instructions.

Do NOT use my database files. They are for inspection only. If you use
them, and repair them, and then run the delete, you will NOT get the
error.

The binary log contains all the DDL statements required create the db
and populate the tables in a way that replicates the error (with the
exception of the final delete).

Play the binary log against a fresh install, and then try the delete.
Do not use my datafiles.

If this is actually what you did, can you confirm your platform? I have
other platforms available (e.g. Linux), but I haven't tested them yet.
If its a problem with the build (and personally, I couldn't get a clean
build from source to work on Mac OS X, IIRC), then I can start playing
around with building from source again ...

cheers,
Martin



On Monday, November 25, 2002, at 06:36 PM, Sinisa Milivojevic wrote:

> Martin Redington writes:
>> How-To-Repeat:
>>
>> Take a freshly installed mysql 3.23.53 instance of mysql (see below
>> for
>> my OS details, and the source of my binaries).
>>
>> Grab ftp://support.mysql.com/pub/mysql/secret/threeiosys.tar.gz, which
>> I have uploaded.
>>
>> Run the supplied binary log file against the database (I get the error
>> when creating the database and the threeiosys user as root, and then
>> running the rest of the commands as root, or when just running
>> everything as root, so I'd just do the latter).
>>
>> Run the following query at the mysql prompt:
>>
>> DELETE FROM PERSON WHERE USERNAME NOT IN ('danny', 'dan');
>>
>>
>> If there is any further information that I can provide, please let me
>> know. I would be very grateful if you could advise me of any progress
>> by email ...
>>
>> regards,
>> Martin
>
> Hi!
>
> I have tested your test case thoroughly.
>
> First of all I have built 3.23.54 (to be out soon) proprely, as per
> instructions in the manual.
>
> I have used your tables, repaired them and then started mysql
> server. I ran the above DELETE command and after that I have checked a
> table.
>
> I have also run similar command on other tables.
>
> All tables were checked and all are correct 100 %.
>
> In short, I was not able to repeat a bug you are reporting.


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13112@lists.mysql.com
To unsubscribe, e-mail

Re: Consistent, repeatable, table corruption on Mac OS X 10.2.2 with mysql 3.23.53

Martin Redington writes:
> Hi Sinisa.
>
> Thanks for the prompt response.
>
> If that's exactly what you did, perhaps I wasn't clear enough in my
> instructions.
>
> Do NOT use my database files. They are for inspection only. If you use
> them, and repair them, and then run the delete, you will NOT get the
> error.
>
> The binary log contains all the DDL statements required create the db
> and populate the tables in a way that replicates the error (with the
> exception of the final delete).
>
> Play the binary log against a fresh install, and then try the delete.
> Do not use my datafiles.
>
> If this is actually what you did, can you confirm your platform? I have
> other platforms available (e.g. Linux), but I haven't tested them yet.
> If its a problem with the build (and personally, I couldn't get a clean
> build from source to work on Mac OS X, IIRC), then I can start playing
> around with building from source again ...
>
> cheers,
> Martin
>
>

I have now done it with mysqlbinlog and it worked again.

We have OS X Jaguar 10.2.2.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13113@lists.mysql.com
To unsubscribe, e-mail

Re: Consistent, repeatable, table corruption on Mac OS X 10.2.2 with mysql 3.23.53

Damn. Well its broken consistently on my machine :-(

I'll try a fresh build from source (BTW, when will 3.23.54 be out ...)

Thanks for your help.

cheers,
Martin.

On Monday, November 25, 2002, at 07:49 PM, Sinisa Milivojevic wrote:

> Martin Redington writes:
>> Hi Sinisa.
>>
>> Thanks for the prompt response.
>>
>> If that's exactly what you did, perhaps I wasn't clear enough in my
>> instructions.
>>
>> Do NOT use my database files. They are for inspection only. If you use
>> them, and repair them, and then run the delete, you will NOT get the
>> error.
>>
>> The binary log contains all the DDL statements required create the db
>> and populate the tables in a way that replicates the error (with the
>> exception of the final delete).
>>
>> Play the binary log against a fresh install, and then try the delete.
>> Do not use my datafiles.
>>
>> If this is actually what you did, can you confirm your platform? I
>> have
>> other platforms available (e.g. Linux), but I haven't tested them yet.
>> If its a problem with the build (and personally, I couldn't get a
>> clean
>> build from source to work on Mac OS X, IIRC), then I can start playing
>> around with building from source again ...
>>
>> cheers,
>> Martin
>>
>>
>
> I have now done it with mysqlbinlog and it worked again.
>
> We have OS X Jaguar 10.2.2.
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13114@lists.mysql.com
To unsubscribe, e-mail