MySQL Bugs: #29138: 'kill' fails in pushbuild

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:	Windows
Assigned to:	Damien Katz	CPU Architecture:	Any
Tags:	pbfail

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.

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.

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.

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.

Pushed into 5.1.20-beta

Pushed into 5.0.46

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.