Launchpad itself

https://bugs.launchpad.net/ubuntu times out consistently

Bug #590992 reported by Gary Poster
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Deryck Hodge
Launchpad itself 10.07

Related branches

lp:~deryck/launchpad/ubuntu-bugs-front-timeout-590992
Björn Tillenius (community): Approve (code/rc)
Diff: 15 lines (+0/-5)
1 file modified
lib/lp/bugs/browser/bugtarget.py (+0/-5)
lp:~deryck/launchpad/ubuntu-bugs-front-caching-590992
Michael Nelson (community): Approve (code)
Diff: 60 lines (+21/-4)
2 files modified
lib/lp/bugs/stories/bugs/xx-product-bugs-page.txt (+18/-3)
lib/lp/bugs/templates/bugtarget-bugs.pt (+3/-1)
Revision history for this message
Deryck Hodge (deryck) wrote :

Something smells rotten. I'm poking now, and will follow up tonight if I don't have enough time to finish investigating.

Changed in malone:
status: New → Triaged
importance: Undecided → Critical
tags: added: timeout
Revision history for this message
Deryck Hodge (deryck) wrote :

Query plans are slightly different on lpnet vs staging, which is causing the timeout. See: https://pastebin.canonical.com/33112/

Presumably, something in the difference in data is causing postgresql to choose differently and causing the slowdown. I don't think there's anything new in this code path to suddenly have caused this. I'll have to dig more later, but wanted to update the bug in case others poke tonight or tomorrow AM before I do.

Deryck Hodge (deryck)
Changed in malone:
assignee: nobody → Deryck Hodge (deryck)
status: Triaged → In Progress
milestone: none → 10.06
Revision history for this message
Deryck Hodge (deryck) wrote :

Fix is approved and I'm getting it applied to lpnet and edge while the branch plays through tests and landings.

Revision history for this message
Deryck Hodge (deryck) wrote :

The one fixed revealed another issue with the hot bugs list timing out. I'm preparing another branch to cache this list.

Revision history for this message
Deryck Hodge (deryck) wrote :

I believe the latter issue was related to DB load. The script causing load issues has been killed and the load is returning to normal. The Ubuntu bugs home page is available for me now.

I am continuing to get the earlier cowboyed fix into a production-devel branch for CP.

Revision history for this message
Deryck Hodge (deryck) wrote :

This has already been qa'ed by cowboying to staging, so marking it qa-ok. Still working on a branch for caching and then I'll prepare a single production-devel branch of the two changes.

Changed in malone:
status: In Progress → Fix Committed
tags: added: qa-ok
Revision history for this message
Deryck Hodge (deryck) wrote :

I'm dialing back the importance of this, since the fixes to our DB load have taken away the need to CP this to production. The fixes in the linked branches can land with the normal rollout.

Changed in malone:
importance: Critical → High
Revision history for this message
Ursula Junque (ursinha) wrote : Bug fixed by a commit

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

tags: added: qa-needstesting
removed: qa-ok
Revision history for this message
Ursula Junque (ursinha) wrote :

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

Deryck Hodge (deryck)
tags: added: qa-ok
removed: qa-needstesting
Curtis Hovey (sinzui)
Changed in malone:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.