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

[Ameya Bhagat]

Tryin to Install mysql but Getting Error and after every restart the package crashing

ProblemType: Package
DistroRelease: Ubuntu 18.04
Package: mysql-server-5.7 5.7.23-0ubuntu0.18.04.1
ProcVersionSignature: Ubuntu 4.15.0-33.36-generic 4.15.18
Uname: Linux 4.15.0-33-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.2
Architecture: amd64
Date: Sat Sep 1 13:01:58 2018
ErrorMessage: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2018-04-03 (150 days ago)
InstallationMedia: Ubuntu 17.04 "Zesty Zapus" - Release amd64 (20170412)
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: ['performance_schema', 'sys', 'auto.cnf', 'ibdata1', 'ib_buffer_pool', 'ib_logfile1', 'debian-5.7.flag', 'ib_logfile0', 'mysql']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-33-generic root=UUID=aabed721-2c1a-4a6d-ac96-bab6dbe1e269 ro find_preseed=/preseed.cfg auto noprompt priority=critical locale=en_US quiet
Python3Details: /usr/bin/python3.6, Python 3.6.5, python3-minimal, 3.6.5-3ubuntu1
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.19.0.5ubuntu2
 apt 1.6.3ubuntu0.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.23-0ubuntu0.18.04.1 failed to install/upgrade: installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
UpgradeStatus: Upgraded to bionic on 2018-07-23 (39 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Andreas Hasenack (ahasenack)]

Thanks for filing this bug in Ubuntu.

I'm seeing this in the mysql error log:
2018-09-01T07:31:57.179473Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-09-01T07:31:57.179486Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2018-09-01T07:31:57.179506Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-09-01T07:31:57.179519Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2018-09-01T07:31:57.179523Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2018-09-01T07:31:57.179547Z 0 [ERROR] Aborting

Looks like something else is listening on mysql's port (3306).

After reboot, is mysql running? Could you show the output of these commands please:
sudo netstat -anp
sudo systemctl status mysql
tail /var/log/mysql/error.log
sudo apt update
sudo apt -f install
tail /var/log/mysql/error.log # again

Thanks

[Ameya Bhagat (infinitybro)]

Yes i did all those commands.. currently i have solved the problem by
switching the port number..and i think it was because of my vmware
workstation was active ..thanks for the Support appreciate it alot :)☺️✌️
sorry for inconvenience caused

On Tue, 2 Oct 2018, 01:40 Andreas Hasenack, <email address hidden> wrote:

> Thanks for filing this bug in Ubuntu.
>
> I'm seeing this in the mysql error log:
> 2018-09-01T07:31:57.179473Z 0 [Note] Server hostname (bind-address):
> '127.0.0.1'; port: 3306
> 2018-09-01T07:31:57.179486Z 0 [Note] - '127.0.0.1' resolves to
> '127.0.0.1';
> 2018-09-01T07:31:57.179506Z 0 [Note] Server socket created on IP:
> '127.0.0.1'.
> 2018-09-01T07:31:57.179519Z 0 [ERROR] Can't start server: Bind on TCP/IP
> port: Address already in use
> 2018-09-01T07:31:57.179523Z 0 [ERROR] Do you already have another mysqld
> server running on port: 3306 ?
> 2018-09-01T07:31:57.179547Z 0 [ERROR] Aborting
>
> Looks like something else is listening on mysql's port (3306).
>
> After reboot, is mysql running? Could you show the output of these
> commands please:
> sudo netstat -anp
> sudo systemctl status mysql
> tail /var/log/mysql/error.log
> sudo apt update
> sudo apt -f install
> tail /var/log/mysql/error.log # again
>
> Thanks
>
>
> ** Changed in: mysql-5.7 (Ubuntu)
> Status: Confirmed => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1790272
>
> Title:
> package mysql-server-5.7 5.7.23-0ubuntu0.18.04.1 failed to
> install/upgrade: installed mysql-server-5.7 package post-installation
> script subprocess returned error exit status 1
>
> Status in mysql-5.7 package in Ubuntu:
> Incomplete
>
> Bug description:
> Tryin to Install mysql but Getting Error and after every restart the
> package crashing
>
> ProblemType: Package
> DistroRelease: Ubuntu 18.04
> Package: mysql-server-5.7 5.7.23-0ubuntu0.18.04.1
> ProcVersionSignature: Ubuntu 4.15.0-33.36-generic 4.15.18
> Uname: Linux 4.15.0-33-generic x86_64
> ApportVersion: 2.20.9-0ubuntu7.2
> Architecture: amd64
> Date: Sat Sep 1 13:01:58 2018
> ErrorMessage: installed mysql-server-5.7 package post-installation
> script subprocess returned error exit status 1
> InstallationDate: Installed on 2018-04-03 (150 days ago)
> InstallationMedia: Ubuntu 17.04 "Zesty Zapus" - Release amd64 (20170412)
> 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: ['performance_schema', 'sys', 'auto.cnf',
> 'ibdata1', 'ib_buffer_pool', 'ib_logfile1', 'debian-5.7.flag',
> 'ib_logfile0', 'mysql']
> ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-33-generic
> root=UUID=aabed721-2c1a-4a6d-ac96-bab6dbe1e269 ro find_preseed=/preseed.cfg
> auto noprompt priority=critical locale=en_US quiet
> Python3Details: /usr/bin/python3.6, Python 3.6.5, python3-minimal,
> 3.6.5-3ubuntu1
> PythonDetails: N/A
> RelatedPackageVersions...

[Andreas Hasenack (ahasenack)]

Thanks for getting back to us with your findings!

Cheers