Bug #75626 Stabilize tests that use SHOW PROCESSLIST
Submitted: 25 Jan 2015 20:55 Modified: 23 Feb 2015 23:08
Reporter: Anitha Gopi Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[25 Jan 2015 20:55] Anitha Gopi 
Description:
This is a patch from webscale. 

A few tests used the output from SHOW PROCESSLIST, without sorting the
output, making them possibly unstable.  Added a sort to all of these.

Plus, there is a race in show processlist, which shows the actual
show processlist run as either "init" or "cleaning up".  To avoid
the test inconsistency, I replace both with "STATE" in these tests.

https://github.com/webscalesql/webscalesql-5.6/commit/805cf3bebd7d8b3203255c8187a017a029eb...

How to repeat:
This can lead to sporadic test failures.
[23 Feb 2015 23:08] Paul DuBois 
Fixed in 5.6.24. Changes for test suite. No changelog entry needed.
[27 Apr 2015 12:52] Laurynas Biveinis 
Author: Matthias Leich <Matthias.Leich@oracle.com>
Date:   Fri Feb 20 14:13:31 2015 +0100

    Bug#20414606 USE SINGLE QUOTES FOR PERL PATHS, IN CASE OF SPECIAL SYMBOLS
    Bug#20414565 DISABLE LARGE_TESTS.ALTER_TABLE IN DEBUG MODE
    Bug#20414569 STABILIZE TESTS THAT USE SHOW PROCESSLIST
    
    In a few cases some minor beautification or
    adjustment to current handling of storage engines in tests.