[slurm-users] problems building slurm with MariaDB 10.4

[Jeffrey McDonald]

Hi,
I'm trying to build the slurm rpms on a Centos 7.8  system with the
mariadb 10.4 RPMs,
# rpm -qa | grep -i mariadb:

MariaDB-common-10.4.13-1.el7.centos.x86_64
MariaDB-server-10.4.13-1.el7.centos.x86_64
MariaDB-compat-10.4.13-1.el7.centos.x86_64
MariaDB-client-10.4.13-1.el7.centos.x86_64
MariaDB-devel-10.4.13-1.el7.centos.x86_64
MariaDB-backup-10.4.13-1.el7.centos.x86_64


When I try to build the rpms, I see the following build errors:
$ rpmbuild -ta slurm-20.02.3.tar.bz2
Processing files: slurm-slurmdbd-20.02.3-1.el7.x86_64
error: File not found:
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so


RPM build errors:
    File not found:
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
    File not found:
/root/rpmbuild/BUILDROOT/slurm-20.02.3-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
--------------------------------------
There are errors in the config run:
--------------------------------------
checking for mysql_config... /usr/bin/mysql_config
configure: WARNING: *** MySQL test program execution failed. A
thread-safe MySQL library is required.


In the build config.log,
configure: WARNING: *** MySQL test program execution failed. A
thread-safe MySQL library is required.

-----------------------------------------------
It seems that there are some missing dependencies and changes with
MariaDB 10.4, namely, there is no /usr/lib64/libmariadb.a (its been
replaced by /usr/lib/libmariadbclient.a) but a soft link from the
latter to the former doesn't fix the issue:
------------------------------------------------
In the config.log, it seems that the system libs are missing from the
mariadb_config interaction:

configure:4953: result: /usr/bin/mysql_config
configure:5054: gcc -o conftest -I/usr/include/mysql
-I/usr/include/mysql/mysql -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE
=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4
-grecord-gcc-switches -Wl,-z,lazy  -m64 -mtune=generi
c  -Wl,-z,relro -Wl,-z,lazy conftest.c -L/usr/lib64/ -lmariadb  >&5
/usr/lib64//libmariadb.a(mariadb_lib.c.o): In function `mysql_server_init':
(.text+0x1ba4): undefined reference to `pthread_once'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_double.isra.2':
(.text+0x17bc): undefined reference to `floor'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_double.isra.2':
(.text+0x180d): undefined reference to `floor'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_float.isra.3':
(.text+0x1b9a): undefined reference to `floorf'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_float.isra.3':
(.text+0x1be4): undefined reference to `floorf'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_long.isra.4':
(.text+0x20e0): undefined reference to `ceilf'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_long.isra.4':
(.text+0x215d): undefined reference to `ceil'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_long.isra.4':
(.text+0x225b): undefined reference to `ceil'
/usr/lib64//libmariadb.a(ma_stmt_codec.c.o): In function
`convert_from_long.isra.4':
(.text+0x229e): undefined reference to `ceilf'
/usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
`mysql_client_plugin_deinit':
(.text+0x20b): undefined reference to `dlclose'
/usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
`mysql_load_plugin_v':
(.text+0x5d9): undefined reference to `dlopen'
/usr/lib64//libmariadb.a(ma_client_plugin.c.o): In function
`mysql_load_plugin_v':

---------------------------------------------

I built the slurm system successfully with version mariadb 5.5. from
centOS, is this a known issue with MariaDB 10.4 ?    Does slurm build
with other versions of MariaDB?

Thanks in advance,
Jeff


-- 
Jeffrey McDonald, PhD
Director of Information Technology
The Hormel Institute
801 16th Ave NE            email: jmcdonal at umn.edu
Austin, MN 55912           phone: +1 507.437.9654