Re: [Condor-users] Quill some tables not populated

[Steven Timm <timm@xxxxxxxx>]

As I asked you before, what are the settings of the QUILL_USE_SQL_LOG
variables in your condor_config file.  You have to set either
QUILL_USE_SQL_LOG = TRUE (which will log *everything*)
or STARTD.QUILL_USE_SQL_LOG = TRUE  which should get the machines tables.
That has to be true in the condor config of every startd in your pool.

I am not sure if you have to have a condor_quill running on every machine
in the pool too, but the manual would say.  If so then you need
a .pgpass file in the SPOOL directory.

Steve Timm
]
On Wed, 29 Jul 2009, Mag Gam wrote:

> Any thoughts?  Still no population in the machines
>
>
> On Wed, Jul 29, 2009 at 6:36 AM, Mag Gam<magawake@xxxxxxxxx> wrote:
> > Also, is this normal
> >
> > -rw-r--r-- 1 condor condor       0 Jul 29 06:33 sql.log
> > sql.log is zero
> >
> > In my QuillLog
> > 7/29 06:34:38 FileLock object is updating timestamp on:
> > /opt/condor/engrmaster/log/sql.log
> > 7/29 06:34:38 FileLock::obtain(1) - @1248863678.168050 lock on
> > /opt/condor/engrmaster/log/sql.log now WRITE
> > 7/29 06:34:38 FileLock::obtain(2) - @1248863678.168109 lock on
> > /opt/condor/engrmaster/log/sql.log now UNLOCKED
> > 7/29 06:34:38 FileLock object is updating timestamp on:
> > /opt/condor/engrmaster/log/sql.log.copy
> > 7/29 06:34:38 FileLock::obtain(1) - @1248863678.168195 lock on
> > /opt/condor/engrmaster/log/sql.log.copy now WRITE
> > 7/29 06:34:38 FileLock::obtain(2) - @1248863678.168237 lock on
> > /opt/condor/engrmaster/log/sql.log.copy now UNLOCKED
> >
> > I am guessing its normal....
> >
> >
> >
> >
> > On Wed, Jul 29, 2009 at 3:28 AM, Mag Gam<magawake@xxxxxxxxx> wrote:
> > > These are the ones that are not populated:
> > >
> > > machines_horizontal
> > > machines_vertical
> > > machines_horizontal_history
> > > machines_vertical_history
> > > matches
> > > rejects
> > > runs
> > > submitters_horizontal
> > > submitters_horizontal_history
> > > transfers
> > >
> > >
> > > I won't mind keeping all the information in my database for a week.
> > > Any options I need to tweak for this?
> > >
> > > TIA
> > >
> > > On Tue, Jul 28, 2009 at 6:44 PM, Erik Paulson<epaulson@xxxxxxxxxxxx> wrote:
> > > > On Tue, Jul 28, 2009 at 8:28 PM, Steven Timm<timm@xxxxxxxx> wrote:
> > > > > On Tue, 28 Jul 2009, Mag Gam wrote:
> > > > >
> > > > > > I am using Quill on Condor 7.2.3 and noticed several tables not even
> > > > > > populated whereas the others are populated. Is there a reason for
> > > > > > this? Is this normal operation? or is there something I should be
> > > > > > looking into?
> > > > > >
> > > > > > TIA
> > > > >
> > > > > It depends on what daemons you are logging quill information for.
> > > > > What are the values of QUILL_USE_SQL_LOG, SCHEDD.QUILL_USE_SQL_LOG,
> > > > > etc?  The tables will only fill up if you have the corresponding
> > > > > quill logging for that daemon turned on.  I have
> > > > > QUILL_USE_SQL_LOG = FALSE, SCHEDD.QUILL_USE_SQL_LOG=TRUE
> > > > > which means only schedd info is logged.
> > > > >
> > > > > Steve Timm
> > > >
> > > > It would also be helpful to know what tables are being filled, and
> > > > what tables are empty.
> > > >
> > > > -Erik
> > > > _______________________________________________
> > > > 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/
> _______________________________________________
> 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/

--
------------------------------------------------------------------
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.