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

[Steven Timm <timm@xxxxxxxx>]

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.

Steve



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;
> count
> --------
> 589521
> (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
>
> Carsten
> _______________________________________________
> Condor-users mailing list
> To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
> subject: Unsubscribe
> You can also unsubscribe by visiting
> https://lists.cs.wisc.edu/mailman/listinfo/condor-users
>
> The archives can be found at:
> https://lists.cs.wisc.edu/archive/condor-users/

--
------------------------------------------------------------------
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.