Software Update - mysql-apt-config - can't continue

[David Harper]

Upon running software updater today, it's tried to update mysql-apt-config, and running that has popped up a debconf choice screen (see attached).

However selecting any of the options, pressing the "Forward" button does absolutely nothing. Can't close the window, can't continue, it's just stuck like that.

I bet if I restart the machine everything will end up in a broken state too! :D

ProblemType: Bug
DistroRelease: Ubuntu 14.10
Package: debconf 1.5.53ubuntu1
ProcVersionSignature: Ubuntu 3.16.0-31.41-generic 3.16.7-ckt5
Uname: Linux 3.16.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.14.7-0ubuntu8.2
Architecture: amd64
CurrentDesktop: Unity
Date: Thu Mar 5 09:53:44 2015
ExecutablePath: /usr/bin/debconf-communicate
InstallationDate: Installed on 2013-07-31 (581 days ago)
InstallationMedia: Ubuntu 13.04 "Raring Ringtail" - Release amd64 (20130424)
InterpreterPath: /usr/bin/perl
PackageArchitecture: all
ProcEnviron:
 LANG=en_GB.UTF-8
 PATH=(custom, no user)
 SHELL=/bin/bash
 XDG_RUNTIME_DIR=<set>
 LANGUAGE=en_GB:en
SourcePackage: debconf
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

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

[Lpu8er (lpu8er)]

Just got the same issue. Performed the following tests, just to get out of this :
- first, install updates from GUI; failed, it hangs forever. I had to kill all apt-get process
- second, apt-get update then apt-get upgrade. After the upgrade, triggers, then the configure mysql-apt-config, but with the console menu.

> ps -aux | grep apt | grep -v 'grep'
root 3422 53.7 5.3 424336 218008 ? SNl 20:11 15:59 /usr/bin/python3 /usr/sbin/aptd
root 5050 0.0 0.0 83784 2224 ? S 20:33 0:00 sudo apt-get upgrade
root 5051 4.8 1.3 101724 55200 ? S 20:33 0:22 apt-get upgrade
root 5673 0.0 0.1 26024 7996 pts/1 Ss+ 20:34 0:00 /usr/bin/dpkg --status-fd 83 --configure mysql-apt-config:all compiz-core:amd64 libcompizconfig0:amd64 libdecoration0:amd64 compiz-plugins-default:amd64 compiz-gnome:amd64 compiz-plugins:amd64 compiz:all unity-services:amd64 libunity-core-6.0-9:amd64 unity:amd64 compiz-plugins-extra:all python-compizconfig:amd64 compizconfig-settings-manager:all
root 5676 0.0 0.3 67644 14288 pts/1 S+ 20:34 0:00 /usr/bin/perl -w /usr/share/debconf/frontend /var/lib/dpkg/info/mysql-apt-config.postinst configure 0.3.2-1ubuntu14.04
root 5682 0.0 0.0 16768 1432 pts/1 S+ 20:34 0:00 /bin/bash /var/lib/dpkg/info/mysql-apt-config.config configure 0.3.2-1ubuntu14.04
root 5794 0.0 0.0 25384 2276 pts/1 S+ 20:41 0:00 whiptail --backtitle Outil de configuration des paquets --title Configuration de mysql-apt-config --output-fd 11 --nocancel --default-item mysql-5.6 --menu This configuration program will detect the current state of your system, check for any installed MySQL Server packages, and try to select the most appropriate version of MySQL Server to be installed. If you are not sure which version to choose for yourself, do not change the auto-selected version. Advanced users can always change the version later, depending on their own needs. Which server version do you wish to receive? 14 208 3 -- mysql-5.6 mysql-5.7-dmr none

Then, I tried to kill the menu process (5794) itself : comes back (probably from another process). Then tried the process mysql-apt-configure (5682) without killing neither the process apt-get upgrade nor dpkg (which contained all triggers and the state). Process came with a malfunc, GUI show me the classic "Report bug" window. The next apt-get upgrade does not show me any package, but I think I simply cleaned apt... until next update.
Mysql works fine too.

If it could help anyone...

[Daniel Felipe (kaedesm)]

Hi Lpu8er! I found a thread with the same issue that you have. Check it out http://unix.stackexchange.com/questions/158052/how-to-configure-the-mysql-apt-repo-on-ubuntu-on-a-non-interactive-shell

[Lpu8er (lpu8er)]

