Bug page timing out; suspect slow query on ValidPersonCache

Bug #290668 reported by Gavin Panella
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)
description: updated
Changed in malone:
importance: Undecided → High
status: New → Triaged
Revision history for this message
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.

Revision history for this message
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)
Changed in malone:
assignee: nobody → allenap
status: Triaged → In Progress
Revision history for this message
Matt Zimmerman (mdz) wrote :

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

Revision history for this message
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

Revision history for this message
Fernando Miguel (fernandomiguel) wrote :

Edge: (Error ID: OOPS-1033EA754)

Revision history for this message
Gavin Panella (allenap) wrote :

A fix has been prepared and is being applied now.

Revision history for this message
Gavin Panella (allenap) wrote :

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

Revision history for this message
Fernando Miguel (fernandomiguel) wrote :

fixed for me

Changed in malone:
status: In Progress → Fix Released
Revision history for this message
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
Revision history for this message
Gavin Panella (allenap) wrote :

In edge and committed to trunk.

Changed in malone:
status: In Progress → Fix Released
Revision history for this message
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