The mysql error log shows that mysql failed to restart because of an
existing mysql process. Killing that stray process and then apt-get
install -f would likely resolve this.
I'm not clear from your followup comment, but sounds like you were able
to get the issue resolved after purging and reinstalling?
** Description changed:
Not able to start mysql-server
ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.29-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.15.0-91.92~16.04.1-generic 4.15.18
Uname: Linux 4.15.0-91-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.22
Architecture: amd64
Date: Sat Mar 28 19:33:55 2020
ErrorMessage: subprocess installed post-installation script returned error
exit status 1
InstallationDate: Installed on 2018-07-23 (613 days ago)
InstallationMedia: Ubuntu 16.04.4 LTS "Xenial Xerus" - Release amd64
(20180228)
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
+ [mysqldump]
+ quick
+ quote-names
+ max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
- [mysqld_safe]
- syslog
+ [mysqld_safe]
+ syslog
MySQLVarLibDirListing: ['ib_buffer_pool', 'client-cert.pem',
'server-cert.pem', 'sys', 'server-key.pem', 'public_key.pem', 'mysql',
'client-key.pem', 'ca-key.pem', 'ibdata1', 'auto.cnf', 'ca.pem',
'debian-5.7.flag', 'ib_logfile1', 'private_key.pem', 'performance_schema',
'ib_logfile0']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-91-generic
root=UUID=4f1f121d-3f60-4402-8cd2-fe1381eff939 ro quiet splash vt.handoff=7
RelatedPackageVersions:
- dpkg 1.18.4ubuntu1.6
- apt 1.2.32
+ dpkg 1.18.4ubuntu1.6
+ apt 1.2.32
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.29-0ubuntu0.16.04.1 failed to
install/upgrade: subprocess installed post-installation script returned error
exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)
+
+
+ == dpkg terminal log ==
+ Setting up mysql-client-5.7 (5.7.29-0ubuntu0.16.04.1) ...
+ Setting up mysql-server-5.7 (5.7.29-0ubuntu0.16.04.1) ...
+ update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf
(my.cnf) in auto mode
+ Renaming removed key_buffer and myisam-recover options (if present)
+ 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 Sat 2020-03-28
19:33:55 IST; 6ms ago
+ Process: 14917 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
(code=exited, status=0/SUCCESS)
+ Process: 14916 ExecStart=/usr/sbin/mysqld [0;1;31m(code=exited,
status=1/FAILURE)[0m
+ Process: 14908 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
(code=exited, status=0/SUCCESS)
+ Main PID: 14916 (code=exited, status=1/FAILURE)
+
+ Mar 28 19:33:55 ML-LAPTOP-1235 systemd[1]: [0;1;31mFailed to start MySQL
Community Server.[0m
+ Mar 28 19:33:55 ML-LAPTOP-1235 systemd[1]: [0;1;39mmysql.service: Unit
entered failed state.[0m
+ Mar 28 19:33:55 ML-LAPTOP-1235 systemd[1]: [0;1;39mmysql.service: Failed
with result 'exit-code'.[0m
+ dpkg: error processing package mysql-server-5.7 (--configure):
+ subprocess installed post-installation script returned error exit status 1
+
+ == kern.log ==
+
+ [118432.492214] audit: type=1400 audit(1585404266.524:520):
+ apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld"
+ name="/etc/my.cnf" pid=15201 comm="mysqld" requested_mask="r"
+ denied_mask="r" fsuid=121 ouid=0
+
+ == mysql log ==
+ 2020-03-28T14:03:56.371288Z 0 [ERROR] Can't start server: Bind on TCP/IP
port: Address already in use
+ 2020-03-28T14:03:56.371291Z 0 [ERROR] Do you already have another mysqld
server running on port: 3306 ?
+ 2020-03-28T14:03:56.371301Z 0 [ERROR] Aborting
** Changed in: mysql-5.7 (Ubuntu)
Status: New => Incomplete
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1869490
Title:
package mysql-server-5.7 5.7.29-0ubuntu0.16.04.1 failed to
install/upgrade: subprocess installed post-installation script
returned error exit status 1
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1869490/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
