fix broken mysql package

Liamdale · 07-28-2018, 12:45 AM

During a regular mint18.2 (KDE) software update using update manager I was informed that the upgrade could not be completed due to broken package. I tried to fix broken package using synaptic (edit > fix broken packages) but it didn't work. I got:

Quote:

Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 96, <> line 1.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 96, <> line 1.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 114, <> line 1.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 114, <> line 1.
Preconfiguring packages ...
(Reading database ... 424400 files and directories currently installed.)
Preparing to unpack .../mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb ...
................
dpkg: error processing archive /var/cache/apt/archives/mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 96.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 96.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 114.
Gtk-WARNING **: Unable to locate theme engine in module_path: "adwaita", at /usr/share/perl5/Debconf/FrontEnd/Gnome.pm line 114.
Errors were encountered while processing:
/var/cache/apt/archives/mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:

sudo apt-get install -f
also didn't work
got

Quote:

Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following additional packages will be installed:
mysql-community-server
The following packages will be upgraded:
mysql-community-server
1 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B/25.3 MB of archives.
After this operation, 22.5 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
(Reading database ... 424400 files and directories currently installed.)
Preparing to unpack .../mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb ...
................
dpkg: error processing archive /var/cache/apt/archives/mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb (--unpack):
subprocess new pre-installation script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/mysql-community-server_5.7.23-1ubuntu16.04_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Not very experienced with broken packages. Please advise.

AwesomeMachine · 07-28-2018, 09:06 AM

The mysql package has a bug in the install scripts. You should report it. It also looks like the adwaita theme was removed. Try installing or reinstalling 'gnome-themes-standard'.

Liamdale · 07-30-2018, 08:24 PM

I tried everything I knew or could find out without any succes. I even tried to reinstall gnome-themes-standard but it brought me right back to the Mysql install error message. As a last resort I used synaptic to remove the broken package but it also removed my current working version of Mysql. Synaptic refused to reinstall mysgl therefore I used apt-get utility on the terminal:

Quote:

sudo apt-get update
sudo apt-get install mysql-server

and the

Quote:

mysql_secure_installation

to reinstall my previous password

Everything is back to normal. Not a road I would like to repeat. Still need to better understand broken packages.

I can not mark this thread as solved because the broken package was not fixed but removed ( including all the unbroken stuff)

Habitual · 07-31-2018, 11:02 AM

https://help.ubuntu.com/
https://help.ubuntu.com/community/CommunityHelpWiki

and a decent (ok, even a shitty one) search engine.

I'd try to break that habit of "tried everything" IF you don't know what you're doing.
I know it is sometimes difficult to process massive amounts of information off the 'net.
But you should exercise your "google.fu" (search engine mastery)

See my signature.