Bug #27350 | test-insert, Unexpected error; "Record has changed since last read in table" | ||
---|---|---|---|
Submitted: | 21 Mar 2007 17:57 | Modified: | 14 May 2007 18:25 |
Reporter: | Matthias Leich | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Falcon storage engine | Severity: | S2 (Serious) |
Version: | 5.2 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[21 Mar 2007 17:57]
Matthias Leich
[21 Mar 2007 17:58]
Matthias Leich
testscript
Attachment: ml003.test (application/octet-stream, text), 1.27 KiB.
[21 Mar 2007 18:22]
Hakan Küçükyılmaz
I could verify the error with the testcases: - index_merge_falcon - ps_8falcon both fail with "Record has changed since last read in table" Regards, Hakan
[23 Mar 2007 17:02]
Hakan Küçükyılmaz
Added test case falcon_bug_27350.test which passes now. I tested the test with loop count of 1 mio but lowered it to 100k to get better run time on Pushbuild. Best regards, Hakan
[23 Mar 2007 19:37]
Matthias Leich
Sorry I cannot confirm this. You accidently lowered the number of loops to 10k and not to 100k! When I run falcon_bug_27350.test with 100k loops I get the unexpected error after about 20k loops. A run of the original test-insert benchmark reveals also the bug. My environment: - MySQL-5.1-falcon last ChangeSet@1.2507, 2007-03-23 (compile-pentium-max) - Linux openSUSE 10.2 (X86-64), Core2Duo (x86 64 Bit)
[23 Mar 2007 22:11]
Hakan Küçükyılmaz
Verified by setting the loop count to 1 million. Sorry for confusion, Hakan
[14 Apr 2007 18:25]
Hakan Küçükyılmaz
Can't verify anymore with loop count of 1 mio. Matthias, please recheck. Best regards, Hakan
[14 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".