Bug #43711 Test main.variables-big fails due to non-deterministic test query.
Submitted: 17 Mar 2009 19:25 Modified: 23 Mar 2009 11:53
Reporter: Patrick Crews Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version: OS:MacOS
Assigned to: Assigned Account CPU Architecture:Any
Tags: big test, test_failure, variables_big

[17 Mar 2009 19:25] Patrick Crews 
Description:
Test variables_big is failing (at least on Mac OSX 10.5)

CURRENT_TEST: main.variables-big
--- <snip>/mysql-5.1-bugteam/mysql-test/r/variables-big.result	2009-03-17 22:20:29.000000000 +0300
+++ <snip>/mysql-5.1-bugteam/mysql-test/r/variables-big.reject	2009-03-17 22:21:18.000000000 +0300
@@ -1,20 +1,24 @@
 set session transaction_prealloc_size=1024*1024*1024*1;
 show processlist;
 Id	User	Host	db	Command	Time	State	Info
-1	root	localhost	test	Query	0	NULL	show processlist
+2	root	localhost	test	Query	0	NULL	show processlist
 set session transaction_prealloc_size=1024*1024*1024*2;
 show processlist;
 Id	User	Host	db	Command	Time	State	Info
-1	root	localhost	test	Query	0	NULL	show processlist
+2	root	localhost	test	Query	0	NULL	show processlist
<snip>

How to repeat:
Run the test:

./mtr --force --big variables_test

Suggested fix:
Alter the test to use mysql-test-run's 'replace_column' function to replace the ID column in the test results.  This information is not pertinent to the test (we're only testing that the server is up and running and not silently crashed).
[17 Mar 2009 19:57] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/69487

2776 Patrick Crews	2009-03-17
      Bug#43711: Test main.variables-big fails due to non-deterministic test query
      
      Used replace_column to remove the variable 'id' column from SHOW PROCESSLIST output.
      Also did some formatting cleanup
[23 Mar 2009 11:53] Patrick Crews 
Closing this bug as a duplicate of Bug#43383	main.variables-big : Weak testing code and result.

The above bug didn't show up when bugs.mysql.com presented possible duplicate bugs due to lack of tags.