[Bug 1011220] Re: package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Marc Cluet]

Unfortunately looks like there's some kind of corruption in your InnoDB
files, this happened due to an upgrade from a pre MySQL 5.1 version to
5.5 directly.

InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 0.
InnoDB: You may have to recover from a backup.

Looking at the MySQL forums this is the recommended way to repair this:

Your error log states mysql does have the support it needs to run with
innoDB support but you`ve modified the size of the ibdata1 file withouth
removing the old file first.

In case you did not have any innodb tables in your mysql installation
it`s safe to remove it and restart mysql in order for it to recreate
that file.

IF you did have data in innodb tables, you should edit your my.cnf file and restore the size value of the following line to it`s default:
'innodb_data_file_path=ibdata1:200M:autoextend '
// 200M was not the default at installation .

After which you should export the database using mysql_dump or any other
export method you prefer, remove the ibdata file, edit my.cnf with new
size, restart mysql, import old data and you should be done.

Marking this bug as invalid since it's not related to packaging and it's
a database data corruption.

** Changed in: mysql-5.5 (Ubuntu)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.5 in Ubuntu.
https://bugs.launchpad.net/bugs/1011220

Title:
  package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade:
  subprocess installed post-installation script returned error exit
  status 1

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1011220/+subscriptions