[debian-mysql] Bug#411672: mysql-server-5.0: Incorrect file format 'host'

Sat Jun 9 23:51:54 UTC 2007

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