Yes, meaning that is a quick fix, 5 month ago, for the same issue ? Or is this a different issue ?
It seems the same for me.

Maybe this is simply not related to debconf, but mysql related. So this bug thread would go unrelated....

Thx for the link, btw.

[ivan (iipavlov)]

This is where it occures for me:
......
Processing triggers for man-db (2.7.0.2-5) ...
Setting up mysql-apt-config (0.3.1-1ubuntu12.04) ...

[Jeff Treleaven (jtreleaven262)]

^sorry about the random add/delete for my debconf
But here is another picture of the frozen upgrade bug...

[Goran Pedic (gpedic)]

I'm stuck with this for some time now. I can't even remove mysql-server because whenever I try to use apt I get:
E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.

because I have to kill the process to get rid of the configure screen.

Running 'sudo dpkg --configure -a' just get's me stuck at the same selection screen in both the GUI and terminal.

I'm using Xubuntu 14.04. The fix in the thread suggested by Daniel Felipe doesn't work for me.

[Goran Pedic (gpedic)]

I've managed to resolve this issue by removing mysql-apt-config.

My /var/log/dpkg.log said:
2015-03-18 16:02:41 startup packages configure
2015-03-18 16:02:41 configure mysql-apt-config:all 0.3.3-1ubuntu14.04 <none>
2015-03-18 16:02:41 status half-configured mysql-apt-config:all 0.3.3-1ubuntu14.04

mysql-apt-config was half-configured (because I had to kill it) so I couldn't use apt-get because it would just tell me to:
'sudo dpkg --configure -a' (which would not work)

I first tried to remove mysql-apt-config using (don't do this, a better solution is offered in the linked thread bellow):
sudo dpkg --remove --force-remove-reinstreq mysql-apt-config

as I couldn't use apt-get or aptitude, but this just managed to bork up my system somewhat as I couldn't properly update or re-install mysql, but at least I was able to use apt-get/aptitude now.

On trying to reinstall mysql-server-5.6:
dpkg: error processing archive /var/cache/apt/archives/mysql-client-5.6_5.6.19-0ubuntu0.14.04.1_amd64.deb (--unpack):
 trying to overwrite '/usr/share/man/man1/mysql_config_editor.1.gz', which is also in package libmysqlclient-dev 5.6.23-1ubuntu14.04
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Processing triggers for man-db (2.6.7.1-1) ...
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-client-5.6_5.6.19-0ubuntu0.14.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-client-core-5.6 (5.6.19-0ubuntu0.14.04.1) ...
dpkg: dependency problems prevent configuration of mysql-server-5.6:
 mysql-server-5.6 depends on mysql-client-5.6 (>= 5.6.19-0ubuntu0.14.04.1); however:
  Package mysql-client-5.6 is not installed.

dpkg: error processing package mysql-server-5.6 (--configure):
 dependency problems - leaving unconfigured
Setting up mysql-common-5.6 (5.6.19-0ubuntu0.14.04.1) ...
Setting up mysql-server-core-5.6 (5.6.19-0ubuntu0.14.04.1) ...
Errors were encountered while processing:
 mysql-server-5.6

THE SOLUTION:
Finally the accepted answer here helped me resolve the issue for good:
https://stackoverflow.com/questions/27154067/could-not-select-ok-in-mysql-apt-config-ubuntu-14-04

If you need to reinstall mysql-server you may want to purge mysql-common, it doesn't seem to get removed automatically along with mysql-server/client, this was also giving me some issues.

I've removed mysql-apt-config from my system (it doesn't seem to be really needed, and I hope this will help avoid a similar situation in the future), reinstalled msyql-server-5.6 and everything is working fine now, but I don't really get the point of all this, why would I ever want to choose between mysql 5.6 and 5.7-dmr if I explicitly installed 5.6. There should be a separate package for 5.7 for imho.

[Lpu8er (lpu8er)]

Hi,

All of these are quick fixes for users. The real question is probably to know if this issue is related to debconf or mysql-apt-config.

Goran : I had to do the same. But mysql-apt-config provides a way to reset the mysql root password, in case of reinstall, which may be useful.

[Marc Guay (marc-guay)]

I just ran into this when the software updater prompted me to update "Auto configuration for MySQL Apt Repo." Perhaps my unusual setup is useful information, I've added the mysql5.6 repos (http://repo.mysql.com/apt/ubuntu/, etc) manually to the "Other software" tab of Settings->Software & Updates.