package mysql-server-5.7 5.7.24-0ubuntu0.18.04.1 failed to install/upgrade: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1

[Rahul Kumar]

Mysql server crashes.

ProblemType: Package
DistroRelease: Ubuntu 18.04
Package: mysql-server-5.7 5.7.24-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-39.42-generic 4.15.18
Uname: Linux 4.15.0-39-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.5
AptOrdering:
 mysql-server-core-5.7:amd64: Install
 mysql-server-5.7:amd64: Install
 mysql-server:amd64: Install
 NULL: ConfigurePending
Architecture: amd64
Date: Fri Nov 16 10:09:02 2018
ErrorMessage: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2018-09-20 (56 days ago)
InstallationMedia: Ubuntu 18.04.1 LTS "Bionic Beaver" - Release amd64 (20180725)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.conf.d: Error: [Errno 21] Is a directory: '/etc/mysql/conf.d/mysql.conf.d'
MySQLConf.etc.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLConf.etc.mysql.mysql.conf.d.mysql.conf.d: Error: [Errno 21] Is a directory: '/etc/mysql/mysql.conf.d/mysql.conf.d'
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['hostelandmess', 'mysql', 'ib_buffer_pool', 'ib_logfile0', 'debian-5.7.flag', 'ibtmp1', 'sys', 'auto.cnf', 'ibdata1', 'ib_logfile1', 'performance_schema']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-39-generic root=UUID=83dbbe73-6b62-4ffa-bda6-b0901b553b3a ro quiet splash vt.handoff=1
Python3Details: /usr/bin/python3.6, Python 3.6.6, python3-minimal, 3.6.5-3ubuntu1
PythonDetails: /usr/bin/python2.7, Python 2.7.15rc1, python-minimal, 2.7.15~rc1-1
RelatedPackageVersions:
 dpkg 1.19.0.5ubuntu2.1
 apt 1.6.6
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.24-0ubuntu0.18.04.1 failed to install/upgrade: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Andreas Hasenack (ahasenack)]

Thanks for filing this bug in Ubuntu.

This is the error that was logged:

ERROR: Unable to start MySQL server:
mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2 - No such file or directory)

Tthe missing directory /etc/mysql/conf.d/ is part of mysql-common: https://packages.ubuntu.com/bionic/all/mysql-common/filelist

If you don't have that installed, then maybe you purged packages that you shouldn't (like mysql-common), or ran rm -rf in some mysql directory in /etc. It's not clear.

I suggest you start from a clean state, as I cannot reproduce that problem with a fresh bionic container.

[Launchpad Janitor (janitor)]

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