[debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze -> wheezy, does not start

[Antti-Juhani Kaijanaho]

Package: mysql-server-5.5
Version: 5.5.24+dfsg-4
Followup-For: Bug #682232

I worked around this by the following:

First, started mysqld with innodb_force_recovery = 1.  Then, verified that none
of my tables actually used InnoDB by the following query: 

 SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';

Finally, after stopping mysqld again, I took a backup of /var/lib/mysql and
then deleted the InnoDB files there.

Afterwards, mysql started fine with innodb_force_recovery = 0 and appears now
to be working correctly.

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.32.33-kvm-i386-20111128-dirty (SMP w/1 CPU core)
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.44
ii  initscripts            2.88dsf-22.1
ii  libc6                  2.13-33
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.1-2
ii  libstdc++6             4.7.1-2
ii  lsb-base               4.1+Debian7
ii  mysql-client-5.5       5.5.24+dfsg-4
ii  mysql-common           5.5.24+dfsg-4
ii  mysql-server-core-5.5  5.5.24+dfsg-4
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.14.2-12
ii  psmisc                 22.19-1
ii  zlib1g                 1:1.2.7.dfsg-13

Versions of packages mysql-server-5.5 recommends:
ii  bsd-mailx [mailx]      8.1.2-0.20111106cvs-1
ii  libhtml-template-perl  2.91-1

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5'
/etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5'
/etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5'

-- debconf information:
  mysql-server/error_setting_password:
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server-5.5/nis_warning:
  mysql-server-5.5/really_downgrade: false
  mysql-server-5.5/start_on_boot: true
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb: