| 2010-10-28 21:03:46 |
Gavin Panella |
bug |
|
|
added bug |
| 2010-10-28 21:03:58 |
Gavin Panella |
tags |
|
timeout |
|
| 2010-10-29 00:27:19 |
Curtis Hovey |
launchpad-registry: status |
New |
Triaged |
|
| 2010-10-29 00:27:22 |
Curtis Hovey |
launchpad-registry: importance |
Undecided |
High |
|
| 2010-10-29 00:27:31 |
Curtis Hovey |
launchpad-registry: milestone |
|
series-future |
|
| 2010-10-29 00:27:48 |
Curtis Hovey |
launchpad-registry: milestone |
series-future |
10.11 |
|
| 2010-10-29 03:21:05 |
Robert Collins |
summary |
Project page timeout on qastaging with 11s of SQL |
Project:+index : Project page timeout on qastaging with 11s of SQL |
|
| 2010-10-29 03:21:35 |
Robert Collins |
description |
OOPS-1762QS22
This happened several times on https://qastaging.launchpad.net/malone, the recovered. Perhaps the long query is overly broad and suffers under load or when the cache is cold. It has some EXISTS clauses in it that are probably a good first place to look. |
OOPS-1762QS22
This happened several times on https://qastaging.launchpad.net/malone, the recovered. Perhaps the long query is overly broad and suffers under load or when the cache is cold. It has some EXISTS clauses in it that are probably a good first place to look.
Branch: launchpad-rev-11812
Revno: 11812
SQL time: 11159 ms
Non-sql time: 774 ms
Total time: 11933 ms
Statement Count: 65
1 10007.0 1 SQL-launchpad-main-slave SELECT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdescriptions, DistributionSourcePackageCache.binpkgnames, DistributionSourcePackageCache.binpkgsummaries, DistributionSourcePackageCache.changelog, DistributionSourcePackageCache.distribution, DistributionSourcePackageCache.id, DistributionSourcePackageCache.name, DistributionSourcePackageCache.sourcepackagename, SourcePackageName.id, SourcePackageName.name, rank(fti, ftq('malone')) AS rank FROM DistributionSourcePackageCache JOIN SourcePackageName ON DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id WHERE DistributionSourcePackageCache.distribution = 1 AND DistributionSourcePackageCache.archive IN (1, 534) AND (DistributionSourcePackageCache.fti @@ ftq('malone') OR DistributionSourcePackageCache.name ILIKE '%' || 'malone' || '%') AND NOT EXISTS ( SELECT 1 FROM Packaging WHERE Packaging.sourcepackagename = SourcePackageName.id ) AND EXISTS ( SELECT 1 FROM SourcePackageRelease spr JOIN SourcePackagePublishingHistory spph ON spph.sourcepackagerelease = spr.id WHERE spr.sourcepackagename = SourcePackageName.id AND spph.distroseries = 106 ) ORDER BY rank DESC LIMIT 8 OFFSET 0
|
|
| 2010-11-01 23:15:24 |
Edwin Grubbs |
launchpad-registry: assignee |
|
Edwin Grubbs (edwin-grubbs) |
|
| 2010-11-02 19:15:20 |
Edwin Grubbs |
launchpad-registry: status |
Triaged |
In Progress |
|
| 2010-11-03 02:01:00 |
Edwin Grubbs |
branch linked |
|
lp:~edwin-grubbs/launchpad/bug-668047-project-dsp-portlet-timeout |
|
| 2010-11-13 00:02:45 |
Launchpad QA Bot |
tags |
timeout |
qa-needstesting timeout |
|
| 2010-11-13 00:02:47 |
Launchpad QA Bot |
launchpad-registry: status |
In Progress |
Fix Committed |
|
| 2010-11-13 09:10:01 |
Robert Collins |
launchpad-registry: status |
Fix Committed |
Fix Released |
|
| 2010-11-13 09:10:10 |
Robert Collins |
tags |
qa-needstesting timeout |
qa-ok |
|
| 2010-11-13 09:27:49 |
Henning Eggers |
tags |
qa-ok |
qa-ok timeout |
|
