Monday, April 29, 2024
 Popular · Latest · Hot · Upcoming
2
rated 0 times [  2] [ 0]  / answers: 1 / hits: 1005  / 2 Years ago, thu, october 27, 2022, 7:36:37

I have 2 updates that could not be installed automatically.


When I try to upgrade with: sudo apt upgrade then I got this message:



The following packages have been kept back: mysql-client mysql-server



So when I try to install it manually like: sudo apt install mysql-client then I got the following message:


The following packages have unmet dependencies: 
mysql-common : Conflicts: mysql-client-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed
Conflicts: mysql-client-core-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed
E: Unable to correct problems, you have held broken packages.

and when I try to install: sudo apt install mysql-server


I got this message:


The following packages have unmet dependencies: 
mysql-common : Conflicts: mysql-server-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed
mysql-community-client : Conflicts: mysql-server-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed
mysql-server-8.0 : Depends: mysql-client-8.0 (>= 8.0.31-0ubuntu0.22.04.1) but it is not installable
Depends: mysql-server-core-8.0 (= 8.0.31-0ubuntu0.22.04.1) but it is not installable
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.

It is on a production server and if it is possible not to delete everything and reinstall mysql without losing my configuration and/or deleting the databases.


Update:


Output of ~$ apt-cache policy mysql-client-8.0


mysql-client-8.0:
Installed: (none)
Candidate: 8.0.31-0ubuntu0.22.04.1
Version table:
8.0.31-0ubuntu0.22.04.1 500
500 http://eu-west-1.ec2.archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages
500 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages
8.0.28-0ubuntu4 500
500 http://eu-west-1.ec2.archive.ubuntu.com/ubuntu jammy/main amd64 Packages

Output of ~$ apt-cache policy mysql-server-core-8.0


mysql-server-core-8.0:
Installed: (none)
Candidate: 8.0.31-0ubuntu0.22.04.1
Version table:
8.0.31-0ubuntu0.22.04.1 500
500 http://eu-west-1.ec2.archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages
500 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages
8.0.28-0ubuntu4 500
500 http://eu-west-1.ec2.archive.ubuntu.com/ubuntu jammy/main amd64 Packages

Output of ~$ sudo apt upgrade


Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
#
# News about significant security updates, features and services will
# appear here to raise awareness and perhaps tease /r/Linux ;)
# Use 'pro config set apt_news=false' to hide this and future APT news.
#
The following packages have been kept back:
mysql-client mysql-server
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

More From » apt

 Answers
0

The clue is in this error message


mysql-community-client : Conflicts: mysql-server-8.0 but 8.0.31-0ubuntu0.22.04.1 is to be installed 

You have the package mysql-community-client installed. This is a command line client that has the same purpose as the package mysql-client but (I believe) falls under a different license.


Nevertheless, its presence causes the server install to fail. So simply remove it, and retry to install the server.


Afterwards, make sure you have one MySQL client installed at all times for basic maintenance, be it mysql-client or mysql-communit-client.


[#147] Friday, October 28, 2022, 2 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
altybol

Total Points: 364
Total Questions: 138
Total Answers: 121

Location: France
Member since Thu, May 6, 2021
3 Years ago
altybol questions
;