Bug #26328 errors from falcon: (1032) - Can't find record in 't1': delete from ...

• Submitted: 13 Feb 2007 15:36
• Modified: 19 Jun 2007 12:28
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 5.2.3-falcon-alpha-debug
• OS: Linux (suse9.3 x86)
• CPU Architecture: Any

[13 Feb 2007 15:36] Shane Bester

Description:
during the tests for bug #26324, occasionally queries fail with this error message:

[ERROR]  15:06:46 [2394]  5432 - query failed (1032) - Can't find record in 't1': delete from t1 order by c1*rand [...]
[ERROR]  15:06:46 [2394]  1336 - query failed (1032) - Can't find record in 't1': delete from t1 order by c1*rand [...]

How to repeat:
will upload standalone testcase soon.

Suggested fix:
...

[13 Feb 2007 16:03] MySQL Verification Team

see top of file for compile instruction, and host,user,database variables

Attachment: testcase.c (text/plain), 7.03 KiB.

[13 Feb 2007 16:04] MySQL Verification Team

snippet of output from the testcase...
The 1020's are normal as I understand.  This bug report is about
the 1032's

query failed  : 1020 (Record has changed since last read in table 't1')
query failed  : 1020 (Record has changed since last read in table 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1020 (Record has changed since last read in table 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1020 (Record has changed since last read in table 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1032 (Can't find record in 't1')
query failed  : 1020 (Record has changed since last read in table 't1')
query failed  : 1032 (Can't find record in 't1')

[18 May 2007 0:22] Calvin Sun

Please re-test, there are some significant changes on reducing update conflicts.

[18 May 2007 14:28] MySQL Verification Team

Calvin, I cannot repeat the bug on 6.0.1BK anymore using this testcase, so it seems fixed.

On another note, this testcase now crashes after 10 minutes of running.  I am opening a new bug report for that.

Thanks!

[18 Jun 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".

[19 Jun 2007 12:28] MC Brown

A note has been added to the 6.0.1 changelog.