Bug page timing out; suspect slow query on ValidPersonCache

Bug #290668 reported by Gavin Panella on 2008-10-29
24
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Launchpad itself
High
Gavin Panella

Bug Description

OOPS-1033EB417

As part of the page performance work last week, ValidPersonCache was prejoined when getting the subscriber list. For bugs with a large number of subscribers this reduced the number of queries by a vast amount (for the bug in question, from over 1000 to ~70 queries). But the prejoin seems to be slow now.

Graham Binns (gmb) on 2008-10-29
description: updated
Changed in malone:
importance: Undecided → High
status: New → Triaged
Gavin Panella (allenap) wrote :

Bug #221075 addressed a similar problem. Revision 6170 is short and sweet and may offer us an alternate solution to a prejoin.

Loïc Minier (lool) wrote :

Couldn't submit bugs due to a timeout, and was told on #launchpad that it's the same bug as this one; I got oopses OOPS-1033ED526 and OOPS-1033EB501.

Gavin Panella (allenap) on 2008-10-29
Changed in malone:
assignee: nobody → allenap
status: Triaged → In Progress
Matt Zimmerman (mdz) wrote :

This problem is having an adverse impact on the Ubuntu 8.10 release process currently underway

Matt Zimmerman (mdz) wrote :

I've been told by Herb on IRC that this only affects edge, so disabling redirection via the "disable redirection for 2 hours" button on http://launchpad.net should help for anyone affected by this

Edge: (Error ID: OOPS-1033EA754)

Gavin Panella (allenap) wrote :

A fix has been prepared and is being applied now.

Gavin Panella (allenap) wrote :

Fix applied to edge. Let me know if you're still having problems.

fixed for me

Changed in malone:
status: In Progress → Fix Released
Graham Binns (gmb) wrote :

This isn't fix released since it's been rolled out to edge as an emergency fix. It can be marked as fix committed when it's landed on Launchpad mainline.

Changed in malone:
status: Fix Released → In Progress
Gavin Panella (allenap) wrote :

In edge and committed to trunk.

Changed in malone:
status: In Progress → Fix Released
Gavin Panella (allenap) wrote :

In RF 7225

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers