Bug #29138 'kill' fails in pushbuild
Submitted: 15 Jun 2007 13:47 Modified: 23 Jun 2007 7:59
Reporter: Mads Martin Joergensen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1, 5.0, 5.1 OS:Microsoft Windows
Assigned to: Damien Katz CPU Architecture:Any
Tags: pbfail

[15 Jun 2007 13:47] Mads Martin Joergensen
Description:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=kill

It appears to affect Windows platforms only.

It affects all versions, currently.  It goes back a ways, although I
didn't hunt around enough to find where it first shows up.

Error looks like (4.1):

mysqltest: At line 32: query 'select 1' succeeded - should have failed
with errno 2006...

Or (5.0, 5.1):

mysqltest: At line 94: query 'reap' succeeded - should have failed with
errno 1053...

Note:  Looks like the first 5.1 failure was in mysql-5.1-marvel on 29
May:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=mysql-5.1-marvel&order=56

However, there was another 5.1 failure earlier, slightly different
error, in mysql-5.1.14-wl3615 on 10 May:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=mysql-5.1.14-wl3615&order=1

4.1 and 5.0 failures go farther back.

How to repeat:
Pushbuild repeats it.
[21 Jun 2007 20:31] 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/29342

ChangeSet@1.2497, 2007-06-21 16:30:51-04:00, dkatz@damien-katzs-computer.local +1 -0
  Bug #29138  	'kill' fails in pushbuild
  
  This is not a complete submission. Checking in for collaboration.
[21 Jun 2007 21:23] 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/29345

ChangeSet@1.2497, 2007-06-21 17:22:57-04:00, dkatz@damien-katzs-computer.local +2 -0
  Bug #29138  	'kill' fails in pushbuild
  
  This is not a complete submission. Checking in for collaboration.
[22 Jun 2007 1:40] 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/29356

ChangeSet@1.2502, 2007-06-21 21:39:52-04:00, dkatz@damien-katzs-computer.local +2 -0
  Bug #29138  'kill' fails in pushbuild
  
  The reason the "reap;" succeeds unexpectedly is because the query was completing(almost always) and the network buffer was big enough to store the query result (sometimes) on Windows, meaning the response was completely sent before the server thread could be killed.
  
  Therefore we use a much longer running query that doesn't have a chance to fully complete before the reap happens, testing the kill properly.
[22 Jun 2007 18:07] Bugs System
Pushed into 5.1.20-beta
[22 Jun 2007 18:09] Bugs System
Pushed into 5.0.46
[23 Jun 2007 7:59] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

No end user changes to document. Closed without further action.