Error during xtradb-cluster installation on ubuntu

I used to run ubuntu 16 with pxc 5.7. After updating to Ubuntu 20.04.2 LTS, I ran the following commands to update the cluster to 8.0:

apt-get remove percona-xtradb-cluster-server-5.7
apt autoremove
wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
dpkg -i percona-release_latest.generic_all.deb
apt-get update
percona-release setup pxc80
apt update
percona-release enable tools release
apt update
apt install percona-xtradb-cluster

During the installation process, the following error is encountered:

Do you want to continue? [Y/n]
Preconfiguring packages ...
Selecting previously unselected package percona-xtradb-cluster-common.
(Reading database ... 115274 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-common_1%3a8.0.22-13-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-common (1:8.0.22-13-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-client.
Preparing to unpack .../percona-xtradb-cluster-client_1%3a8.0.22-13-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-client (1:8.0.22-13-1.focal) ...
Setting up percona-xtradb-cluster-common (1:8.0.22-13-1.focal) ...
(Reading database ... 115300 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-server_1%3a8.0.22-13-1.focal_amd64.deb ...
/var/lib/dpkg/tmp.ci/preinst: line 10: /var/lib/mysql/service.state: No such file or directory
dpkg: error processing archive /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.22-13-1.focal_amd64.deb (--unpack):
 new percona-xtradb-cluster-server package pre-installation script subprocess returned error exit status 1
Selecting previously unselected package percona-xtradb-cluster.
Preparing to unpack .../percona-xtradb-cluster_1%3a8.0.22-13-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster (1:8.0.22-13-1.focal) ...
Errors were encountered while processing:
 /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.22-13-1.focal_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

The folder /var/lib/mysql doesn’t exist on my machine. I would assume that percona installs it, because it also installed a mysql binary at /usr/bin during the failed installation mentioned above.

What am I missing here?

1 Like

Hi @hildebro

This issue appears as apt removed only server packages but all other 5.7 connected packages were left.
It is better to remove these packages in the following way:
dpkg --purge percona-xtradb-cluster-server-5.7 percona-xtradb-cluster-common-5.7 percona-xtradb-cluster-client-5.7 percona-xtrabackup-24

1 Like

Hello, do you found any solution for this case?? I have the problem too

1 Like

hey @Ahmad_Irsyadur_Roziq
Please show the logs

1 Like

When i first install percona xtraDB got error unpacking .deb percona xtradb cluster server, I am install at ubuntu 20.04, I already running apt fix broken but still error when first install

(Reading database … 98460 files and directories currently installed.)
Preparing to unpack …/percona-xtradb-cluster-server_1%3a8.0.27-18-1.focal_amd64.deb …
/var/lib/dpkg/tmp.ci/preinst: line 10: /var/lib/mysql/service.state: No such file or directory
dpkg: error processing archive /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.27-18-1.focal_amd64.deb (–unpack):
new percona-xtradb-cluster-server package pre-installation script subprocess returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.27-18-1.focal_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

1 Like

trying to get 8 installing is #$#$@
essentially broken pc now trying to go from 5 to 8

and why after doing purges of percona and mysql is /usr/share/mysql still their ?

why does the installer not install mysql packages and create the mysql user etc !!!

apt upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
  python3-software-properties software-properties-common software-properties-gtk update-notifier update-notifier-common
The following packages will be upgraded:
  imagemagick-6-common imagemagick-6.q16 libeditorconfig0 libimage-magick-perl libimage-magick-q16-perl libjs-jquery-ui libmagick++-6.q16-8 libmagickcore-6.q16-6 libmagickcore-6.q16-6-extra
  libmagickwand-6.q16-6 libopenexr-dev libopenexr25 libpython2.7 libpython2.7-dev libpython2.7-minimal libpython2.7-stdlib python2.7 python2.7-dev python2.7-minimal
19 upgraded, 0 newly installed, 0 to remove and 5 not upgraded.
19 esm-apps security updates
Need to get 11.9 MB of archives.
After this operation, 5120 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libimage-magick-q16-perl amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [108 kB]
Get:2 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libimage-magick-perl all 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [53.9 kB]
Get:3 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 imagemagick-6-common all 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [65.0 kB]
Get:4 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libmagickcore-6.q16-6 amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [1790 kB]
Get:5 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libmagickwand-6.q16-6 amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [327 kB]
Get:6 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 python2.7-dev amd64 2.7.18-13ubuntu1.1+esm2 [286 kB]
Get:7 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libpython2.7-dev amd64 2.7.18-13ubuntu1.1+esm2 [2520 kB]
Get:8 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libpython2.7 amd64 2.7.18-13ubuntu1.1+esm2 [1163 kB]
Get:9 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 python2.7 amd64 2.7.18-13ubuntu1.1+esm2 [250 kB]
Get:10 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libpython2.7-stdlib amd64 2.7.18-13ubuntu1.1+esm2 [1977 kB]
Get:11 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 python2.7-minimal amd64 2.7.18-13ubuntu1.1+esm2 [1405 kB]
Get:12 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libpython2.7-minimal amd64 2.7.18-13ubuntu1.1+esm2 [347 kB]
Get:13 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 imagemagick-6.q16 amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [224 kB]
Get:14 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libeditorconfig0 amd64 0.12.5-2ubuntu0.1~esm1 [14.7 kB]                                                                           
Get:15 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libjs-jquery-ui all 1.13.1+dfsg-1ubuntu0.1~esm1 [253 kB]                                                                          
Get:16 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libmagick++-6.q16-8 amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [157 kB]                                                       
Get:17 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libopenexr-dev amd64 2.5.7-1ubuntu0.1~esm1 [73.5 kB]                                                                              
Get:18 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libopenexr25 amd64 2.5.7-1ubuntu0.1~esm1 [779 kB]                                                                                 
Get:19 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security/main amd64 libmagickcore-6.q16-6-extra amd64 8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1 [70.1 kB]                                              
Fetched 11.9 MB in 6s (1911 kB/s)                                                                                                                                                                          
(Reading database ... 706231 files and directories currently installed.)
Preparing to unpack .../00-libimage-magick-q16-perl_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking libimage-magick-q16-perl (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../01-libimage-magick-perl_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_all.deb ...
Unpacking libimage-magick-perl (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../02-imagemagick-6-common_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_all.deb ...
Unpacking imagemagick-6-common (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../03-libmagickcore-6.q16-6_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking libmagickcore-6.q16-6:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../04-libmagickwand-6.q16-6_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking libmagickwand-6.q16-6:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../05-python2.7-dev_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking python2.7-dev (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../06-libpython2.7-dev_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking libpython2.7-dev:amd64 (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../07-libpython2.7_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking libpython2.7:amd64 (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../08-python2.7_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking python2.7 (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../09-libpython2.7-stdlib_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking libpython2.7-stdlib:amd64 (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../10-python2.7-minimal_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking python2.7-minimal (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../11-libpython2.7-minimal_2.7.18-13ubuntu1.1+esm2_amd64.deb ...
Unpacking libpython2.7-minimal:amd64 (2.7.18-13ubuntu1.1+esm2) over (2.7.18-13ubuntu1.1) ...
Preparing to unpack .../12-imagemagick-6.q16_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking imagemagick-6.q16 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../13-libeditorconfig0_0.12.5-2ubuntu0.1~esm1_amd64.deb ...
Unpacking libeditorconfig0:amd64 (0.12.5-2ubuntu0.1~esm1) over (0.12.5-2) ...
Preparing to unpack .../14-libjs-jquery-ui_1.13.1+dfsg-1ubuntu0.1~esm1_all.deb ...
Unpacking libjs-jquery-ui (1.13.1+dfsg-1ubuntu0.1~esm1) over (1.13.1+dfsg-1) ...
Preparing to unpack .../15-libmagick++-6.q16-8_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking libmagick++-6.q16-8:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Preparing to unpack .../16-libopenexr-dev_2.5.7-1ubuntu0.1~esm1_amd64.deb ...
Unpacking libopenexr-dev (2.5.7-1ubuntu0.1~esm1) over (2.5.7-1) ...
Preparing to unpack .../17-libopenexr25_2.5.7-1ubuntu0.1~esm1_amd64.deb ...
Unpacking libopenexr25:amd64 (2.5.7-1ubuntu0.1~esm1) over (2.5.7-1) ...
Preparing to unpack .../18-libmagickcore-6.q16-6-extra_8%3a6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1_amd64.deb ...
Unpacking libmagickcore-6.q16-6-extra:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) over (8:6.9.11.60+dfsg-1.3build2) ...
Setting up imagemagick-6-common (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libeditorconfig0:amd64 (0.12.5-2ubuntu0.1~esm1) ...
Setting up libopenexr25:amd64 (2.5.7-1ubuntu0.1~esm1) ...
Setting up libmagickcore-6.q16-6:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libopenexr-dev (2.5.7-1ubuntu0.1~esm1) ...
Setting up libpython2.7-minimal:amd64 (2.7.18-13ubuntu1.1+esm2) ...
Setting up libjs-jquery-ui (1.13.1+dfsg-1ubuntu0.1~esm1) ...
Setting up python2.7-minimal (2.7.18-13ubuntu1.1+esm2) ...
Setting up libmagickwand-6.q16-6:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libmagick++-6.q16-8:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libmagickcore-6.q16-6-extra:amd64 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libimage-magick-q16-perl (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libpython2.7-stdlib:amd64 (2.7.18-13ubuntu1.1+esm2) ...
Setting up imagemagick-6.q16 (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libimage-magick-perl (8:6.9.11.60+dfsg-1.3ubuntu0.22.04.1+esm1) ...
Setting up libpython2.7:amd64 (2.7.18-13ubuntu1.1+esm2) ...
Setting up libpython2.7-dev:amd64 (2.7.18-13ubuntu1.1+esm2) ...
Setting up python2.7 (2.7.18-13ubuntu1.1+esm2) ...
Setting up python2.7-dev (2.7.18-13ubuntu1.1+esm2) ...
Processing triggers for desktop-file-utils (0.26-1ubuntu3) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu3) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
/sbin/ldconfig.real: /libx32/ld-linux-x32.so.2 is not a symbolic link

Processing triggers for man-db (2.10.2-1) ...
Processing triggers for mailcap (3.70+nmu1ubuntu1) ...
Processing triggers for bamfdaemon (0.5.6+22.04.20220217-0ubuntu1) ...
Rebuilding /usr/share/applications/bamf-2.index...
Scanning processes...                                                                                                                                                                                       
Scanning processor microcode...                                                                                                                                                                             
Scanning linux images...                                                                                                                                                                                    

Running kernel seems to be up-to-date.

The processor microcode seems to be up-to-date.

No services need to be restarted.

No containers need to be restarted.

No user sessions are running outdated binaries.

No VM guests are running outdated hypervisor (qemu) binaries on this host.
root@aio:/tmp# sudo percona-release setup pxc80
* Disabling all Percona Repositories
* Enabling the Percona XtraDB Cluster 8.0 repository
* Enabling the Percona Tools repository
Get:1 https://ocean.surfshark.com/debian stretch InRelease [2313 B]
Hit:2 https://dl.winehq.org/wine-builds/ubuntu jammy InRelease                                                                                                                                             
Err:1 https://ocean.surfshark.com/debian stretch InRelease                                                                                                                                                 
  The following signatures were invalid: EXPKEYSIG 1DB7590E83C8F643 Surfshark package maintainer <admin@surfshark.com>
Hit:3 http://repo.percona.com/prel/apt jammy InRelease                                                                                                                                                     
Hit:4 http://repo.percona.com/pxc-80/apt jammy InRelease                                                                                                                                                   
Hit:5 http://repo.percona.com/tools/apt jammy InRelease                                                                                                                                                    
Ign:6 https://download.puffinbrowser.com/repo stable InRelease                                                                                                                                     
Hit:7 https://packages.teejeetech.com/ukuu/g6YLZAWavG/ubuntu/bionic/amd64 stable InRelease                                                                                   
Hit:8 http://archive.ubuntu.com/ubuntu jammy InRelease                                                                                                                       
Hit:9 https://packages.lunarg.com/vulkan/1.3.216 focal InRelease                                                                                       
Hit:10 https://esm.ubuntu.com/apps/ubuntu jammy-apps-security InRelease                                                          
Hit:11 https://download.puffinbrowser.com/repo stable Release                                                                    
Get:12 http://archive.ubuntu.com/ubuntu jammy-updates InRelease [119 kB]                                                         
Hit:13 https://esm.ubuntu.com/apps/ubuntu jammy-apps-updates InRelease                                               
Hit:14 https://ppa.launchpadcontent.net/kicad/kicad-6.0-releases/ubuntu jammy InRelease                              
Get:15 https://esm.ubuntu.com/infra/ubuntu jammy-infra-security InRelease [7453 B]                                      
Get:16 https://esm.ubuntu.com/infra/ubuntu jammy-infra-updates InRelease [7452 B]                                                   
Get:18 http://archive.ubuntu.com/ubuntu jammy-backports InRelease [107 kB]                                                         
Hit:19 https://ppa.launchpadcontent.net/team-xbmc/xbmc-nightly/ubuntu jammy InRelease
Get:20 http://archive.ubuntu.com/ubuntu jammy-security InRelease [110 kB]
Hit:21 http://archive.ubuntu.com/ubuntu jammy-proposed InRelease
Fetched 351 kB in 4s (95.8 kB/s)
Reading package lists... Done
W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: https://ocean.surfshark.com/debian stretch InRelease: The following signatures were invalid: EXPKEYSIG 1DB7590E83C8F643 Surfshark package maintainer <admin@surfshark.com>
W: https://packages.lunarg.com/vulkan/1.3.216/dists/focal/InRelease: Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg), see the DEPRECATION section in apt-key(8) for details.
W: Failed to fetch https://ocean.surfshark.com/debian/dists/stretch/InRelease  The following signatures were invalid: EXPKEYSIG 1DB7590E83C8F643 Surfshark package maintainer <admin@surfshark.com>
W: Some index files failed to download. They have been ignored, or old ones used instead.
root@aio:/tmp# sudo apt install -y percona-xtradb-cluster
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  libdbd-mysql-perl libmysqlclient21 mysql-common percona-xtradb-cluster-client percona-xtradb-cluster-common percona-xtradb-cluster-server
Suggested packages:
  tinyca pv
The following NEW packages will be installed:
  libdbd-mysql-perl libmysqlclient21 mysql-common percona-xtradb-cluster percona-xtradb-cluster-client percona-xtradb-cluster-common percona-xtradb-cluster-server
0 upgraded, 7 newly installed, 0 to remove and 5 not upgraded.
Need to get 105 MB/107 MB of archives.
After this operation, 363 MB of additional disk space will be used.
Get:1 http://repo.percona.com/pxc-80/apt jammy/main amd64 percona-xtradb-cluster-common amd64 1:8.0.30-22-1.jammy [28.2 kB]
Get:2 http://archive.ubuntu.com/ubuntu jammy/main amd64 mysql-common all 5.8+1.0.8 [7212 B]
Get:3 http://repo.percona.com/pxc-80/apt jammy/main amd64 percona-xtradb-cluster-client amd64 1:8.0.30-22-1.jammy [20.9 MB]
Get:4 http://repo.percona.com/pxc-80/apt jammy/main amd64 percona-xtradb-cluster-server amd64 1:8.0.30-22-1.jammy [84.2 MB]                                                                                
Get:5 http://repo.percona.com/pxc-80/apt jammy/main amd64 percona-xtradb-cluster amd64 1:8.0.30-22-1.jammy [3634 B]                                                                                        
Fetched 105 MB in 27s (3849 kB/s)                                                                                                                                                                          
Preconfiguring packages ...
Selecting previously unselected package percona-xtradb-cluster-common.
(Reading database ... 706231 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-common_1%3a8.0.30-22-1.jammy_amd64.deb ...
Unpacking percona-xtradb-cluster-common (1:8.0.30-22-1.jammy) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.8+1.0.8_all.deb ...
Unpacking mysql-common (5.8+1.0.8) ...
Replaced by files in installed package percona-xtradb-cluster-common (1:8.0.30-22-1.jammy) ...
Selecting previously unselected package libmysqlclient21:amd64.
Preparing to unpack .../libmysqlclient21_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking libmysqlclient21:amd64 (8.0.32-0ubuntu0.22.04.2) ...
Selecting previously unselected package libdbd-mysql-perl:amd64.
Preparing to unpack .../libdbd-mysql-perl_4.050-5_amd64.deb ...
Unpacking libdbd-mysql-perl:amd64 (4.050-5) ...
Selecting previously unselected package percona-xtradb-cluster-client.
Preparing to unpack .../percona-xtradb-cluster-client_1%3a8.0.30-22-1.jammy_amd64.deb ...
Unpacking percona-xtradb-cluster-client (1:8.0.30-22-1.jammy) ...
Setting up percona-xtradb-cluster-common (1:8.0.30-22-1.jammy) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up mysql-common (5.8+1.0.8) ...
Setting up libmysqlclient21:amd64 (8.0.32-0ubuntu0.22.04.2) ...
Setting up libdbd-mysql-perl:amd64 (4.050-5) ...
Selecting previously unselected package percona-xtradb-cluster-server.
(Reading database ... 706285 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-server_1%3a8.0.30-22-1.jammy_amd64.deb ...
/var/lib/dpkg/tmp.ci/preinst: line 10: /var/lib/mysql/service.state: No such file or directory
dpkg: error processing archive /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.30-22-1.jammy_amd64.deb (--unpack):
 new percona-xtradb-cluster-server package pre-installation script subprocess returned error exit status 1
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
invoke-rc.d: initscript mysql, action "start" failed.
× mysql.service - LSB: Start/ Stop MySQL Community Server daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: failed (Result: exit-code) since Sun 2023-02-12 14:18:35 AEST; 5ms ago
       Docs: man:systemd-sysv-generator(8)
    Process: 190760 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
        CPU: 34ms

Feb 12 14:18:35 aio mysql[190760]: /etc/init.d/mysql: line 33: /usr/share/mysql/mysql-helpers: No such file or directory
Feb 12 14:18:35 aio mysql[190767]: /etc/init.d/mysql: line 43: mysqld: command not found
Feb 12 14:18:35 aio mysql[190773]: /etc/init.d/mysql: line 46: my_print_defaults: command not found
Feb 12 14:18:35 aio mysql[190779]: /etc/init.d/mysql: line 46: my_print_defaults: command not found
Feb 12 14:18:35 aio mysql[190786]: /etc/init.d/mysql: line 46: my_print_defaults: command not found
Feb 12 14:18:35 aio mysql[190791]: /etc/init.d/mysql: line 46: my_print_defaults: command not found
Feb 12 14:18:35 aio mysql[190794]: install: invalid user ‘mysql’
Feb 12 14:18:35 aio systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Feb 12 14:18:35 aio systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 12 14:18:35 aio systemd[1]: Failed to start LSB: Start/ Stop MySQL Community Server daemon.
dpkg: error while cleaning up:
 new percona-xtradb-cluster-server package post-removal script subprocess returned error exit status 1
Selecting previously unselected package percona-xtradb-cluster.
Preparing to unpack .../percona-xtradb-cluster_1%3a8.0.30-22-1.jammy_amd64.deb ...
Unpacking percona-xtradb-cluster (1:8.0.30-22-1.jammy) ...
Errors were encountered while processing:
 /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.30-22-1.jammy_amd64.deb
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@aio:/tmp# 


percona8.txt (85.4 KB)

Was this ever resolved? Having an identical issue at the moment but with Ubuntu 22.04

Preparing to unpack .../percona-xtradb-cluster-server_1%3a8.0.35-27-1.jammy_amd64.deb ...
/var/lib/dpkg/tmp.ci/preinst: line 10: /var/lib/mysql/service.state: No such file or directory
dpkg: error processing archive /var/cache/apt/archives/percona-xtradb-cluster-server_1%3a8.0.35-27-1.jammy_amd64.deb (--unpack):
 new percona-xtradb-cluster-server package pre-installation script subprocess returned error exit status 1
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
invoke-rc.d: initscript mysql, action "start" failed.
× mysql.service - LSB: Start/ Stop MySQL Community Server daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: failed (Result: exit-code) since Fri 2024-02-16 13:37:21 GMT; 8ms ago
       Docs: man:systemd-sysv-generator(8)
    Process: 109053 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
        CPU: 51ms

@Monk it would be great if you could provide me with exact STR and commands you are executing as I cannot reproduce the issue and everything works well for me