Re: [HTCondor-users] condor_status: sort vs limit

[John M Knoeller <johnkn@xxxxxxxxxxx>]

-sort JobStart will sort based on the raw value of the JobStart attribute, not based on the way you formatted the data.

Also the sort happens in condor_status, not in the collector so mixing -sort with -limit will not do what you want it to do
this case. 

It's not technically a bug, more emergent behavior that isn't really desirable.   

Changing the collector to build a complete result set, sort it, and then return only the desired quantity would 
give the collector *more* work to do than it does today.   The Addition of the -limit option was intended to give
the collector a chance to do less work, especially when doing locate queries. 


-----Original Message-----
From: HTCondor-users <htcondor-users-bounces@xxxxxxxxxxx> On Behalf Of Stefano Dal Pra
Sent: Thursday, June 11, 2020 2:30 PM
To: HTCondor-Users Mail List <htcondor-users@xxxxxxxxxxx>
Subject: [HTCondor-users] condor_status: sort vs limit

Hello,
I have a "bug or feature" question.

Today I was looking for a way to identify a few of the oldest running 
jobs in the cluster, so i tried something like this:

[root@farm-ops ~]# date
gio 11 giu 2020, 21.13.49, CEST
[root@farm-ops ~]# condor_status -sort JobStart -af 
'formatTime(JobStart,"%Y-%m-%d:%H:%M:%S")' GlobalJobId -lim 2
2020-06-11:15:12:17 ce01-htc.cr.cnaf.infn.it#494816.0#1591881064
2020-06-11:20:51:55 sn-01.cr.cnaf.infn.it#5037059.0#1591899848

Which doesn't work as i would expect, as the sort operates on the 
"limit-ed" resultset.

In fact, the desired result comes truncating later, this way.
[root@farm-ops ~]# condor_status -sort JobStart -af 
'formatTime(JobStart,"%Y-%m-%d:%H:%M:%S")' GlobalJobId | head -2
2020-06-06:23:06:06 sn-01.cr.cnaf.infn.it#4907255.5#1591477533
2020-06-06:23:06:06 sn-01.cr.cnaf.infn.it#4907255.8#1591477533

Is that intended behaviour?

Cheers,
Stefano
_______________________________________________
HTCondor-users mailing list
To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users

The archives can be found at:
https://lists.cs.wisc.edu/archive/htcondor-users/