Bug #48825 UPDATE returns error 1032: Can't find record in 'table'
Submitted: 17 Nov 2009 2:54 Modified: 17 Dec 2009 5:29
Reporter: Aurimas Mikalauskas Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.84 OS:Linux (Red Hat Enterprise Linux Server release 5.4 (Tikanga) 2.6.18-164.el5 x86_64)
Assigned to: CPU Architecture:Any
Tags: innodb, UPDATE

[17 Nov 2009 2:54] Aurimas Mikalauskas 
Description:
From a highly loaded MySQL server application occasionally receives this error:

update text_recent set mod_date=CURRENT_TIMESTAMP() where profile_id=? and other_profile_id=?]; SQL state [HY000]; error code [1032]; Can't find record in 'text_recent'

CREATE TABLE `text_recent` (
  `profile_id` int(11) NOT NULL,
  `other_profile_id` int(11) NOT NULL,
  `mod_date` datetime NOT NULL,
  KEY `other_profile_id` (`other_profile_id`),
  KEY `prof_date_ind` (`profile_id`,`mod_date`),
  KEY `text_recent_profile` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

How to repeat:
can't consistently reproduce
[17 Nov 2009 5:29] Valeriy Kravchuk 
Please, send the results of:

explain select * from text_recent where profile_id=? and other_profile_id=?\G

with parameters replaced by some real values.
[18 Dec 2009 0:00] Bugs System 
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".