Ubuntu
mysql-8.0 package

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

Bug #2023492 reported by Rodrigo Huerta on 2023-06-11

This bug report is a duplicate of: Bug #2019003: package mysql-server-8.0 8.0.33-0ubuntu0.22.04.1 failed to install/upgrade: Can't start server: Bind on TCP/IP port: Address already in use. Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	mysql-8.0 (Ubuntu)	New	Undecided	Unassigned

Bug Description

trying to install mysql server throug shell and returned error

ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mysql-server-8.0 8.0.33-0ubuntu0.22.04.2
ProcVersionSignature: Ubuntu 5.19.0-43.44~22.04.1-generic 5.19.17
Uname: Linux 5.19.0-43-generic x86_64
ApportVersion: 2.20.11-0ubuntu82.5
Architecture: amd64
CasperMD5CheckResult: pass
Date: Sun Jun 11 12:07:02 2023
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2023-06-11 (0 days ago)
InstallationMedia: Ubuntu 22.04.2 LTS "Jammy Jellyfish" - Release amd64 (20230223)
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: my.cnf links to /etc/mysql/mysql.cnf
MySQLVarLibDirListing: ['undo_001', 'server-key.pem', 'sys', 'debian-5.7.flag', '#ib_16384_0.dblwr', 'mysql', 'ca-key.pem', 'private_key.pem', 'ca.pem', 'mysql.ibd', 'performance_schema', '#innodb_redo', '#ib_16384_1.dblwr', 'binlog.index', 'binlog.000001', 'ib_buffer_pool', 'ibdata1', 'server-cert.pem', 'public_key.pem', '#innodb_temp', 'binlog.000002', 'undo_002', 'client-cert.pem', 'client-key.pem', 'auto.cnf']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.19.0-43-generic root=UUID=16be9538-8faf-48be-95ab-9e2328e79c1c ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.10, Python 3.10.6, python3-minimal, 3.10.6-1~22.04
PythonDetails: N/A
RelatedPackageVersions:
dpkg 1.21.1ubuntu2.2
apt 2.4.9
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.33-0ubuntu0.22.04.2 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)

Tags:

Revision history for this message

Rodrigo Huerta (huertamerodio) wrote on 2023-06-11:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (2.0 KiB, text/plain; charset="utf-8")
AptOrdering.txt Edit (672 bytes, text/plain; charset="utf-8")
Dependencies.txt Edit (3.0 KiB, text/plain; charset="utf-8")
Df.txt Edit (404 bytes, text/plain; charset="utf-8")
Dmesg.txt Edit (87.0 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (129.4 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.txt Edit (38.1 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (1.1 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (3.1 KiB, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.cnf.txt Edit (682 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysql.cnf.txt Edit (132 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysqld.cnf.txt Edit (2.2 KiB, text/plain; charset="utf-8")
ProcCpuinfoMinimal.txt Edit (1.5 KiB, text/plain; charset="utf-8")

Revision history for this message

Alex Murray (alexmurray) wrote on 2023-06-13: Bug is not a security issue

Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find.

information type:

Private Security → Public

Revision history for this message

Sergio Durigan Junior (sergiodj) wrote on 2023-06-14:

Thank you for taking the time to file a bug report.

Based on the output present in Logs.var.log.mysql.error.log.txt:

2023-06-11T18:07:00.490581Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-06-11T18:07:00.503843Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use
2023-06-11T18:07:00.503871Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2023-06-11T18:07:00.503901Z 0 [ERROR] [MY-010119] [Server] Aborting

this seems to be a somewhat known problem that happens when trying to install mysql-server while another instance is already running. For some reason, the first instance seems to take too long to stop and the second instance tries to bind to port 3306, which is being listened on by the first instance.

This problem has been reported by other users, so I took the liberty of marking this bug as duplicate of bug #2019003. Please feel free to leave a comment here if you disagree with this action. Thank you.