=== Ursinha is now known as Guest9857 === almaisan-away is now known as al-maisan === al-maisan is now known as almaisan-away [20:55] wheee [20:55] 17921 OOPS-10c6e2453422218f59fb3e8e621ea198 Person:+contactuser [21:30] wgrant: https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-bcba588b8f33bfa5da7c88e680763bf8 [23:17] lifeless: Interesting, obviously a cold cache somehow. [23:17] lifeless: I suspect that GIN will be nice -- it's usually the FTI index that ends up cold. [23:17] Since the entire set of Ubuntu bugs is kept very hot by the regular full index scans. [23:21] lifeless: 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] cool [23:21] yesterday had 1.6K timeouts still [23:21] Yeah, mostly not bug-related, though. [23:21] Only a few hundred. [23:21] Most of them being +commentedbugs [23:22] kk [23:22] is the root bugs api one fixed ? [23:22] Ja [23:22] Overrode it to [], timeouts went away and nobody has complained. [23:24] hah [23:24] Hopefully DF will be back today so I can fix Distribution:+search's query [23:25] lifeless: All the +patches timeouts and most of Distribution:EntryResource:searchTasks will go away when I denorm latest_patch_uploaded. [23:30] StevenK: You didn't revert that bad rev..? [23:48] wgrant: I figured that since jml's QA was going to block it I could fix it better [23:50] StevenK: jml's thing will be deployable in 10 hours, so you'd best be swift. [23:51] wgrant: How best to fix it? self.findBranches().limit() ? [23:51] That won't work. [23:51] I didn't think so. [23:51] The Stormiest way to do it is to use a subselect. [23:51] Well, that's the SQLiest way to do it too [23:51] UPDATE doesn't support LIMIT [23:52] Ah, so it has to be WHERE id IS IN ...