package mysql-server-5.7 5.7.19-0ubuntu0.17.04.1 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1

[CY Teng]

I am not able to uninstall and install mysql again. Not sure what is going on. Please help, thank you.

ProblemType: Package
DistroRelease: Ubuntu 17.04
Package: mysql-server-5.7 5.7.19-0ubuntu0.17.04.1
ProcVersionSignature: Ubuntu 4.10.0-30.34-generic 4.10.17
Uname: Linux 4.10.0-30-generic x86_64
ApportVersion: 2.20.4-0ubuntu4.5
Architecture: amd64
Date: Wed Aug 9 21:12:43 2017
ErrorMessage: subprocess new pre-installation script returned error exit status 1
InstallationDate: Installed on 2017-07-17 (23 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: ['debian-5.7.flag', 'ibtmp1', 'ib_logfile0', 'multi-master.info', 'aria_log_control', 'ibdata1', 'ib_logfile1', 'aria_log.00000001', 'performance_schema', 'bugs', 'ib_buffer_pool', 'mysql', 'auto.cnf']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.10.0-30-generic.efi.signed root=UUID=a30731e4-5340-4576-b671-542bc3aebddd 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.19-0ubuntu0.17.04.1 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

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

[Christian Ehrhardt  (paelzer)]

Hi CY,
that is odd - as if partially removed and the system is unsure in which state it is.
From your log:
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5

Even on a non existing service that should work.

Could you run the following in a console and share the full output?:
$ systemctl status mysql
$ sudo invoke-rc.d mysql stop
$ systemctl stop mysql
$ systemctl status mysql

[Launchpad Janitor (janitor)]

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