30 April 2017

[FIXED] MySQL-Server 5.7

Affect Distribution Importance Assigned to Status
MySQL-Server 5.7 Ubuntu 16.04.1 (x86_64) High h3rucutu Solved

Version : 5.7.18
Packages : mysql-server-5.7 (mysql-server-5.7.18-0ubuntu0.16.04.1)
mysql-server (mysql-server-5.7.18-0ubuntu0.16.04.1)
Bug Description : Upgrading MySQL-Server to 5.7.18 version using apt-get
Reproduce : ~$ sudo apt-get upgrade mysql-server-5.7 mysql-server
Also Found : launchpad(bug-1605948)
Solution : ~$ sudo service mysql start
~$ sudo mysql_upgrade -p
~$ sudo dpkg --configure mysql-server-5.7
~$ sudo dpkg --configure mysql-server

Root Caused :
  1. While upgrading mysql-server, mysql-server has been shutting down [insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script `mysql' overrides LSB defaults (0 1 6)].
  2. When the mysql_upgrade running, it's can't connect to mysql-server [mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server].
  3. Leaving error on mysql-server-5.7 [dpkg: error processing package mysql-server-5.7 (--configure): subprocess installed post-installation script returned error exit status 1].
  4. And also leaving error on mysql-server too [dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.7; however: Package mysql-server-5.7 is not configured yet].

0 comments: