Bug #24396 event_bugs test failure
Submitted: 17 Nov 2006 15:18 Modified: 8 Dec 2006 16:57
Reporter: Lars Thalmann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1 OS:Any (All)
Assigned to: Andrey Hristov CPU Architecture:Any

[17 Nov 2006 15:18] Lars Thalmann 
Description:
events_bugs                    [ fail ]

Errors are (from /tmp/var-ps_row-121/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/events_bugs.result	Thu Nov 16 12:50:26 2006
--- r/events_bugs.reject	Thu Nov 16 13:19:16 2006
***************
*** 255,261 ****
  set global event_scheduler=off;
  select event_name, event_definition, interval_value, interval_field from information_schema.events order by event_name;
  event_name	event_definition	interval_value	interval_field
! e22830_1	alter event e22830_1 on schedule every (select 8 from dual) hour	8	HOUR
  e22830_2	alter event e22830_2 on schedule every (select 8 from t1) hour	1	HOUR
  e22830_3	alter event e22830_3 on schedule every f22830() hour	1	HOUR
  e22830_4	alter event e22830_4 on schedule every (select f22830() from dual) hour	1	HOUR
--- 255,261 ----
  set global event_scheduler=off;
  select event_name, event_definition, interval_value, interval_field from information_schema.events order by event_name;
  event_name	event_definition	interval_value	interval_field
! e22830_1	alter event e22830_1 on schedule every (select 8 from dual) hour	1	HOUR
  e22830_2	alter event e22830_2 on schedule every (select 8 from t1) hour	1	HOUR
  e22830_3	alter event e22830_3 on schedule every f22830() hour	1	HOUR
  e22830_4	alter event e22830_4 on schedule every (select f22830() from dual) hour	1	HOUR

How to repeat:
Pushbuild
[17 Nov 2006 15:25] Andrey Hristov 
Either the box is slow, valgrind? Or just has high load of building/running tests of another commit. There are 2 secs sleep interval, after which a status is checked. When under load it seems even 2 secs are not enough to run 4 events :(
[22 Nov 2006 13:11] 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/15701

ChangeSet@1.2387, 2006-11-22 14:06:59+01:00, andrey@example.com +1 -0
  fix for bug#24396
[22 Nov 2006 13:19] Andrey Hristov 
fix pushed to 5.1-maint
[8 Dec 2006 16:57] Andrey Hristov 
No need of changelog entry