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

[Chris AtLee]

How many builders do you have?

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
>