Bug #26328 errors from falcon: (1032) - Can't find record in 't1': delete from ...
Submitted: 13 Feb 2007 16:36 Modified: 19 Jun 2007 14:28
Reporter: Shane Bester
Status: Closed
Category:Server: Falcon Severity:S3 (Non-critical)
Version:5.2.3-falcon-alpha-debug OS:Linux (suse9.3 x86)
Assigned to: Target Version:

[13 Feb 2007 16: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 17:03] Shane Bester 
see top of file for compile instruction, and host,user,database variables

Attachment: testcase.c (text/plain), 7.03 KiB.
[13 Feb 2007 17:04] Shane Bester 
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 2:22] Calvin Sun 
Please re-test, there are some significant changes on reducing update conflicts.
[18 May 2007 16:28] Shane Bester 
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!
[19 Jun 2007 1: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 14:28] MC Brown 
A note has been added to the 6.0.1 changelog.