Bug #39857 main.status fails sporadically on pushbuild
Submitted: 4 Oct 2008 12:46 Modified: 10 Feb 2009 23:18
Reporter: Sven Sandberg Email Updates:
Status: Duplicate Impact on me:
None 
Category:Tests: Server Severity:S7 (Test Cases)
Version:5.1, 6.x OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: main.status, pushbuild, sporadic, test failure

[4 Oct 2008 12:46] Sven Sandberg 
Description:
pushbuild says:

main.status                    [ fail ]

--- C:/cygwin/home/pushbuild/pb1/pb/bzr_mysql-5.1-5.1.29-rc/29/mysql-5.1.30-pb29/mysql-test/r/status.result	2008-10-03 17:55:12.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\bzr_mysql-5.1-5.1.29-rc\29\mysql-5.1.30-pb29\mysql-test\r\status.reject	2008-10-03 20:32:03.765625000 +0300
@@ -20,7 +20,7 @@
 unlock tables;
 show status like 'Table_locks_waited';
 Variable_name	Value
-Table_locks_waited	1
+Table_locks_waited	2
 drop table t1;
 set global general_log = @old_general_log;
 select 1;

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases

How to repeat:
E.g., here:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-5.1.29-rc&order=... vm-win2003-32-a/ps_row

Has failed over 600 times according to xref: http://tinyurl.com/5x58y6
[5 Jan 2009 22:58] Patrick Crews 
I am not seeing this same failing behavior as of this writing.
I do not see a pattern to the test failure, it seems to be failing on a variety of settings:  normal, ps-protocol, etc.  However, when the test does fail, it appears to be failing in the same manner (shown below).

I will take this bug for some research to see if it is a weak test or a problem with the server.

main.status                    [ fail ]

--- /data0/pushbuild/pb/bzr_mysql-6.0-bugteam/394/bzr_mysql-6.0-bugteam-exp/mysql-test/r/status.result	2008-12-30 11:57:25.000000000 +0300
+++ /data0/pushbuild/pb/bzr_mysql-6.0-bugteam/394/bzr_mysql-6.0-bugteam-exp/mysql-test/r/status.reject	2008-12-30 12:32:51.000000000 +0300
@@ -243,6 +243,7 @@
 FLUSH STATUS;
 SELECT * FROM v1 WHERE NAME = 'Threads_connected' AND VALUE < @tc;
 NAME	VALUE
+THREADS_CONNECTED	3
 SELECT * FROM v1 WHERE NAME = 'Threads_running' AND VALUE < @tr;
 NAME	VALUE
 DROP VIEW v1;
[2 Feb 2009 9:13] Lars Thalmann 
See also BUG#39937
[4 Feb 2009 19:00] Davi Arnaut 
Duplicate of Bug#37481?
[10 Feb 2009 23:18] Patrick Crews 
The symptoms of this bug have been corrected as a result of other bug-fixing efforts:
See Bug #42602	main.status: random failures

Closing this bug out as a duplicate.