Bug heat calculation should be done using a stored procedure
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Graham Binns |
Bug Description
What happens:
If calculate-
What should happen:
The problem is that we try to calculate bug heat serially, even for outdated bugs (of which there are at least hundreds even on a quiet day). So, c-b-h.py tries to go through the several thousand jobs in its queue one by one and never gets finished. There are ways to mitigate this problem but it would be simpler to do the calculations all at once as part of garbo-hourly or -daily.
We should replace the jobs-based bug heat calculation code with a stored procedure. This could work for both re-calculations of outdated bug heat (by being called for all out of date bugs by garbo) and on-change recalculations.
Related branches
- Curtis Hovey (community): Approve (rc)
- Björn Tillenius (community): Approve (db)
- Stuart Bishop (community): Approve (db)
- Canonical Launchpad Engineering: Pending (code) requested
-
Diff: 387 lines (+211/-33)6 files modifieddatabase/schema/security.cfg (+1/-0)
database/schema/trusted.sql (+115/-0)
lib/lp/bugs/configure.zcml (+4/-2)
lib/lp/bugs/doc/bug-heat.txt (+66/-20)
lib/lp/bugs/interfaces/bug.py (+3/-0)
lib/lp/bugs/model/bug.py (+22/-11)
Changed in malone: | |
status: | Triaged → In Progress |
assignee: | nobody → Graham Binns (gmb) |
milestone: | none → 10.05 |
Changed in malone: | |
status: | In Progress → Fix Committed |
Changed in malone: | |
status: | Fix Committed → Fix Released |