Upgrading from Ubuntu 18 to 22 and 1.14 to 1.15

[tmi...@gmail.com]

Hello,

We are working through the upgrade, and I was able to get Ubuntu from 18.04 to 22.04, however when running the playbook (https://github.com/artefactual/deploy-pub/blob/master/playbooks/archivematica-jammy/singlenode.yml)

I am running into issues with the percona playbook. First I had to remove the percona-release package so it would reinstall, but it seems to be failing on installing/upgrading to percona 5.7.

I tried running the install manually, but get the following error

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libperconaserverclient18.1 libreadline7 libtinfo5 percona-server-common-5.6
Use 'apt autoremove' to remove them.
The following additional packages will be installed:
  libmecab2 percona-server-client-5.7 percona-server-common-5.7
The following packages will be REMOVED:
  percona-server-client-5.6 percona-server-server-5.6
The following NEW packages will be installed:
  libmecab2 percona-server-client-5.7 percona-server-common-5.7 percona-server-server-5.7
0 upgraded, 4 newly installed, 2 to remove and 1 not upgraded.
Need to get 0 B/69.8 MB of archives.
After this operation, 81.3 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Preconfiguring packages ...
(Reading database ... 175097 files and directories currently installed.)
Preparing to unpack .../percona-server-common-5.7_5.7.44-48-1.jammy_amd64.deb ...
Unpacking percona-server-common-5.7 (5.7.44-48-1.jammy) ...
dpkg: error processing archive /var/cache/apt/archives/percona-server-common-5.7_5.7.44-48-1.jammy_amd64.deb (--unpack):
 trying to overwrite '/usr/share/mysql/bulgarian/errmsg.sys', which is also in package percona-server-server-5.6 5.6.51-91.0-1.bionic
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/percona-server-common-5.7_5.7.44-48-1.jammy_amd64.deb
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)

When I try uninstalling percona*5.6* it looks like that might work, but wants to install mysql8 in it's place.

Any thoughts on the best order of operations?

Thank you!

Tom