[Condor-users] daemons_vertical_history and daemons_vertical tables in quill

[Steven Timm <timm@xxxxxxxx>]

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.