[slurm-users] SLURM's reservations

[De Giorgi Jean-Claude]

Hello Sébastien,

Thanks for your answer. I found what I needed.

Regards,
Jean-Claude


From: slurm-users <slurm-users-bounces at lists.schedmd.com> on behalf of Sébastien VIGNERON <sebastien.vigneron at criann.fr>
Reply-To: Slurm User Community List <slurm-users at lists.schedmd.com>
Date: Friday, 6 April 2018 at 17:12
To: Slurm User Community List <slurm-users at lists.schedmd.com>
Subject: Re: [slurm-users] SLURM's reservations

Hi,

In the DB, yes, in resv_table table. If you need usernames resolution, you need to use the assoc_table table. You may also need to translate the flags and tres fields (look for slurm source code for that).

In slurm 17.02.9, the resv_table has this form:
+------------+----------------------+------+-----+---------+-------+
| Field      | Type                 | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+-------+
| id_resv    | int(10) unsigned     | NO   | PRI | 0       |       |
| deleted    | tinyint(4)           | NO   |     | 0       |       |
| assoclist  | text                 | NO   |     | NULL    |       |
| flags      | smallint(5) unsigned | NO   |     | 0       |       |
| nodelist   | text                 | NO   |     | NULL    |       |
| node_inx   | text                 | NO   |     | NULL    |       |
| resv_name  | text                 | NO   |     | NULL    |       |
| time_start | bigint(20) unsigned  | NO   | PRI | 0       |       |
| time_end   | bigint(20) unsigned  | NO   |     | 0       |       |
| tres       | text                 | NO   |     | NULL    |       |
+------------+----------------------+------+-----+---------+-------+

Cordialement / Best regards,

Sébastien VIGNERON
CRIANN,
Ingénieur / Engineer
Technopôle du Madrillet
745, avenue de l'Université
76800 Saint-Etienne du Rouvray - France
tél. +33 2 32 91 42 91
fax. +33 2 32 91 42 92
http://www.criann.fr
mailto:sebastien.vigneron at criann.fr
support: support at criann.fr


Le 6 avr. 2018 à 15:46, De Giorgi Jean-Claude <jean-claude.degiorgi at epfl.ch<mailto:jean-claude.degiorgi at epfl.ch>> a écrit :

Hi all,

Is there a way to get a list of the old reservations?
Maybe in the DB?

Thanks,
Jean-Claude

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20180409/f3507868/attachment.html>