Ubuntu
mysql-8.0 package

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

Bug #2069209 reported by Amie Nel on 2024-06-12

This bug report will be marked for expiration in 53 days if no further activity occurs. (find out why)

This bug affects 1 person

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

Bug Description

>>> apt terminal output (mysql log output below)
dpkg: error processing package mysql-server-8.0 (--configure):
installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-8.0; however:
Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for gnome-menus (3.36.0-1.1ubuntu3) ...
Processing triggers for libc-bin (2.39-0ubuntu8.2) ...
No apport report written because the error message indicates its a followup error from a previous failure.
Processing triggers for ma
n-db (2.12.0-4build2) ...
Processing triggers for desktop-file-utils (0.27-2build1) ...
Errors were encountered while processing:
mysql-server-8.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

>>> /var/log/mysql/error.log

2024-06-12T20:09:57.798491Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:09:57.798543Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:09:57.803283Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
2024-06-12T20:09:57.803307Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2024-06-12T20:09:57.803349Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-12T20:09:59.169728Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-2ubuntu3) (Ubuntu).
2024-06-12T20:09:59.773808Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-2ubuntu3) starting as process 1431576
2024-06-12T20:09:59.783053Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-12T20:10:02.025268Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-12T20:10:02.627277Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:10:02.627347Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:10:02.633449Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
2024-06-12T20:10:02.633484Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2024-06-12T20:10:02.633529Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-12T20:10:03.917400Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-2ubuntu3) (Ubuntu).
2024-06-12T20:10:04.526415Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-2ubuntu3) starting as process 1431669
2024-06-12T20:10:04.535868Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-12T20:10:06.781597Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-12T20:10:07.519056Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:10:07.519105Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:10:07.523931Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
2024-06-12T20:10:07.523954Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2024-06-12T20:10:07.524000Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-12T20:10:08.678658Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-2ubuntu3) (Ubuntu).
2024-06-12T20:10:09.289154Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-2ubuntu3) starting as process 1431720
2024-06-12T20:10:09.298212Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-12T20:10:11.874229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-12T20:10:12.577431Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:10:12.577480Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:10:12.583200Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
2024-06-12T20:10:12.583234Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2024-06-12T20:10:12.583292Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-12T20:10:13.832398Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-2ubuntu3) (Ubuntu).
2024-06-12T20:10:19.470954Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-0ubuntu0.24.04.1) starting as process 1432206
2024-06-12T20:10:19.495484Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-12T20:10:21.685240Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-12T20:10:22.296587Z 4 [System] [MY-013381] [Server] Server upgrade from '80036' to '80037' started.
2024-06-12T20:10:36.751870Z 4 [System] [MY-013381] [Server] Server upgrade from '80036' to '80037' completed.
2024-06-12T20:10:37.211946Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:10:37.211993Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:10:37.217982Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2024-06-12T20:10:37.238414Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-06-12T20:10:37.238521Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.37-0ubuntu0.24.04.1' socket: '/tmp/tmp.0cKhfIYSwv/mysqld.sock' port: 0 (Ubuntu).
2024-06-12T20:10:37.278078Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.37-0ubuntu0.24.04.1).
2024-06-12T20:10:39.558841Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37-0ubuntu0.24.04.1) (Ubuntu).
2024-06-12T20:10:40.822005Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.37-0ubuntu0.24.04.1) starting as process 1432582
2024-06-12T20:10:40.832383Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-12T20:10:42.848055Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-12T20:10:43.457662Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-12T20:10:43.457739Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-12T20:10:43.461855Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
2024-06-12T20:10:43.461874Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2024-06-12T20:10:43.461897Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-12T20:10:44.874971Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.37-0ubuntu0.24.04.1) (Ubuntu).

ProblemType: Package
DistroRelease: Ubuntu 24.04
Package: mysql-server-8.0 8.0.37-0ubuntu0.24.04.1
ProcVersionSignature: Ubuntu 6.8.0-35.35-generic 6.8.4
Uname: Linux 6.8.0-35-generic x86_64
ApportVersion: 2.28.1-0ubuntu3
Architecture: amd64
CasperMD5CheckResult: pass
Date: Wed Jun 12 22:10:44 2024
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2024-04-27 (47 days ago)
InstallationMedia: Ubuntu 24.04 LTS "Noble Numbat" - Release amd64 (20240424)
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
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-6.8.0-35-generic root=UUID=f5eb4952-92f3-47fd-a2fe-a5b5c073351c ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.12, Python 3.12.3, python3-minimal, 3.12.3-0ubuntu1
PythonDetails: N/A
RelatedPackageVersions:
dpkg 1.22.6ubuntu6
apt 2.7.14build2
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.37-0ubuntu0.24.04.1 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)
modified.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: [modified]
mtime.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: 2024-04-27T11:24:32.151391

Tags:

Revision history for this message

Amie Nel (nel-amie) wrote on 2024-06-12:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (2.0 KiB, text/plain; charset="utf-8")
AptOrdering.txt Edit (247 bytes, text/plain; charset="utf-8")
Dependencies.txt Edit (3.2 KiB, text/plain; charset="utf-8")
Df.txt Edit (479 bytes, text/plain; charset="utf-8")
Dmesg.txt Edit (261.4 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (7.9 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.txt Edit (1.7 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (2.8 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (76.6 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")
MySQLVarLibDirListing.txt Edit (1.6 MiB, text/plain; charset="utf-8")
ProcCpuinfoMinimal.txt Edit (1.2 KiB, text/plain; charset="utf-8")

Revision history for this message

Paride Legovini (paride) wrote on 2024-06-14:

Hello and thanks for this bug report. From the attached Logs.var.log.mysql.error.log.txt looks like port 3306 is consistently busy. The following is repeated several times:

[ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?

Does a manual restart of mysql work? Do you remember restarting the daemon manually, without the using systemctl or other init system helpers? Thanks.

Changed in mysql-8.0 (Ubuntu):
status:	New → Incomplete

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.

Ubuntumysql-8.0 package