Broken mysql, cannot use, remove, reinstall, fix
Running an upgrade on Lunix Mint 18.3, I got an error with processing mysql-server. I ran sudo dpkg --configure -a, the same error persisted. Output of latter as follows below. If I try to remove mysql, or reinstall, it aborts citing a Catch-22 of dependency problems. My medical records software (openemr) is dependent on this, so I am anxious to resolve it quickly. Help! Thank you!
robert@robert-ideacentre-AIO-520-22IKU ~ $ sudo apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.
3 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up mysql-server-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1010: Error dropping database (can't rmdir './performance_schema/', errno: 17)
mysql_upgrade failed with exit status 5
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up adobe-flashplugin (1:20190409.1-0ubuntu0.16.04.1) ...
update-alternatives: error: alternative link /usr/lib/mozilla/plugins/flashplugin-alternative.so is already managed by mozilla-flashplugin.backup.20190407
dpkg: error processing package adobe-flashplugin (--configure):
subprocess installed post-installation script returned error exit status 2
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
No apport report written because the error message indicates it's a follow-up error from a previous failure.
Errors were encountered while processing:
mysql-server-5.7
adobe-flashplugin
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
robert@robert-ideacentre-AIO-520-22IKU ~ $ sudo dpkg --configure -a
Setting up mysql-server-5.7 (5.7.25-0ubuntu0.16.04.2) ...
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1010: Error dropping database (can't rmdir './performance_schema/', errno: 17)
mysql_upgrade failed with exit status 5
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up adobe-flashplugin (1:20190409.1-0ubuntu0.16.04.1) ...
update-alternatives: error: alternative link /usr/lib/mozilla/plugins/flashplugin-alternative.so is already managed by mozilla-flashplugin.backup.20190407
dpkg: error processing package adobe-flashplugin (--configure):
subprocess installed post-installation script returned error exit status 2
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.7
adobe-flashplugin
mysql-server
robert@robert-ideacentre-AIO-520-22IKU ~ $