during installation of mysql server on ubuntu 20.04.1 LTS , it crashed with a bug

[Muhammad Salam]

(Reading database ... 397613 files and directories currently installed.)
Preparing to unpack .../mysql-server-8.0_8.0.21-0ubuntu0.20.04.4_amd64.deb ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mysql-server-8.0_8.0.21-0
ubuntu0.20.04.4_amd64.deb (--unpack):
 new mysql-server-8.0 package pre-installation script subprocess returned error
exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-8.0_8.0.21-0ubuntu0.20.04.4_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 (not installed)
ProcVersionSignature: Ubuntu 5.4.0-48.52-generic 5.4.60
Uname: Linux 5.4.0-48-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.9
Architecture: amd64
CasperMD5CheckResult: skip
Date: Sat Sep 26 15:33:33 2020
ErrorMessage: new mysql-server-8.0 package pre-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2020-09-24 (1 days ago)
InstallationMedia: Ubuntu 20.04.1 LTS "Focal Fossa" - Release amd64 (20200731)
Python3Details: /usr/bin/python3.8, Python 3.8.2, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.19.7ubuntu3
 apt 2.0.2ubuntu0.1
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 (not installed) failed to install/upgrade: new mysql-server-8.0 package pre-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[David González (allenskd)]

Would like to mention this is happening to me as well. I'm using an image of Ubuntu Server 20.04 with Amazon AWS Lightsail. I'm clueless on what to do anymore. It's a fresh install of ubuntu server. I believe mariadb is also impacted (but I know that would require a new ticket so ignore this).

[Robie Basak (racb)]

Thank you for taking the time to report this bug and helping to make Ubuntu better.

Since it seems likely to me that this is a local configuration problem, rather than a bug in Ubuntu, I'm marking this bug as Incomplete.

If indeed this is a local configuration problem, you can find pointers to get help for this sort of problem here: http://www.ubuntu.com/support/community

Or if you believe that this is really a bug, then you may find it helpful to read "How to report bugs effectively" http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then provide a more complete description of the problem, explain why you believe this is a bug in Ubuntu rather than a problem specific to your system, and then change the bug status back to New.

[Eduardo Bonato (ebonato)]

Please look at bug #1899075 if it look similar to your use case.

[Christian Ehrhardt  (paelzer)]

@Eduardo - your bug 1899075 actually is bug 1612517 which you assumed already. But this bug here is not showing the the issue of "old configs no more working on upgrade" in the logs.

[Launchpad Janitor (janitor)]

[Expired for mysql-8.0 (Ubuntu) because there has been no activity for 60 days.]

[Kesavan Muthuvel (k7-india)]

Validate the service path `ls -laF /lib/systemd/system/mysql.service`

- Check for any broken service link (`/etc/systemd/system/mysql.service `)
- Remove any MariaDB stuff (`sudo dpkg --get-selections | grep maria`)
- Details found at https://blog.kesavan.info/2024/03/03/fix-for-mysql-8x-installation-failure-on-ubuntu-20-04/