Re: [Condor-users] Quill not saving historical job data (Condor 7.0.1)?

[Daniel Forrest <forrest@xxxxxxxxxxxxx>]

Justin,

> When i run condor_history [owner] (on the machine running quill) i get:
> 
> Error while opening the history cursors: ERROR:  column reference
> "scheddname" is ambiguous at character 314
> 
> and the postgres log contains:
> 
> ERROR:  column reference "scheddname" is ambiguous at character 314
> STATEMENT:  DECLARE HISTORY_OWNER_VER_CUR CURSOR FOR SELECT
> hv.cluster_id,hv.proc_id,hv.attr,hv.val FROM Jobs_Horizontal_History hh,
> Jobs_Vertical_History hv WHERE hh.cluster_id=hv.cluster_id AND
> hh.proc_id=hv.proc_id AND hh.owner='[owner]' AND hh.scheddname =
> '[quill_host]' AND hh.scheddbirthdate = 1219245801  ORDER BY scheddname,
> cluster_id,proc_id;

This is a bug in the database query, the final clause needs to be:

"... ORDER BY hh.scheddname, hh.cluster_id,hh.proc_id"

I have a patch for this, but I haven't pushed it to the Condor team
yet.  It does not affect how the history is stored in the database.

I assume from what you've said that "condor_history" (with no args)
produces no output (the historical database is empty)?

We are running Condor 7.1.1 now (even though it was pulled), but the
same problem exists in 7.1.0.  Quill has worked fine for us with both
versions, both for job queue and historical entries.

-- 
Daniel K. Forrest	Laboratory for Molecular and
forrest@xxxxxxxxxxxxx	Computational Genomics
(608) 262 - 9479	University of Wisconsin, Madison