Package: mysql-server Version: 4.0.24-10sarge1 Severity: important While querying MySQL heavily, the server crashes after several querys. For example, the "Checking for crashed MySQL tables in the background" job on startup doesn't complete. Or you can't mysqldump every database alone. If you run mysqldump for the whole server, it works, but not for each database alone.
Syslog shows the following message: Oct 3 23:41:35 wvbg mysqld[19517]: mysqld got signal 11; Oct 3 23:41:35 wvbg mysqld[19517]: This could be because you hit a bug. It is also possible that this binary Oct 3 23:41:35 wvbg mysqld[19517]: or one of the libraries it was linked against is corrupt, improperly built, Oct 3 23:41:35 wvbg mysqld[19517]: or misconfigured. This error can also be caused by malfunctioning hardware. Oct 3 23:41:35 wvbg mysqld[19517]: We will try our best to scrape up some info that will hopefully help diagnose Oct 3 23:41:35 wvbg mysqld[19517]: the problem, but since we have already crashed, something is definitely wrong Oct 3 23:41:35 wvbg mysqld[19517]: and this may fail. Oct 3 23:41:35 wvbg mysqld[19517]: Oct 3 23:41:35 wvbg mysqld[19517]: key_buffer_size=16777216 Oct 3 23:41:35 wvbg mysqld[19517]: read_buffer_size=131072 Oct 3 23:41:35 wvbg mysqld[19517]: max_used_connections=2 Oct 3 23:41:35 wvbg mysqld[19517]: max_connections=100 Oct 3 23:41:35 wvbg mysqld[19517]: threads_connected=1 Oct 3 23:41:35 wvbg mysqld[19517]: It is possible that mysqld could use up to Oct 3 23:41:35 wvbg mysqld[19517]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K Oct 3 23:41:35 wvbg mysqld[19517]: bytes of memory Oct 3 23:41:35 wvbg mysqld[19517]: Hope that's ok; if not, decrease some variables in the equation. Oct 3 23:41:35 wvbg mysqld[19517]: Oct 3 23:41:35 wvbg mysqld_safe[19565]: Number of processes running now: 0 Oct 3 23:41:35 wvbg mysqld_safe[19567]: restarted So the server stays more or less usable, because mysql is restarted immediatly, but some connections are lost every time. The server has 1024MB RAM, so using 233 MB for MySQL should not be a problem. -- System Information: Debian Release: 3.1 Architecture: ia64 Kernel: Linux 2.4.25-hpe-11-mckinley-smp Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages mysql-server depends on: ii adduser 3.63 Add and remove users and groups ii debconf 1.4.30.13 Debian configuration management sy ii libc6.1 2.3.2.ds1-22 GNU C Library: Shared libraries an ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu ii libgcc1 1:3.4.3-13 GCC support library ii libmysqlclient12 4.0.24-10sarge1 mysql database client library ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent ii mysql-client 4.0.24-10sarge1 mysql database client binaries ii mysql-common 4.0.24-10sarge1 mysql database common files (e.g. ii passwd 1:4.0.3-31sarge5 change and administer password and ii perl 5.8.4-8 Larry Wall's Practical Extraction ii psmisc 21.5-1 Utilities that use the proc filesy ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime -- debconf information: mysql-server/nis_warning: mysql-server/really_downgrade_from_41: false mysql-server/mysql_update_hints1: mysql-server/start_on_boot: true mysql-server/postrm_remove_databases: false * mysql-server/mysql_install_db_notes: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
