Hi Akanksha,
in your logs I see

mysqld is running as pid 9221
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

Which implies it failed to start/restart on an upgrae,.
When looking for errors I found:

2021-05-16T07:06:41.654237Z 0 [System] [MY-013602] [Server] Channel mysql_main 
configured to support TLS. Encrypted connections are now supported for this 
channel.
2021-05-16T07:06:41.657827Z 0 [ERROR] [MY-010273] [Server] Could not create 
unix socket lock file /opt/lampp/var/mysql/mysql.sock.lock.
2021-05-16T07:06:41.658385Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix 
socket lock file.

Which shows us what failed and made me suspicious as this is an uncommon path 
that was used.
With that in mind I found

[ 1737.039283] audit: type=1400 audit(1621080213.808:139):
apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld"
name="/opt/lampp/var/mysql/mysql.sock.lock" pid=10896 comm="mysqld"
requested_mask="c" denied_mask="c" fsuid=126 ouid=126


And now things made sense, if you configure "too far away" from the default 
config you have to modify the apparmor profile as well to allow that.
By default apparmor tries to isolate the mysqld process to protect your system 
and in this case the new path that you have configured is blocked by that 
isolation.

If you have changed that (either allowed the path or configured it to a
common one that is allowed by default) the upgrade will likely work
again.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1928569

Title:
  package mysql-server-8.0 8.0.25-0ubuntu0.20.04.1 failed to
  install/upgrade: installed mysql-server-8.0 package post-installation
  script subprocess returned error exit status 1

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1928569/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to