Ticket 2622

Summary: squeue -o %all
Product: Slurm Reporter: Michael DiDomenico <mdidomenico>
Component: User CommandsAssignee: Tim Wickberg <tim>
Status: RESOLVED FIXED QA Contact:
Severity: 5 - Enhancement    
Priority: ---    
Version: 14.11.5   
Hardware: Linux   
OS: Linux   
Site: IDACCR Alineos Sites: ---
Atos/Eviden Sites: --- Confidential Site: ---
Coreweave sites: --- Cray Sites: ---
DS9 clusters: --- HPCnow Sites: ---
HPE Sites: --- IBM Sites: ---
NOAA SIte: --- OCF Sites: ---
Recursion Pharma Sites: --- SFW Sites: ---
SNIC sites: --- Linux Distro: ---
Machine Name: CLE Version:
Version Fixed: 16.05.0 Target Release: ---
DevPrio: --- Emory-Cloud Sites: ---

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.