[users at bb.net] buildbot CPU usage
tardyp at gmail.com
Wed Feb 1 15:56:18 UTC 2017
Le lun. 30 janv. 2017 à 17:49, Francesco Di Mizio <
francescodimizio at gmail.com> a écrit :
> Digging this up again. Havent moved to a physical server yet. I will first
> be splitting the bbot server and postgres on different hosts.
> What I've noticed the CPU spiking is always (and I rea) due to queries
> SELECT logchunks.first_line, logchunks.last_line, logchunks.content,
> logchunks.compressed FROM logchunks WHERE logchunks.logid = 56343 ORDER BY
> If I am correct that call can only come from CompressLog
> <https://github.com/buildbot/buildbot/blob/cfe60e31206748bcf01232eb13c0d6177cd04d5d/master/buildbot/db/logs.py#L252> .
> They do take a very long time (even 1 minute). While running all the system
> is stuck. I wonder if I should use some custom postgres config, I am simply
> running the official postgres 9.5 container.
If your logs are not anormally large, like you said already this should not
take one minute.
That said, I have released in 0.9.3 an optimization that removes that
particular request so that the compression happens on a stream of smaller
You might consider an upgrade in order to see if the situation improves.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the users