[MDEV-31786] PMM Installation Blocking MariaDB Install Created: 2023-07-27  Updated: 2023-09-17

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Juan Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Rocky 9.2


Attachments: File epel-next-testing.repo     File epel-next.repo     File epel-testing.repo     File epel.repo     File mariadb.repo     File percona-original-release.repo     File percona-prel-release.repo     File rocky-addons.repo     File rocky-devel.repo     File rocky-extras.repo     File rocky.repo    

 Description   

First installing Percona repositories to be able to use PMM to monitor this instance, I then install MariaDB repo for the latest 10.9.
MariaDB says it installs, then does not appear, thus:

yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.9.7
 
~# dnf -y install MariaDB-server MariaDB-shared MariaDB-common MariaDB-backup MariaDB-client MariaDB-server-debuginfo MariaDB-backup-debuginfo MariaDB-shared-debuginfo MariaDB-common-debuginfo MariaDB-backup-debuginfo MariaDB-client-debuginfo MariaDB-cracklib-password-check galera-4
Last metadata expiration check: 0:09:55 ago on Thu 27 Jul 2023 05:42:12 PM -04.
Dependencies resolved.
==================================================================================================================================================================================
 Package                                                Architecture                  Version                                 Repository                                     Size
==================================================================================================================================================================================
Installing:
 MariaDB-backup                                         x86_64                        10.9.7-1.el9                            mariadb-main                                  6.9 M
 MariaDB-backup-debuginfo                               x86_64                        10.9.7-1.el9                            mariadb-main                                   58 M
 MariaDB-client                                         x86_64                        10.9.7-1.el9                            mariadb-main                                  8.5 M
 MariaDB-client-debuginfo                               x86_64                        10.9.7-1.el9                            mariadb-main                                   54 M
 MariaDB-common                                         x86_64                        10.9.7-1.el9                            mariadb-main                                   88 k
 MariaDB-common-debuginfo                               x86_64                        10.9.7-1.el9                            mariadb-main                                  177 k
 MariaDB-cracklib-password-check                        x86_64                        10.9.7-1.el9                            mariadb-main                                   12 k
 MariaDB-server                                         x86_64                        10.9.7-1.el9                            mariadb-main                                   18 M
 MariaDB-server-debuginfo                               x86_64                        10.9.7-1.el9                            mariadb-main                                  114 M
 MariaDB-shared                                         x86_64                        10.9.7-1.el9                            mariadb-main                                  130 k
     replacing  mariadb-connector-c.x86_64 3.2.6-1.el9_0
     replacing  mariadb-connector-c-config.noarch 3.2.6-1.el9_0
 MariaDB-shared-debuginfo                               x86_64                        10.9.7-1.el9                            mariadb-main                                  492 k
 galera-4                                               x86_64                        26.4.14-1.el9                           mariadb-main                                  1.3 M
Installing dependencies:
 Percona-Server-client-57                               x86_64                        5.7.42-46.1.el9                         percona-release-x86_64                        1.8 M
 Percona-Server-server-57                               x86_64                        5.7.42-46.1.el9                         percona-release-x86_64                         20 M
     replacing  mariadb-connector-c-config.noarch 3.2.6-1.el9_0
 Percona-Server-shared-57                               x86_64                        5.7.42-46.1.el9                         percona-release-x86_64                        830 k
 boost-program-options                                  x86_64                        1.75.0-8.el9                            appstream                                     106 k
 daxctl-libs                                            x86_64                        71.1-8.el9                              baseos                                         41 k
 libpmem                                                x86_64                        1.12.1-1.el9                            appstream                                     111 k
 ndctl-libs                                             x86_64                        71.1-8.el9                              baseos                                         88 k
 perl-Sys-Hostname                                      x86_64                        1.23-480.el9                            appstream                                      17 k
 
Transaction Summary
==================================================================================================================================================================================
Install  20 Packages
 
