launchpad-dev team mailing list archive

[Robert Collins <robert.collins@xxxxxxxxxxxxx>]

On Sat, Nov 13, 2010 at 1:43 AM, Henning Eggers
<henning.eggers@xxxxxxxxxxxxx> wrote:
> I am seeing timeouts on qastaging left and right. Not on every page but on
> most pages it seems.

So, the general thing to do here is to analyse the problems ;).

> Times out:
> https://qastaging.launchpad.net/ubuntu/natty/+source/deja-dup

Works (11926 fixed it)

> https://bugs.qastaging.launchpad.net/

Works but it had horrible cold cache performance, 3rd hit on the page it worked.
   At least 53 queries/external actions issued in 3.02 seconds


> https://qastaging.launchpad.net/pyroom

'5 recent bugs' or something like that query is slow:
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_closed, 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,
Product.answers_usage, Product.blueprints_usage, Product.owner,
Product.translations_usage, Product.active, Product.autoupdate,
Product.bug_reported_acknowledgement,
Product.bug_reporting_guidelines, Product.bug_supervisor,
Product.bugtracker, Product.date_next_suggest_packaging,
Product.datecreated, Product.description, Product.development_focus,
Product.displayname, Product.downloadurl, Product.driver,
Product.enable_bug_expiration, Product.freshmeatproject,
Product.homepage_content, Product.homepageurl, Product.icon,
Product.id, Product.lastdoap, Product.license_approved,
Product.license_info, Product.reviewed, Product.logo,
Product.max_bug_heat, Product.mugshot, Product.name,
Product.official_answers, Product.official_blueprints,
Product.official_malone, Product.official_rosetta,
Product.private_bugs, Product.programminglang, Product.project,
Product.registrant, Product.remote_product,
Product.reviewer_whiteboard, Product.screenshotsurl,
Product.security_contact, Product.sourceforgeproject, Product.summary,
Product.title, Product.translation_focus, Product.translationgroup,
Product.translationpermission, Product.wikiurl, SourcePackageName.id,
SourcePackageName.name, Bug.date_last_message, Bug.date_last_updated,
Bug.date_made_private, Bug.datecreated, Bug.description,
Bug.duplicateof, Bug.heat, Bug.heat_last_updated, Bug.id,
Bug.latest_patch_uploaded, Bug.message_count, Bug.name,
Bug.number_of_duplicates, Bug.owner, Bug.private,
Bug.security_related, Bug.title, Bug.users_affected_count,
Bug.users_unaffected_count, Bug.who_made_private FROM BugTask LEFT
JOIN Bug ON BugTask.bug = Bug.id LEFT JOIN Product ON BugTask.product
= Product.id LEFT JOIN SourcePackageName ON BugTask.sourcepackagename
= SourcePackageName.id WHERE (1=1) AND Bug.id = BugTask.bug AND
BugTask.product = 7160 AND Bug.duplicateof is NULL AND \n (Bug.private
= FALSE OR EXISTS (\n SELECT BugSubscription.bug\n FROM
BugSubscription, TeamParticipation\n WHERE TeamParticipation.person =
2 AND\n BugSubscription.person = TeamParticipation.team AND\n
BugSubscription.bug = Bug.id))\n ORDER BY BugTask.datecreated DESC
LIMIT 5 OFFSET 0'

I can't see a bug matching this already - but ../malone worked on the
same server.

-Rob