Bug #114824 debian 12 repo broken for innodb-cluster
Submitted: 30 Apr 2024 13:45 Modified: 30 Apr 2024 17:15
Reporter: Kingsley Tart Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Package Repos Severity:S1 (Critical)
Version:8.0.37 OS:Debian (bookworm)
Assigned to: CPU Architecture:x86

[30 Apr 2024 13:45] Kingsley Tart
Description:
Cannot install on Debian 12; get loads of 404 errors from repo.

With the following in an apt sources file, I was unable to install innodb-cluster:

deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-tools
deb-src [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0

Similarly, I have some test servers that already have 8.0.36 installed, but apt-get upgrade (after an update) fails with the following errors:

The following packages will be upgraded:
  mysql-client mysql-cluster-community-client mysql-cluster-community-client-core mysql-cluster-community-client-plugins mysql-cluster-community-server mysql-cluster-community-server-core mysql-common
7 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 64.7 MB of archives.
After this operation, 9,607 kB of additional disk space will be used.
Do you want to continue? [Y/n] 
Err:1 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:2 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client-core amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:3 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client-plugins amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:4 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-server-core amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:5 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-server amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:6 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-client amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
Err:7 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-common amd64 8.0.37-1debian12
  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.215.234.26 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-co...  404  Not Found [IP: 23.215.234.26 80]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

How to repeat:
Try to install innodb-cluster-8.0 on Debian 12 with the following in apt-sources, or simply try to upgrade on a server that already has an earlier version installed:

deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-tools
deb-src [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0

Suggested fix:
Not sure what to put here.
[30 Apr 2024 14:29] MySQL Verification Team
Hi,

Might be temporary error with CDN .. have you tried installing latest repo config mysql-apt-config_0.8.29-1_all.deb ?

https://dev.mysql.com/downloads/repo/apt/

I am not reproducing it now, can you retest please.

Thanks
[30 Apr 2024 16:50] Kingsley Tart
Hi. I'm still getting the error.

I have mysql-apt-config installed already:

--8<--
# apt list --installed | grep mysql-apt

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

mysql-apt-config/unknown,now 0.8.29-1 all [installed]
--8<--

The mysql.list file:

root@distDB-test21b:/etc/apt/sources.list.d# cat 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 [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-apt-config
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0
deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-tools
#deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-tools-preview
deb-src [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ bookworm mysql-cluster-8.0

After re-running apt-get update:

# apt-get upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
  linux-image-amd64
The following packages will be upgraded:
  base-files bind9-dnsutils bind9-host bind9-libs bsdextrautils bsdutils btl-firewall btl-perl-cmdline btl-perl-net-ipaddr-local eject fdisk libblkid1 libc-bin libc-l10n libc6 libcryptsetup12 libfdisk1 libgnutls30 libmariadb3 libmount1 libnss-systemd libpam-systemd libsmartcols1 libsystemd-shared libsystemd0 libudev1 libuuid1 libuv1 locales mariadb-common mount
  mysql-client mysql-cluster-community-client mysql-cluster-community-client-core mysql-cluster-community-client-plugins mysql-cluster-community-server mysql-cluster-community-server-core mysql-common postfix qemu-guest-agent systemd systemd-sysv tar tzdata udev usbutils usr-is-merged util-linux util-linux-extra util-linux-locales
50 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
Need to get 64.7 MB/90.7 MB of archives.
After this operation, 9,678 kB of additional disk space will be used.
Do you want to continue? [Y/n] 
Err:1 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:2 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client-core amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:3 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-client-plugins amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:4 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-server-core amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:5 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-cluster-community-server amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:6 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-client amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
Err:7 http://repo.mysql.com/apt/debian bookworm/mysql-cluster-8.0 amd64 mysql-common amd64 8.0.37-1debian12
  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-cl...  404  Not Found [IP: 23.208.252.139 80]
E: Failed to fetch http://repo.mysql.com/apt/debian/pool/mysql-cluster-8.0/m/mysql-cluster-community/mysql-co...  404  Not Found [IP: 23.208.252.139 80]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Regards,
Kingsley.
BTW, what I would prefer to install is the LTS version, but my googling failed to find me any instructions on how to add the repo for that.
[30 Apr 2024 17:15] MySQL Verification Team
Hi,

Looks like 8.0.37 is not yet pushed to all nodes. Thanks for report we'll fix it asap.
[30 Apr 2024 21:02] Philip Olson
My comments don't address the bug, but for clarification just in case:

* The bug report references a desire for "innodb-cluster" while attempting to install "mysql-cluster" and the two are different. Install the standard mysql-server-community to get InnoDB Cluster.

  https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html

* If you desire MySQL 8.4 instead of MySQL 8.0, then you can install the latest repository setup package from here (which is mysql-apt-config_0.8.30-1_all.deb not mysql-apt-config_0.8.29-1_all.deb) to access the latest repository information, which includes 8.4:

  https://dev.mysql.com/downloads/repo/apt/
[2 May 2024 4:54] MySQL Verification Team
Hi,

Irrelevant to the issue where these mysql-cluster files are not in the repo, I didn't notice but my colleague did, you say you want to install innodb-cluster. To install innodb-cluster you need regular mysql server, the mysql-cluster is for the ndbcluster and not for innodb cluster.