Required Galera missing from MariaDB??

Richard G

Richard G

Verified User
Joined
Jul 6, 2008
Messages
13,529
Location
Maastricht
I was just doing something with yum for something else and then suddenly this message appeared:
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
MariaDB-server-10.2.33-1.el7.centos.x86_64 has missing requires of galera
Click to expand...

So I went looking on my servers and it seems galera is not installed on any of the servers? At this moment they all still run MariaDB 10.2.33.

However, it says "has missing requirements", shouldn't this have been added/build by custombuild?

Do I need to install this via yum or is do I not need to worry?
 
galera should be installed by CB. Doesn't it show any errors when you run "./build mysql"?
 
On all my servers (Centos 7 and 8) a rpm -qa galera gives no result.

No errors on building mysql:
Code: 
2020-10-09 16:47:41 (18.0 MB/s) - '/usr/local/directadmin/custombuild/mysql/centos7-64.txt' saved [328/328]

Found /usr/local/directadmin/custombuild/mysql/MariaDB-client-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-devel-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-server-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-shared-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-common-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-compat-10.2.33-1.el7.centos.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MariaDB-backup-10.2.33-1.el7.centos.x86_64.rpm
Installing dependencies...
Installing libjemalloc...
Found /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el7.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/jemalloc-devel-3.6.0-1.el7.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/jemalloc-3.6.0-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:jemalloc-3.6.0-1.el7             ################################# [ 50%]
   2:jemalloc-devel-3.6.0-1.el7       ################################# [100%]
Installing galera...
Found /usr/local/directadmin/custombuild/mysql/galera-4-26.4.5-1.el7.centos.x86_64.rpm
warning: /usr/local/directadmin/custombuild/mysql/galera-4-26.4.5-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:galera-4-26.4.5-1.el7.centos     ################################# [100%]
Stopping mysqld ...
Updating MariaDB 10.2.33 to 10.2.33
warning: MariaDB-client-10.2.33-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-compat-10.2.33-1.el7.cent################################# [ 14%]
   2:MariaDB-common-10.2.33-1.el7.cent################################# [ 29%]
   3:MariaDB-client-10.2.33-1.el7.cent################################# [ 43%]
   4:MariaDB-server-10.2.33-1.el7.cent################################# [ 57%]
   5:MariaDB-devel-10.2.33-1.el7.cento################################# [ 71%]
   6:MariaDB-shared-10.2.33-1.el7.cent################################# [ 86%]
   7:MariaDB-backup-10.2.33-1.el7.cent################################# [100%]
Created symlink from /etc/systemd/system/mysql.service to /etc/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /etc/systemd/system/mariadb.service.
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
This installation of MySQL is already upgraded to 10.2.33-MariaDB, use --force if you still need to run mysql_upgrade
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
Installation completed.
 
Last edited:
Could it be that yum sees it in the epel release or Centos 8 in the Appstream and this causes the notice because it's not installed via epel or Appstream?
If yes, wouldn't it be better to add galera in the yum exclude line?
 
From your output:
Code: 
Updating / installing...
   1:galera-4-26.4.5-1.el7.centos     ################################# [100%]

What's the output of:
Code: 
rpm -qa | grep galera
 
Ah I did the command wrong. I did rpm -qa galera which gave no output.
With the grep it outputs this:
galera-4-26.4.5-1.el7.centos.x86_64

But why was yum complaining then before about the missing requirement? Should galera be added to the yum exclusions like MariaDB and Mysql are?
 
What's the output of:
Code: 
rpm -q galera
rpm -q galera-4

I guess yum is still erroring on this?
 
It responds at galera-4
Code: 
# rpm -q galera-4
galera-4-26.4.5-1.el7.centos.x86_64

at this moment I don't see yum erroring on this anymore. That was on one server and I did a "yum clean all" and looks silent now.
 
seeing this now too on my servers.

Running transaction
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
MariaDB-server-10.1.46-1.el7.centos.x86_64 has missing requires of galera
Click to expand...

rpm -qa | grep galera
galera-4-26.4.5-1.el7.centos.x86_64
Click to expand...

but its harmless, correct?
 
Since Galera is installed and mysql is running fine, it's seems no issue, is only a warning, no error.
You might also try the command:
Code: 
yum clean all
and the warning should not occur anymore if I'm not mistaken.
 
Odd.... it's back again. I wanted to install yum cron and then this again:
Code: 
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
MariaDB-server-10.2.33-1.el7.centos.x86_64 has missing requires of galera
  Installing : yum-cron-3.4.3-167.el7.centos.noarch                                                                                               1/1 
  Verifying  : yum-cron-3.4.3-167.el7.centos.noarch

Still... galera -is- installed.
 
You must log in or register to reply here.
Back
Top