| 2010-09-12 04:07:09 |
Micah Gersten |
bug |
|
|
added bug |
| 2010-09-12 04:22:31 |
Robert Collins |
summary |
bug loading times out with many bug tasks/nominations |
BugTask:+index times out with many bug tasks/nominations |
|
| 2010-09-12 04:25:31 |
Robert Collins |
description |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.edge.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1716ED446
OOPS-1716ED494 |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.edge.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1716ED446
Branch: launchpad-rev-11522
Revno: 11522
SQL time: 6062 ms
Non-sql time: 7545 ms
Total time: 13607 ms
Statement Count: 601
13 repeats of
"7 13 295 22 273 SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, ..."
23 of "2 23 704 30 674 SQL-launchpad-main-slave SELECT ValidPersonCache.id FROM ValidPersonCache WHERE ValidPersonCache.id = %s LIMIT 1
50 like these: "21 5 32 6 26 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.component = 3 AND (1=1)
22 5 26 5 21 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 55139 AND (1=1)
23 5 22 4 18 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 56764 AND (1=1)
24 5 20 4 16 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePer"
100 or more like "125 2 5 2 3 SQL-launchpad-main-slave 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, 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 SourcePackagePublishingHistory, SourcePackageRelease WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = 52281 AND SourcePackagePublishingHistory.distroseries = 103 AND SourcePackagePublishingHistory.archive IN (1, 534) AND SourcePackagePublishingHistory.status IN (2) AND (1=1) ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT 1"
OOPS-1716ED494
|
|
| 2010-09-13 19:46:15 |
Deryck Hodge |
malone: status |
New |
Triaged |
|
| 2010-09-13 19:46:20 |
Deryck Hodge |
malone: importance |
Undecided |
High |
|
| 2010-09-13 19:46:27 |
Deryck Hodge |
tags |
|
timeout |
|
| 2010-09-16 11:55:52 |
Paul Sladen |
summary |
BugTask:+index times out with many bug tasks/nominations |
BugTask:+index times out with many bug tasks/nominations (eg. Bug #1) |
|
| 2010-10-14 05:01:38 |
Robert Collins |
tags |
timeout |
pg83 timeout |
|
| 2011-01-12 16:57:31 |
Robert Collins |
launchpad: importance |
High |
Critical |
|
| 2011-02-17 21:57:27 |
Robert Collins |
description |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.edge.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1716ED446
Branch: launchpad-rev-11522
Revno: 11522
SQL time: 6062 ms
Non-sql time: 7545 ms
Total time: 13607 ms
Statement Count: 601
13 repeats of
"7 13 295 22 273 SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, ..."
23 of "2 23 704 30 674 SQL-launchpad-main-slave SELECT ValidPersonCache.id FROM ValidPersonCache WHERE ValidPersonCache.id = %s LIMIT 1
50 like these: "21 5 32 6 26 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.component = 3 AND (1=1)
22 5 26 5 21 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 55139 AND (1=1)
23 5 22 4 18 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 56764 AND (1=1)
24 5 20 4 16 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePer"
100 or more like "125 2 5 2 3 SQL-launchpad-main-slave 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, 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 SourcePackagePublishingHistory, SourcePackageRelease WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = 52281 AND SourcePackagePublishingHistory.distroseries = 103 AND SourcePackagePublishingHistory.archive IN (1, 534) AND SourcePackagePublishingHistory.status IN (2) AND (1=1) ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT 1"
OOPS-1716ED494
|
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1716ED446
Branch: launchpad-rev-11522
Revno: 11522
SQL time: 6062 ms
Non-sql time: 7545 ms
Total time: 13607 ms
Statement Count: 601
13 repeats of
"7 13 295 22 273 SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, ..."
23 of "2 23 704 30 674 SQL-launchpad-main-slave SELECT ValidPersonCache.id FROM ValidPersonCache WHERE ValidPersonCache.id = %s LIMIT 1
50 like these: "21 5 32 6 26 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.component = 3 AND (1=1)
22 5 26 5 21 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 55139 AND (1=1)
23 5 22 4 18 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 56764 AND (1=1)
24 5 20 4 16 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePer"
100 or more like "125 2 5 2 3 SQL-launchpad-main-slave 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, 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 SourcePackagePublishingHistory, SourcePackageRelease WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = 52281 AND SourcePackagePublishingHistory.distroseries = 103 AND SourcePackagePublishingHistory.archive IN (1, 534) AND SourcePackagePublishingHistory.status IN (2) AND (1=1) ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT 1"
OOPS-1716ED494 |
|
| 2011-02-18 04:29:24 |
Robert Collins |
description |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1716ED446
Branch: launchpad-rev-11522
Revno: 11522
SQL time: 6062 ms
Non-sql time: 7545 ms
Total time: 13607 ms
Statement Count: 601
13 repeats of
"7 13 295 22 273 SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, ..."
23 of "2 23 704 30 674 SQL-launchpad-main-slave SELECT ValidPersonCache.id FROM ValidPersonCache WHERE ValidPersonCache.id = %s LIMIT 1
50 like these: "21 5 32 6 26 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.component = 3 AND (1=1)
22 5 26 5 21 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 55139 AND (1=1)
23 5 22 4 18 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePermission.person = TeamParticipation.team AND TeamParticipation.person = 2497367 AND ArchivePermission.sourcepackagename = 56764 AND (1=1)
24 5 20 4 16 SQL-launchpad-main-slave SELECT COUNT(*) FROM ArchivePermission, TeamParticipation WHERE ArchivePermission.archive = 1 AND ArchivePermission.permission = 1 AND ArchivePer"
100 or more like "125 2 5 2 3 SQL-launchpad-main-slave 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, 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 SourcePackagePublishingHistory, SourcePackageRelease WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id AND SourcePackageRelease.sourcepackagename = 52281 AND SourcePackagePublishingHistory.distroseries = 103 AND SourcePackagePublishingHistory.archive IN (1, 534) AND SourcePackagePublishingHistory.status IN (2) AND (1=1) ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT 1"
OOPS-1716ED494 |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1875D380 |
|
| 2011-02-18 08:06:56 |
Robert Collins |
description |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1875D380 |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1875D380
Branch: launchpad-rev-12399
Revno: 12399
SQL time: 7510 ms
Non-sql time: 7524 ms
Total time: 15034 ms
Statement Count: 555
1 150 2638 17 2621 SQL-launchpad-main-slave
SELECT SourcePackagePublishingHistory.ancestor,
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,
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 SourcePackagePublishingHistory,
SourcePackageRelease
WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
AND SourcePackageRelease.sourcepackagename = $INT
AND SourcePackagePublishingHistory.distroseries = $INT
AND SourcePackagePublishingHistory.archive IN ($INT, $INT)
AND SourcePackagePublishingHistory.status IN ($INT)
AND ($INT=$INT)
ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT $INT
2 77 675 8 667 SQL-launchpad-main-slave
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 = $INT LIMIT $INT |
|
| 2011-02-22 10:15:45 |
Robert Collins |
branch linked |
|
lp:~lifeless/launchpad/bug-636158 |
|
| 2011-02-23 01:31:09 |
Launchpad QA Bot |
launchpad: milestone |
|
11.03 |
|
| 2011-02-23 01:31:09 |
Launchpad QA Bot |
launchpad: assignee |
|
Robert Collins (lifeless) |
|
| 2011-02-23 01:31:11 |
Launchpad QA Bot |
tags |
lp-bugs pg83 timeout |
lp-bugs pg83 qa-needstesting timeout |
|
| 2011-02-23 01:31:14 |
Launchpad QA Bot |
launchpad: status |
Triaged |
Fix Committed |
|
| 2011-02-23 02:52:12 |
Robert Collins |
tags |
lp-bugs pg83 qa-needstesting timeout |
lp-bugs pg83 qa-ok timeout |
|
| 2011-02-23 10:17:43 |
Robert Collins |
description |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1875D380
Branch: launchpad-rev-12399
Revno: 12399
SQL time: 7510 ms
Non-sql time: 7524 ms
Total time: 15034 ms
Statement Count: 555
1 150 2638 17 2621 SQL-launchpad-main-slave
SELECT SourcePackagePublishingHistory.ancestor,
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,
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 SourcePackagePublishingHistory,
SourcePackageRelease
WHERE SourcePackagePublishingHistory.sourcepackagerelease = SourcePackageRelease.id
AND SourcePackageRelease.sourcepackagename = $INT
AND SourcePackagePublishingHistory.distroseries = $INT
AND SourcePackagePublishingHistory.archive IN ($INT, $INT)
AND SourcePackagePublishingHistory.status IN ($INT)
AND ($INT=$INT)
ORDER BY SourcePackagePublishingHistory.datepublished DESC LIMIT $INT
2 77 675 8 667 SQL-launchpad-main-slave
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 = $INT LIMIT $INT |
When trying to load bug 217908 in the following context, I received 2 successive OOPS messages:
https://bugs.launchpad.net/ubuntu/+source/firefox-3.0/+bug/217908
OOPS-1880E1269 |
|
| 2011-02-23 10:43:17 |
William Grant |
launchpad: status |
Fix Committed |
Fix Released |
|
