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

[Mag Gam <magawake@xxxxxxxxx>]

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