Person:+uploaded-packages timeouts

Bug #711104 reported by Micah Gersten
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Robert Collins

Bug Description

OOPS-1897G1684
https://launchpad.net/%7Ed.filoni/+uploaded-packages

Branch: launchpad-rev-12568
Revno: 12568
SQL time: 6605 ms
Non-sql time: 7475 ms
Total time: 14080 ms
Statement Count: 1275

late evaluation:
620x PackageBuild
620x BuildFarmJob
a total of 6 seconds waste

Tags: qa-ok timeout

Related branches

Changed in launchpad:
status: New → Triaged
importance: Undecided → Critical
summary: - Timeout on +uploaded-packages
+ Person:+uploaded-packages timeouts
description: updated
description: updated
Changed in launchpad:
assignee: nobody → Robert Collins (lifeless)
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
milestone: none → 11.04
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
Revision history for this message
Robert Collins (lifeless) wrote :

This worked - it doesn't time out on qastaging! Its possible that refactoring the query to need less tables would let us change to a pre-iter-hook instead and let the pagination be calculated faster. A job for another day though : working is working.

tags: added: qa-ok
removed: qa-needstesting
Revision history for this message
Robert Collins (lifeless) wrote :

4 seconds first hit on prod.

Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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