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

["Erik Paulson" <epaulson@xxxxxxxxxxxx>]

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