Ticket 2622 - squeue -o %all
Summary: squeue -o %all
Status: RESOLVED FIXED
Alias: None
Product: Slurm
Classification: Unclassified
Component: User Commands (show other tickets)
Version: 14.11.5
Hardware: Linux Linux
: 5 - Enhancement
Assignee: Tim Wickberg
QA Contact:
URL:
Depends on:
Blocks:
 
Reported: 2016-04-10 23:49 MDT by Michael DiDomenico
Modified: 2017-08-29 16:30 MDT (History)
0 users

See Also:
Site: IDACCR
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: 16.05.0
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 Michael DiDomenico 2016-04-10 23:49:20 MDT
We use 'squeue -o %all' as output to feed a script which uploads the data into a database.  Can the column headings be made unique and database field name friendly (ie no ':' or '()' ).
Comment 1 Tim Wickberg 2016-04-11 02:53:26 MDT
I do see a few minor caveats with how %all works - squeue is internally creating a format string of "%a|%b|%c|..." that is then fed to the normal parsing code. (A few recent additions do not show up here - squeue now has more than 52 possible fields to display, and some are only available using the --Format syntax.) 

The spaces in the column names appear to be a bug, and I'm looking at fixing that now.

The ":" in "S:C:T" is not likely to change, and the "PRIORITY(REASON)" is also unlikely to change. Your parser is likely stuck with that. Your best current workaround would be to feed an explicit list of the column names you're interested in (excluding those you don't need, and/or have column names that disagree with your parser) to -o rather that using %all.

Bug 2046 is looking at adding JSON output for "scontrol show jobs" and similar commands which may be better suited for import into your database instead, although this likely will not be done until sometime after 16.05 is released.
Comment 2 Tim Wickberg 2016-04-11 03:36:48 MDT
Commit 6cfe0b0eb for the (yet-to-be-released 16.05) fixes the errant spaces in the column definitions. That single-character patch to squeue could be applied on 14.11 if desired.
Comment 3 Tim Wickberg 2017-08-29 16:30:10 MDT
Marking fixed as of 16.05.