Bug #12136 Make test kill fails on OpenServer 6.0.0
Submitted: 24 Jul 2005 0:56 Modified: 13 Oct 2005 15:13
Reporter: Boyd GERBER Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.13, 4.1.15--nightly-20050916 OS:OpenServer 6.0.0
Assigned to: Jim Winstead CPU Architecture:Any

[24 Jul 2005 0:56] Boyd GERBER
Description:
./mysql-test-run or make test fails.

kill                           [ fail ]

Errors are (from /home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/mysql-test/var/log/mysqltest-time) :
/home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/client/.libs/lt-mysqltest: At line 31: query 'select 1' succeeded - should have failed with errno 2006...
/home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/client/.libs/lt-mysqltest: At line 34: query 'select ((@id := kill_id) - kill_id) from t1' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Resuming Tests

How to repeat:
./mysql-test-run --force

kill                           [ fail ]

Errors are (from /home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/mysql-test/var/log/mysqltest-time) :
/home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/client/.libs/lt-mysqltest: At line 31: query 'select 1' succeeded - should have failed with errno 2006...
/home/mount/uw714/top/zenez/zen/build/osr6/mysql-4.1.13/client/.libs/lt-mysqltest: At line 34: query 'select ((@id := kill_id) - kill_id) from t1' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Resuming Tests
[16 Sep 2005 8:54] Valeriy Kravchuk
Thank you for your bug report.

I've got the ability to verify SCO-related bugs finally. The same bug you described was repeated on yesterday's snapshot of 4.1.15, built with the following options:

CC=cc CFLAGS="-I/opt/K/SCO/Unix/6.0.0Ni/usr/include -I/usr/local/include" CXX=CC \
CXXFLAGS="-I/opt/K/SCO/Unix/6.0.0Ni/usr/include -I/usr/local/include" ./configure --prefix=/home/mysqldev/valeriy/4.1 \
--with-comment="MySQL Pro (GPL)" --with-extra-charsets=complex \
--with-server-suffix="-pro-gpl" --enable-thread-safe-client \
--enable-local-infile --build=i686-unknown-sysv5SCO_SV6.0.0 \
--disable-shared --with-readline --with-archive-storage-engine \
--with-innodb --with-debug

on our new SCO OpenServer 6 machine:

bash-2.03$ uname -a
SCO_SV opnsrv6a 5 6.0.0 i386

I've got the following results from ./mysql-test-run --force

keywords                       [ pass ]
kill                           [ fail ]

Errors are (from /home/mysqldev/valeriy/4.1/mysql-test/var/log/mysqltest-time) :

mysqltest: At line 31: query 'select 1' succeeded - should have failed with errn
o 2006... (the last lines may be the most important ones)

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
Resuming Tests

limit                          [ pass ]

There are some other test failures too, but that is the different story.
[20 Sep 2005 16:33] 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/internals/30113
[13 Oct 2005 15:13] Jim Winstead
Fixed in 4.1.16 and 5.0.15.