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

Status changed to 'Confirmed' because the bug affects multiple users.

Is there any workaround for this? I can't install anything, package is broken.

And I can't work without MySQL.

I ended up completely formatting my HDD, because the last upgrade f*** up my system:
- every time I opened a new tab in Terminal of the file explorer it crashed.
- I couldn't make mysql start.
- the system was really unstable.

I lost a day of fixing problems, formatting and installing new Linux (LinuxMINT now btw).. this shouldn't happen guys ...

Oh man, not formatting.

This upgrade f*** my both computers. There must be some lighter way to do it. Maybe reinstalling from CD? I think there is some option when running installer.

Thanks anyway for your fast response, I'm really sorry this things happen.

Can anyone suggest workaround, please? At least tell me to reinstall Ubuntu.

This is what I did to get mysql 5.5 running on ubuntu 12.04

After upgrading to 12.04 I got the errors listed in the bug report and I
could not start mysql or set a password.

what I did was to run

1) sudo apt-get --purge remove mysql-server-5.1 mysql-server-5.5

and then run

2) sudo apt-get install mysql-server-5.5
3) sudo netstat- tap | grep mysql
4) sudo etc/init.d/mysql restart

After these steps mysql started running fine, I could create password and I
then installed phpmyadmin to create tables and manage the database. Hope it
helps.

Thanks,

On Mon, May 7, 2012 at 1:12 PM, Sasa Stamenkovic
<email address hidden>wrote:

> Can anyone suggest workaround, please? At least tell me to reinstall
> Ubuntu.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/989353
>
> Title:
> package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade:
> subprocess installed post-installation script returned error exit
> status 1
>
> Status in “mysql-5.5” package in Ubuntu:
> Confirmed
>
> Bug description:
> unable to login to mysql, Error: unable to set password fro mysql
> "root" user.
>
> I then tried to uninstall and then I got more error messages
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: mysql-server-5.5 5.5.22-0ubuntu1
> ProcVersionSignature: Ubuntu 3.2.0-24.37-generic 3.2.14
> Uname: Linux 3.2.0-24-generic i686
> ApportVersion: 2.0.1-0ubuntu6
> AptOrdering:
> libjaxp1.3-java: Remove
> mysql-server-5.5: Configure
> mysql-server: Configure
> Architecture: i386
> Date: Thu Apr 26 21:51:30 2012
> DuplicateSignature:
> Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
> start: Job failed to start
> invoke-rc.d: initscript mysql, action "start" failed.
> dpkg: error processing mysql-server-5.5 (--configure):
> subprocess installed post-installation script returned error exit
> status 1
> ErrorMessage: subprocess installed post-installation script returned
> error exit status 1
> InstallationMedia: Ubuntu-Netbook 10.04 "Lucid Lynx" - Release i386
> (20100429.4)
> Logs.var.log.daemon.log:
>
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['mysql_upgrade_info', 'test', 'shoppingcart',
> 'performance_schema', 'ibdata1', 'debian-5.1.flag', 'mysql',
> 'debian-5.5.flag']
> SourcePackage: mysql-5.5
> Title: package mysql-server-5.5 5.5.22-0ubuntu1 failed to
> install/upgrade: subprocess installed post-installation script returned
> error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-04-27 (0 days ago)
>
> To manage notifications about this bug go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/989353/+subscriptions
>

@Ritchard Thanks, but this didn't work for me :(

Here is what I get:

1)

 Went fine

2)

# apt-get install mysql-server-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  mysql-server-core-5.5
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 5,782 kB/14.5 MB of archives.
After this operation, 49.5 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://rpm.scl.rs/linux/ubuntu/archive/ precise/main mysql-server-core-5.5 i386 5.5.22-0ubuntu1 [5,782 kB]
Fetched 5,782 kB in 38s (152 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-server-core-5.5.
(Reading database ... 243237 files and directories currently installed.)
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.22-0ubuntu1_i386.deb) ...
Selecting previously unselected package mysql-server-5.5.
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.22-0ubuntu1_i386.deb) ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
Setting up mysql-server-core-5.5 (5.5.22-0ubuntu1) ...
Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
120507 20:46:54 [Note] Plugin 'FEDERATED' is disabled.
120507 20:46:54 InnoDB: The InnoDB memory heap is disabled
120507 20:46:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120507 20:46:54 InnoDB: Compressed tables use zlib 1.2.3.4
120507 20:46:54 InnoDB: Initializing buffer pool, size = 128.0M
120507 20:46:54 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
120507 20:46:54 [ERROR] Plugin 'InnoDB' init function returned error.
120507 20:46:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120507 20:46:54 [ERROR] Unknown/unsupported storage engine: InnoDB
120507 20:46:54 [ERROR] Aborting

