Tuesday, September 3, 2019

14.04 - Updating to MySQL 5.6.27 fails but why?

I am using Ubuntu 14.04.3 LTS, I was using MySQL 5.6.24 via (https://launchpad.net/~ondrej/+archive/ubuntu/mysql-5.6) and have just tried to update it but it dies with:



0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-0ubuntu0.14.04.1) starting as process 3486 ...
3486 [Note] Plugin 'FEDERATED' is disabled.
3486 [Note] InnoDB: Using atomics to ref count buffer pool pages
3486 [Note] InnoDB: The InnoDB memory heap is disabled
3486 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

3486 [Note] InnoDB: Memory barrier is not used
3486 [Note] InnoDB: Compressed tables use zlib 1.2.8
3486 [Note] InnoDB: Using Linux native AIO
3486 [Note] InnoDB: Using CPU crc32 instructions
3486 [Note] InnoDB: Initializing buffer pool, size = 128.0M
3486 [Note] InnoDB: Completed initialization of buffer pool
3486 [Note] InnoDB: Highest supported file format is Barracuda.
3486 [Note] InnoDB: 128 rollback segment(s) are active.
3486 [Note] InnoDB: Waiting for purge to start
3486 [Note] InnoDB: 5.6.27 started; log sequence number 1059121176

3486 [Note] Binlog end
3486 [Note] InnoDB: FTS optimize thread exiting.
3486 [Note] InnoDB: Starting shutdown...
3486 [Note] InnoDB: Shutdown completed; log sequence number 1059121186
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
subprocess installed post-installation script returned error exit status 1
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
Processing triggers for ureadahead (0.100.0-16) ...

Errors were encountered while processing:
mysql-server-5.6
E: Sub-process /usr/bin/dpkg returned an error code (1)


I have run through the following answers:



E: Mysql-server-5.5 Installation Error



mysql-server-5.5 has unmet dependencies




Why did installation of MySQL 5.6 on Ubuntu 14.04 fail?



How do I resolve unmet dependencies after adding a PPA?



But I am still no closer to figuring out what is wrong with this other than that it might be something to be with dependencies. I have tried:



dpkg -l | grep mysql

ii libdbd-mysql-perl 4.025-1 amd64 Perl5 database interface to the MySQL database

ii libmysqlclient18:amd64 5.6.25-3+deb.sury.org~trusty+1 amd64 MySQL database client library
ii mysql-client-5.6 5.6.27-0ubuntu0.14.04.1 amd64 MySQL database client binaries
ii mysql-client-core-5.6 5.6.27-0ubuntu0.14.04.1 amd64 MySQL database core client binaries
ii mysql-common 5.6.25-3+deb.sury.org~trusty+1 all MySQL database common files, e.g. /etc/mysql/my.cnf
iF mysql-server-5.6 5.6.27-0ubuntu0.14.04.1 amd64 MySQL database server binaries and system database setup
ii mysql-server-core-5.6 5.6.27-0ubuntu0.14.04.1 amd64 MySQL database server binaries
rc php5-mysqlnd 5.5.30+dfsg-1+deb.sury.org~trusty+1 amd64 MySQL module for php5 (Native Driver)


Which indicates that mysql-common is a lesser version than the rest of them, not sure if this makes much of a difference here though as on another system it is there but at a higher revision than the rest of them at .24.




Found this that suggests that it may be something to do with the apparmor (had no idea that this could affect things) config but I did not upgrade from 5.5:



https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1455773



Only other option I can see here for me is to try to update to 5.7 and see if that has any change for my problem.



Any additional feedback or suggestions on how I could resolve this would be greatly appreciated as I really have no idea why this is happening now.

No comments:

Post a Comment

11.10 - Can't boot from USB after installing Ubuntu

I bought a Samsung series 5 notebook and a very strange thing happened: I installed Ubuntu 11.10 from a usb pen drive but when I restarted (...