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

[Bill Deegan]

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
>