Bug #41255 wait_timeout_func fails
Submitted: 5 Dec 2008 11:10 Modified: 15 Oct 2012 14:47
Reporter: Georgi Kodinov Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1-bugteam, 6.0-bugteam OS:Linux (sles10-ia64-a)
Assigned to: CPU Architecture:Any
Tags: experimental, pb1, pb2, test failure
Triage: Triaged: D3 (Medium)

[5 Dec 2008 11:10] Georgi Kodinov
Description:
main.wait_timeout_func fails in pushbuild1 (host 'sles10-ia64-a' no innodb) since 21 Nov 2008.

How to repeat:
look at pushbuild

Suggested fix:
Fix the test and then re-enable it.
[5 Dec 2008 11:25] 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/60717

2728 Georgi Kodinov	2008-12-05
      Disable wait_timeout_func and report bug #41255.
[8 Dec 2008 10:22] Bugs System
Pushed into 5.1.31  (revid:kgeorge@mysql.com-20081205112419-lsc6n9sgksl32rx7) (version source revid:kgeorge@mysql.com-20081205112419-lsc6n9sgksl32rx7) (pib:5)
[8 Dec 2008 11:32] Bugs System
Pushed into 6.0.9-alpha  (revid:kgeorge@mysql.com-20081205112419-lsc6n9sgksl32rx7) (version source revid:kgeorge@mysql.com-20081205112719-wklal4ed8u44i68k) (pib:5)
[30 Dec 2008 9:06] Sven Sandberg
The error message is:

main.wait_timeout_func         [ fail ]

--- /data0/pushbuild/pb2-2/pb/bzr_mysql-6.0-bugteam/296/mysql-6.0.9-alpha-pb296/mysql-test/r/wait_timeout_func.result	2008-11-21 19:42:11.000000000 +0300
+++ /data0/pushbuild/pb2-2/pb/bzr_mysql-6.0-bugteam/296/mysql-6.0.9-alpha-pb296/mysql-test/r/wait_timeout_func.reject	2008-11-21 23:20:16.000000000 +0300
@@ -10,8 +10,11 @@
 SET @@session.wait_timeout = <session_value> - 1;
 connection default;
 wait until connections ready
+Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM information_schema.processlist
 SELECT info FROM information_schema.processlist;
 info
+NULL
+NULL
 SELECT info FROM information_schema.processlist
 '#--------------------FN_DYNVARS_186_03-------------------------#'
 SET @@global.wait_timeout= <global_value>;
@@ -23,8 +26,12 @@
 Expect 1
 1
 connection default;
+Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM information_schema.processlist
 SELECT info FROM information_schema.processlist;
 info
+NULL
+NULL
+NULL
 SELECT info FROM information_schema.processlist
 SELECT UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;;
 UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases
[30 Dec 2008 9:07] Sven Sandberg
xref: http://tinyurl.com/7be8vp
[19 Jan 2009 11:23] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:01] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:07] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[12 May 2009 11:31] Philip Stoev
The problem with this test is that it executes a blanket query against I_S.PROCESSLIST, which is sensitive to the presence of unrelated mysql connections.

A general solution for this class of problems is being discussed and this bug will be used as a guinea pig.
[26 Apr 2010 14:06] Alexander Nozdrin
Moving to Verified, because it seems, nobody is working on it.
[26 Apr 2010 14:51] Alexander Nozdrin
Making experimental on Solaris due to this bug.