Ticket 16782 - mysql needed for slurm client?
Summary: mysql needed for slurm client?
Status: RESOLVED INFOGIVEN
Alias: None
Product: Slurm
Classification: Unclassified
Component: Build System and Packaging (show other tickets)
Version: 23.02.2
Hardware: Linux Linux
: 4 - Minor Issue
Assignee: Tim McMullan
QA Contact:
URL:
Depends on:
Blocks:
 
Reported: 2023-05-22 01:32 MDT by Yann
Modified: 2023-05-26 11:10 MDT (History)
0 users

See Also:
Site: Université de Genève
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

Note You need to log in before you can comment on or make changes to this ticket.
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