MaloneApplication:CollectionResource is slow/times out

Bug #627974 reported by Robert Collins
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
Critical
Unassigned

Bug Description

This was reporting as an 11second API for a user, I dont' have a prod OOPS for it yet, but a staging one is fairly clear:

https://lp-oops.canonical.com/oops.py/?oopsid=1704S20

https://api.staging.launchpad.net/1.0/bugs?assignee=clint-fewbar

ser: Anonymous User
DB id: Anonymous
Branch: launchpad
Revno: 9710
SQL time: 10320 ms
Non-sql time: 65 ms
Total time: 10385 ms
Statement Count: 7

1 9997.0 1 launchpad-main-master SELECT COUNT(*) FROM Bug WHERE Bug.private = FALSE

This is essentially a table scan. I haven't looked locally to see the cause, but its probably pretty simple.

Revision history for this message
Robert Collins (lifeless) wrote :

Bah wrong bug, sorry for the noise.

Changed in malone:
status: Triaged → Fix Released
assignee: nobody → Robert Collins (lifeless)
milestone: none → 10.12
milestone: 10.12 → 10.10
status: Fix Released → Triaged
assignee: Robert Collins (lifeless) → nobody
milestone: 10.10 → none
tags: added: pg83
Changed in launchpad:
importance: High → Critical
Revision history for this message
Robert Collins (lifeless) wrote :

So looking at this, I think that the url was hacked and actually is just listing all bugs by heat. Closing this bug as a result

Changed in launchpad:
status: Triaged → Invalid
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.