[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Condor-users] Assertion error in Quill

Do you have QUILL_DB_USER defined in the configuration
file?  By default it should be "quillwriter"
That is what got me past this error when I was seeing it.
Also note that although QUILL_DB_USER appears in the configuration
section of the manual it does not yet appear in the section where
all the QUILL variables are mentioned, nor in the Index.

Steve Timm

On Mon, 8 Oct 2007, Matt Baker wrote:

Thanks for the info,

I've recreated the database, giving quillwriter access to it, and also
changed the .pgpass file to contain the ip address instead of the
hostname. I'm still getting the following errors:

QUILLLOG (multiple entries like this)
10/8 10:19:40 ******************************************************
10/8 10:19:40 ** condor_quill (CONDOR_QUILL) STARTING UP
10/8 10:19:40 ** /opt/condor/sbin/condor_quill
10/8 10:19:40 ** $CondorVersion: 6.9.4 Aug 30 2007 $
10/8 10:19:40 ** $CondorPlatform: I386-LINUX_RHEL3 $
10/8 10:19:40 ** PID = 25657
10/8 10:19:40 ** Log last touched 10/8 10:15:15
10/8 10:19:40 ******************************************************
10/8 10:19:40 Using config source: /opt/condor/etc/condor_config
10/8 10:19:40 Using local config sources:
10/8 10:19:40    /opt/condor/etc/condor_config.local
10/8 10:19:40 DaemonCore: Command Socket at <xxx.xxx.xxx.xxx:27037>
10/8 10:19:40 main_init() called
10/8 10:19:40 configuring tt options from config file
10/8 10:19:40 Using Polling Period = 10
10/8 10:19:40 Using logs 10/8 10:19:40 /export/home/condor/log/sql.log
10/8 10:19:40
10/8 10:19:40 ERROR "Assertion ERROR on (jobQueueDBUser)" at line 137 in
file dbms_utils.C

MASTERLOG (multiple entries like this)
10/8 10:19:40 The QUILL (pid 25657) exited with status 4
10/8 10:19:40 restarting /opt/condor/sbin/condor_quill in 521 seconds

As before, condor_status and condor_q SEEM to work:

-- Quill: quill@xxxxxxxxxxxx : <xxx.xxx.xxx.xxx:5432> : quillcm

But after submitting a job, running condor_q shows an empty queue.

Any ideas?

U. of Arkansas

OK--I stand corrected... I did check before I sent the e-mail but perhaps
the old version was cached in my browser.

May I make the following coments--

on step #6 it is easy to use the wrong postgres syntax
to create the database and *think* it is owned by quillwriter
but in fact it was not.  It would help if the correct syntax
was just put there in the docs.

$ createdb --username=quillwriter quillcm -W

createlang plpgsql quillcm

I believe that the two psql loads of the *.sql files must also be
done as quillwriter user--at least that was the way it worked
for me after two previous failures and dropping the database.

Also note that there are still some bugs with how the condor_history
daemon interacts with quill--I have reported these in a condor-support
ticket.  In particular if you try to do condor_history -name quill@hostname
from some other host than hostname, it won't work.

Steve Timm

Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting

The archives can be found at:

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.