Person:+specworkload timeouts

Bug #735970 reported by Robert Collins on 2011-03-16
24
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
Unassigned

Bug Description

  4 SELECT $INT FROM (SELECT Specification.approver, Specification.assignee, Specification.completer, ... tion_status = $INT AND Specification.definition_status = $INT) ) LIMIT $INT) AS "_tmp" LIMIT $INT:
   GET: 4 Robots: 4 Local: 0
      2 https://blueprints.launchpad.net/%7Elocoteams/+specworkload (Person:+specworkload)
       OOPS-1900H932, OOPS-1900K59
      1 https://blueprints.launchpad.net/%7Elaunchpad-beta-testers/+specworkload (Person:+specworkload)
       OOPS-1900J432
      1 https://blueprints.launchpad.net/%7Eloco-philippine-team/+specworkload (Person:+specworkload)
       OOPS-1900B479

death by sql
1 94 9389 99 9290 SQL-launchpad-main-slave
SELECT $INT
FROM
  (SELECT Specification.approver, Specification.assignee, Specification.completer, Specification.date_completed, Specification.date_goal_decided, Specification.date_goal_proposed, Specification.date_started, Specification.datecreated, Specification.definition_status, Specification.direction_approved, Specification.distribution, Specification.distroseries, Specification.drafter, Specification.goal_decider, Specification.goal_proposer, Specification.goalstatus, Specification.id, Specification.implementation_status, Specification.man_days, Specification.milestone, Specification.name, Specification.OWNER, Specification.priority, Specification.private, Specification.product, Specification.productseries, Specification.specurl, Specification.starter, Specification.summary, Specification.superseded_by, Specification.title, Specification.whiteboard
   FROM Specification
   WHERE ($INT=$INT
          OR Specification.OWNER = $INT
          OR Specification.assignee = $INT
          OR Specification.drafter = $INT
          OR Specification.approver = $INT
          OR Specification.id IN
            (SELECT specification
             FROM SpecificationSubscription
             WHERE person = $INT)
          OR Specification.id IN
            (SELECT specification
             FROM SpecificationFeedback
             WHERE reviewer = $INT))
     AND (Specification.product IS NULL
          OR Specification.product NOT IN
            (SELECT Product.id
             FROM Product
             WHERE Product.active IS FALSE))
     AND NOT (Specification.implementation_status = $INT
              OR Specification.definition_status IN ($INT, $INT)
              OR (Specification.implementation_status = $INT
                  AND Specification.definition_status = $INT))LIMIT $INT) AS "_tmp" LIMIT $INT

tags: added: timeout
removed: oops
summary: - Person:+specworkload
+ Person:+specworkload timeouts
description: updated
William Grant (wgrant) wrote :

For each member in the batch, it a separate query to determine if there are any specs to show. If there are, it does another query to fetch them. Should be a pretty simple preloading case.

Curtis Hovey (sinzui) on 2012-09-14
tags: added: blueprints teams users
tags: added: specifications
removed: blueprints
William Grant (wgrant) on 2012-10-15
Changed in launchpad:
assignee: nobody → William Grant (wgrant)
status: Triaged → In Progress
William Grant (wgrant) on 2015-10-05
Changed in launchpad:
assignee: William Grant (wgrant) → nobody
status: In Progress → Triaged
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers