[16:14] <GunnarHj> The "Timeout error" problem when searching among translations is worse than ever. Bug #736005. Please take a look.
[16:14] <ubot5> bug 736005 in Ubuntu Translations "POFile:+translate timeouts" [Critical,Triaged] https://launchpad.net/bugs/736005
[16:20] <cjwatson> Yeah, I wonder why that suddenly got worse
[16:21] <cjwatson> Maybe I regressed it by accident as part of some tech-debt fixes, hmm
[16:25] <GunnarHj> cjwatson: Good if you figure it out. Needless to say I have no clue.
[16:28] <cjwatson> Poking at the offending query with EXPLAIN at the moment
[16:32] <cjwatson> Good lord I'm not sure I've ever seen cost estimates that large before
[16:32] <cjwatson> Limit  (cost=142338680428.46..142338938780.76 rows=11 width=99)
[16:32] <cjwatson> (I got bored of waiting for EXPLAIN (ANALYZE, BUFFERS), so those are probably not very accurate)
[16:37] <cjwatson> Found a relevant difference in old vs. new queries, possibly
[16:42] <cjwatson> Huh.  Storm miscompiling a query?
[16:45] <cjwatson> More intriguing than I'd expected
=== dilfridge is now known as icicle
[17:21] <cjwatson> https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/395934
[17:21] <cjwatson> GunnarHj: ^
[17:21] <cjwatson> (I don't expect you to review that, just FYI)
[17:23] <GunnarHj> cjwatson: Thanks, at least it sounds promising. :)
[17:40] <GunnarHj> cjwatson: Saw that you merged it, but no difference so far. Is there more into it before it gets effective?
[17:44] <tomwardill> GunnarHj: it'll need a deployment of launchpad
[17:47] <cjwatson> ^ that
[17:47] <cjwatson> Likely tomorrow
[17:57] <GunnarHj> cjwatson: I see. Thanks for the quick action!
=== ijohnson is now known as ijohnson|lunch
=== ijohnson|lunch is now known as ijohnson
=== icicle is now known as dilfridge