120507 20:46:54 [Note] /usr/sbin/mysqld: Shutdown complete

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mysql-server-5.5
E: Sub-process /usr/bin/dpkg returned an error code (1)

I tried again, and I got:

# apt-get --purge remove mysql-server-5.1 mysql-server-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
Virtual packages like 'mysql-server-5.1' can't be removed
The following packages will be REMOVED:
  mysql-server-5.5*
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 31.3 MB disk space will be freed.
Do you want to continue [Y/n]? Y
(Reading database ... 243407 files and directories currently installed.)
Removing mysql-server-5.5 ...
Purging configuration files for mysql-server-5.5 ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...

The most important part is:

Virtual packages like 'mysql-server-5.1' can't be removed

I can't get rid of mysql-server-5.1.

Thanks in advance.

what do you see when you run dpkg -l | grep mysql-server?

On Mon, May 7, 2012 at 3:08 PM, Sasa Stamenkovic
<email address hidden>wrote:

> I tried again, and I got:
>
> # apt-get --purge remove mysql-server-5.1 mysql-server-5.5
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Virtual packages like 'mysql-server-5.1' can't be removed
> The following packages will be REMOVED:
> mysql-server-5.5*
> 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
> 1 not fully installed or removed.
> After this operation, 31.3 MB disk space will be freed.
> Do you want to continue [Y/n]? Y
> (Reading database ... 243407 files and directories currently installed.)
> Removing mysql-server-5.5 ...
> Purging configuration files for mysql-server-5.5 ...
> Processing triggers for ureadahead ...
> Processing triggers for man-db ...
>
> The most important part is:
>
> Virtual packages like 'mysql-server-5.1' can't be removed
>
> I can't get rid of mysql-server-5.1.
>
> Thanks in advance.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/989353
>
> Title:
> package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade:
> subprocess installed post-installation script returned error exit
> status 1
>
> Status in “mysql-5.5” package in Ubuntu:
> Confirmed
>
> Bug description:
> unable to login to mysql, Error: unable to set password fro mysql
> "root" user.
>
> I then tried to uninstall and then I got more error messages
>
> ProblemType: Package
> DistroRelease: Ubuntu 12.04
> Package: mysql-server-5.5 5.5.22-0ubuntu1
> ProcVersionSignature: Ubuntu 3.2.0-24.37-generic 3.2.14
> Uname: Linux 3.2.0-24-generic i686
> ApportVersion: 2.0.1-0ubuntu6
> AptOrdering:
> libjaxp1.3-java: Remove
> mysql-server-5.5: Configure
> mysql-server: Configure
> Architecture: i386
> Date: Thu Apr 26 21:51:30 2012
> DuplicateSignature:
> Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
> start: Job failed to start
> invoke-rc.d: initscript mysql, action "start" failed.
> dpkg: error processing mysql-server-5.5 (--configure):
> subprocess installed post-installation script returned error exit
> status 1
> ErrorMessage: subprocess installed post-installation script returned
> error exit status 1
> InstallationMedia: Ubuntu-Netbook 10.04 "Lucid Lynx" - Release i386
> (20100429.4)
> Logs.var.log.daemon.log:
>
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['mysql_upgrade_info', 'test', 'shoppingcart',
> 'performance_schema', 'ibdata1', 'debian-5.1.flag', 'mysql',
> 'debian-5.5.flag']
> SourcePackage: mysql-5.5
> Title: package mysql-server-5.5 5.5.22-0ubuntu1 failed to
> install/upgrade: subprocess installed post-installation script returned
> error exit status 1
> UpgradeStatus: Upgraded to precise on 2012-04-27 (0 days ago)
>
> To manage notifications about this bug go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/989353/+subscriptions
>

richard@richard-laptop:~$ sudo pico 1335532033831.log
[sudo] password for richard:
richard@richard-laptop:~$ sudo dpkg -l |grep mysql-server[sudo] password
for richard:
ii mysql-server-5.5 5.5.22-0ubuntu1
                 MySQL database server binaries and system database setup
ii mysql-server-core-5.5 5.5.22-0ubuntu1
                 MySQL database server binaries
