[Bug 1013641] Re: package mysql-server-5.5 5.5.24-0ubuntu0.12.04.1 failed to install/upgrade: Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück

[Marc Cluet]

Hi Hugo,

First of all, I wouldn't recommend doing an upgrade jumping a release
over, you went straight from 11.04 to 12.04 without upgrading to 11.10
first, this is not supported and can have unexpected complications.

Unfortunately looks like there's some kind of corruption in your InnoDB
files.

InnoDB: Error: auto-extending data file ./ibdata1 is of a different size

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/1013641

Title:
  package mysql-server-5.5 5.5.24-0ubuntu0.12.04.1 failed to
  install/upgrade: Unterprozess installiertes post-installation-Skript
  gab den Fehlerwert 1 zurück

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