Ticket 8882

Summary:	rpmbuild error: File not found accounting_storage_mysql.so
Product:	Slurm	Reporter:	Ole.H.Nielsen <Ole.H.Nielsen>
Component:	Build System and Packaging	Assignee:	Nate Rini <nate>
Status:	RESOLVED DUPLICATE	QA Contact:
Severity:	3 - Medium Impact
Priority:	---	CC:	nate
Version:	20.02.1
Hardware:	Linux
OS:	Linux
See Also:	https://bugs.schedmd.com/show_bug.cgi?id=6488
Site:	DTU Physics	Slinky Site:	---
Alineos Sites:	---	Atos/Eviden Sites:	---
Confidential Site:	---	Coreweave sites:	---
Cray Sites:	---	DS9 clusters:	---
Google sites:	---	HPCnow Sites:	---
HPE Sites:	---	IBM Sites:	---
NOAA SIte:	---	NoveTech Sites:	---
Nvidia HWinf-CS Sites:	---	OCF Sites:	---
Recursion Pharma Sites:	---	SFW Sites:	---
SNIC sites:	---	Tzag Elita Sites:	---
Linux Distro:	---	Machine Name:
CLE Version:		Version Fixed:
Target Release:	---	DevPrio:	---
Emory-Cloud Sites:	---
Attachments:	config.log (gzipped)

Description Ole.H.Nielsen@fysik.dtu.dk 2020-04-17 04:29:05 MDT

I'm following up on a slurm-users mailing list thread where slurm.spec is missing a build prerequisite, causing the rpmbuild error: File not found accounting_storage_mysql.so

Would you kindly consider this as a bug in the slurm.spec file?

To reproduce the error I worked on a CentOS 7.7 server without any special prerequisites installed.  First time around rpmbuild failed and required me to install the following prerequisites:
# yum install munge-devel readline-devel pam-devel

Now the building process starts correctly:

$ rpmbuild -ta slurm-20.02.1.tar.bz2
(lines deleted)
Processing files: slurm-slurmdbd-20.02.1-1.el7.x86_64
error: File not found: /home/camp/ohni/rpmbuild/BUILDROOT/slurm-20.02.1-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
RPM build errors:
    File not found: /home/camp/ohni/rpmbuild/BUILDROOT/slurm-20.02.1-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so
    File not found: /home/camp/ohni/rpmbuild/BUILDROOT/slurm-20.02.1-1.el7.x86_64/usr/lib64/slurm/accounting_storage_mysql.so

I realize that the user should have asked explicitly for mysql support, in which case a correct error message is printed:

$ rpmbuild -ta slurm-20.02.1.tar.bz2 --with mysql
error: Failed build dependencies:
        mysql-devel >= 5.0.0 is needed by slurm-20.02.1-1.el7.x86_64

This is a confusing situation.  Perhaps the slurm.spec file should have "--with mysql" as the default.  Alternatively, the build should exclude building of slurm-slurmdbd if the mysql-devel prerequisite is absent.

Thanks,
Ole

Comment 2 Nate Rini 2020-04-17 12:36:11 MDT

Ole,

Can you please provide the config.log from the rpm build?

Thanks,
--Nate

Comment 3 Ole.H.Nielsen@fysik.dtu.dk 2020-04-18 00:05:27 MDT

Created attachment 13871 [details]
config.log (gzipped)

Comment 4 Ole.H.Nielsen@fysik.dtu.dk 2020-04-18 00:06:19 MDT

Hi Nate,

(In reply to Nate Rini from comment #2)
> Can you please provide the config.log from the rpm build?

Yes, it's done now.

Thanks for your support.
Ole

Comment 6 Nate Rini 2020-04-20 09:15:01 MDT

Ole,

This is the same issue as bug#6488. We had previously tried to force the change you suggest which caused other issues. I'm going to close this ticket and we can pursue the issue in bug#6488.

Thanks,
--Nate

*** This ticket has been marked as a duplicate of ticket 6488 ***

Comment 7 Ole.H.Nielsen@fysik.dtu.dk 2020-04-20 09:47:43 MDT

(In reply to Nate Rini from comment #6)
> Ole,
> 
> This is the same issue as bug#6488. We had previously tried to force the
> change you suggest which caused other issues. I'm going to close this ticket
> and we can pursue the issue in bug#6488.

Thanks Nate, this sounds like to right approach.  

FWIW I have updated my Slurm RPM build instructions in
https://wiki.fysik.dtu.dk/niflheim/Slurm_installation#build-slurm-packages
to explicitly require mysql:

# rpmbuild -ta slurm-$VER.tar.bz2 --with mysql

This is going to catch the case where mysql is not installed.