Bug #17815 Scheduler may not see a change of an event
Submitted: 1 Mar 2006 2:57 Modified: 4 Apr 2006 11:41
Reporter: Andrey Hristov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S2 (Serious)
Version:5.1.8-debug OS:
Assigned to: Andrey Hristov CPU Architecture:Any

[1 Mar 2006 2:57] Andrey Hristov
Description:
If an event is altered and the OS allocates the same memory for the new object then the scheduler will fail to see a difference and won't reinit it's sleeping for the new interval value.

How to repeat:
Happens sporadically.
[7 Mar 2006 11:17] Andrey Hristov
Currently only if the event is on top of the queue and has been changed more than once in a given second the second change (timing for example) won't be catched.
[7 Mar 2006 16:48] 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/3544
[4 Apr 2006 11:41] Andrey Hristov
Will be fixed as part of 17619 : Scheduler race conditions. This is a kind of a race condition.