This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| wiki:disk_reservation [2016/11/29 22:16] – [Admission rules] neyron | wiki:disk_reservation [2016/11/29 23:05] – [Admission rules] neyron | ||
|---|---|---|---|
| Line 64: | Line 64: | ||
| FROM resources r | FROM resources r | ||
| LEFT JOIN assigned_resources a ON a.resource_id = r.resource_id | LEFT JOIN assigned_resources a ON a.resource_id = r.resource_id | ||
| - | LEFT JOIN jobs j ON j.assigned_moldable_job = a.moldable_job_id AND j.state | + | LEFT JOIN jobs j ON j.assigned_moldable_job = a.moldable_job_id AND j.state |
| WHERE | WHERE | ||
| r.type = ' | r.type = ' | ||
| Line 77: | Line 77: | ||
| ) | ) | ||
| GROUP BY r.host, j.job_user | GROUP BY r.host, j.job_user | ||
| - | ORDER BY r.host ASC | + | ORDER BY r.host ASC, j.job_user DESC |
| EOF | EOF | ||
| } | } | ||
| Line 156: | Line 156: | ||
| Mind setting a relevant priority for the new admission rule. | Mind setting a relevant priority for the new admission rule. | ||
| - | Finally, just like for deploy jobs, we allow only whole nodes for //compute with disk// jobs. For that, we edit the corresponding rule: '' | + | Finally, just like for deploy jobs, we might want to allow only whole nodes for //compute with disk// jobs. For that, we edit the corresponding rule: '' |
| <code perl> | <code perl> | ||
| -# Restrict allowed properties for deploy jobs to force requesting entire nodes | -# Restrict allowed properties for deploy jobs to force requesting entire nodes | ||