BugTask:+index timeout - death by sql in PersonSubscriptions(user, bug)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Gary Poster |
Bug Description
https:/
OOPS-2022AU38
OOPS-2022G63
OOPS-2022A66
OOPS-2023AV26
OOPS-2023H30
OOPS-2023D24
I haven't been able to load the bug in a browser at all, accessing the bug via launchpadlib-API is no problem.
Module canonical.
self.
Module lp.bugs.
psi = PersonSubscript
Module lp.bugs.
self.
Module lp.bugs.
self.
Module lp.bugs.
subscriber, subscribed_bug, subscription)
Module lp.bugs.
if principal in self.administra
Module storm.sqlobject, line 552, in __contains__
return item in result_set
is triggering late lookups many times over.
Related branches
- j.c.sackett (community): Approve
-
Diff: 181 lines (+65/-18)2 files modifiedlib/lp/bugs/model/personsubscriptioninfo.py (+15/-14)
lib/lp/bugs/model/tests/test_personsubscriptioninfo.py (+50/-4)
summary: |
- Constant Timeouts on bug 728840 + BugTask:+index timeout - death by sql in PersonSubscriptions(user, bug) |
description: | updated |
tags: | added: timeout |
Changed in launchpad: | |
status: | New → Triaged |
importance: | Undecided → Critical |
Changed in launchpad: | |
assignee: | nobody → Данило Шеган (danilo) |
status: | Triaged → In Progress |
Changed in launchpad: | |
assignee: | Данило Шеган (danilo) → nobody |
status: | In Progress → Triaged |
Changed in launchpad: | |
status: | Triaged → In Progress |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Interestingly, and as a partial workaround, this works consistently when not logged in.