Re: [Condor-users] daemons_vertical_history and daemons_vertical tables in quill

[Steven Timm <timm@xxxxxxxx>]

I sent the file to Erik off-list.  There is already an active
condor-admin ticket on this topic.

Steve Timm


On Wed, 24 Sep 2008, Erik Paulson wrote:

> Can you send me the full Quill Log file (and, if it's handy, the
> sql.log and schedd_sql.log, if you use that too?)
>
> You can send it to me directly, or put it into condor-admin, your choice.
>
> -Erik
>
>
> On Tue, Sep 23, 2008 at 8:13 PM, Steven Timm <timm@xxxxxxxx> wrote:
> > I have a quill instance from condor 7.0.3
> > that has been crashing repeatedly.  It had worked for
> > quite some time but then the postgres database
> > got accidentally wiped out and I have now twice tried to
> > wipe and recreate the database but have been unsuccessful. It always
> > hangs with the error below, about once per hour.
> >
> > Every time quill starts up, it goes back to June 26 or
> > so and tries to load the whole history of the schedd from that
> > time until now into the daemons_vertical and daemons_vertical_history
> > tables.  I have wiped all the files in spool and restarted
> > condor, it still is getting it from somewhere.  My question is where?
> > Short of totally reinstalling condor from scratch I am at a loss
> > to figure out what to do next.  Anyone else who has seen
> > this, your help would be appreciated.
> >
> > Thanks
> >
> > Steve Timm
> >
> >
> > 9/23 20:09:11 SQL COMMAND: INSERT INTO daemons_vertical_history (MyType,
> > name, lastreportedtime, attr, val, endtime) SELECT MyType, name,
> > lastreportedtime, attr, val, '7/16/2008 15:53:12 CDT' FROM
> > daemons_vertical
> > WHERE MyType = 'Scheduler' AND name = 'fgitb-gk.fnal.gov' AND attr =
> > 'MyCurrentTime' AND val != '1216241592'
> > 9/23 20:09:11 SQL COMMAND: UPDATE daemons_vertical SET val = '1216241592',
> > lastreportedtime = '7/16/2008 15:53:12 CDT' WHERE MyType = 'Scheduler' AND
> > name = 'fgitb-gk.fnal.gov' AND attr = 'MyCurrentTime' AND val !=
> > '1216241592'
> >
> >
> > --
> > ------------------------------------------------------------------
> > 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.
> > _______________________________________________
> > 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/
> _______________________________________________
> 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.