Activity log for bug #739051

Date Who What changed Old value New value Message
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