Person:+specworkload timeouts
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Triaged
|
High
|
Unassigned |
Bug Description
4 SELECT $INT FROM (SELECT Specification.
GET: 4 Robots: 4 Local: 0
2 https:/
OOPS-1900H932, OOPS-1900K59
1 https:/
OOPS-1900J432
1 https:/
OOPS-1900B479
death by sql
1 94 9389 99 9290 SQL-launchpad-
SELECT $INT
FROM
(SELECT Specification.
FROM Specification
WHERE ($INT=$INT
OR Specification.OWNER = $INT
OR Specification.
OR Specification.
OR Specification.
OR Specification.id IN
(SELECT specification
FROM SpecificationSu
WHERE person = $INT)
OR Specification.id IN
(SELECT specification
FROM SpecificationFe
WHERE reviewer = $INT))
AND (Specification.
OR Specification.
(SELECT Product.id
FROM Product
WHERE Product.active IS FALSE))
AND NOT (Specification.
OR Specification.
OR (Specification.
tags: |
added: timeout removed: oops |
summary: |
- Person:+specworkload + Person:+specworkload timeouts |
description: | updated |
tags: | added: blueprints teams users |
tags: |
added: specifications removed: blueprints |
Changed in launchpad: | |
assignee: | nobody → William Grant (wgrant) |
status: | Triaged → In Progress |
Changed in launchpad: | |
assignee: | William Grant (wgrant) → nobody |
status: | In Progress → Triaged |
Changed in launchpad: | |
importance: | Critical → High |
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.