Bug #27707 insert table error 1032 - Can't find record in <table>
Submitted: 9 Apr 2007 3:21 Modified: 9 May 2007 7:46
Reporter: Yoon Jay Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:4.1.15 OS:Linux
Assigned to: CPU Architecture:Any
Tags: 1032, Can't find record in

[9 Apr 2007 3:21] Yoon Jay
Description:
hello.
I have a very simple problem.
when my applicaion insert into a specific table, sometimes i found error code '1032-Can't find record in <my table>' and inserting was stopped. 
this problem is not occured everytime. just sometimes. so i don't think my applicaion has some problems.

help me plz.

Table Infor.
CREATE TABLE TableName(
F1 int(4) unsigned NOT NULL AUTO_INCREMENT,
F2 nvarchar(16) NOT NULL,
F3 tinyint(1) unsigned NOT NULL,
F4 nvarchar(10) NOT NULL,
F5 nvarchar(20) NOT NULL,
F6 nvarchar(16) NOT NULL,
F7 int(4) unsigned NOT NULL,
F8 int(4) unsigned NOT NULL,
F9 int(4) unsigned NOT NULL,
F10 int(4) unsigned NOT NULL,
F11 int(4) unsigned NOT NULL,
F12 int(4) unsigned NOT NULL,
PRIMARY KEY( F1 ), INDEX USING btree( F2 ) )",

insert statment is so normal.
Insert Into Tablename ( F1 ... F12 ) values ( .... );

if this working is successed, the table has 211531 rows.

Upgrading the lastest version is just solution. right?

thanks to read.

How to repeat:
 error 1032 - Can't find record in <table>
[9 Apr 2007 7:46] Sveta Smirnova
Thank you for the report.

But 4.1.15 version is quite old.

Please upgrade to last 4.1.22 version and if you can repeat the problem provide output of df command.
[9 May 2007 23: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".