8.0.15 to 8.0.16 upgrade fails due to permissions on Ubuntu

[Rajeev Jha]

Hi

Where do we report the bug issues found in mysql platform specific binary packages? Can someone point me in the right direction? Here is the issue we had after updating to 8.0.16 on Ubuntu


Environment is Ubuntu 16.04 LTS
This machine first installed 8.0.11
Current upgrade was 8.0.15 -> 8.0.16
The update was done through aptitude

The mysql server refused to start after the upgrade. There were 2 issues. The mysql/mysql_upgrade_info file still had 8.0.15 as entry after the update.


Apr 25 09:08:09 yuktix-apiv11devm1 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Apr 25 09:08:09 yuktix-apiv11devm1 systemd[1]: Failed to start MySQL Community Server


error.log had

[Server] Could not create server upgrade info file at '/var/lib/mysql/'.
2019-04-25T09:08:08.106750Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.

so it looked like a permission issue with /var/lib/mysql. Looks like the upgrade was not able to write to that file because the ownership was with root. A sudo chown mysql on mysql_upgrade_info fixed that issue.



After that another issues was missing /var/run/mysqld files.

$sudo /usr/sbin/mysqld-debug --user=mysql --log-error-verbosity=3

Server hostname (bind-address): '*'; port: 3306
IPv6 is available.
- '::' resolves to '::';
Server socket created on IP: '::'.
Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
Unable to setup unix socket lock file.
Aborting


creating the directory manually fixed that issue. off-topic but 8.0.x updates have been one heck of bumpy rides so far.