[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Condor-users] condor quill again (aging 'run' table)

Yes, we've seen things like that before.  Things get confused.
We've had a ticket open for months, the problem is that you need
to capture the state right when things first go out of sync and
we haven't been able to do that yet.  sometimes a restart of
condor and postgres will help, sometimes it won't.


On Thu, 18 Dec 2008, Carsten Aulbert wrote:

Hi all,

we are trying to take some load of our servers by using condor_quill,
however it seems that quill is in a weird state right now. We started
with quill in late October and it looked fine, but when we now go
directly to the database and look at the 'run' table it seems that it
contains only aged information about jobs which are already gone.

atlasquill=# select count(*) from runs;
(1 row)

atlasquill=# select * from runs order by startts limit 5;
atlasquill=# select * from runs order by startts desc limit 5;

show that the erliest entries are from Oct 30th and the latest ones are
from 16th of November. Other tables seem to contain current information,
but this pretty large table seems to be outdated.

Anyone ever seen something like this? Anything we can do about this?

Cheers && TIA

Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting

The archives can be found at:

Steven C. Timm, Ph.D  (630) 840-8525
timm@xxxxxxxx  http://home.fnal.gov/~timm/
Fermilab Computing Division, Scientific Computing Facilities,
Grid Facilities Department, FermiGrid Services Group, Assistant Group Leader.