Package: mysql-server-5.0 Version: 5.0.41-2 Followup-For: Bug #411672 [Hmmm, I seem to give Sean extra work these days. ;D]
Hi! I suffer the same problem as the original poster: I too get a message that InnoDB can't recover because the 'host' table seems in disarray. Here's the output of syslog: Jun 10 01:25:56 danai mysqld_safe[9074]: started Jun 10 01:25:56 danai mysqld[9077]: InnoDB: Warning: we did not need to do crash recovery, but log scan Jun 10 01:25:56 danai mysqld[9077]: InnoDB: progressed past the checkpoint lsn 0 43630235 up to lsn 0 43630245 Jun 10 01:25:56 danai mysqld[9077]: 070610 1:25:56 InnoDB: Started; log sequence number 0 43630235 Jun 10 01:25:56 danai mysqld[9077]: 070610 1:25:56 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Jun 10 01:25:56 danai mysqld[9077]: 070610 1:25:56 [Note] Starting crash recovery... Jun 10 01:25:56 danai mysqld[9077]: 070610 1:25:56 [Note] Crash recovery finished. Jun 10 01:25:57 danai mysqld[9077]: 070610 1:25:57 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' Jun 10 01:25:57 danai mysqld_safe[9088]: ended Then after a few seconds I get this: Jun 10 01:26:11 danai /etc/init.d/mysql[9226]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jun 10 01:26:11 danai /etc/init.d/mysql[9226]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jun 10 01:26:11 danai /etc/init.d/mysql[9226]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jun 10 01:26:11 danai /etc/init.d/mysql[9226]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! I've also read the following post: http://slowhome.org/2007/03/04/chicken-and-egg-problem-with-mysql/ It seems that MySQL can't fix the privilege tables because mysqld isn't running. But mysqld can't start because of this broken table. The reason I got the broken table in the first place, is because of a hard reboot caused by hal (the n'th time I've got problems with it, but I'll report this bug in due course). My filesystem is XFS, so this might be the reason why not every data gets written to the FS: it uses a pool, and only effectively writes to the disk after a little while. If you need any more information, I'll provide it as soon as I can, given my busy schedule in the coming weeks. Best regards Danai SAE-HAN (韓達耐) -- 題目:《晚泊岳陽》 作者:歐陽修（１００７－１０７２） 臥聞岳陽城里鐘，系舟岳陽城下樹。 正見空江明月來，云水蒼茫失江路。 夜深江月弄清輝，水上人歌月下歸； 一闋聲長聽不盡，輕舟短楫去如飛。 -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.21-1-amd64 (SMP w/1 CPU core) Locale: LANG=nl_BE.UTF-8, LC_CTYPE=nl_BE.UTF-8 (charmap=UTF-8) 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-10 GNU C Library: Shared libraries ii libdbi-perl 1.55~svn20070405-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.2-20070528-1 GCC support library ii libmysqlclient15off 5.0.41-2 MySQL database client library ii libncurses5 5.6-3 Shared libraries for terminal hand ii libreadline5 5.2-3 GNU readline and history libraries ii libstdc++6 4.2-20070528-1 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.41-2 MySQL database client binaries ii mysql-common 5.0.41-2 MySQL database common files ii passwd 1:4.0.18.1-9 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-15 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii mailx 1:8.1.2-0.20070424cvs-1 A simple mail user agent -- debconf information: mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false mysql-server-5.0/no_upgrade_with_isam_tables: * mysql-server-5.0/mysql_install_db_notes: * mysql-server-5.0/need_sarge_compat: false mysql-server/error_setting_password: mysql-server-5.0/mysql_update_hints1: mysql-server-5.0/need_sarge_compat_done: true
