MySQL Bugs: #108469: MySQL Workbench disappeared from Ubuntu and Debian repositories

Bug #108469	MySQL Workbench disappeared from Ubuntu and Debian repositories
Submitted:	13 Sep 2022 12:06	Modified:	28 Sep 2022 6:02
Reporter:	René Bos	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Package Repos	Severity:	S3 (Non-critical)
Version:		OS:	Linux (Debian and Ubuntu)
Assigned to:		CPU Architecture:	Any

Description:
MySQL Workbench seems to have disappeared from MySQL APT's repositories. Tested with Ubuntu 20.04 (Focal), Ubuntu 22.04 (Jammy) and Debian Bullseye. Installation through APT fails with the message: Unable to locate package mysql-workbench-community

When searching https://repo.mysql.com/apt/ubuntu/dists/ the package seems to be gone for most Ubuntu versions. It still exists in some old ones. Same for Debian.

Contents of /etc/apt/sources.list.d/mysql.list seems to be correct:
### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out entries below, but any other modifications may be lost.
# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications.
deb [signed-by=/etc/apt/trusted.gpg.d/mysql.gpg] https://repo.mysql.com/apt/ubuntu/ jammy mysql-apt-config
deb [signed-by=/etc/apt/trusted.gpg.d/mysql.gpg] https://repo.mysql.com/apt/ubuntu/ jammy mysql-8.0
deb [signed-by=/etc/apt/trusted.gpg.d/mysql.gpg] https://repo.mysql.com/apt/ubuntu/ jammy mysql-tools
# deb [signed-by=/etc/apt/trusted.gpg.d/mysql.gpg] http://repo.mysql.com/apt/ubuntu/ jammy mysql-tools-preview
deb-src [signed-by=/etc/apt/trusted.gpg.d/mysql.gpg] https://repo.mysql.com/apt/ubuntu/ jammy mysql-8.0

How to repeat:
1. curl -O https://repo.mysql.com//mysql-apt-config_0.8.23-1_all.deb
2. sudo dpkg -i mysql-apt-config_0.8.23-1_all.deb
	MySQL Server & Cluster: mysql-8.0
	MySQL Tools & Connectors: Enabled
	MySQL Preview Packages: Disabled
3. sudo apt-get update
4. sudo apt-get install mysql-workbench-community
	Reading package lists... Done
	Building dependency tree... Done
	Reading state information... Done
	E: Unable to locate package mysql-workbench-community

Hello René Bos,

Thank you for the bug report.
Could you please perform the below steps and let us know the results?

sudo apt-cache policy mysql-workbench-community
sudo apt-get clean
sudo apt-get update
sudo apt-get install mysql-workbench-community

Regards,
Ashwini Patil

Hi Ashwini,

