Bug#458350: /usr/sbin/mysqld: mysql connection crashes using select distinct or select ... group by
Andreas Sassermann
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
--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Andreas Sassermann
compiled on my nslu2.
This version does not show the bug. Unfortuantely I could not figure
out how to build packages
according to debian policies but I think this shows an update to a more
current version should
fix the problem.
Andreas