=== Ursinha is now known as Guest9857
=== almaisan-away is now known as al-maisan
=== al-maisan is now known as almaisan-away
lifeless17921  OOPS-10c6e2453422218f59fb3e8e621ea198  Person:+contactuser20:55
lifelesswgrant: https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-bcba588b8f33bfa5da7c88e680763bf821:30
wgrantlifeless: Interesting, obviously a cold cache somehow.23:17
wgrantlifeless: I suspect that GIN will be nice -- it's usually the FTI index that ends up cold.23:17
wgrantSince the entire set of Ubuntu bugs is kept very hot by the regular full index scans.23:17
wgrantlifeless: The only major repeatable timeouts are Person:+commentedbugs and Person:+bugs and their API equivalents for particularly prolific people (better than they used to be, but still bad), and things that use last_patch_uploaded, which I'm about to add to bugtaskflat.23:21
lifelessyesterday had 1.6K timeouts still23:21
wgrantYeah, mostly not bug-related, though.23:21
wgrantOnly a few hundred.23:21
wgrantMost of them being +commentedbugs23:21
lifelessis the root bugs api one fixed ?23:22
wgrantOverrode it to [], timeouts went away and nobody has complained.23:22
wgrantHopefully DF will be back today so I can fix Distribution:+search's query23:24
wgrantlifeless: All the +patches timeouts and most of Distribution:EntryResource:searchTasks will go away when I denorm latest_patch_uploaded.23:25
wgrantStevenK: You didn't revert that bad rev..?23:30
StevenKwgrant: I figured that since jml's QA was going to block it I could fix it better23:48
wgrantStevenK: jml's thing will be deployable in 10 hours, so you'd best be swift.23:50
StevenKwgrant: How best to fix it? self.findBranches().limit() ?23:51
wgrantThat won't work.23:51
StevenKI didn't think so.23:51
wgrantThe Stormiest way to do it is to use a subselect.23:51
wgrantWell, that's the SQLiest way to do it too23:51
wgrantUPDATE doesn't support LIMIT23:51
StevenKAh, so it has to be WHERE id IS IN ...23:52

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!