timeout querying archives for recipes via API
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Steve Kowalik |
Bug Description
Trying to get a recipe using:
from launchpadlib.
lp = Launchpad.
neon = lp.people.
recipe = neon.recipes[0]
results in OOPS-5801e40d03d4e8c0de8fbd46c1971a2a after a while.
Slow query:
SELECT *
FROM (
(SELECT Archive.enabled,
FROM Archive,
WHERE Archive.purpose = $INT
AND TeamParticipati
AND TeamParticipati
ORDER BY Archive.id)
UNION
(SELECT Archive.enabled,
FROM Archive,
WHERE Archive.purpose = $INT
AND ArchivePermissi
AND TeamParticipati
AND TeamParticipati
ORDER BY Archive.id)) AS "_2cce"
ORDER BY displayname
Related branches
- William Grant: Approve (code)
-
Diff: 275 lines (+74/-44)5 files modifiedlib/lp/code/browser/sourcepackagerecipe.py (+2/-2)
lib/lp/code/model/sourcepackagerecipe.py (+5/-23)
lib/lp/code/model/tests/test_sourcepackagerecipe.py (+21/-1)
lib/lp/code/vocabularies/configure.zcml (+6/-2)
lib/lp/code/vocabularies/sourcepackagerecipe.py (+40/-16)
Changed in launchpad: | |
status: | New → Triaged |
importance: | Undecided → Critical |
tags: | added: oops |
tags: | added: recipe |
tags: |
added: timeout removed: oops |
description: | updated |
summary: |
- OOPS when trying to get a recipe using the python API + timeout querying archives for recipes via API |
tags: | added: api |
Fixed in stable r15908 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 15908>.