MySQL Bugs: #79649: Ubuntu mysql-apt-config missing MySQL server version 5.6 from menu

Bug #79649	Ubuntu mysql-apt-config missing MySQL server version 5.6 from menu
Submitted:	15 Dec 2015 15:06	Modified:	16 Dec 2015 12:47
Reporter:	Van Stokes	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S1 (Critical)
Version:	5.6.28	OS:	Ubuntu (14.04.3)
Assigned to:	Lars Tangvald	CPU Architecture:	Any
Tags:	apt, MySQL, server

Description:
A new mysql-apt-config was downloaded and installed today and when the user interface appeared to select the products 5.6 was not available - only 5.7!

We are not ready to be forced to upgrade to 5.7.

How to repeat:
apt-get update
apt-get dist-upgrade

Suggested fix:
Added 5.6 option (repository) back into the mysql-apt-config

I had to manually modify the apt source list file (/etc/apt/sources.list.d/mysql.list) and change 5.7 back to 5.6.

Hi,

We had some caching issues with repo.mysql.com yesterday, which I'm thinking/hoping is the cause of your problem.
Which version of mysql-apt-config did you install? The current version, 0.6.0, will always give a choice of both 5.6 and 5.7, and should default to 5.6 if you have it installed.

Could you verify that this is still a problem? And if so, what you see in the interface and output?

No. The problem still persists:

root@atl-mysql01:/usr/share/doc# uname -a
Linux atl-mysql01 3.16.0-53-generic #72~14.04.1-Ubuntu SMP Fri Nov 6 18:17:23 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

root@atl-mysql01:/usr/share/doc# dpkg -l | grep mysql | grep ii
ii  libmysqlclient18:amd64              5.6.28-1ubuntu14.04                 amd64        MySQL shared client libraries
ii  mysql-apt-config                    0.6.0-1                             all          Auto configuration for MySQL APT Repo.
ii  mysql-client                        5.6.28-1ubuntu14.04                 amd64        MySQL Client meta package depending on latest version
ii  mysql-common                        5.6.28-1ubuntu14.04                 amd64        MySQL Common
ii  mysql-community-client              5.6.28-1ubuntu14.04                 amd64        MySQL Client
ii  mysql-community-server              5.6.28-1ubuntu14.04                 amd64        MySQL Server

When I run:

  dpkg-reconfigure mysql-apt-config

Only version 5.7 is present for the mysql sever option.

Slight long shot, but:

When running reconfigure on mysql-apt-config you should have 3 choices:
- MySQL Server (currently selected version)
- MySQL Tools & Connectors (disabled/enabled)
- Apply

When selecting MySQL Server, you should get the choices
- mysql-5.6
- mysql-5.7
- None

On some systems I've tested I've noticed an odd visual glitch with the dialog system, so that the currently highlighted option would be invisible and you'd see something like:'
- 
- mysql-5.7
- None

Any chance this is what you're seeing (move the cursor up and down after selecting MySQL Server)?
Also, what are you seeing inside the () after MySQL Server on the main menu?

Ah, ok. I see what has happened.

You are correct, when I select 'MySQL Server' it does provide me with a list of servers to choose from. I didn't do that. It appeared to me that my only option was 5.7.

However, the version in parenthesis is confusing. It should default to the currently installed major version (if one is installed) and not revert to the default (i.e. 5.7 in this case). Every time I run the mysql-apt-config it resets back to 5.7.

See screen shot attached.

Confusing screen shot.

Attachment: Screenshot from 2015-12-16 07:42:52.png (image/png, text), 114.64 KiB.

Hi,

Thanks for the feedback.
That it's selecting 5.7 as a default when you have 5.6 installed is a bug that we'll look into.
We'll also try to make the menu less confusing.

Opened related bug:
https://bugs.mysql.com/bug.php?id=79668
The cause is that mysql-apt-config doesn't detect mysql-community-server, only mysql-server