[Buildbot-devel] 0.8.0rc2 goes of to lala land for /waterfall

[Bill Deegan]

On Thu, May 6, 2010 at 4:41 PM, Chris AtLee <chris at atlee.ca> wrote:
> How many builders do you have?

10 builders on 2 build slaves (8 win32 and 2 linux if that matters,
master is linux)
sqllite db on local disk.

-Bill

>
> On Thu, May 6, 2010 at 7:40 PM, Bill Deegan <bill at baddogconsulting.com> wrote:
>> Donno about the logging.
>>
>> My guess is the DB needs some indexes, it kinda looks like it's doing
>> a table scan for a lot of things because waterfall is REALLY REALLY
>> slow.
>> -Bill
>>
>> On Wed, May 5, 2010 at 7:02 PM,  <exarkun at twistedmatrix.com> wrote:
>>> On 12:07 am, bill at baddogconsulting.com wrote:
>>>>
>>>> Jean-Paul,
>>>>
>>>> On Wed, May 5, 2010 at 3:08 PM,  <exarkun at twistedmatrix.com> wrote:
>>>>>
>>>>> On 09:45 pm, bill at baddogconsulting.com wrote:
>>>>>>
>>>>>> After a day of running it's pegging the CPU and not responding to
>>>>>> /waterfal.
>>>>>>
>>>>>> Strace indicates it's doing a lot of reads. I'm not sure what file.
>>>>>>
>>>>>> How can I get more info on what it's doing to be able to file a bug?
>>>>>
>>>>> On Linux?  /proc/pid/fd/ will tell you what file it's reading.
>>>>
>>>> Looks like that's the state.sqlite file.
>>>>
>>>> It's on a local filesystem to the buildbot master.
>>>> Nothing else should be hammering that filesystem.
>>>>
>>>> What info can I grab to see what's causing this.
>>>> I just checked and it's not pegging the CPU right now.
>>>> But earlier it was for many minutes.
>>>
>>> Does the new database code have a toggle to enable query logging? That's
>>> often a good place to start investigating weird database issues.
>>>
>>> Jean-Paul
>>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Buildbot-devel mailing list
>> Buildbot-devel at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/buildbot-devel
>>
>