Package: mysql-server-5.0 Version: 5.0.30-2 Severity: important
Hi, I'm experiencing problems with the new mysql-server 5.0.30 (-1 or -2), i've found an SQL command that either make it crash or hang depending on the content of the tables. I've tested this only on x86-64 archs but on multiple (Amd Opterons, Intel Woodcrest and Xen Virtual Domains). This doesn't happens in version 5.0.27 mysql> SELECT * FROM m LEFT JOIN u ON u.id = m.checked_out GROUP BY m.id ORDER BY m.row, m.ordering, m.type, m.name LIMIT 0, 30; ERROR 2013 (HY000): Lost connection to MySQL server during query If i remove the LIMIT stanza and/or one of the order by everything goes fine. If i strip the table m to less than 30 line too. When narrowing the lower subset of entry/sql command i got this one too: mysql> alter table u drop registerDate; mysql> SELECT * FROM m LEFT JOIN u ON u.id = m.checked_out GROUP BY m.id ORDER BY m.row, m.ordering, m.type, m.name LIMIT 0, 30; ... 30 rows in set (0.00 sec) *** glibc detected *** double free or corruption (!prev): 0x00000000012201e0 *** Attached should be the sql usefull to reproduce the bug. -- System Information: Debian Release: 4.0 APT prefers unstable APT policy: (500, 'unstable') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.16-2-xen-em64t-p4 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) (ignored: LC_ALL set to C) Versions of packages mysql-server-5.0 depends on: ii adduser 3.100 Add and remove users and groups ii debconf [debconf-2.0] 1.5.10 Debian configuration management sy ii libc6 2.3.6.ds1-9 GNU C Library: Shared libraries ii libdbi-perl 1.53-1 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.1-21 GCC support library ii libmysqlclient15off 5.0.30-2 mysql database client library ii libncurses5 5.5-5 Shared libraries for terminal hand ii libreadline5 5.2-1 GNU readline and history libraries ii libstdc++6 4.1.1-21 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-11 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-22 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.30-2 mysql database client binaries ii mysql-common 5.0.30-2 mysql database common files (e.g. ii passwd 1:4.0.18.1-6 change and administer password and ii perl 5.8.8-7 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: true mysql-server-5.0/start_on_boot: true mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/need_sarge_compat_done: true mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes:
crash.sql.gz
Description: Binary data
