Re: [Condor-users] Condor Quill Problem

["Natarajan, Senthil" <senthil@xxxxxxxx>]

Hi Steve,
Yes I have .pgpass file under $(SPOOL) directory it has a line info with the following format

machinename:5432:quillDataBaseName:quillwriter:password

Yes, PostgreSQL is running.

Here is the output of condor_config_val -dump | grep QUILL

DAEMON_LIST = COLLECTOR, MASTER, NEGOTIATOR, SCHEDD, STARTD, QUILL, DBMSD
QUILL = $(SBIN)/condor_quill
QUILL_ADDRESS_FILE = $(LOG)/.quill_address
QUILL_DB_IP_ADDR = machinename:5432
QUILL_DB_NAME = quilldb_cybersphere3
QUILL_DB_QUERY_PASSWORD = quillreader password
QUILL_DB_TYPE = PGSQL
QUILL_DB_USER = quillwriter
QUILL_DBSIZE_LIMIT = 20
QUILL_ENABLED = TRUE
QUILL_HISTORY_DURATION = 30
QUILL_IS_REMOTELY_QUERYABLE = TRUE
QUILL_JOB_HISTORY_DURATION = 3650
QUILL_LOG = $(LOG)/QuillLog
QUILL_MAINTAIN_DB_CONN = TRUE
QUILL_MANAGE_VACUUM = FALSE
QUILL_NAME = quill@machinename
QUILL_POLLING_PERIOD = 10
QUILL_RESOURCE_HISTORY_DURATION = 3650
QUILL_RUN_HISTORY_DURATION = 3650
QUILL_USE_SQL_LOG = TRUE

If I run condor_q I get the following, (right now no jobs in the queue)
>>>condor_q


-- Quill: quill@machinename : <machinename:5432> : quilldb_cybersphere3 : 2009-01-06 10:28:02-05
 ID      OWNER            SUBMITTED     RUN_TIME ST PRI SIZE CMD

0 jobs; 0 idle, 0 running, 0 held

Running condor_history returns nothing, (And there is no rows in the corresponding tables in the PostgreSQL.) But I had ran around 20 test jobs.

condor_history -name quill@machinename senthil


-- Quill: quill@machinename : < machinename:5432> : quilldb_cybersphere3
 ID      OWNER            SUBMITTED     RUN_TIME ST   COMPLETED CMD
No historical jobs in the database match your query


Looks like Quill daemon is not accessing the database seems, but I couldn't not see any error msg in the QuillLog or DbmsdLog

Thanks,
Senthil

-----Original Message-----
From: condor-users-bounces@xxxxxxxxxxx [mailto:condor-users-bounces@xxxxxxxxxxx] On Behalf Of Steven Timm
Sent: Monday, January 05, 2009 5:12 PM
To: Condor-Users Mail List
Subject: Re: [Condor-users] Condor Quill Problem

Send the output of

condor_config_val -dump | grep QUILL

also, do you have your .pgpass file stored in the $(SPOOL) directory
on the machine that runs the schedd?

Is postgres up and running?   the error message indicates
that it is probably not, or else you can't talk to it due
to the missing .pgpass file.

What happens with just plain condor_q?

Steve timm



On Mon, 5 Jan 2009, Natarajan, Senthil wrote:

> Hi,
> I am trying to set up Quill (Condor 7.0.5, PostgreSQL 8.3.5)
> condor_q and condor_history  informations are not saving in the database.
>
> When I try
> condor_q -direct quilld
>
> -- Failed to fetch ads from: <xxx.xx.xxx.xx:36983> : xxxxxxxx
>
> -- Quill daemon at quill@xxxxxx(<xxx.xx.xxx.xx:36983>)
>        associated with schedd xxxxxx(<xxx.xx.xxx.xx:36981>)
>        is not reachable or can't talk to rdbms.
>        - Not failing over due to -direct
>
> There is no error msg in QuillLog and DbmsdLog.
>
> Could you please let me know what might be the problem.
>
> Thanks,
> Senthil
>

-- 
------------------------------------------------------------------
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.
_______________________________________________
Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/condor-users

The archives can be found at: 
https://lists.cs.wisc.edu/archive/condor-users/