Bug #16984 | Events: running out of threads | ||
---|---|---|---|
Submitted: | 31 Jan 2006 18:42 | Modified: | 10 Feb 2006 20:33 |
Reporter: | Peter Gulutzan | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S1 (Critical) |
Version: | 5.1.6-alpha-debug | OS: | Linux (SUSE 10.0) |
Assigned to: | Andrey Hristov | CPU Architecture: | Any |
[31 Jan 2006 18:42]
Peter Gulutzan
[31 Jan 2006 22:43]
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/1966
[9 Feb 2006 20:39]
Andrey Hristov
Fixed in 5.1.7 With 5.1.6 no more than 1000-1500 executions off all defined events can be done. The threads are not detached so every activate event counts against the number of SQL server threads. SQL threads detach themselves. This may lead to situation where the server has to be restarted.
[10 Feb 2006 20:33]
Paul DuBois
Bug appears only in unreleased code. No changelog entry needed.
[8 Sep 2006 15:32]
Jason Buck
I'm seeing exactly this behaviour in 5.1.11-beta. Same event scenario, same log messages/sequence. Usually after only a few hundred iterations of the event. This fix was certainly rolled forward into 5.1.11? Are there any further fixes due for this?