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

[Lohar Jaydeep Hemant]

error occured because something issue with dependency

ProblemType: Package
DistroRelease: Ubuntu 17.04
Package: mysql-server-5.7 5.7.18-0ubuntu0.17.04.1
ProcVersionSignature: Ubuntu 4.10.0-28.32-generic 4.10.17
Uname: Linux 4.10.0-28-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.20.4-0ubuntu4.5
Architecture: amd64
Date: Fri Jul 21 00:21:51 2017
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2017-06-16 (34 days ago)
InstallationMedia: Ubuntu 16.10 "Yakkety Yak" - Release amd64 (20161012.2)
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.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ib_logfile1', 'ib_logfile0', 'sys', 'ibdata1', 'mysql', 'debian-5.7.flag', 'performance_schema', 'ib_buffer_pool', 'auto.cnf']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.10.0-28-generic root=UUID=6f8e7a4c-68e6-4dd0-85ed-d86b92137eb6 ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.18.10ubuntu2
 apt 1.4
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.18-0ubuntu0.17.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to zesty on 2017-06-16 (34 days ago)

[Christian Ehrhardt  (paelzer)]

Hi Lohar,

from the log:
2017-07-20T18:52:53.167712Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?

An upgrade of a service restarts it to pick up the new changes, in your case there is something running on the port that mysql wants to listen on.
Due to that it fails to (re-)start which lets the upgrade fail.

You'll have to find what is actually on that port and clean it up - another mysql not controlled by the service maybe? You can find with e.g.
$ ss -atnp '( src :3306 )'

[Christian Ehrhardt  (paelzer)]

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

Since it seems likely to me that this is a local configuration problem, rather than 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-5.7 (Ubuntu) because there has been no activity for 60 days.]