Some CVE pages time out constantly

[Tom Reynolds]

https://launchpad.net/bugs/cve/CVE-2017-5753 times out constantly for me whether logged in or not.

Error ID: OOPS-8ed18c9dfd84817e8c4c7d4b212229bb

While it constantly fails for me, the 'ubot5' IRC bot did successfully return the page title on a single request.

[Launchpad QA Bot (lpqabot)]

Fixed in stable r18823 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/18823>.

[Colin Watson (cjwatson)]

It's a bit hard to tell whether that patch has made much difference since staging is sufficiently much slower than production to obscure any gains, but it at least doesn't seem to have made matters any worse. We'll see once it's on production.

[Colin Watson (cjwatson)]

Well, it's faster, but not fast enough: it's still timing out. A current OOPS is OOPS-88ba1d4284215d4813e0f7e59c73983e. In that, it takes rather more than five seconds between the query in the bugtask_set.getBugTaskPeople call in BugLinksListingView.buglinks and the next database query, which is an authentication check on a person. It's hard to tell how much of that is the cost of materialising the list of Person rows and how much is other stuff in between. (Also the authentication check may be a problem in itself, though I can't be sure about that.)

I think we probably need to make sure that the whole list is batched, rather than just batching the individual lists of tasks for each bug.