[users at bb.net] buildbot CPU usage

Pierre Tardy 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
> like:
> SELECT logchunks.first_line, logchunks.last_line, logchunks.content,
> logchunks.compressed FROM logchunks WHERE logchunks.logid = 56343 ORDER BY
> logchunks.first_line
> 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.
Hi Francesco,
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...
URL: <http://lists.buildbot.net/pipermail/users/attachments/20170201/8d457d71/attachment.html>

More information about the users mailing list