[debian-mysql] Bug#577836: mysql-server-5.0: Aborted cached query causes next query to hang (mysql bug 40264)

[Andrew Pimlott]

Package: mysql-server-5.0
Version: 5.0.51a-24+lenny3
Severity: important

Mysql bug 40264:

When query caching is enabled, large amounts of queries are sent to the
server in succession, and a query is aborted, the query cache is put
into a state which hangs indefinitely the next time that query is
executed.

http://bugs.mysql.com/bug.php?id=40264

Query caching is enabled by default and this problem could strike at any
time, causing mysterious and possibly serious failures.  Would you
consider applying the simple patch to the Debian package?

Andrew

-- System Information:
Debian Release: 5.0.4
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.31-302-rs (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                3.110             add and remove users and groups
ii  debconf [debconf-2.0]  1.5.24            Debian configuration management sy
ii  libc6                  2.7-18lenny2      GNU C Library: Shared libraries
ii  libdbi-perl            1.605-1           Perl5 database interface by Tim Bu
ii  libgcc1                1:4.3.2-1.1       GCC support library
ii  libmysqlclient15off    5.0.51a-24+lenny3 MySQL database client library
ii  libncurses5            5.7+20081213-1    shared libraries for terminal hand
ii  libreadline5           5.2-3.1           GNU readline and history libraries
ii  libstdc++6             4.3.2-1.1         The GNU Standard C++ Library v3
ii  libwrap0               7.6.q-16          Wietse Venema's TCP wrappers libra
ii  lsb-base               3.2-20            Linux Standard Base 3.2 init scrip
ii  mysql-client-5.0       5.0.51a-24+lenny3 MySQL database client binaries
ii  mysql-common           5.0.51a-24+lenny3 MySQL database common files
ii  passwd                 1:4.1.1-6+lenny1  change and administer password and
ii  perl                   5.10.0-19lenny2   Larry Wall's Practical Extraction 
ii  psmisc                 22.6-1            Utilities that use the proc filesy
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-3 A simple mail user agent
ii  heirloom-mailx [ma 12.3+cvs20080629-1    feature-rich BSD mail(1)
pn  libhtml-template-p <none>                (no description available)

Versions of packages mysql-server-5.0 suggests:
pn  tinyca                        <none>     (no description available)

-- debconf information excluded