Bug #41255 wait_timeout_func fails

• Submitted: 5 Dec 2008 11:10
• Modified: 15 Oct 2012 14:47
• Reporter: Georgi Kodinov
• Status: Unsupported
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1-bugteam, 6.0-bugteam
• OS: Linux (sles10-ia64-a)
• CPU Architecture: Any
• Tags: experimental, pb1, pb2, test failure

[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:[e-mail]-20081205112419-lsc6n9sgksl32rx7) (version source revid:[e-mail]-20081205112419-lsc6n9sgksl32rx7) (pib:5)

[8 Dec 2008 11:32] Bugs System

Pushed into 6.0.9-alpha  (revid:[e-mail]-20081205112419-lsc6n9sgksl32rx7) (version source revid:[e-mail]-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:[e-mail]-20090119095303-uwwvxiibtr38djii) (version source revid:[e-mail]-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:[e-mail]-20090119104956-guxz190n2kh31fxl) (version source revid:[e-mail]-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:[e-mail]-20090119144033-4aylstx5czzz88i5) (version source revid:[e-mail]-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.