On Sat, Jan 18, 2020 at 08:53:59PM -0800, Kevin Fenzi wrote: > On Sat, Jan 18, 2020 at 11:32:30PM +0100, Fabio Valentini wrote: > ...snip... > > > > Sounds interesting! > > Koji might suffer from the database dump cron job ... though I'm not > > sure at which time of day it's supposed to run. > > The backup runs at 00:00UTC + $RANDOM % 7200 seconds. > > We have tried all kinds of things to lower the impact of it. :( > There's a set of commits in the upcoming 1.20 koji version that I really > hope will help out. I'd also really like to move the database host to > rhel8 (and a newer postgres) which should just help by itself, but also > would allow us to partition the buildroot_listing table (which is most > of the problem, it being inserted into all the time and being 215GB).o After a number of issues today with the koji db load going thru the roof and becoming unresponsive, I upgraded koji to the just released 1.20.0 koji release. It seems to have helped a ton. No real load issues since then, and things were still pretty responsive (all be it a bit slower) while the backups ran. Backups also finished in about 1/2 the time as before. Additionally, there were some disk space issues on some builders which I have also cleaned up. I'm hopefull that we are back to having a stable koji. Thanks everyone for your patience as we work through these issues. kevin
Attachment:
signature.asc
Description: PGP signature
_______________________________________________ devel mailing list -- devel@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to devel-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/devel@xxxxxxxxxxxxxxxxxxxxxxx
