ProductSet:CollectionResource:#projects timeouts

Bug #727020 reported by Robert Collins
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Robert Collins

Bug Description

OOPS-1885O2159
https://api.launchpad.net/1.0/projects

SQL time: 11496 ms
Non-sql time: 2620 ms
Total time: 14116 ms
Statement Count: 271

Death by late evaluation:
1 58 3186 54 3132 SQL-launchpad-main-master
SELECT ProductSeries.branch,
       ProductSeries.datecreated,
       ProductSeries.driver,
       ProductSeries.id,
       ProductSeries.name,
       ProductSeries.OWNER, ProductSeries.product,
                            ProductSeries.releasefileglob,
                            ProductSeries.releaseverstyle,
                            ProductSeries.status,
                            ProductSeries.summary,
                            ProductSeries.translations_autoimport_mode,
                            ProductSeries.translations_branch
FROM ProductSeries
WHERE ProductSeries.id = $INTLIMIT $INT
2 58 2680 46 2634 SQL-launchpad-main-master
SELECT CommercialSubscription.date_created,
       CommercialSubscription.date_expires,
       CommercialSubscription.date_last_modified,
       CommercialSubscription.date_starts,
       CommercialSubscription.id,
       CommercialSubscription.product,
       CommercialSubscription.purchaser,
       CommercialSubscription.registrant,
       CommercialSubscription.sales_system_id,
       CommercialSubscription.whiteboard
FROM CommercialSubscription
WHERE CommercialSubscription.product = $INT
3 58 1468 25 1443 SQL-launchpad-main-master
SELECT ProductLicense.id,
       ProductLicense.license,
       ProductLicense.product
FROM ProductLicense
WHERE ProductLicense.product = $INT
ORDER BY ProductLicense.license
4 57 826 14 812 SQL-launchpad-main-master
SELECT OfficialBugTag.tag
FROM OfficialBugTag
WHERE OfficialBugTag.product = $INT
ORDER BY OfficialBugTag.tag

Tags: qa-ok timeout

Related branches

description: updated
summary: - ProductSet:CollectionResource:#projects timeout on 28th Jan
+ ProductSet:CollectionResource:#projects timeouts
Revision history for this message
Robert Collins (lifeless) wrote :

The cause is, again, _link generation for API object representations.

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

an entry:
{"project_group_link": null,
 "license_reviewed": "tag:launchpad.net:2008:redacted",
 "license_info": "This project is itself a licence. The work is based on SIL OFL which allows others to use its text in part for free licences, which are distinct from OFL.",
 "remote_product": null,
 "recipes_collection_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/recipes",
 "development_focus_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/trunk",
 "bug_supervisor_link": "https://api.launchpad.net/1.0/~sladen",
 "registrant_link": "https://api.launchpad.net/1.0/~sabdfl",
 "official_bug_tags": [],
 "active_milestones_collection_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/active_milestones", "commercial_subscription_is_due": false,
 "translation_focus_link": null,
 "licenses": ["Other/Open Source"],
 "all_milestones_collection_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/all_milestones",
 "bug_reported_acknowledgement": null,
 "display_name": "Ubuntu Font Licence",
 "wiki_url": null, "title": "The Ubuntu Font Licence",
 "homepage_url": "http://font.ubuntu.com/ufl/",
 "download_url": null,
 "is_permitted": "tag:launchpad.net:2008:redacted",
 "reviewer_whiteboard": "tag:launchpad.net:2008:redacted",
 "self_link": "https://api.launchpad.net/1.0/ubuntu-font-licence",
 "resource_type_link": "https://api.launchpad.net/1.0/#project",
 "programming_language": null,
 "description": "Canonical are working with SFLC and SIL on a revision of the OFL with the intent of adopting that revision for a future version of the Ubuntu Font Family. This Ubuntu Font Licence serves as an interim licence until that is complete.", "security_contact_link": null,
  "brand_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/brand",
 "sourceforge_project": null,
 "http_etag": "\"47369687b7848bba26f18c39670937bfdb50d70a-818d6575af6b0850cd411180682849f493348ab0\"",
 "date_next_suggest_packaging": "2011-09-28T02:34:20.059204+00:00",
 "bug_reporting_guidelines": "Be nice to each other, and note that this is our first shot at an interim licence!",
 "active": true,
 "bug_tracker_link": null,
 "name": "ubuntu-font-licence",
 "license_approved": "tag:launchpad.net:2008:redacted",
 "driver_link": null,
 "freshmeat_project": null,
 "screenshots_url": null,
 "web_link": "https://launchpad.net/ubuntu-font-licence",
 "summary": "An interim, free licence for the Ubuntu Font Family.",
 "logo_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/logo",
 "owner_link": "https://api.launchpad.net/1.0/~sabdfl",
 "qualifies_for_free_hosting": true,
 "releases_collection_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/releases",
 "date_created": "2010-09-27T20:20:58.268600+00:00",
 "series_collection_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/series",
 "commercial_subscription_link": null,
 "icon_link": "https://api.launchpad.net/1.0/ubuntu-font-licence/icon"
}

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

Hitting api.launchpad.dev/1.0/projects shows this pretty clearly.

Changed in launchpad:
assignee: nobody → Robert Collins (lifeless)
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
milestone: none → 11.04
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
William Grant (wgrant)
tags: added: qa-ok
removed: qa-needstesting
Changed in launchpad:
status: Fix Committed → Fix Released
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.