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

[Richard]

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)

[Launchpad Janitor (janitor)]

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

[Sasa Stamenkovic (umpirsky)]

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

And I can't work without MySQL.

[Petar Tahchiev (paranoiabla)]

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 ...

[Sasa Stamenkovic (umpirsky)]

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.

[Sasa Stamenkovic (umpirsky)]

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

[Richard (resaulsberry)]

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
>

[Sasa Stamenkovic (umpirsky)]

@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)

[Sasa Stamenkovic (umpirsky)]

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.

[Richard (resaulsberry)]

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 (resaulsberry)]

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...

[Sasa Stamenkovic (umpirsky)]

@Richard

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

[Sasa Stamenkovic (umpirsky)]

Any idea?

[Sasa Stamenkovic (umpirsky)]

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

[daniel4ing (4ing)]

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

[James Page (james-page)]

@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,

[daniel4ing (4ing)]

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

[Richard (resaulsberry)]

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.