| 2010-05-04 23:00:12 |
Max Bowsher |
bug |
|
|
added bug |
| 2010-05-07 14:59:51 |
Julian Edwards |
soyuz: status |
New |
Triaged |
|
| 2010-05-07 14:59:54 |
Julian Edwards |
soyuz: importance |
Undecided |
High |
|
| 2010-05-07 14:59:59 |
Julian Edwards |
soyuz: assignee |
|
Steve Kowalik (stevenk) |
|
| 2010-05-07 15:00:08 |
Julian Edwards |
tags |
|
oops ppa timeout |
|
| 2010-10-14 04:54:35 |
Robert Collins |
tags |
oops ppa timeout |
pg83 ppa timeout |
|
| 2010-10-18 06:55:16 |
Kai Kasurinen |
bug |
|
|
added subscriber Kai Kasurinen |
| 2010-11-24 07:26:05 |
Micah Gersten |
bug |
|
|
added subscriber Micah Gersten |
| 2010-11-24 07:30:39 |
Robert Collins |
description |
After the 10.04 rollout, I'm finding that copying packages between PPAs is now almost impossible due to timeout OOPSes.
I'm accustomed to doing a single-web-request copy of 5 source packages (hardy through lucid) in copy-binaries mode from mercurial-ppa/staging-snapshots to mercurial-ppa/snapshots several times a week. It worked fine until today's rollout, after which I consistently get a timeout OOPS. Here are some OOPS codes:
12:30 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585D1377
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585F1349
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585O1581
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585E1350
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585EC1266
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585H1403
12:38 < ubottu> https://lp-oops.canonical.com/oops.py/?oopsid=1585G1436 |
OOPS-1789EA420
https://edge.launchpad.net/%7Eubuntu-mozilla-security/+archive/ppa/+copy-packages
Branch: launchpad-rev-11952
Revno: 11952
SQL time: 10025 ms
Non-sql time: 5224 ms
Total time: 15249 ms
Statement Count: 1218
huge numbers of repeats.
index Reps Total time Average time Saving Database id Statement
1 317 997 3 994 SQL-launchpad-main-master INSERT INTO BinaryPackagePublishingHistory (binarypackagerelease, section, datepublished, status, priority, archive, component, scheduleddeletiondate, removal_comment, datemadepending, datesuperseded, distroarchseries, dateremoved, pocket, datecreated) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, CURRENT_TIMESTAMP AT TIME ZONE 'UTC') RETURNING BinaryPackagePublishingHistory.id
2 118 174 1 173 SQL-launchpad-main-master SELECT BinaryPackageFile.binarypackagerelease, BinaryPackageFile.filetype, BinaryPackageFile.id, BinaryPackageFile.libraryfile FROM BinaryPackageFile WHERE BinaryPackageFile.binarypackagerelease = %s ORDER BY BinaryPackageFile.libraryfile
3 86 141 1 140 SQL-launchpad-main-master SELECT BuildFarmJob.builder, BuildFarmJob.date_created, BuildFarmJob.date_finished, BuildFarmJob.date_first_dispatched, BuildFarmJob.date_started, BuildFarmJob.failure_count, BuildFarmJob.id, BuildFarmJob.job_type, BuildFarmJob.log, BuildFarmJob.processor, BuildFarmJob.status, BuildFarmJob.virtualized FROM BuildFarmJob WHERE BuildFarmJob.id = %s LIMIT 1
4 86 93 1 92 SQL-launchpad-main-master SELECT PackageBuild.archive, PackageBuild.build_farm_job, PackageBuild.dependencies, PackageBuild.id, PackageBuild.pocket, PackageBuild.upload_log FROM PackageBuild WHERE PackageBuild.id = %s LIMIT 1
5 67 142 2 140 SQL-launchpad-main-master SELECT LibraryFileAlias.content, LibraryFileAlias.date_created, LibraryFileAlias.expires, LibraryFileAlias.filename, LibraryFileAlias.hits, LibraryFileAlias.id, LibraryFileAlias.last_accessed, LibraryFileAlias.mimetype, LibraryFileAlias.restricted FROM LibraryFileAlias WHERE LibraryFileAlias.id = %s LIMIT 1
6 54 117 2 115 SQL-launchpad-main-master SELECT BinaryPackageName.id, BinaryPackageName.name FROM BinaryPackageName WHERE BinaryPackageName.id = %s LIMIT 1
7 53 137 2 135 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries WHERE DistroArchSeries.distroseries = %s ORDER BY DistroArchSeries.architecturetag
8 12 38 3 35 SQL-launchpad-main-master SELECT SourcePackageReleaseFile.filetype, SourcePackageReleaseFile.id, SourcePackageReleaseFile.libraryfile, SourcePackageReleaseFile.sourcepackagerelease FROM SourcePackageReleaseFile WHERE SourcePackageReleaseFile.sourcepackagerelease = %s ORDER BY SourcePackageReleaseFile.libraryfile
9 11 49 4 45 SQL-session SELECT TeamParticipation.id, TeamParticipation.person, TeamParticipation.team FROM TeamParticipation WHERE TeamParticipation.person = %s AND TeamParticipation.team = %s
10 10 67 6 61 SQL-launchpad-main-master SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person WHERE Person.id = %s LIMIT 1
11 7 25 3 22 SQL-launchpad-main-master SELECT Component.id, Component.name FROM Component WHERE Component.name = %s ORDER BY Component.id
12 6 9 1 8 SQL-launchpad-main-master SELECT ProcessorFamily.description, ProcessorFamily.id, ProcessorFamily.name, ProcessorFamily.restricted, ProcessorFamily.title FROM ProcessorFamily WHERE ProcessorFamily.id = %s LIMIT 1
13 5 22 4 18 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries WHERE DistroArchSeries.distroseries = %s AND DistroArchSeries.architecturetag = %s ORDER BY DistroArchSeries.id
14 3 84 28 56 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=824712 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
15 3 56 18 38 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=825261 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
16 3 23 7 16 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=825264 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
17 3 15 5 10 SQL-launchpad-main-master INSERT INTO SourcePackagePublishingHistory (datemadepending, component, removal_comment, datecreated, distroseries, dateremoved, status, pocket, archive, section, sourcepackagerelease, datepublished, datesuperseded, scheduleddeletiondate) VALUES (%s, %s, %s, CURRENT_TIMESTAMP AT TIME ZONE 'UTC', %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING SourcePackagePublishingHistory.id
18 3 8 2 6 SQL-session SELECT sourcepackageformatselection.distroseries, sourcepackageformatselection.format, sourcepackageformatselection.id FROM sourcepackageformatselection WHERE sourcepackageformatselection.distroseries = %s AND sourcepackageformatselection.format = %s
19 2 615 307 308 SQL-launchpad-main-master SELECT SourcePackagePublishingHistory.archive, SourcePackagePublishingHistory.component, SourcePackagePublishingHistory.datecreated, SourcePackagePublishingHistory.datemadepending, SourcePackagePublishingHistory.datepublished, SourcePackagePublishingHistory.dateremoved, SourcePackagePublishingHistory.datesuperseded, SourcePackagePublishingHistory.distroseries, SourcePackagePublishingHistory.id, SourcePackagePublishingHistory.pocket, SourcePackagePublishingHistory.removal_comment, SourcePackagePublishingHistory.removed_by, SourcePackagePublishingHistory.scheduleddeletiondate, SourcePackagePublishingHistory.section, SourcePackagePublishingHistory.sourcepackagerelease, SourcePackagePublishingHistory.status, SourcePackagePublishingHistory.supersededby, BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release, DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM BinaryPackageBuild, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) AND BinaryPackageBuild.id IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) ORDER BY SourcePackagePublishingHistory.id, DistroArchSeries.architecturetag
20 2 358 179 179 SQL-launchpad-main-master SELECT DISTINCT LibraryFileAlias.filename, LibraryFileContent.sha1 FROM LibraryFileAlias, LibraryFileContent, SourcePackagePublishingHistory, SourcePackageRelease, SourcePackageReleaseFile WHERE SourcePackagePublishingHistory.archive = %s AND SourcePackageRelease.id = SourcePackagePublishingHistory.sourcepackagerelease AND SourcePackageReleaseFile.sourcepackagerelease = SourcePackageRelease.id AND LibraryFileAlias.id = SourcePackageReleaseFile.libraryfile AND LibraryFileAlias.filename IN (%s, %s, %s) AND LibraryFileContent.id = LibraryFileAlias.content
21 2 35 17 18 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries JOIN PocketChroot ON PocketChroot.distroarchseries = DistroArchSeries.id JOIN LibraryFileAlias ON PocketChroot.chroot = LibraryFileAlias.id WHERE DistroArchSeries.distroseries = %s ORDER BY DistroArchSeries.architecturetag |
|
| 2010-11-24 07:31:48 |
Robert Collins |
tags |
pg83 ppa timeout |
ppa timeout |
|
| 2010-11-24 07:35:33 |
Robert Collins |
soyuz: assignee |
Steve Kowalik (stevenk) |
|
|
| 2010-11-24 07:36:55 |
Robert Collins |
summary |
+copy-packages nearly unusable due to timeouts |
Archive:+copy-packages nearly unusable due to timeouts |
|
| 2010-12-06 03:10:04 |
Robert Collins |
description |
OOPS-1789EA420
https://edge.launchpad.net/%7Eubuntu-mozilla-security/+archive/ppa/+copy-packages
Branch: launchpad-rev-11952
Revno: 11952
SQL time: 10025 ms
Non-sql time: 5224 ms
Total time: 15249 ms
Statement Count: 1218
huge numbers of repeats.
index Reps Total time Average time Saving Database id Statement
1 317 997 3 994 SQL-launchpad-main-master INSERT INTO BinaryPackagePublishingHistory (binarypackagerelease, section, datepublished, status, priority, archive, component, scheduleddeletiondate, removal_comment, datemadepending, datesuperseded, distroarchseries, dateremoved, pocket, datecreated) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, CURRENT_TIMESTAMP AT TIME ZONE 'UTC') RETURNING BinaryPackagePublishingHistory.id
2 118 174 1 173 SQL-launchpad-main-master SELECT BinaryPackageFile.binarypackagerelease, BinaryPackageFile.filetype, BinaryPackageFile.id, BinaryPackageFile.libraryfile FROM BinaryPackageFile WHERE BinaryPackageFile.binarypackagerelease = %s ORDER BY BinaryPackageFile.libraryfile
3 86 141 1 140 SQL-launchpad-main-master SELECT BuildFarmJob.builder, BuildFarmJob.date_created, BuildFarmJob.date_finished, BuildFarmJob.date_first_dispatched, BuildFarmJob.date_started, BuildFarmJob.failure_count, BuildFarmJob.id, BuildFarmJob.job_type, BuildFarmJob.log, BuildFarmJob.processor, BuildFarmJob.status, BuildFarmJob.virtualized FROM BuildFarmJob WHERE BuildFarmJob.id = %s LIMIT 1
4 86 93 1 92 SQL-launchpad-main-master SELECT PackageBuild.archive, PackageBuild.build_farm_job, PackageBuild.dependencies, PackageBuild.id, PackageBuild.pocket, PackageBuild.upload_log FROM PackageBuild WHERE PackageBuild.id = %s LIMIT 1
5 67 142 2 140 SQL-launchpad-main-master SELECT LibraryFileAlias.content, LibraryFileAlias.date_created, LibraryFileAlias.expires, LibraryFileAlias.filename, LibraryFileAlias.hits, LibraryFileAlias.id, LibraryFileAlias.last_accessed, LibraryFileAlias.mimetype, LibraryFileAlias.restricted FROM LibraryFileAlias WHERE LibraryFileAlias.id = %s LIMIT 1
6 54 117 2 115 SQL-launchpad-main-master SELECT BinaryPackageName.id, BinaryPackageName.name FROM BinaryPackageName WHERE BinaryPackageName.id = %s LIMIT 1
7 53 137 2 135 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries WHERE DistroArchSeries.distroseries = %s ORDER BY DistroArchSeries.architecturetag
8 12 38 3 35 SQL-launchpad-main-master SELECT SourcePackageReleaseFile.filetype, SourcePackageReleaseFile.id, SourcePackageReleaseFile.libraryfile, SourcePackageReleaseFile.sourcepackagerelease FROM SourcePackageReleaseFile WHERE SourcePackageReleaseFile.sourcepackagerelease = %s ORDER BY SourcePackageReleaseFile.libraryfile
9 11 49 4 45 SQL-session SELECT TeamParticipation.id, TeamParticipation.person, TeamParticipation.team FROM TeamParticipation WHERE TeamParticipation.person = %s AND TeamParticipation.team = %s
10 10 67 6 61 SQL-launchpad-main-master SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person WHERE Person.id = %s LIMIT 1
11 7 25 3 22 SQL-launchpad-main-master SELECT Component.id, Component.name FROM Component WHERE Component.name = %s ORDER BY Component.id
12 6 9 1 8 SQL-launchpad-main-master SELECT ProcessorFamily.description, ProcessorFamily.id, ProcessorFamily.name, ProcessorFamily.restricted, ProcessorFamily.title FROM ProcessorFamily WHERE ProcessorFamily.id = %s LIMIT 1
13 5 22 4 18 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries WHERE DistroArchSeries.distroseries = %s AND DistroArchSeries.architecturetag = %s ORDER BY DistroArchSeries.id
14 3 84 28 56 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=824712 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
15 3 56 18 38 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=825261 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
16 3 23 7 16 SQL-launchpad-main-master SELECT BinaryPackagePublishingHistory.archive, BinaryPackagePublishingHistory.binarypackagerelease, BinaryPackagePublishingHistory.component, BinaryPackagePublishingHistory.datecreated, BinaryPackagePublishingHistory.datemadepending, BinaryPackagePublishingHistory.datepublished, BinaryPackagePublishingHistory.dateremoved, BinaryPackagePublishingHistory.datesuperseded, BinaryPackagePublishingHistory.distroarchseries, BinaryPackagePublishingHistory.id, BinaryPackagePublishingHistory.pocket, BinaryPackagePublishingHistory.priority, BinaryPackagePublishingHistory.removal_comment, BinaryPackagePublishingHistory.removed_by, BinaryPackagePublishingHistory.scheduleddeletiondate, BinaryPackagePublishingHistory.section, BinaryPackagePublishingHistory.status, BinaryPackagePublishingHistory.supersededby, "_prejoin1".user_defined_fields, "_prejoin1".architecturespecific, "_prejoin1".binarypackagename, "_prejoin1".binpackageformat, "_prejoin1".breaks, "_prejoin1".build, "_prejoin1".component, "_prejoin1".conflicts, "_prejoin1".datecreated, "_prejoin1".debug_package, "_prejoin1".depends, "_prejoin1".description, "_prejoin1".enhances, "_prejoin1".essential, "_prejoin1".homepage, "_prejoin1".id, "_prejoin1".installedsize, "_prejoin1".pre_depends, "_prejoin1".priority, "_prejoin1".provides, "_prejoin1".recommends, "_prejoin1".replaces, "_prejoin1".section, "_prejoin1".shlibdeps, "_prejoin1".suggests, "_prejoin1".summary, "_prejoin1".version FROM BinaryPackageBuild, BinaryPackageRelease, DistroArchSeries, BinaryPackagePublishingHistory LEFT JOIN BinaryPackageRelease AS "_prejoin1" ON BinaryPackagePublishingHistory.binarypackagerelease = "_prejoin1".id WHERE BinaryPackagePublishingHistory.binarypackagerelease= BinaryPackageRelease.id AND BinaryPackagePublishingHistory.distroarchseries= DistroArchSeries.id AND BinaryPackageRelease.build=BinaryPackageBuild.id AND BinaryPackageBuild.source_package_release=825264 AND DistroArchSeries.distroseries=103 AND BinaryPackagePublishingHistory.archive=5856 AND BinaryPackagePublishingHistory.pocket=0 AND (1=1) ORDER BY BinaryPackagePublishingHistory.id DESC
17 3 15 5 10 SQL-launchpad-main-master INSERT INTO SourcePackagePublishingHistory (datemadepending, component, removal_comment, datecreated, distroseries, dateremoved, status, pocket, archive, section, sourcepackagerelease, datepublished, datesuperseded, scheduleddeletiondate) VALUES (%s, %s, %s, CURRENT_TIMESTAMP AT TIME ZONE 'UTC', %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING SourcePackagePublishingHistory.id
18 3 8 2 6 SQL-session SELECT sourcepackageformatselection.distroseries, sourcepackageformatselection.format, sourcepackageformatselection.id FROM sourcepackageformatselection WHERE sourcepackageformatselection.distroseries = %s AND sourcepackageformatselection.format = %s
19 2 615 307 308 SQL-launchpad-main-master SELECT SourcePackagePublishingHistory.archive, SourcePackagePublishingHistory.component, SourcePackagePublishingHistory.datecreated, SourcePackagePublishingHistory.datemadepending, SourcePackagePublishingHistory.datepublished, SourcePackagePublishingHistory.dateremoved, SourcePackagePublishingHistory.datesuperseded, SourcePackagePublishingHistory.distroseries, SourcePackagePublishingHistory.id, SourcePackagePublishingHistory.pocket, SourcePackagePublishingHistory.removal_comment, SourcePackagePublishingHistory.removed_by, SourcePackagePublishingHistory.scheduleddeletiondate, SourcePackagePublishingHistory.section, SourcePackagePublishingHistory.sourcepackagerelease, SourcePackagePublishingHistory.status, SourcePackagePublishingHistory.supersededby, BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release, DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM BinaryPackageBuild, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) AND BinaryPackageBuild.id IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) ORDER BY SourcePackagePublishingHistory.id, DistroArchSeries.architecturetag
20 2 358 179 179 SQL-launchpad-main-master SELECT DISTINCT LibraryFileAlias.filename, LibraryFileContent.sha1 FROM LibraryFileAlias, LibraryFileContent, SourcePackagePublishingHistory, SourcePackageRelease, SourcePackageReleaseFile WHERE SourcePackagePublishingHistory.archive = %s AND SourcePackageRelease.id = SourcePackagePublishingHistory.sourcepackagerelease AND SourcePackageReleaseFile.sourcepackagerelease = SourcePackageRelease.id AND LibraryFileAlias.id = SourcePackageReleaseFile.libraryfile AND LibraryFileAlias.filename IN (%s, %s, %s) AND LibraryFileContent.id = LibraryFileAlias.content
21 2 35 17 18 SQL-launchpad-main-master SELECT DistroArchSeries.architecturetag, DistroArchSeries.distroseries, DistroArchSeries.enabled, DistroArchSeries.id, DistroArchSeries.official, DistroArchSeries.owner, DistroArchSeries.package_count, DistroArchSeries.processorfamily, DistroArchSeries.supports_virtualized FROM DistroArchSeries JOIN PocketChroot ON PocketChroot.distroarchseries = DistroArchSeries.id JOIN LibraryFileAlias ON PocketChroot.chroot = LibraryFileAlias.id WHERE DistroArchSeries.distroseries = %s ORDER BY DistroArchSeries.architecturetag |
5 https://launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800C349, OOPS-1800G2129, OOPS-1800K1139, OOPS-1800M2146, OOPS-1800O1826
3 https://edge.launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800EB307, OOPS-1800ED1901, OOPS-1800ED329
1 https://launchpad.net/%7Eubuntu-langpack/+archive/ppa/+index (Archive:+index)
OOPS-1800L840
|
|
| 2010-12-06 03:14:12 |
Robert Collins |
description |
5 https://launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800C349, OOPS-1800G2129, OOPS-1800K1139, OOPS-1800M2146, OOPS-1800O1826
3 https://edge.launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800EB307, OOPS-1800ED1901, OOPS-1800ED329
1 https://launchpad.net/%7Eubuntu-langpack/+archive/ppa/+index (Archive:+index)
OOPS-1800L840
|
5 https://launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800C349, OOPS-1800G2129, OOPS-1800K1139, OOPS-1800M2146, OOPS-1800O1826
3 https://edge.launchpad.net/ubuntu/+archive/primary/+copy-packages (Archive:+copy-packages)
OOPS-1800EB307, OOPS-1800ED1901, OOPS-1800ED329
1 https://launchpad.net/%7Eubuntu-langpack/+archive/ppa/+index (Archive:+index)
OOPS-1800L840
Picking 1800L840:
Branch: launchpad-rev-12004
Revno: 12004
SQL time: 14566 ms
Non-sql time: 1575 ms
Total time: 16141 ms
Statement Count: 235
Long SQL Statements (Shows up to five statements)
Time Reps Database id Statement
1 3667.0 1 SQL-launchpad-main-master SELECT COUNT(*) FROM SourcePackageName, SourcePackagePublishingHistory, SourcePackageRelease WHERE SourcePackagePublishingHistory.archive = 32 AND SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = SourcePackageName.id AND (1=1)
2 1919.0 1 SQL-launchpad-main-master SELECT COUNT(*) FROM ((SELECT DISTINCT SourcePackageRelease.user_defined_fields, SourcePackageRelease.architecturehintlist, SourcePackageRelease.build_conflicts, SourcePackageRelease.build_conflicts_indep, SourcePackageRelease.builddepends, SourcePackageRelease.builddependsindep, SourcePackageRelease.changelog, SourcePackageRelease.changelog_entry, SourcePackageRelease.component, SourcePackageRelease.copyright, SourcePackageRelease.creator, SourcePackageRelease.dateuploaded, SourcePackageRelease.dsc, SourcePackageRelease.dsc_binaries, SourcePackageRelease.dsc_format, SourcePackageRelease.dsc_maintainer_rfc822, SourcePackageRelease.dsc_standards_version, SourcePackageRelease.dscsigningkey, SourcePackageRelease.format, SourcePackageRelease.homepage, SourcePackageRelease.id, SourcePackageRelease.maintainer, SourcePackageRelease.section, SourcePackageRelease.sourcepackage_recipe_build, SourcePackageRelease.sourcepackagename, SourcePackageRelease.upload_archive, SourcePackageRelease.upload_distroseries, SourcePackageRelease.urgency, SourcePackageRelease.version FROM BinaryPackageBuild, BuildFarmJob, PackageBuild, SourcePackageRelease WHERE BinaryPackageBuild.source_package_release = SourcePackageRelease.id AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.archive = %s AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status = %s) EXCEPT (SELECT DISTINCT SourcePackageRelease.user_defined_fields, SourcePackageRelease.architecturehintlist, SourcePackageRelease.build_conflicts, SourcePackageRelease.build_conflicts_indep, SourcePackageRelease.builddepends, SourcePackageRelease.builddependsindep, SourcePackageRelease.changelog, SourcePackageRelease.changelog_entry, SourcePackageRelease.component, SourcePackageRelease.copyright, SourcePackageRelease.creator, SourcePackageRelease.dateuploaded, SourcePackageRelease.dsc, SourcePackageRelease.dsc_binaries, SourcePackageRelease.dsc_format, SourcePackageRelease.dsc_maintainer_rfc822, SourcePackageRelease.dsc_standards_version, SourcePackageRelease.dscsigningkey, SourcePackageRelease.format, SourcePackageRelease.homepage, SourcePackageRelease.id, SourcePackageRelease.maintainer, SourcePackageRelease.section, SourcePackageRelease.sourcepackage_recipe_build, SourcePackageRelease.sourcepackagename, SourcePackageRelease.upload_archive, SourcePackageRelease.upload_distroseries, SourcePackageRelease.urgency, SourcePackageRelease.version FROM BinaryPackageBuild, BuildFarmJob, PackageBuild, SourcePackageRelease WHERE BinaryPackageBuild.source_package_release = SourcePackageRelease.id AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.archive = %s AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status = %s)) AS "_tmp"
3 1117.0 1 SQL-launchpad-main-master SELECT SourcePackageRelease.user_defined_fields, SourcePackageRelease.architecturehintlist, SourcePackageRelease.build_conflicts, SourcePackageRelease.build_conflicts_indep, SourcePackageRelease.builddepends, SourcePackageRelease.builddependsindep, SourcePackageRelease.changelog, SourcePackageRelease.changelog_entry, SourcePackageRelease.component, SourcePackageRelease.copyright, SourcePackageRelease.creator, SourcePackageRelease.dateuploaded, SourcePackageRelease.dsc, SourcePackageRelease.dsc_binaries, SourcePackageRelease.dsc_format, SourcePackageRelease.dsc_maintainer_rfc822, SourcePackageRelease.dsc_standards_version, SourcePackageRelease.dscsigningkey, SourcePackageRelease.format, SourcePackageRelease.homepage, SourcePackageRelease.id, SourcePackageRelease.maintainer, SourcePackageRelease.section, SourcePackageRelease.sourcepackage_recipe_build, SourcePackageRelease.sourcepackagename, SourcePackageRelease.upload_archive, SourcePackageRelease.upload_distroseries, SourcePackageRelease.urgency, SourcePackageRelease.version FROM SourcePackageRelease JOIN ( SELECT spr.id as sourcepackagerelease, MAX(spph.id) FROM SourcePackagePublishingHistory spph, SourcePackageRelease spr WHERE spr.sourcepackagename IN (380, 392, 52690, 396, 376, 378, 370, 406, 408, 52559, 420, 52561, 412, 414, 394, 48171, 52563, 40871, 410, 52562, 384, 52558, 416, 386, 374, 372, 52554, 402, 404, 52560, 52555, 390, 388, 62590, 400, 418, 382, 398) AND spph.sourcepackagerelease = spr.id AND spph.archive IN (1, 534) AND spph.status IN (1, 2) AND spph.distroseries = 103 GROUP BY spr.id) AS spph ON SourcePackageRelease.id = spph.sourcepackagerelease
4 669.0 1 SQL-launchpad-main-master SELECT * FROM ((SELECT BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release FROM BinaryPackageBuild, BinaryPackagePublishingHistory, BinaryPackageRelease, BuildFarmJob, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s) AND SourcePackagePublishingHistory.archive != PackageBuild.archive AND BinaryPackagePublishingHistory.archive = SourcePackagePublishingHistory.archive AND BinaryPackagePublishingHistory.binarypackagerelease = BinaryPackageRelease.id AND BinaryPackageRelease.build = BinaryPackageBuild.id AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status IN (%s) ORDER BY BinaryPackageBuild.id) UNION (SELECT BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release FROM BinaryPackageBuild, BuildFarmJob, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s) AND SourcePackagePublishingHistory.archive = PackageBuild.archive AND BinaryPackageBuild.package_build = PackageBuild.id AND PackageBuild.build_farm_job = BuildFarmJob.id AND BuildFarmJob.status IN (%s) ORDER BY BinaryPackageBuild.id)) AS "_21899" ORDER BY id
5 638.0 1 SQL-launchpad-main-master SELECT * FROM ((SELECT BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release FROM BinaryPackageBuild, BinaryPackagePublishingHistory, BinaryPackageRelease, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s) AND SourcePackagePublishingHistory.archive != PackageBuild.archive AND BinaryPackagePublishingHistory.archive = SourcePackagePublishingHistory.archive AND BinaryPackagePublishingHistory.binarypackagerelease = BinaryPackageRelease.id AND BinaryPackageRelease.build = BinaryPackageBuild.id AND SourcePackagePublishingHistory.archive = %s ORDER BY BinaryPackageBuild.id) UNION (SELECT BinaryPackageBuild.distro_arch_series, BinaryPackageBuild.id, BinaryPackageBuild.package_build, BinaryPackageBuild.source_package_release FROM BinaryPackageBuild, DistroArchSeries, PackageBuild, SourcePackagePublishingHistory WHERE BinaryPackageBuild.package_build = PackageBuild.id AND BinaryPackageBuild.distro_arch_series = DistroArchSeries.id AND SourcePackagePublishingHistory.distroseries = DistroArchSeries.distroseries AND SourcePackagePublishingHistory.sourcepackagerelease = BinaryPackageBuild.source_package_release AND SourcePackagePublishingHistory.id IN (%s) AND SourcePackagePublishingHistory.archive = PackageBuild.archive AND SourcePackagePublishingHistory.archive = %s ORDER BY BinaryPackageBuild.id)) AS "_21896" ORDER BY id
Repeated SQL Statements
Reps Total time Average time Saving Database id Statement
1 79 114 1 113 SQL-launchpad-main-master SELECT PackageBuild.archive, PackageBuild.build_farm_job, PackageBuild.dependencies, PackageBuild.id, PackageBuild.pocket, PackageBuild.upload_log FROM PackageBuild WHERE PackageBuild.id = %s LIMIT 1
2 78 87 1 86 SQL-launchpad-main-master SELECT BuildFarmJob.builder, BuildFarmJob.date_created, BuildFarmJob.date_finished, BuildFarmJob.date_first_dispatched, BuildFarmJob.date_started, BuildFarmJob.failure_count, BuildFarmJob.id, BuildFarmJob.job_type, BuildFarmJob.log, BuildFarmJob.processor, BuildFarmJob.status, BuildFarmJob.virtualized FROM BuildFarmJob WHERE BuildFarmJob.id = %s LIMIT 1
3 8 10 1 9 SQL-launchpad-main-master SELECT TeamParticipation.id, TeamParticipation.person, TeamParticipation.team FROM TeamParticipation WHERE TeamParticipation.person = %s AND TeamParticipation.team = %s |
|
| 2010-12-08 12:29:08 |
Kai Kasurinen |
removed subscriber Kai Kasurinen |
|
|
|
| 2011-01-12 17:02:34 |
Robert Collins |
launchpad: importance |
High |
Critical |
|
| 2011-01-19 22:23:51 |
j.c.sackett |
launchpad: assignee |
|
William Grant (wgrant) |
|
| 2011-02-02 02:10:26 |
William Grant |
launchpad: status |
Triaged |
In Progress |
|
| 2011-05-04 15:03:37 |
levien |
bug |
|
|
added subscriber levien |
| 2011-05-11 07:17:54 |
William Grant |
launchpad: assignee |
William Grant (wgrant) |
|
|
| 2011-05-11 07:17:55 |
William Grant |
launchpad: status |
In Progress |
Triaged |
|
| 2011-06-13 11:04:57 |
Mantas Kriaučiūnas |
bug |
|
|
added subscriber Mantas Kriaučiūnas |
| 2011-12-14 00:42:05 |
Scott Kitterman |
bug |
|
|
added subscriber Scott Kitterman |
| 2012-01-10 10:37:28 |
Raphaël Badin |
branch linked |
|
lp:~rvb/launchpad/ppa-copy-notifications-javascript |
|
| 2012-01-11 22:30:55 |
Launchpad QA Bot |
launchpad: assignee |
|
Raphaël Badin (rvb) |
|
| 2012-01-11 22:31:48 |
Launchpad QA Bot |
tags |
lp-soyuz ppa timeout |
lp-soyuz ppa qa-needstesting timeout |
|
| 2012-01-11 22:31:50 |
Launchpad QA Bot |
launchpad: status |
Triaged |
Fix Committed |
|
| 2012-01-12 08:53:07 |
Steve Kowalik |
tags |
lp-soyuz ppa qa-needstesting timeout |
lp-soyuz ppa qa-ok timeout |
|
| 2012-01-12 11:27:48 |
William Grant |
launchpad: status |
Fix Committed |
In Progress |
|
| 2012-06-25 16:58:07 |
Kamal Mostafa |
bug |
|
|
added subscriber Kamal Mostafa |
| 2012-09-11 14:09:06 |
Curtis Hovey |
launchpad: assignee |
Raphaël Badin (rvb) |
|
|
| 2012-09-11 14:09:41 |
Curtis Hovey |
launchpad: status |
In Progress |
Triaged |
|
| 2012-10-01 20:32:37 |
Colin Watson |
launchpad: status |
Triaged |
In Progress |
|
| 2012-10-01 20:32:37 |
Colin Watson |
launchpad: assignee |
|
Colin Watson (cjwatson) |
|
| 2012-10-15 02:46:25 |
William Grant |
tags |
lp-soyuz ppa qa-ok timeout |
lp-soyuz package-copies ppa qa-ok timeout |
|
| 2012-10-29 09:14:33 |
Launchpad Janitor |
branch linked |
|
lp:~cjwatson/launchpad/always-copy-packages-asynchronously |
|
| 2012-10-29 18:00:41 |
Launchpad QA Bot |
tags |
lp-soyuz package-copies ppa qa-ok timeout |
lp-soyuz package-copies ppa qa-needstesting timeout |
|
| 2012-10-29 18:00:42 |
Launchpad QA Bot |
launchpad: status |
In Progress |
Fix Committed |
|
| 2012-10-30 05:45:03 |
Steve Kowalik |
tags |
lp-soyuz package-copies ppa qa-needstesting timeout |
bad-commit-16210 lp-soyuz package-copies ppa qa-ok timeout |
|
| 2012-10-30 06:12:35 |
Steve Kowalik |
tags |
bad-commit-16210 lp-soyuz package-copies ppa qa-ok timeout |
lp-soyuz package-copies ppa qa-ok timeout |
|
| 2012-10-31 01:07:02 |
William Grant |
launchpad: status |
Fix Committed |
Fix Released |
|
| 2012-11-12 15:21:12 |
Colin Watson |
launchpad: status |
Fix Released |
In Progress |
|
| 2012-11-12 17:26:15 |
Colin Watson |
branch linked |
|
lp:~cjwatson/launchpad/always-copy-packages-asynchronously-2 |
|
| 2012-11-14 18:10:36 |
Launchpad QA Bot |
tags |
lp-soyuz package-copies ppa qa-ok timeout |
lp-soyuz package-copies ppa qa-needstesting timeout |
|
| 2012-11-14 18:10:37 |
Launchpad QA Bot |
launchpad: status |
In Progress |
Fix Committed |
|
| 2012-11-15 00:58:18 |
Colin Watson |
tags |
lp-soyuz package-copies ppa qa-needstesting timeout |
lp-soyuz package-copies ppa qa-ok timeout |
|
| 2012-11-15 06:02:31 |
William Grant |
launchpad: status |
Fix Committed |
Fix Released |
|
