[debian-mysql] Bug#420807: mysql-server-5.0: Whole system blocked after mysql server start

[sean finney]

severity 420807 important
tags 420807 unreproducible
thanks

hi wojciech,

sorry for the late reply, this was partially due to us being busy but
also due to the lack of solid information in the report.

if you don't have mysql-server set to start at boot, does the system
work fine?

is there anything that looks related in
 - /var/log/syslog
 - /var/log/mysql*
 - dmesg output

when the system starts slowing down, if you stop mysql-server do things
return to normal?

if you run a command like top and sort by cpu usage, what does it look
like when the system starts to slow down?

if you run a command like top and sort by memory usage, what does it
look like when the system starts to slow down?

any other information that might help?  for example, how do clients
connect to the database, what kind of clients, is this a heavy usage
server, etc.


thanks,
	sean

On Tue, 2007-04-24 at 20:00 +0200, Wojciech Jeczmien wrote:
> Package: mysql-server-5.0
> Version: 5.0.38-3
> Severity: critical
> Justification: breaks the whole system
> 
> After update system works only few minutes. 
> Few minutes after starting mysql system slows. It is not possible to log 
> in - shell cannot be open, dhcp server stop serving addresses, shutdown 
> (reboot) hangs (alt-ctrl-del salute wont work). The only way to reboot 
> system is cold reboot (reset button). 
> 
> -- System Information:
> Debian Release: lenny/sid
>   APT prefers unstable
>   APT policy: (500, 'unstable')
> Architecture: i386 (i686)
> 
> Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core)
> Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
> Shell: /bin/sh linked to /bin/bash
> 
> 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.13       Debian configuration management sy
> ii  libc6                       2.5-2        GNU C Library: Shared libraries
> ii  libdbi-perl                 1.54-1       Perl5 database interface by Tim Bu
> ii  libgcc1                     1:4.1.1-21   GCC support library
> ii  libmysqlclient15off         5.0.38-3     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.1     Linux Standard Base 3.1 init scrip
> ii  mysql-client-5.0            5.0.38-3     mysql database client binaries
> ii  mysql-common                5.0.38-3     mysql database common files (e.g. 
> ii  passwd                      1:4.0.18.1-7 change and administer password and
> ii  perl                        5.8.8-7      Larry Wall's Practical Extraction 
> ii  psmisc                      22.5-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-show failed
>