I run a server with Ubuntu 20.04 installed from Percona respitory according to instructions on the website.
Everything is working fine and have done so for a long time, but today when doing a sudo apt-update && sudo apt upgrade, I get an error message about unmet dependency
percona-server-server : Dependent on: percona-server-common (= 8.0.25-15-1.focal) but 8.0.26-16-1.focal is installed
The terminal suggest apt --fix-broken install . ,but it seems that this will downgrade percona ? - Any feedback would be great.
Could you please provide us with the output of the following command:
apt list | grep percona
and with the complete output of:
sudo apt upgrade
This could help us to check where the issue could be because our test attempt to update to 8.0.26 version, having 8.0.25 installed, went smoothly:
root@88d30fd3e34c:/# apt update && apt upgrade
Hit:1 http://repo.percona.com/prel/apt focal InRelease
Hit:2 http://repo.percona.com/ps-80/apt focal InRelease
Hit:3 http://security.ubuntu.com/ubuntu focal-security InRelease
Hit:4 http://archive.ubuntu.com/ubuntu focal InRelease
Hit:5 http://archive.ubuntu.com/ubuntu focal-updates InRelease
Hit:6 http://archive.ubuntu.com/ubuntu focal-backports InRelease
Reading package lists... Done
Building dependency tree
Reading state information... Done
3 packages can be upgraded. Run 'apt list --upgradable' to see them.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages will be upgraded:
percona-server-client percona-server-common percona-server-server
3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 68.4 MB of archives.
After this operation, 50.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://repo.percona.com/ps-80/apt focal/main amd64 percona-server-server amd64 8.0.26-16-1.focal [63.5 MB]
Get:2 http://repo.percona.com/ps-80/apt focal/main amd64 percona-server-client amd64 8.0.26-16-1.focal [4416 kB]
Get:3 http://repo.percona.com/ps-80/apt focal/main amd64 percona-server-common amd64 8.0.26-16-1.focal [445 kB]
Fetched 68.4 MB in 1s (65.9 MB/s)
debconf: delaying package configuration, since apt-utils is not installed
(Reading database ... 10623 files and directories currently installed.)
Preparing to unpack .../percona-server-server_8.0.26-16-1.focal_amd64.deb ...
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of stop.
.
Unpacking percona-server-server (8.0.26-16-1.focal) over (8.0.25-15-1.focal) ...
Preparing to unpack .../percona-server-client_8.0.26-16-1.focal_amd64.deb ...
Unpacking percona-server-client (8.0.26-16-1.focal) over (8.0.25-15-1.focal) ...
Preparing to unpack .../percona-server-common_8.0.26-16-1.focal_amd64.deb ...
Unpacking percona-server-common (8.0.26-16-1.focal) over (8.0.25-15-1.focal) ...
Setting up percona-server-common (8.0.26-16-1.focal) ...
Setting up percona-server-client (8.0.26-16-1.focal) ...
Setting up percona-server-server (8.0.26-16-1.focal) ...
* Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
* Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
* See http://www.percona.com/doc/percona-server/8.0/management/udf_percona_toolkit.html for more details
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
root@88d30fd3e34c:/#
root@hp-server-1:~# sudo apt upgrade
Leser pakkelister ... Ferdig
Skaper oversikt over avhengighetsforhold
Leser tilstandsinformasjon ... Ferdig
Du vil kanskje kjøre «apt --fix-broken install» for å rette på dette.
Følgende pakker har uinnfridde avhengighetsforhold:
percona-server-server : Avhenger av: percona-server-common (= 8.0.25-15-1.focal) men 8.0.26-16-1.focal er installert
Avhenger av: percona-server-client (= 8.0.25-15-1.focal) men 8.0.26-16-1.focal er installert
E: Uinnfridde avhengighetsforhold. Prøv «apt --fix-broken install» uten pakker (eller angi en løsning).
root@hp-server-1:~#
@stirch Your suggestion might fix the broken install, but not the underlying problem why this suddenly happen. Also, this is a live online system, and I’m afraid of doing anything that might cause trouble.
This system was initially installed in 2016 using ubuntu 16.04 and later upgraded to ubuntu 20.40. All normal upgrades are usually done using alt-get update && apt-get upgrade.
I have to do it, because it was on my production server. I haven’t time to dig deep into, but problem the seems to be in the post-istall script of the deb-package.
Another important thing - MySQL 8.0.26-16 is the first stabile version of Mysql 8.0.26 in the percona repository, so before you install the update should turn off the Testing repository