2011-03-20 23:52:24 |
Robert Collins |
bug |
|
|
added bug |
2011-04-11 06:19:43 |
Robert Collins |
description |
5 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 5 Robots: 1 Local: 2
3 https://launchpad.net/glib/+index (Product:+index)
OOPS-1904C1214, OOPS-1904G1551, OOPS-1904H1646
2 https://launchpad.net/gnome-scan/+index (Product:+index)
OOPS-1904E1630, OOPS-1904E1672 |
6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs] |
|
2011-04-11 06:22:40 |
Robert Collins |
description |
6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs] |
6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs]
slow SQL looking guessing at packaging
11706ms SQL-launchpad-main-slave SELECT DISTINCT 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('indicator-applet')) AS rank
FROM DistributionSourcePackageCache
JOIN SourcePackageName ON DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id
JOIN SourcePackageRelease ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN SourcePackagePublishingHistory ON SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
WHERE DistributionSourcePackageCache.distribution = 1
AND DistributionSourcePackageCache.archive IN (1,
534)
AND (DistributionSourcePackageCache.fti @@ ftq('indicator-applet')
OR DistributionSourcePackageCache.name ILIKE '%' || 'indicator-applet' || '%')
AND NOT EXISTS
(SELECT 1
FROM Packaging
WHERE Packaging.sourcepackagename = SourcePackageName.id)
AND SourcePackagePublishingHistory.distroseries = 106
ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT 8
OFFSET 0 |
|
2011-04-11 07:49:32 |
Robert Collins |
description |
6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs]
slow SQL looking guessing at packaging
11706ms SQL-launchpad-main-slave SELECT DISTINCT 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('indicator-applet')) AS rank
FROM DistributionSourcePackageCache
JOIN SourcePackageName ON DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id
JOIN SourcePackageRelease ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN SourcePackagePublishingHistory ON SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
WHERE DistributionSourcePackageCache.distribution = 1
AND DistributionSourcePackageCache.archive IN (1,
534)
AND (DistributionSourcePackageCache.fti @@ ftq('indicator-applet')
OR DistributionSourcePackageCache.name ILIKE '%' || 'indicator-applet' || '%')
AND NOT EXISTS
(SELECT 1
FROM Packaging
WHERE Packaging.sourcepackagename = SourcePackageName.id)
AND SourcePackagePublishingHistory.distroseries = 106
ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT 8
OFFSET 0 |
6 SELECT DISTINCT DistributionSourcePackageCache.archive, DistributionSourcePackageCache.binpkgdesc ... istroseries = $INT ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT $INT OFFSET $INT:
GET: 6 Robots: 0 Local: 0
3 https://launchpad.net/ubuntu-it/+index (Product:+index)
OOPS-1926E737, OOPS-1926G741, OOPS-1926G742
1 https://launchpad.net/glib/+index (Product:+index)
OOPS-1926H1059
1 https://launchpad.net/indicator-applet/+index (Product:+index)
OOPS-1926B1590
[1 other URLs]
6 SELECT ProductReleaseFile.date_uploaded, ProductReleaseFile.description, ProductReleaseFile.filet ... .productrelease IN ($INT ... $INT) AND ($INT=$INT) ORDER BY ProductReleaseFile.date_uploaded DESC:
GET: 6 Robots: 0 Local: 6
6 https://launchpad.net/rhythmbox/+index (Product:+index)
OOPS-1926C1169, OOPS-1926E1448, OOPS-1926G1357, OOPS-1926H1436, OOPS-1926H1439
slow SQL looking guessing at packaging
11706ms SQL-launchpad-main-slave SELECT DISTINCT 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('indicator-applet')) AS rank
FROM DistributionSourcePackageCache
JOIN SourcePackageName ON DistributionSourcePackageCache.sourcepackagename = SourcePackageName.id
JOIN SourcePackageRelease ON SourcePackageRelease.sourcepackagename = SourcePackageName.id
JOIN SourcePackagePublishingHistory ON SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
WHERE DistributionSourcePackageCache.distribution = 1
AND DistributionSourcePackageCache.archive IN (1,
534)
AND (DistributionSourcePackageCache.fti @@ ftq('indicator-applet')
OR DistributionSourcePackageCache.name ILIKE '%' || 'indicator-applet' || '%')
AND NOT EXISTS
(SELECT 1
FROM Packaging
WHERE Packaging.sourcepackagename = SourcePackageName.id)
AND SourcePackagePublishingHistory.distroseries = 106
ORDER BY rank DESC, DistributionSourcePackageCache.name LIMIT 8
OFFSET 0 |
|
2011-04-27 08:33:25 |
Paolo Sammicheli |
bug |
|
|
added subscriber Paolo Sammicheli |
2012-06-13 08:02:53 |
William Grant |
launchpad: assignee |
|
William Grant (wgrant) |
|
2012-06-13 08:02:56 |
William Grant |
launchpad: status |
Triaged |
In Progress |
|
2012-06-13 08:05:29 |
William Grant |
branch linked |
|
lp:~wgrant/launchpad/dspc-trgm-indices |
|
2012-06-13 08:06:04 |
William Grant |
branch linked |
|
lp:~wgrant/launchpad/package-search-timeouts |
|
2012-07-09 21:51:18 |
Launchpad QA Bot |
tags |
timeout |
qa-needstesting timeout |
|
2012-07-09 22:35:09 |
William Grant |
tags |
qa-needstesting timeout |
qa-ok timeout |
|
2012-07-10 17:00:41 |
Launchpad QA Bot |
tags |
qa-ok timeout |
qa-needstesting timeout |
|
2012-07-10 17:00:44 |
Launchpad QA Bot |
launchpad: status |
In Progress |
Fix Committed |
|
2012-07-10 23:50:43 |
William Grant |
tags |
qa-needstesting timeout |
qa-ok timeout |
|
2012-07-11 02:25:46 |
William Grant |
launchpad: status |
Fix Committed |
Fix Released |
|
2012-07-12 20:01:56 |
Curtis Hovey |
tags |
qa-ok timeout |
disclosure infrastructure qa-ok timeout |
|