Ok,
I was able to repeat the
InnoDB: error in sec index entry update in ...
error with a table containing just 2 rows :).
The error happens when you UPDATE or REPLACE
a character column where only the case of the letters
changes:
....
mysql> update bob set b = 'AMBJORG' where a = 7400;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> update bob set b = 'Ambjorg' where a = 7400;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
....
The fix will be in 3.23.43. I will also look
if this could have something to do with the
replication bug of auto-increment columns.
Thank you!
Heikki
Innobase Oy
>Date: Mon, 24 Sep 2001 07:24:59
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>From: Heikki Tuuri <[EMAIL PROTECTED]>
>Subject: Re: update to strange InnoDB errors
>
>Robert,
>
>you are a genius in finding bugs :).
>
>The bug has been reported by two users before you.
>Since CHECK TABLE says ok, the table is probably
>ok now.
>
>The bug may be in purge in multiversioning: it removes
>a secondary index record too early. Or it may the
>in a lock wait.
>
>Can you describe what operations could cause the
>secondary index entry to change:
>
>- Do you delete rows from USER_USER?
>- Do you update the column containing 'Ambjorg'?
>- Do you use REPLACE to update the column containing
> 'Ambjorg'?
>
>What is the create table statement for USER_USER?
>What is the content of row number 7451 in the table
>presently, or does it exist at all?
>
>By the way, why there seem to be tuples for
>'ambjorg', 'Ambjorg', and 'AMBJORG'?
>
>Regards,
>
>Heikki
>
>>Er, a little embarassed that I did not check the bugfixes page before
>>reporting that. Anyhow, here is the check table to go with that report:
>>
>>+----------------------+-------+----------+----------+
>>| Table | Op | Msg_type | Msg_text |
>>+----------------------+-------+----------+----------+
>>| rateGenius.USER_USER | check | status | OK |
>>+----------------------+-------+----------+----------+
>>
>>robert
>>
>>--
>>robert cope \ Water? No thank you, fish make love in it.
>>[EMAIL PROTECTED] /
>> \
>>
>>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
