timeouts for branch listing for user with a *lot* of branches

Bug #397034 reported by James Westby on 2009-07-08
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Tim Penhey

Bug Description


is starting to timeout for me. This started occurring about 25,000 branches,
so it's unlikely to many users, but this overview is very useful for me.



Related branches

Tim Penhey (thumper) wrote :

Can I get you to check again, or to paste oops ids if you get them.

This works for me:

<!-- at least 345 queries issued in 3.61 seconds -->
<!-- Launchpad 2.2.6 (r8791) -->

Changed in launchpad-code:
status: New → Incomplete
Tim Penhey (thumper) wrote :

Actually I think this has to do with the inefficient way we generate lp: links for official package branches.

Changed in launchpad-code:
importance: Undecided → High
status: Incomplete → Triaged
James Westby (james-w) wrote :

e.g. OOPS-1286ED84



Ursula Junque (ursinha) on 2009-07-09
tags: added: timeout
Tim Penhey (thumper) wrote :

I'm looking at this now.

Changed in launchpad-code:
assignee: nobody → Tim Penhey (thumper)
milestone: none → 2.2.7
status: Triaged → In Progress
Tim Penhey (thumper) wrote :

This has been partially fixed, but not to my complete satisfaction yet. So deferring to 2.2.8 to finish the fix.

Changed in launchpad-code:
milestone: 2.2.7 → 2.2.8

It does not only affect projects, it also strikes at individual users pages, such as lp:~mwhudson at edge and staging enviroment.


Edge - OOPS-1307EA21

Staging - OOPS-1307S390

Tim Penhey (thumper) wrote :

Actually those ones are bug 396593 and should be ok when edge updates.

Tim Penhey (thumper) wrote :

Fixing this got trumped by the 3.0 UI work. Should be able to look at it for post 3.0.

The query count on these pages is still very high, but it doesn't seem to be timing out every time right now.

Changed in launchpad-code:
milestone: 2.2.8 → 3.1.10
Tim Penhey (thumper) on 2009-10-27
Changed in launchpad-code:
status: In Progress → Fix Committed
Changed in launchpad-code:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers