[Buildbot-commits] [SPAM] Re: [Buildbot] #829: Buildbot 0.8.0rc2 master uses huge CPU while builds are running

[Buildbot]

#829: Buildbot 0.8.0rc2 master uses huge CPU while builds are running
---------------------+------------------------------------------------------
Reporter:  bdbaddog  |       Owner:       
    Type:  defect    |      Status:  new  
Priority:  critical  |   Milestone:  0.8.1
 Version:  0.8.0     |    Keywords:       
---------------------+------------------------------------------------------

Comment(by bdbaddog):

 If I strace the process while it's pegging the cpu. It's reading from the
 sqlite db file. Pretty much the whole time.

 I ran an strace on buildbot. It bailed out when the file hit 2GB (it's a
 32bit system).
 1/2 of the lines in the strace log were reading from the sqlite datafile.

 The buildbot master memory footprint was only 89MB, so it isn't swapping.

 I believe it should be possible to log all the queries to get a handle on
 what's happening based on : [http://stackoverflow.com/questions/1607368
 /sql-query-logging-for-sqlite]

 If I get a chance over the weekend I'll try to enable that.
 Can you point me to the code where the sqlite connection is opened?

-- 
Ticket URL: <http://buildbot.net/trac/ticket/829#comment:29>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation