Bug #36131 Random failures of falcon_bug_22175 test

• Submitted: 16 Apr 2008 11:22
• Modified: 2 Aug 2008 15:52
• Reporter: Rafal Somla
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• Version: 6.0.5-alpha
• OS: Any
• Assigned to: Vladislav Vaintroub
• CPU Architecture: Any

[16 Apr 2008 11:22] Rafal Somla

Description:
Random failures of falcon_bug_22175 test have been observed on PB, resulting in incorrect test results:

@@ -29,7 +29,6 @@
 # Switch to connection default
 SELECT * FROM t1;
 s1
-6
 SELECT * FROM t2;
 s1
 DROP TRIGGER t1_bi;

This has been seen recently in 6.0-main, 6.0-build and 6.0-falcon-team trees.

How to repeat:
I could not repeat this by running test several times. Must be some subtle timing/high load combination which triggers it.

[21 May 2008 15:04] Philip Stoev

This bug is easily reproducible on a 8-core machine as follows:

$  perl mysql-test-run.pl --suite=falcon falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175  falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175 falcon_bug_22175

It will happen either on the execution of the 3-rd test from the run or shortly after.

[2 Aug 2008 15:31] Philip Stoev

This bug is no longer repeatable on neither a slow machine nor on a fast one. If the underlying issue has been resolved, I suggest that we close it.

Thank you.