[webkit-dev] git.webkit.org problem

[William Siegrist]

On Feb 29, 2012, at 6:22 PM, Mark Rowe wrote:

> 
> On 2012-02-29, at 18:20, Dirk Pranke <dpranke at chromium.org> wrote:
> 
>> On Wed, Feb 29, 2012 at 6:10 PM, Mark Rowe <mrowe at apple.com> wrote:
>>> 
>>> On 2012-02-29, at 17:05, Lucas Forschler <lforschler at apple.com> wrote:
>>> 
>>> build.webkit.org should be back online now with 0.8.5.
>>> 
>>> Thanks for your patience!
>>> 
>>> 
>>> For anyone following along at home, upgrading to Buildbot v0.8.5 alone
>>> actually made build.webkit.org substantially slower. After profiling it for
>>> a while we noticed that it was spending an exceptionally long time
>>> performing queries against its SQLite database. Some analysis on the queries
>>> that were being run showed that the database lacked appropriate indices for
>>> the queries, causing full table scans across rather large tables. Ouch. A
>>> few "CREATE INDEX …" statements later and now build.webkit.org is responding
>>> much more quickly than it has been in quite some time.
>>> 
>>> If anyone notices any bad behavior that they suspect may be related to this
>>> upgrade, please let us know.
>>> 
>> 
>> svn.webkit.org (and trac) appears to be very unhappy at the moment;
>> seems like this is likely related?
> 
> It may be that svn.webkit.org is unhappy about the thundering herd of reconnecting build slaves after the downtime.  We'll look in to it. 
> 

I'm rebooting it again. I'm not sure if this is the same cause as the overnight problems or the slaves getting new checkouts. 

-Bill