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