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

[Mag Gam <magawake@xxxxxxxxx>]

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