As seen on OOPS-939A1430, OOPS-939F1337, OOPS-939F1340, OOPS-939F1347, OOPS-939F1354, OOPS-939F1385, OOPS-939F1406, OOPS-939F1411, OOPS-939F1412, OOPS-939F1414, bugs/+index is timing out with less than 5 seconds total time.
Needs to be verified since there were 38 occurrences of this timeout in only one day.
The query is ran to fill in the recently fixed bugs section of the bugs index page.
Exception type: TimeoutError
Exception value: 'SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, "_prejoin1".active, "_prejoin1".autoupdate, "_prejoin1".bug_reporting_guidelines, "_prejoin1".bug_supervisor, "_prejoin1".bugtracker, "_prejoin1".datecreated, "_prejoin1".description, "_prejoin1".development_focus, "_prejoin1".displayname, "_prejoin1".downloadurl, "_prejoin1".driver, "_prejoin1".enable_bug_expiration, "_prejoin1".freshmeatproject, "_prejoin1".homepage_content, "_prejoin1".homepageurl, "_prejoin1".icon, "_prejoin1".id, "_prejoin1".lastdoap, "_prejoin1".license_approved, "_prejoin1".license_info, "_prejoin1".reviewed, "_prejoin1".logo, "_prejoin1".mugshot, "_prejoin1".name, "_prejoin1".official_answers, "_prejoin1".official_blueprints, "_prejoin1".official_codehosting, "_prejoin1".official_malone, "_prejoin1".official_rosetta, "_prejoin1".owner, "_prejoin1".private_bugs, "_prejoin1".programminglang, "_prejoin1".project, "_prejoin1".reviewer_whiteboard, "_prejoin1".screenshotsurl, "_prejoin1".security_contact, "_prejoin1".sourceforgeproject, "_prejoin1".summary, "_prejoin1".title, "_prejoin1".translationgroup, "_prejoin1".translationpermission, "_prejoin1".wikiurl, "_prejoin2".id, "_prejoin2".name, Bug.date_last_message, Bug.date_last_updated, Bug.date_made_private, Bug.datecreated, Bug.description, Bug.duplicateof, Bug.id, Bug.message_count, Bug.name, Bug.number_of_duplicates, Bug.owner, Bug.private, Bug.security_related, Bug.title, Bug.who_made_private FROM Bug, BugTask LEFT JOIN Product AS "_prejoin1" ON BugTask.product = "_prejoin1".id LEFT JOIN SourcePackageName AS "_prejoin2" ON BugTask.sourcepackagename = "_prejoin2".id WHERE Bug.id = BugTask.bug AND (BugTask.status = 30) AND Bug.private = FALSE AND (1=1) ORDER BY BugTask.date_closed DESC, BugTask.id LIMIT 20 OFFSET 0', ()
Last occurrences: OOPS-943A2193, OOPS-943A2195, OOPS-943A2225, OOPS-943A2253, OOPS-943F2030, OOPS-943G852, OOPS-943G861, OOPS-943G879
Said in 31th july weekly meeting: BjortT is going to have to check with the losas to get more information.