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

[exarkun at twistedmatrix.com]

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