Bug #32172 information_schema test fails with wait_condition timeout

Submitted: 7 Nov 2007 21:06 Modified: 6 Dec 2007 13:21
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1, 6.0 OS:Windows
Assigned to: Alexander Nozdrin CPU Architecture:Any
Tags: pbfail

[7 Nov 2007 21:06] Timothy Smith
Description:
It seems that a wait condition timeout of 30 seconds is too short in the information_schema test.  On a loaded box (at least vm-win2003-32-a) the
test times out, causing test failure:

main.information_schema        [ fail ]

--- C:/cygwin/home/pushbuild/pb1/pb/mysql-6.0-opt/21/mysql-6.0.4-alpha-pb21/mysql-test/r/information_schema.result	2007-11-07 17:10:02.000000000 +0300
+++ C:\cygwin\home\pushbuild\pb1\pb\mysql-6.0-opt\21\mysql-6.0.4-alpha-pb21\mysql-test\r\information_schema.reject	2007-11-07 18:16:13.546875000 +0300
@@ -1502,6 +1502,7 @@
 WHERE variable_name LIKE 'ABORTED_CONNECTS' OR
 variable_name LIKE 'BINLOG_CACHE_DISK_USE';
 END$$
+Timeout in wait_condition.inc for select count(*) = 0 from information_schema.events where event_name='event_status'
 SELECT variable_name FROM server_status;
 variable_name
 ABORTED_CONNECTS

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

Suggested fix:
Perhaps let $wait_timeout = 60.
[12 Nov 2007 14:26] 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/37576

ChangeSet@1.2609, 2007-11-12 17:26:32+03:00, anozdrin@station. +1 -0
  A patch for BUG#32172: information_schema test fails with
  wait_condition timeout.
  
  The problem was that the event thread didn't manage to execute
  the event in 30 seconds on highly-loaded box. The fix is to
  increase timeout.
  
  This is a fix for the test suite.
[13 Nov 2007 8:49] Alexander Nozdrin
Pushed into 5.1-rt.
[6 Dec 2007 9:59] Bugs System
Pushed into 5.1.23-rc
[6 Dec 2007 10:01] Bugs System
Pushed into 6.0.5-alpha
[6 Dec 2007 13:21] Paul DuBois
Change to test case. No changelog entry needed.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.