server upgrade 14.04 to 16.04 exited with error

[purvez desai]

Following is a section of the screen from where the Errors section appears:

====================================

Running hooks in /etc/ca-certificates/update.d...
done.
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
Error in function:

A fatal error occurred

Please report this as a bug and include the files
/var/log/dist-upgrade/main.log and /var/log/dist-upgrade/apt.log in
your report. The upgrade has aborted.
Your original sources.list was saved in
/etc/apt/sources.list.distUpgrade.

SystemError: E:Sub-process /usr/bin/dpkg returned an error code (1)

Could not install the upgrades

The upgrade has aborted. Your system could be in an unusable state. A
recovery will run now (dpkg --configure -a).

Please report this bug in a browser at
http://bugs.launchpad.net/ubuntu/+source/ubuntu-release-upgrader/+filebug
and attach the files in /var/log/dist-upgrade/ to the bug report.
installArchives() failed

Setting up mysql-server-5.7 (5.7.17-0ubuntu0.16.04.1) ...
Renaming removed key_buffer and myisam-recover options (if present)
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
invoke-rc.d: release upgrade in progress, error is not fatal
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
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.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server

Upgrade complete

The upgrade has completed but there were errors during the upgrade
process.

To continue please press [ENTER]

=============================

As instructed I've tar the dist-upgrade directory and included it as an attachment

[purvez desai (purvez)]

Searching on the web I have found things that look similar :

Here : https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1573279

and here : https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1577712

It has been decided that the first link is a duplicate of the second link. Bug 1577712 shows as Completed on 2016-07-21.

Yet I'm having the same problem some 9 months later. Perhaps my situation only 'looks' similar to the previous ones.

I'm going to try the 'accepted answer' at following link to see whether it fixes it or not.

http://askubuntu.com/questions/760724/16-04-upgrade-broke-mysql-server

I'll report back.

[purvez desai (purvez)]

Reporting back after doing the purge and install instructions.

Here is the output after the apt install instruction:

==================

nexargi@server-02:/$ sudo apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  aptitude-common g++-4.8 gcc-4.9-base libboost-iostreams1.54.0 libboost-iostreams1.58.0 libc-ares2 libck-connector0 libcwidget3 libdbd-mysql-perl libdbi-perl libept1.4.12 libgcrypt11-dev libgcrypt20-dev
  libgnutlsxx27 libgpg-error-dev libisl10 libprocps3 libsigc++-2.0-0c2a libstdc++-4.8-dev libterm-readkey-perl libv8-3.14.5 libxapian22v5 linux-image-3.11.0-15-generic linux-image-extra-3.11.0-15-generic
  python-chardet python-cheetah python-configobj python-json-pointer python-jsonpatch python-oauth python-pkg-resources python-prettytable python-requests python-serial python-six python-urllib3 python-yaml
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
  mysql-server-5.7 mysql-server-core-5.7
Suggested packages:
  mailx tinyca
Recommended packages:
  libhtml-template-perl
The following NEW packages will be installed:
  mysql-server mysql-server-5.7 mysql-server-core-5.7
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/10.6 MB of archives.
After this operation, 94.7 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
N: Ignoring file '50unattended-upgrades.ucf-old' in directory '/etc/apt/apt.conf.d/' as it has an invalid filename extension
Preconfiguring packages ...
Selecting previously unselected package mysql-server-core-5.7.
(Reading database ... 98452 files and directories currently installed.)
Preparing to unpack .../mysql-server-core-5.7_5.7.17-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.17-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server-5.7.
Preparing to unpack .../mysql-server-5.7_5.7.17-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.17-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.17-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.17-0ubuntu0.16.04.1) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for systemd (229-4ubuntu16) ...
Processing triggers for ureadahead (0.100.0-19) ...
Setting up mysql-server-core-5.7 (5.7.17-0ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.17-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
mysqld: Can't read dir of '/etc/mysql/mysql.conf.d/' (Errcode: 13 - Permission denied)
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed po...

[purvez desai (purvez)]

I'm getting rather frustrated because I'm not getting any response from Canonical about this problem.

Here is some additional stuff that I tried.

I reverted back to Ubuntu 14.04 and tried to 'just' upgrade mysql to 5.7. I got similar messages about not being able to access /etc/mysql/mysql.conf.d (permission denied). So I googled those and came across this bug reported:

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

This seemed like very much what I was experiencing when upgrading from mysql5.5 to mysql5.7. So I reverted back to 14.04 and ran do-release-upgrade but this time ensured that when asked whether I want to replace /etc/apparmor.d/user.sbin.mysqld I said 'Y'.

However I still ended up with the same problem.

Clearly there is something else that I haven't found or cottoned on to yet.

Please I need URGENT help here.

Thanks

[purvez desai (purvez)]

Please read this to understand what the REAL underlying problem was and how to solve it manually.

https://answers.launchpad.net/ubuntu/+question/614629

[purvez desai (purvez)]

I am still concerned at Canonical's inability/unwillingness to engage with me about the above reported bug.

Clearly they either have much BIGGER problems OR are not interested in very small users.

SAD REALLY.