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

[mohammad taheri]

Warning: Unable to start the server.
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: activating (auto-restart) (Result: exit-code) since Sun 2020-08-02 12:44:41 +0430; 7ms ago
    Process: 30027 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 30056 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 30056 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"
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
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processing triggers for systemd (2
45.4-4ubuntu3.2) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for libc-bin (2.31-0ubuntu9) ...
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.3
ProcVersionSignature: Ubuntu 5.4.0-42.46-generic 5.4.44
Uname: Linux 5.4.0-42-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.4
Architecture: amd64
CasperMD5CheckResult: skip
Date: Sun Aug 2 12:44:41 2020
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2020-07-21 (11 days ago)
InstallationMedia: Ubuntu 20.04 LTS "Focal Fossa" - Release amd64 (20200423)
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
MySQLVarLibDirListing: ['binlog.000011', '#innodb_temp', 'mysql.ibd', 'hamnamad-All-Series.pid', 'mysql', 'binlog.000013', 'ibdata1', 'ib_buffer_pool', 'performance_schema', '#ib_16384_0.dblwr', 'binlog.000019', 'binlog.000024', 'ibtmp1', 'ca-key.pem', 'undo_001', 'private_key.pem', 'debian-5.7.flag', 'auto.cnf', 'ib_logfile1', 'binlog.000008', 'server-cert.pem', 'binlog.000018', 'binlog.000004', 'binlog.000009', 'client-key.pem', 'server-key.pem', 'ca.pem', 'binlog.000012', 'public_key.pem', 'undo_002', 'binlog.000022', 'binlog.000017', 'binlog.000021', 'client-cert.pem', 'binlog.000010', 'binlog.000007', 'sys', 'binlog.000023', 'binlog.000025', 'binlog.index', 'binlog.000020', 'binlog.000015', 'binlog.000003', 'binlog.000005', 'binlog.000002', 'binlog.000001', '#ib_16384_1.dblwr', 'mysql.sock', 'binlog.000014', 'binlog.000006', 'binlog.000016', 'ib_logfile0']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-42-generic root=UUID=2dd4b51d-8b69-47e0-830c-4ec5a96cfb9d ro quiet splash vt.handoff=7
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 8.0.21-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)

[Christian Ehrhardt  (paelzer)]

Your bug misses the error logs one would usually attach, but from the bit I see it seems your server failed to (re-)start.

But a service (re)start is a requirement for an upgrade - since the file is missing I recommend you check /var/log/mysql/error.log which often has more info why it failed to start.

Resolving these issues you find in there and re-installing the package usually helps.

[Christian Ehrhardt  (paelzer)]

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

Since there isn't enough information in your report to differentiate between a local configuration problem and 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.

[Launchpad Janitor (janitor)]

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