[slurm-users] SLURM's reservations

[Sébastien VIGNERON]

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> 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/20180406/ff98d480/attachment.html>