MySQL Bugs: #27121: rows disappear (after successful insert)

Bug #27121	rows disappear (after successful insert)
Submitted:	14 Mar 2007 9:06	Modified:	10 May 2007 23:03
Reporter:	itamar mtz	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.21-standard-log	OS:	Linux (Fedora Core release 5)
Assigned to:		CPU Architecture:	Any
Tags:	disappearing rows

Description:
I have a mid-sized MySQL operation (two 4.1 servers in a multi-master scheme), only one is being accessed. lately i've gotten reports from users of creating resources and then seeing the resources disappear. example from the BINLOG (i've changed the table fieldnames for the example) :

#070227  6:27:14 server id 1  log_pos 120991173         Intvar
SET INSERT_ID=2322;

INSERT INTO table(identifiable_field) VALUES ("identifieable_value");

only to check it later and see the same row (ID 2322) is taken by another value and a customer who claims he inserted it already only to have it disappear. I did validate that there is no DELETE or UPDATE queries related to that table nor any such done on the other mysql server.

How to repeat:
I was unable to reproduce this problem

Some additional data that might be helpful: 

* Engine type is InnoDB 
* that specific query was not encapsulated in a transaction
* the code itself referred to that same ID in that context meaning mysql returned that insert id to the client

Thank you for the bug report. Could you please try with the latest
released version 4.1.22. Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".