Total download size: 284 M
Downloading Packages:
(1/20): MariaDB-client-10.9.7-1.el9.x86_64.rpm                                                                                                    4.6 MB/s | 8.5 MB     00:01
(2/20): MariaDB-backup-10.9.7-1.el9.x86_64.rpm                                                                                                    3.6 MB/s | 6.9 MB     00:01
(3/20): MariaDB-common-10.9.7-1.el9.x86_64.rpm                                                                                                    130 kB/s |  88 kB     00:00
(4/20): MariaDB-common-debuginfo-10.9.7-1.el9.x86_64.rpm                                                                                          236 kB/s | 177 kB     00:00
(5/20): MariaDB-cracklib-password-check-10.9.7-1.el9.x86_64.rpm                                                                                    15 kB/s |  12 kB     00:00
(6/20): MariaDB-backup-debuginfo-10.9.7-1.el9.x86_64.rpm                                                                                           11 MB/s |  58 MB     00:05
(7/20): MariaDB-server-10.9.7-1.el9.x86_64.rpm                                                                                                    8.5 MB/s |  18 MB     00:02
(8/20): MariaDB-client-debuginfo-10.9.7-1.el9.x86_64.rpm                                                                                           10 MB/s |  54 MB     00:05
(9/20): MariaDB-shared-10.9.7-1.el9.x86_64.rpm                                                                                                    149 kB/s | 130 kB     00:00
(10/20): MariaDB-shared-debuginfo-10.9.7-1.el9.x86_64.rpm                                                                                         503 kB/s | 492 kB     00:00
(11/20): galera-4-26.4.14-1.el9.x86_64.rpm                                                                                                        1.1 MB/s | 1.3 MB     00:01
(12/20): Percona-Server-client-57-5.7.42-46.1.el9.x86_64.rpm                                                                                      809 kB/s | 1.8 MB     00:02
(13/20): Percona-Server-shared-57-5.7.42-46.1.el9.x86_64.rpm                                                                                      3.3 MB/s | 830 kB     00:00
(14/20): ndctl-libs-71.1-8.el9.x86_64.rpm                                                                                                         619 kB/s |  88 kB     00:00
(15/20): daxctl-libs-71.1-8.el9.x86_64.rpm                                                                                                        1.0 MB/s |  41 kB     00:00
(16/20): libpmem-1.12.1-1.el9.x86_64.rpm                                                                                                          3.3 MB/s | 111 kB     00:00
(17/20): perl-Sys-Hostname-1.23-480.el9.x86_64.rpm                                                                                                1.9 MB/s |  17 kB     00:00
(18/20): boost-program-options-1.75.0-8.el9.x86_64.rpm                                                                                            2.1 MB/s | 106 kB     00:00
(19/20): MariaDB-server-debuginfo-10.9.7-1.el9.x86_64.rpm                                                                                          15 MB/s | 114 MB     00:07
(20/20): Percona-Server-server-57-5.7.42-46.1.el9.x86_64.rpm                                                                                      1.6 MB/s |  20 MB     00:12
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                              13 MB/s | 284 MB     00:21
Percona Original release/x86_64 YUM repository                                                                                                    602 kB/s | 4.7 kB     00:00
Importing GPG key 0x8507EFA5:
 Userid     : "Percona Development Team (Packaging key) <info@percona.com>"
 Fingerprint: 4D1B B29D 63D9 8E42 2B21 13B1 9334 A25F 8507 EFA5
 From       : /etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
The downloaded packages were saved in cache until the next successful transaction.
" ============================================================================
" Netrw Directory Listing                                        (netrw v170)
"   /etc/my.cnf.d
"   Sorted by      name
"   Sort sequence: [\/]$,\<core\%(\.\d\+\)\=\>,\.h$,\.c$,\.cpp$,\~\=\*$,*,\.o$,\.obj$,\.info$,\.swp$,\.bak$,\~$
"   Quick Help: <F1>:help  -:go up dir  D:delete  R:rename  s:sort-by  x:special
" ==============================================================================
 
~# systemctl restart mariadb
Failed to restart mariadb.service: Unit mariadb.service not found.
~# dnf -y list installed | egrep -i "percona|mariadb"
mariadb-connector-c.x86_64                  3.2.6-1.el9_0                    @appstream
mariadb-connector-c-config.noarch           3.2.6-1.el9_0                    @appstream
percona-release.noarch                      1.0-27                           @@commandline

Installed repos attached.



 Comments   
Comment by Juan [ 2023-07-27 ]

Clean up the repos by removing Percona, reinstall, and everything works fine.

#cd /etc/yum.repos.d
yum.repos.d#rm -fr ./percona-*
yum.repos.d#yum clean all
yum.repos.d#yum clean metadata
yum.repos.d#yum clean all
yum.repos.d#dnf -y install MariaDB-server MariaDB-shared MariaDB-common MariaDB-backup MariaDB-client MariaDB-server-debuginfo MariaDB-backup-debuginfo MariaDB-shared-debuginfo MariaDB-common-debuginfo MariaDB-backup-debuginfo MariaDB-client-debuginfo MariaDB-cracklib-password-check galera-4
yum.repos.d# systemctl restart mariadb
yum.repos.d# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.9.7-MariaDB-log MariaDB Server
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]> exit

Generated at Thu Feb 08 10:26:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.