[debian-mysql] Bug#481350: mysql-server-5.0: On arm, 5.0.32-7etch5 segfaults frequently, where 5.0.32-7etch1 is ok.

[Brian Brunswick]

Package: mysql-server-5.0
Version: 5.0.32-7etch1
Severity: grave
Justification: renders package unusable


I'm running a mythtv setup using diskless machines as the front and back ends,
and a DNS-323 with a chrooted debian etch installation as the file and
mysql server.

I just tried an update on this, but with the newer mysql version, the server segfaults all
the time.

May 15 02:01:30 erech mysqld[23780]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 220671 K
May 15 02:01:30 erech mysqld[23780]: bytes of memory
May 15 02:01:30 erech mysqld[23780]: Hope that's ok; if not, decrease some variables in the equation.
May 15 02:01:30 erech mysqld[23780]: 
May 15 02:01:31 erech mysqld_safe[24160]: Number of processes running now: 0
May 15 02:01:31 erech mysqld_safe[24162]: restarted
May 15 02:01:32 erech mysqld[24165]: 080515  2:01:32 [Note] /usr/sbin/mysqld: ready for connections.
May 15 02:01:32 erech mysqld[24165]: Version: '5.0.32-Debian_7etch5-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  
Debian etch distribution
May 15 02:02:37 erech mysqld[24165]: mysqld got signal 11;
May 15 02:02:38 erech mysqld[24165]: This could be because you hit a bug. It is also possible that this binary
May 15 02:02:38 erech mysqld[24165]: or one of the libraries it was linked against is corrupt, improperly built,
May 15 02:02:38 erech mysqld[24165]: or misconfigured. This error can also be caused by malfunctioning hardware.
May 15 02:02:38 erech mysqld[24165]: We will try our best to scrape up some info that will hopefully help diagnose
May 15 02:02:38 erech mysqld[24165]: the problem, but since we have already crashed, something is definitely wrong
May 15 02:02:38 erech mysqld[24165]: and this may fail.
May 15 02:02:38 erech mysqld[24165]: 
May 15 02:02:38 erech mysqld[24165]: key_buffer_size=3145728
May 15 02:02:38 erech mysqld[24165]: read_buffer_size=131072
May 15 02:02:38 erech mysqld[24165]: max_used_connections=10
May 15 02:02:38 erech mysqld[24165]: max_connections=100
May 15 02:02:38 erech mysqld[24165]: threads_connected=10
May 15 02:02:38 erech mysqld[24165]: It is possible that mysqld could use up to 
May 15 02:02:38 erech mysqld[24165]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 220671 K
May 15 02:02:38 erech mysqld[24165]: bytes of memory
May 15 02:02:38 erech mysqld[24165]: Hope that's ok; if not, decrease some variables in the equation.
May 15 02:02:38 erech mysqld[24165]: 
May 15 02:02:39 erech mysqld_safe[24222]: Number of processes running now: 0
May 15 02:02:39 erech mysqld_safe[24224]: restarted
May 15 02:02:42 erech mysqld[24227]: 080515  2:02:42 [Note] /usr/sbin/mysqld: ready for connections.
May 15 02:02:42 erech mysqld[24227]: Version: '5.0.32-Debian_7etch5-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  
Debian etch distribution
May 15 02:05:33 erech mysqld[24227]: mysqld got signal 11;
May 15 02:05:33 erech mysqld[24227]: This could be because you hit a bug. It is also possible that this binary
May 15 02:05:33 erech mysqld[24227]: or one of the libraries it was linked against is corrupt, improperly built,
May 15 02:05:33 erech mysqld[24227]: or misconfigured. This error can also be caused by malfunctioning hardware.
May 15 02:05:33 erech mysqld[24227]: We will try our best to scrape up some info that will hopefully help diagnose
May 15 02:05:33 erech mysqld[24227]: the problem, but since we have already crashed, something is definitely wrong
May 15 02:05:33 erech mysqld[24227]: and this may fail.
May 15 02:05:33 erech mysqld[24227]: 
May 15 02:05:33 erech mysqld[24227]: key_buffer_size=3145728
May 15 02:05:33 erech mysqld[24227]: read_buffer_size=131072
May 15 02:05:33 erech mysqld[24227]: max_used_connections=7
May 15 02:05:33 erech mysqld[24227]: max_connections=100
May 15 02:05:33 erech mysqld[24227]: threads_connected=7
May 15 02:05:33 erech mysqld[24227]: It is possible that mysqld could use up to 
May 15 02:05:33 erech mysqld[24227]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 220671 K
May 15 02:05:33 erech mysqld[24227]: bytes of memory
May 15 02:05:33 erech mysqld[24227]: Hope that's ok; if not, decrease some variables in the equation.
May 15 02:05:33 erech mysqld[24227]: 

Reverting to the previous version everything is fine.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: arm (armv5tejl)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12.6-arm1
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)

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-13etch5 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
hi  libmysqlclient15off    5.0.32-7etch1     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
hi  mysql-client-5.0       5.0.32-7etch1     mysql database client binaries
hi  mysql-common           5.0.32-7etch1     mysql database common files (e.g. 
ii  passwd                 1:4.0.18.1-7      change and administer password and
ii  perl                   5.8.8-7etch3      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:
pn  mailx                         <none>     (no description available)

-- debconf information:
  mysql-server/root_password: (password omitted)
  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