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

["Matt Hope" <matthew.hope@xxxxxxxxx>]

On 2/16/07, Erik Paulson <epaulson@xxxxxxxxxxx> wrote:
> 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.

It might be worth noting that previous to this it was considered
perfectly ok (several posts in the archives on this - some from me :)
as a last resort for a screwed up queue to delete the jobqueue.log
file (for instance if a dodgy qedit put invalid characters in it).

Will doing that in this case cause primary key violations if you do
not do something else with Quill (or will this instead trigger a
dropping of all historical info from quill)?

Either is probably grounds for a big warning message about this no
longer being a good way to 'reset' a dodgy queue.

Matt