mysql-server-8.0 8.0.29-0ubuntu0.20.04.3 failed to install/upgrade: Can't start server: Bind on TCP/IP port: Address already in use

[Ali Hassan]

unable to install mysql serve and mysql workbeanch on ubuntu 20.04

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.29-0ubuntu0.20.04.3
ProcVersionSignature: Ubuntu 5.13.0-40.45~20.04.1-generic 5.13.19
Uname: Linux 5.13.0-40-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.23
Architecture: amd64
CasperMD5CheckResult: skip
Date: Fri May 6 14:14:39 2022
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-05-06 (0 days ago)
InstallationMedia: Ubuntu 20.04.2.0 LTS "Focal Fossa" - Release amd64 (20210209.1)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'
MySQLVarLibDirListing: ['#ib_16384_0.dblwr', 'auto.cnf', 'binlog.000001', 'client-cert.pem', 'server-key.pem', 'public_key.pem', 'ibdata1', '#ib_16384_1.dblwr', 'mysql.ibd', 'sys', 'ib_logfile0', 'ib_buffer_pool', 'binlog.index', 'ib_logfile1', 'mysql', 'performance_schema', 'client-key.pem', 'server-cert.pem', 'ca-key.pem', 'binlog.000002', 'private_key.pem', 'undo_002', 'debian-5.7.flag', '#innodb_temp', 'undo_001', 'ca.pem']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.13.0-40-generic root=UUID=0ee5580f-81c1-44fd-a78e-ef5b6f1beccf ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.8, Python 3.8.10, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.19.7ubuntu3
 apt 2.0.6
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.29-0ubuntu0.20.04.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Paride Legovini (paride)]

Hello and thanks for this bug report. In the attached logs I see the following:

MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'

This looks like a local configuration problem (circular symlinking), rather than a bug in Ubuntu.

You can find pointers to get help for this sort of problem here: https://ubuntu.com/support/community-support

Since we use this bug tracker to track bugs in Ubuntu, rather than configuration problems, I'm marking this bug as Invalid. This helps us to focus on fixing bugs in Ubuntu.

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. Thanks!

[Lena Voytek (lvoytek)]

Hello,

The error Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' is actually an error with the reporting system and not your configuration. Info on the actual error likely lies in the error.log file.

Would you be able to attach the file /var/log/mysql/error.log to this bug to help me diagnose the issue?

Thanks!

[Xosé (ubuntu-galizaweb)]

I was following the recommended procedure to install Moodle (on https://docs.moodle.org/400/en/Step-by-step_Installation_Guide_for_Ubuntu): sudo apt install apache2 mysql-client mysql-server php7.4 libapache2-mod-php

[Paride Legovini (paride)]

Thanks Lena. Looks like the error is:

2022-05-06T09:14:37.838870Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use
2022-05-06T09:14:37.838962Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2022-05-06T09:14:37.839679Z 0 [ERROR] [MY-010119] [Server] Aborting

which is normally due to the fact that mysqld has been manually started without using the proper init system helpers.

@Ali/@Xosé: in this case what we need is some verification that the problem happens starting with a clear Ubuntu system, and without manually starting mysqld. If you can verify this actually happens, please comment back with the exact steps we should follow to reproduce the issue. I suggest trying to reproduce the issue in a LXD container. Thanks!

[Lena Voytek (lvoytek)]

Thanks for finding the errors Paride, for some reason the attachments weren't showing up last time when I looked into this bug. Given the errors, this is likely another duplicate of LP: #1921378.
Before I mark it as such though, Ali / Xosé can you try installing mysql again to see if it works the second time? You can use the following commands:

sudo apt purge mysql*
sudo apt install mysql-server

Thanks!

[Launchpad Janitor (janitor)]

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