[debian-mysql] Bug#458350: /usr/sbin/mysqld: mysql connection crashes using select distinct or select ... group by

[Andreas Sassermann]

Package: mysql-server-5.0
Version: 5.0.32-7etch3
Severity: grave
Justification: renders package unusable
File: /usr/sbin/mysqld

*** Please type your report below this line ***

to repeat try:

NEWSYS:~# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.32-Debian_7etch3 Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select distinct db, user from db;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> select  db, user from db group by 1,2;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: mysql

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> Bye
NEWSYS:~#

This is not dependent on using mysql systemdatabase. I tried it only
with myisam tables.



-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: arm (armv5tel)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-5-ixp4xx
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.102             Add and remove users and groups
ii  debconf [debconf-2.0]  1.5.11etch1       Debian configuration 
management sy
ii  libc6                  2.3.6.ds1-13etch4 GNU C Library: Shared libraries
ii  libdbi-perl            1.53-1etch1       Perl5 database interface by 
Tim Bu
ii  libgcc1                1:4.1.1-21        GCC support library
ii  libmysqlclient15off    5.0.32-7etch3     mysql database client library
ii  libncurses5            5.5-5             Shared libraries for 
terminal hand
ii  libreadline5           5.2-2             GNU readline and history 
libraries
ii  libstdc++6             4.1.1-21          The GNU Standard C++ Library v3
ii  libwrap0               7.6.dbs-13        Wietse Venema's TCP 
wrappers libra
ii  lsb-base               3.1-23.2etch1     Linux Standard Base 3.1 
init scrip
ii  mysql-client-5.0       5.0.32-7etch3     mysql database client binaries
ii  mysql-common           5.0.32-7etch3     mysql database common files 
(e.g.
ii  passwd                 1:4.0.18.1-7      change and administer 
password and
ii  perl                   5.8.8-7etch1      Larry Wall's Practical 
Extraction
ii  psmisc                 22.3-1            Utilities that use the proc 
filesy
ii  zlib1g                 1:1.2.3-13        compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information:
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true