Re: [Condor-users] quoted strings in quill schema

[Erik Paulson <epaulson@xxxxxxxxxxx>]

On Fri, Feb 16, 2007 at 12:22:06PM +0000, Matt Hope wrote:
> 
> As a side note:
> > primary key(cid,pid)
> 
> What happens for cluster id resets? Or is such a view the domain of Quill++?
> 

In the 6.8 Quill, the tables for the current job queue are always cleared
and reloaded from the current contents of job_queue.log, so if the cluster
id resets it's fine. The worry is the historical jobs. However, the common
reason for the cluster number to be reset is for the entire condor install
on a machine to be reset, and since a V6.8 Quill is associated with only
one schedd, the Quill database is usually reset at the same time. 

The next version of Quill has a primary key of 
(scheddname, jobqueuebirthdate, cluster_id, proc_id) for historical jobs. 
jobqueuebirthdate is only reset when the entire jobqueue.log file is reset.

-Erik