richard@richard-laptop:~$ sudo dpkg -l |grep mysql
ii libdbd-mysql-perl 4.020-1build2
                 Perl5 database interface to the MySQL database
rc libmysqlclient16 5.1.62-0ubuntu0.11.10.1
                 MySQL database client library
ii libmysqlclient18 5.5.22-0ubuntu1
                 MySQL database client library
ii mysql-client-5.5 5.5.22-0ubuntu1
                 MySQL database client binaries
ii mysql-client-core-5.5 5.5.22-0ubuntu1
                 MySQL database core client binaries
ii mysql-common 5.5.22-0ubuntu1
                 MySQL database common files, e.g. /etc/mysql/my.cnf
rc mysql-navigator 1.4.2-13
                  GUI client program for MySQL database server
ii mysql-server-5.5 5.5.22-0ubuntu1
                 MySQL database server binaries and system database setup
ii mysql-server-core-5.5 5.5.22-0ubuntu1
                 MySQL database server binaries
ii php5-mysql 5.3.10-1ubuntu3.1
                 MySQL module for php5
richard@richard-laptop:~$

On Mon, May 7, 2012 at 4:20 PM, Richard Saulsberry
<email address hidden>wrote:

> what do you see when you run dpkg -l | grep mysql-server?
>
>
>
>
> On Mon, May 7, 2012 at 3:08 PM, Sasa Stamenkovic <
> <email address hidden>> wrote:
>
>> I tried again, and I got:
>>
>> # apt-get --purge remove mysql-server-5.1 mysql-server-5.5
>> Reading package lists... Done
>> Building dependency tree
>> Reading state information... Done
>> Virtual packages like 'mysql-server-5.1' can't be removed
>> The following packages will be REMOVED:
>> mysql-server-5.5*
>> 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
>> 1 not fully installed or removed.
>> After this operation, 31.3 MB disk space will be freed.
>> Do you want to continue [Y/n]? Y
>> (Reading database ... 243407 files and directories currently installed.)
>> Removing mysql-server-5.5 ...
>> Purging configuration files for mysql-server-5.5 ...
>> Processing triggers for ureadahead ...
>> Processing triggers for man-db ...
>>
>> The most important part is:
>>
>> Virtual packages like 'mysql-server-5.1' can't be removed
>>
>> I can't get rid of mysql-server-5.1.
>>
>> Thanks in advance.
>>
>> --
>> You received this bug notification because you are subscribed to the bug
>> report.
>> https://bugs.launchpad.net/bugs/989353
>>
>> Title:
>> package mysql-server-5.5 5.5.22-0ubuntu1 failed to install/upgrade:
>> subprocess installed post-installation script returned error exit
>> status 1
>>
>> Sta...

@Richard

# dpkg -l | grep mysql-server
ii mysql-server-core-5.5 5.5.22-0ubuntu1 MySQL database server binaries

Any idea?

I fixed it thanks to http://askubuntu.com/questions/134574/fixing-broken-myslq-server-package-after-upgrade-to-12-04

My problem was related to the datadir. I had it set up to go to an external harddisk but when I pointed it back to the default setup it worked fine again. When I change it back to the other path, mysql won't start.

datadir = /var/lib/mysql
#datadir = /mnt/Work/mysql

@4ing

Mysql is restricted in terms of what it can access by apparmor - if you use non-standard locations then you need to update the apparmor profile to include them.

These can get set in /etc/apparmor.d/local/usr.sbin.mysqld - you will need to add something like:

  /mnt/Work/mysql r,
  /mnt/Work/mysql/** rwk,

Thanks for the response james, I actually tried that but couldn't get it to work. I fixed the problem by just linking to the database files in the /usr/var/lib

LinkedIn
------------

Bug,

I'd like to add you to my professional network on LinkedIn.

- Richard

Richard Saulsberry
Owner at Integrity Settlement Adjusters, LLC
West Palm Beach, Florida Area

Confirm that you know Richard Saulsberry:
https://www.linkedin.com/e/-g04i2f-hkb28087-6d/isd/15740817358/YSZmonwk/?hs=false&tok=3KYpGHVWgh2lU1

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/-g04i2f-hkb28087-6d/hAH8cB_IxutWogwIiW6OgmsIkXu5fIZmKKAt8cg/goo/989353%40bugs%2Elaunchpad%2Enet/20061/I5237109963_1/?hs=false&tok=1q91K5B3sh2lU1

(c) 2012 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.