Ticket 16782

Summary:	mysql needed for slurm client?
Product:	Slurm	Reporter:	Yann <yann.sagon>
Component:	Build System and Packaging	Assignee:	Tim McMullan <mcmullan>
Status:	RESOLVED INFOGIVEN	QA Contact:
Severity:	4 - Minor Issue
Priority:	---
Version:	23.02.2
Hardware:	Linux
OS:	Linux
Site:	Université de Genève	Alineos Sites:	---
Atos/Eviden Sites:	---	Confidential Site:	---
Coreweave sites:	---	Cray Sites:	---
DS9 clusters:	---	HPCnow Sites:	---
HPE Sites:	---	IBM Sites:	---
NOAA SIte:	---	OCF Sites:	---
Recursion Pharma Sites:	---	SFW Sites:	---
SNIC sites:	---	Linux Distro:	---
Machine Name:		CLE Version:
Version Fixed:		Target Release:	---
DevPrio:	---	Emory-Cloud Sites:	---

Description Yann 2023-05-22 01:32:57 MDT

Dear team,

we build slurm from source with the spec file provided on Rocky8.

We are using slurmdbd with storage on a mysql-server. For this reason we installed mysql on the build node.

We saw then that there is a dependency on mysql for the package "slurm". Is there any reason for that?

Best

Yann

Comment 1 Jason Booth 2023-05-22 15:02:50 MDT

Just for clarification, are you using the provided slurm.spec provided by the tarball from our site, or are you using another one provided by Rocky8?

Comment 2 Yann 2023-05-23 02:05:41 MDT

We use slurm.spec from the src tarball

Comment 5 Tim McMullan 2023-05-25 07:06:58 MDT

Hi Yann,

There are 2 plugins in slurm that use the mysql libraries.  The obvious one is the accounting_storage/mysql plugin which only the slurmdbd loads.

The jobcomp/mysql plugin also requires mysql and can be loaded much more broadly if enabled.  Due to its potential use in more than just the slurmdbd it gets packaged in the "slurm" rpm, and therefore also gets the mysql dependency.

Let me know if that helps clear things up!
--Tim

Comment 6 Yann 2023-05-26 08:58:05 MDT

Hi, thanks for the clarification.

Maybe it would be good to package the "tools" (sacct, sinfo etc) in a separate package without MySQL dependency?

Our issue is that we compile slurm with MySQL bigger than 8 and we need sacct on our openxdmod server which doesn't support MySQL bigger than 5.x.

Anyway, thanks for the information, we'll figure out a workaround, you can close the issue.

Best

Comment 7 Tim McMullan 2023-05-26 11:10:42 MDT

(In reply to Yann from comment #6)
> Hi, thanks for the clarification.
> 
> Maybe it would be good to package the "tools" (sacct, sinfo etc) in a
> separate package without MySQL dependency?

Its somewhat complicated to do this in an "always works" way since sacct can actually load the plugin in question.

> Our issue is that we compile slurm with MySQL bigger than 8 and we need
> sacct on our openxdmod server which doesn't support MySQL bigger than 5.x.
> 
> Anyway, thanks for the information, we'll figure out a workaround, you can
> close the issue.
> 
> Best

Ok, I'll close this out but let us know if you have any other questions!

Thanks,
--Tim