Percona-server-server-5.7.39-42 Upgrade Failure on Debian 10 and Ubuntu 20.04

MySQL & MariaDB Percona Server for MySQL 5.7
1

Yesterday I ran a normal “apt update && apt ugprade” like I always do and there was an upgrade available for the 3 following packages :

The following packages will be upgraded:
   percona-server-client-5.7 percona-server-common-5.7 percona-server-server-5.7

This was an upgrade from 5.7.38-41-1 to 5.7.39-42-1.

Then the upgrade of “percona-server-server-5.7” failed and I’m now totally unable to start mysql anymore…

Here are the errors :

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - Percona Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mysql.service.d
           └─limits.conf
   Active: activating (auto-restart) (Result: exit-code) since Wed 2022-08-17 09:38:52 CEST; 8ms ago
  Process: 3381 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
  Process: 3426 ExecStartPre=/usr/bin/ps_mysqld_helper (code=exited, status=0/SUCCESS)
  Process: 3432 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)

Aug 17 09:38:52 ubuntu-srv systemd[1]: Failed to start Percona Server.
dpkg: error processing package percona-server-server-5.7 (--configure):
 installed percona-server-server-5.7 package post-installation script subprocess returned error exit status 1
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for systemd (241-7~deb10u8) ...
Errors were encountered while processing:
 percona-server-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)

This was on an Ubuntu 20.04 server, but then I also tried on a Debian 10 snapshot server running the same things and I got the same error.

I was able to restore a snapshot of the Ubuntu server to keep my prod running and I excluded the Percona updates with “apt-mark hold” but I don’t understand why Percona failed, I usually don’t have any problem with this kind of minor updates.

Any idea how could I fix it ? Thank you.

1 Like