Dpkg error installing libperconaserverclient20-dev on Ubuntu 20.04

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hello,

When installing a new Percona Cluster server with Ubuntu 20.04, I’m getting a somewhat odd error if I try to install “libperconaserverclient20-dev” to get the “mysql_config_editor” binary.

I can do “apt install percona-xtradb-cluster-server-5.7” and it does install correctly.

Then, I try to install “libperconaserverclient20-dev”. This one depends on libperconaserverclient20 and percona-server-common-5.7. This last one can’t be installed if “percona-xtradb-cluster-server-5.7” is installed too:

apt install libperconaserverclient20-dev

Reading package lists… Done

Building dependency tree

Reading state information… Done

The following package was automatically installed and is no longer required:

libboost-program-options1.71.0

Use ‘apt autoremove’ to remove it.

The following additional packages will be installed:

libperconaserverclient20 percona-server-common-5.7

The following NEW packages will be installed:

libperconaserverclient20 libperconaserverclient20-dev percona-server-common-5.7

0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.

Need to get 0 B/1918 kB of archives.

After this operation, 16.4 MB of additional disk space will be used.

Do you want to continue? [Y/n]

Selecting previously unselected package percona-server-common-5.7.

(Reading database … 160913 files and directories currently installed.)

Preparing to unpack …/percona-server-common-5.7_5.7.32-35-1.focal_amd64.deb …

Unpacking percona-server-common-5.7 (5.7.32-35-1.focal) …

dpkg: error processing archive /var/cache/apt/archives/percona-server-common-5.7_5.7.32-35-1.focal_amd64.deb (–unpack):

trying to overwrite ‘/usr/include/coredumper/coredumper.h’, which is also in package percona-xtradb-cluster-server-5.7 5.7.31-31.45-3.focal

dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)

Selecting previously unselected package libperconaserverclient20:amd64.

Preparing to unpack …/libperconaserverclient20_5.7.32-35-1.focal_amd64.deb …

Unpacking libperconaserverclient20:amd64 (5.7.32-35-1.focal) …

Selecting previously unselected package libperconaserverclient20-dev.

Preparing to unpack …/libperconaserverclient20-dev_5.7.32-35-1.focal_amd64.deb …

Unpacking libperconaserverclient20-dev (5.7.32-35-1.focal) …

Errors were encountered while processing:

/var/cache/apt/archives/percona-server-common-5.7_5.7.32-35-1.focal_amd64.deb

E: Sub-process /usr/bin/dpkg returned an error code (1)

I have checked that all related packages are provided by Percona’s repo. This machine only has Ubuntu default repos and the ones set up by percona-release_latest.focal_all.deb.

Looks like there is an issue with those packages. Can anyone check?

Thank you.

1 Like
2

Hi @vrcsts

Thanks for your report.

Yes such issue can appear and if you need to install libperconaserverclient20 - it is recommended to download it from website: https://downloads.percona.com/downloads/Percona-XtraDB-Cluster-57/Percona-XtraDB-Cluster-5.7.31-31.45-3/binary/debian/focal/x86_64/libperconaserverclient20-dev_5.7.31-31.45-3.focal_amd64.deb https://downloads.percona.com/downloads/Percona-XtraDB-Cluster-57/Percona-XtraDB-Cluster-5.7.31-31.45-3/binary/debian/focal/x86_64/libperconaserverclient20_5.7.31-31.45-3.focal_amd64.deb

I have checked and improve our release process so starting from next release such issue should not appear and it will be possible to install ibperconaserverclient package from our PXC-57 repository.

One more time - thank you for the report as it helps making our products better :slight_smile:

1 Like
3

Manually installing both packages works ok and provide the mysql_config_editor binary:

dpkg -i libperconaserverclient20_5.7.31-31.45-3.focal_amd64.deb libperconaserverclient20-dev_5.7.31-31.45-3.focal_amd64.deb

Still, after an “apt update”, apt asks to upgrade with the version in the repo:

apt list --upgradable

Listing… Done

libperconaserverclient20-dev/unknown 5.7.32-35-1.focal amd64 [upgradable from: 5.7.31-31.45-3.focal]

libperconaserverclient20/unknown 5.7.32-35-1.focal amd64 [upgradable from: 5.7.31-31.45-3.focal]

Had to mark both on hold:

apt-mark hold libperconaserverclient20-dev libperconaserverclient20

libperconaserverclient20-dev set on hold.

libperconaserverclient20 set on hold.

Regards

1 Like
4

Hi @vrcsts

As I told you in my previous comment - the issue in repo would be fixed once we issue new PXC-57 release

1 Like
5

Hello,

This is still an issue with version 5.7.35-38-1.bionic, maybe with later ones too. I makes harder to update servers as I have to sort this out every time I need to update each server or keep those packages on hold.

Any news about when this can be solved in a new PXC-57 release?

Regards.

1 Like
6

Hi @vrcsts

It is necessary to use pxc-57 repository instead of original
How to do this?
sudo percona-release setup pxc-57
This command will disable all percona repos and enable only pxc-57 and pxb-24 repos

2 Likes
7

I’ve installed mydumper on my production server for taking full backup.

But ,I’m facing issue with mysql libraries. can someone please help me here…

root@xxxxxxxx:~# mydumper -V
mydumper: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory
root@xxxxxxxx:~#

root@xxxxxxxx:~# sudo apt install libmariadb-dev
Reading package lists… Done
Building dependency tree
Reading state information… Done
You might want to run ‘apt --fix-broken install’ to correct these.
The following packages have unmet dependencies:
libmariadb-dev : Depends: libmariadb3 (= 3.0.3-1build1) but it is not going to be installed
libperconaserverclient20 : Depends: percona-server-common-5.7 (= 5.7.41-44-1.bionic) but it is not going to be installed
E: Unmet dependencies. Try ‘apt --fix-broken install’ with no packages (or specify a solution).
root@xxxxxx:~#

It’s a production mysql instance, EC2 ubuntu 18.04 instance, I need to fix without Mysql service down.

8

Hi @Evgeniy_Patlan

Running this ‘sudo percona-release setup pxc-57’ , Will cause any mysql service outage if we run on already installed and running production mysql server ?

The problem on my case is, Mydumper command failing with below message.

root@xxxxxxxx:~# mydumper -V
mydumper: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory
root@xxxxxxxx:~#

Tried to install maria libraries. using → sudo apt install libmariadb-dev, it’s giving me the actual issue which you were speaking on this forum…

oot@xxxxxxxx:~# sudo apt install libmariadb-dev
Reading package lists… Done
Building dependency tree
Reading state information… Done
You might want to run ‘apt --fix-broken install’ to correct these.
The following packages have unmet dependencies:
libmariadb-dev : Depends: libmariadb3 (= 3.0.3-1build1) but it is not going to be installed
libperconaserverclient20 : Depends: percona-server-common-5.7 (= 5.7.41-44-1.bionic) but it is not going to be installed
E: Unmet dependencies. Try ‘apt --fix-broken install’ with no packages (or specify a solution).
root@xxxxxx:~#

It’s a production mysql instance, EC2 ubuntu 18.04 instance, I need to fix without Mysql service down.

9

hi @Bhargav_Naidu_M
percona-release doesn’t perform any actions with databases. This script only install needed repositories