Bug #10872 'select ((@id := kill_id) - kill_id) from t1': Lost connection to MySQL

• Submitted: 25 May 2005 23:03
• Modified: 29 May 2005 0:44
• Reporter: David Dick
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.12
• OS: Linux (Redhat 7.3)
• CPU Architecture: Any

[25 May 2005 23:03] David Dick

Description:
isam                           [ skipped ]
join                           [ pass ]
join_crash                     [ pass ]
join_outer                     [ pass ]
key                            [ pass ]
key_cache                      [ pass ]
key_diff                       [ pass ]
key_primary                    [ pass ]
keywords                       [ pass ]
kill                           [ fail ]

Errors are (from /home/dave/mysql-4.1.12/mysql-test/var/log/mysqltest-time) :
/home/dave/mysql-4.1.12/client/.libs/mysqltest: At line 34: unable to execute statement 'select ((@id := kill_id) - kill_id) from t1': Lost connection to MySQL server during query (mysql_stmt_errno=2013 returned=1)
(the last lines may be the most important ones)

Aborting: kill failed in ps-protocol mode. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished

How to repeat:
./configure
make
make test

Suggested fix:
seems to be a regression.  4.1.11 passed the test suite without an issue

[29 May 2005 0:44] Jorge del Conde

Hi,

I was unable to reproduce this bug in both, RH 7.2 and FC2:

Starting Tests

TEST                            RESULT
-------------------------------------------------------
kill                           [ pass ]   
-------------------------------------------------------

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
All 1 tests were successful.

I used 4.1.13 from our bk tree.

[29 May 2005 5:37] David Dick

caused by an older (4.1.11) installation clashing with the 4.1.12 installation.  deleted the old installation, no more problems.