Question

3

Fixing broken myslq-server package after upgrade to 12.04

rated 0 times [ 3] [ 0] / answers: 1 / hits: 15086 / 2 Years ago, thu, march 10, 2022, 6:32:14

After upgrade to 12.04 mysql server was unable to start.

I tried many different things but without any luck.

Now when I try to install it, I get:

$  sudo apt-get install mysql-server-5.5

Reading package lists... Done

Building dependency tree       

Reading state information... Done

Suggested packages:

  tinyca

The following NEW packages will be installed:

  mysql-server-5.5

0 upgraded, 1 newly installed, 0 to remove and 39 not upgraded.

Need to get 0 B/8,708 kB of archives.

After this operation, 31.3 MB of additional disk space will be used.

Preconfiguring packages ...

Selecting previously unselected package mysql-server-5.5.

(Reading database ... 243325 files and directories currently installed.)

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

ureadahead will be reprofiled on next reboot

Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...

120509 20:32:08 [Note] Plugin 'FEDERATED' is disabled.

120509 20:32:08 InnoDB: The InnoDB memory heap is disabled

120509 20:32:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120509 20:32:08 InnoDB: Compressed tables use zlib 1.2.3.4

120509 20:32:08 InnoDB: Initializing buffer pool, size = 128.0M

120509 20:32:08 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!

120509 20:32:09 [ERROR] Plugin 'InnoDB' init function returned error.

120509 20:32:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

120509 20:32:09 [ERROR] Unknown/unsupported storage engine: InnoDB

120509 20:32:09 [ERROR] Aborting



120509 20:32:09 [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)

Can someone suggest some way to fix this or I must to reinstall entire system?

Thanks in advance.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

bsorbedeldy

Add To Favorites

Follow

Total Points: 315

Total Questions: 110

Total Answers: 108

Location: Reunion

Member since Mon, Dec 28, 2020

3 Years ago

bsorbedeldy questions

1 grub-efi-arm64-signed : Depends: grub-efi-arm64 (= 2.06-2ubuntu7) but 2.06-2ubuntu10 is to be installed

Mon, Jul 11, 22, 09:56, 2 Years ago

1 Ubuntu 22.04.1 LTS - Hotspot - Connected but without internet on Android 11

Fri, Feb 18, 22, 14:05, 2 Years ago

1 How to install cpupower on Ubuntu 20.04 with kernel 5.17+

Mon, Apr 25, 22, 03:39, 2 Years ago

1 Ubuntu partition does not seem to use all free space: how did it happen? and can it be done with Gnome's "Disks"?

Wed, May 10, 23, 12:41, 1 Year ago

1 XPS 9510 with OLED screen no brightness control with Ubuntu 21.04

Tue, Jun 21, 22, 21:35, 2 Years ago

View All

answered 2 Years ago finatch · Accepted Answer

Reinstalling your complete system is not needed. If anything you can always do

sudo apt-get remove --purge mysql-server

sudo apt-get install mysql-server-5.5

Things that happend when I installed mysql and ran into trouble:

It is possible your missing or have a corrupt /etc/my.cnf (see the message about a problem in .cnf?). If so ...
```
sudo mv /etc/mysql/my.cnf  /etc/mysql/my.cnf.old 

sudo cp /etc/mysql/my.cnf.dpkg-old /etc/mysql/my.cnf

/etc/init.d/mysql start
```
Ofcourse do 1st check if you have a my.cnf.dpkg.dist