Re: [Condor-users] Configuring Quill: sql logs are empty

[Jeff Ramnani <jramnani@xxxxxxxxxxxxxxx>]

On Jul 28, 2011, at 5:26 PM, Jeff Ramnani wrote:

> I'm working on configuring Condor Quill according to the manual here: http://www.cs.wisc.edu/condor/manual/v7.4.4/3_12Quill.html.  The issue I'm having is that some tables are being populated, but others aren't.  Specifically, the job history tables.

I have found the answer to my question in the /etc/condor/condor_config file.

#
# If Quill is enabled, by default it will only mirror the current job
# queue into the database. For historical jobs, and classads from other
# sources, the SQL Log must be enabled.
#QUILL_USE_SQL_LOG=FALSE

#
# The SQL Log can be enabled on a per-daemon basis. For example, to collect
# historical job information, but store no information about execute machines,
# uncomment these two lines
#QUILL_USE_SQL_LOG = FALSE
#SCHEDD.QUILL_USE_SQL_LOG = TRUE

After setting the configuration variable, "SCHEDD.QUILL_USE_SQL_LOG = TRUE", the job history tables started populating.

I also found this mailing list thread helpful: https://www-auth.cs.wisc.edu/lists/condor-users/2009-July/msg00214.shtml

Apologies for the spam, and I hope this message helps someone else who has the same issue. :)

Jeff Ramnani | Software Engineer | jramnani@xxxxxxxxxxxxxxx | (w)  312-542-2360 | www.drwholdings.com

This e-mail and any attachments may contain information that is confidential and proprietary and otherwise protected from disclosure. If you are not the intended recipient of this e-mail, do not read, duplicate or redistribute it by any means. Please immediately delete it and any attachments and notify the sender that you have received it in error. Unintended recipients are prohibited from taking action on the basis of information in this e-mail or any attachments. The DRW Companies make no representations that this e-mail or any attachments are free of computer viruses or other defects.