time out linking blueprint dependencies

Bug #244957 reported by Diogo Matsubara
22
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Edwin Grubbs

Bug Description

As seen in OOPS-914EC72 the +linkdependency page is issuing >3000 queries effectively timing out.

Recent: OOPS-1007EC106

Steps to reproduce:
1. Open https://blueprints.staging.launchpad.net/ubuntu/+spec/packagekit-intrepid/+linkdependency
2. Fill in "Dependes On": package-kit
3. Click Continue
4. Timeout oops

description: updated
Revision history for this message
Curtis Hovey (sinzui) wrote :

Switching the code to use storm may help.

Changed in blueprint:
assignee: nobody → bac
importance: Undecided → High
milestone: none → 2.1.10
status: New → Triaged
Changed in blueprint:
assignee: bac → bradcrittenden
description: updated
Revision history for this message
Brad Crittenden (bac) wrote :

1) The UI does not show a way for me to navigate to the +linkdependency page, so I suspect I shouldn't be able to but I can go to the URL directly. This is probably a permissions problem.

2) The database queries appear to be very straightforward. I wonder if there is a cycle in the database causing the timeout?

Will continue to investigate.

Changed in blueprint:
assignee: bradcrittenden → edwin-grubbs
Curtis Hovey (sinzui)
Changed in blueprint:
milestone: 2.1.10 → 2.1.11
Revision history for this message
Curtis Hovey (sinzui) wrote :

Stuart proposed an alternate SQL query that may be easier to implement.

Changed in blueprint:
status: Triaged → In Progress
Revision history for this message
Edwin Grubbs (edwin-grubbs) wrote :

Revision 7243.

Changed in blueprint:
status: In Progress → Fix Committed
Revision history for this message
Andrew Hunter (rexbron) wrote :

Has this hit edge yet, as I seem to no longer experience the issue?

Changed in blueprint:
status: Fix Committed → Fix Released
Curtis Hovey (sinzui)
visibility: private → public
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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