I seem to messed up my Ubuntu 22.04 (Jammy) test, that version is working fine (or I can't just reproduce the problem now). Both Ubuntu 20.04 (Focal) and Debian Bullseye are not working. When you check https://repo.mysql.com/apt/ubuntu/dists/jammy/mysql-tools/binary-amd64/Packages you can see it includes mysql-workbench-community, while both https://repo.mysql.com/apt/ubuntu/dists/focal/mysql-tools/binary-amd64/Packages and the bullseye variant does not contain it.

Output from Ubuntu 20.04 (sorry, that machine is in Dutch):
sbreukie@asbreukie-Latitude-5511 $ sudo apt-cache policy mysql-workbench-community
N: Kan pakket mysql-workbench-community niet vinden
 asbreukie@asbreukie-Latitude-5511 $ sudo apt-get clean
 asbreukie@asbreukie-Latitude-5511 $ sudo apt-get update
Geraakt:1 http://repo.mysql.com/apt/ubuntu focal InRelease
Geraakt:2 http://archive.canonical.com/ubuntu focal InRelease
Geraakt:3 http://dl.google.com/linux/chrome/deb stable InRelease
Geraakt:4 http://ppa.launchpad.net/linuxuprising/shutter/ubuntu focal InRelease
Geraakt:5 http://ppa.launchpad.net/yannubuntu/boot-repair/ubuntu focal InRelease
Geraakt:6 http://archive.ubuntu.com/ubuntu focal InRelease
Ophalen:7 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB]
Ophalen:8 http://archive.ubuntu.com/ubuntu focal-backports InRelease [108 kB]
Ophalen:9 http://archive.ubuntu.com/ubuntu focal-security InRelease [114 kB]
Ophalen:10 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 DEP-11 Metadata [277 kB]
Ophalen:11 http://archive.ubuntu.com/ubuntu focal-updates/universe amd64 DEP-11 Metadata [391 kB]
Ophalen:12 http://archive.ubuntu.com/ubuntu focal-updates/multiverse i386 Packages [8.480 B]
Ophalen:13 http://archive.ubuntu.com/ubuntu focal-updates/multiverse amd64 Packages [24,5 kB]
Ophalen:14 http://archive.ubuntu.com/ubuntu focal-updates/multiverse amd64 DEP-11 Metadata [944 B]
Ophalen:15 http://archive.ubuntu.com/ubuntu focal-backports/main amd64 Packages [45,6 kB]
Ophalen:16 http://archive.ubuntu.com/ubuntu focal-backports/main i386 Packages [36,1 kB]
Ophalen:17 http://archive.ubuntu.com/ubuntu focal-backports/main amd64 DEP-11 Metadata [7.980 B]
Ophalen:18 http://archive.ubuntu.com/ubuntu focal-backports/universe amd64 Packages [23,9 kB]
Ophalen:19 http://archive.ubuntu.com/ubuntu focal-backports/universe i386 Packages [13,5 kB]
Ophalen:20 http://archive.ubuntu.com/ubuntu focal-backports/universe amd64 DEP-11 Metadata [30,5 kB]
Ophalen:21 http://archive.ubuntu.com/ubuntu focal-security/main i386 Packages [491 kB]
Ophalen:22 http://archive.ubuntu.com/ubuntu focal-security/main amd64 Packages [1.715 kB]
Ophalen:23 http://archive.ubuntu.com/ubuntu focal-security/main Translation-en [288 kB]
Ophalen:24 http://archive.ubuntu.com/ubuntu focal-security/main amd64 DEP-11 Metadata [40,8 kB]
Ophalen:25 http://archive.ubuntu.com/ubuntu focal-security/restricted amd64 Packages [1.175 kB]
Ophalen:26 http://archive.ubuntu.com/ubuntu focal-security/restricted Translation-en [166 kB]
Ophalen:27 http://archive.ubuntu.com/ubuntu focal-security/universe amd64 DEP-11 Metadata [77,5 kB]
Ophalen:28 http://archive.ubuntu.com/ubuntu focal-security/multiverse amd64 DEP-11 Metadata [2.464 B]
5.152 kB opgehaald in 2s (2.258 kB/s)
Pakketlijsten worden ingelezen... Klaar
 asbreukie@asbreukie-Latitude-5511 $ sudo apt-get install mysql-workbench-community
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De statusinformatie wordt gelezen... Klaar
No apt package "mysql-workbench-community", but there is a snap with that name.
Try "snap install mysql-workbench-community"
E: Kan pakket mysql-workbench-community niet vinden

And from a Debian Bullseye Docker container (started with just docker run -it debian:bullseye bash):
root@9df45262b957:/# apt-cache policy mysql-workbench-community
N: Unable to locate package mysql-workbench-community
root@9df45262b957:/# apt-get clean
root@9df45262b957:/# apt-get update
Hit:1 http://security.debian.org/debian-security bullseye-security InRelease
Hit:2 http://deb.debian.org/debian bullseye InRelease
Hit:3 http://deb.debian.org/debian bullseye-updates InRelease
Hit:4 http://repo.mysql.com/apt/debian bullseye InRelease
Reading package lists... Done                 
root@9df45262b957:/# apt-get install mysql-workbench-community
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package mysql-workbench-community

root@22f0121b9602:/# cat /etc/apt/sources.list.d/mysql.list 
### THIS FILE IS AUTOMATICALLY CONFIGURED ###
# You may comment out entries below, but any other modifications may be lost.
# Use command 'dpkg-reconfigure mysql-apt-config' as root for modifications.
deb http://repo.mysql.com/apt/debian/ bullseye mysql-apt-config
deb http://repo.mysql.com/apt/debian/ bullseye mysql-8.0
deb http://repo.mysql.com/apt/debian/ bullseye mysql-tools
#deb http://repo.mysql.com/apt/debian/ bullseye mysql-tools-preview
deb-src http://repo.mysql.com/apt/debian/ bullseye mysql-8.0

Best regards,

René

Hello René Bos,

Thank you for the details.
Discussed this issue internally with the build team and confirmed that Ubuntu 20.04 fixed. Thank you!

Regards,
Ashwini Patil

Hi Ashwini,

Thanks a lot for getting it fixed for Ubuntu 22.04! I asked my colleague and he confirms the fix.

However, the package still cannot be found on Debian Bullseye.

Reproducing with Docker is easy:

Start the Debian Bullseye container:
  docker run -it debian:bullseye bash

And inside the container run:
  apt update && \
  apt install -y lsb-release gnupg curl wget && \
  curl -O https://repo.mysql.com//mysql-apt-config_0.8.23-1_all.deb && \
  dpkg -i mysql-apt-config_0.8.23-1_all.deb && \
  apt-get update && \
  apt-get install mysql-workbench-community

You will see that it can't find the package. When you use the ubuntu:focal image using (docker run -it ubuntu:focal bash) and execute the install commands you will see that it is available and installs fine.

I and my colleagues are not using Debian Bullseye ourselfs but fix it may be usefull for others.

Best regards,

René Bos