Distribution:+bugs-index time outs
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Robert Collins |
Bug Description
OOPS-1839G1380
https:/
11. 207 14060ms SQL-launchpad-
SELECT BugTask.assignee,
BugTask.bug,
BugTask.id,
FROM BugTask
JOIN Bug ON BugTask.bug = Bug.id
WHERE Bug.id = BugTask.bug
AND BugTask.
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.private = FALSE
ORDER BY Bug.heat DESC, BugTask.id LIMIT 40
OFFSET 0
Related branches
- Jonathan Lange (community): Abstain
- Stuart Bishop (community): Approve
-
Diff: 71 lines (+12/-5)2 files modifiedlib/lp/bugs/browser/bugtarget.py (+1/-1)
lib/lp/bugs/model/bugtask.py (+11/-4)
- Launchpad code reviewers: Pending requested
-
Diff: 5399 lines (+2369/-742)98 files modifiedconfigs/development/launchpad-lazr.conf (+0/-4)
configs/testrunner/launchpad-lazr.conf (+0/-3)
database/sampledata/current-dev.sql (+149/-113)
database/sampledata/current.sql (+144/-109)
database/schema/comments.sql (+4/-3)
database/schema/launchpad_session.sql (+25/-0)
database/schema/patch-2208-51-0.sql (+18/-0)
database/schema/patch-2208-52-0.sql (+14/-0)
database/schema/patch-2208-53-0.sql (+20/-0)
database/schema/patch-2208-54-0.sql (+6/-0)
database/schema/patch-2208-55-0.sql (+24/-0)
database/schema/patch-2208-56-0.sql (+33/-0)
database/schema/patch-2208-57-1.sql (+14/-0)
database/schema/patch-2208-59-0.sql (+38/-0)
database/schema/security.cfg (+6/-0)
database/schema/security.py (+182/-99)
database/schema/trusted.sql (+14/-0)
lib/canonical/config/schema-lazr.conf (+5/-8)
lib/canonical/launchpad/database/message.py (+2/-0)
lib/canonical/launchpad/interfaces/message.py (+2/-0)
lib/canonical/launchpad/pagetests/basics/notfound-traversals.txt (+1/-1)
lib/canonical/launchpad/pagetests/webservice/xx-hide-comments.txt (+2/-2)
lib/canonical/launchpad/security.py (+23/-8)
lib/canonical/launchpad/zcml/message.zcml (+4/-3)
lib/lp/app/stories/launchpad-root/site-search.txt (+5/-3)
lib/lp/archivepublisher/config.py (+8/-7)
lib/lp/archivepublisher/deathrow.py (+2/-7)
lib/lp/archivepublisher/interfaces/publisherconfig.py (+58/-0)
lib/lp/archivepublisher/model/publisherconfig.py (+68/-0)
lib/lp/archivepublisher/publishing.py (+1/-6)
lib/lp/archivepublisher/tests/test_publisherconfig.py (+92/-0)
lib/lp/archivepublisher/zcml/configure.zcml (+25/-1)
lib/lp/bugs/browser/bugcomment.py (+1/-1)
lib/lp/bugs/configure.zcml (+5/-1)
lib/lp/bugs/doc/bugmessage-visibility.txt (+9/-8)
lib/lp/bugs/doc/bugnotification-sending.txt (+9/-3)
lib/lp/bugs/enum.py (+4/-4)
lib/lp/bugs/interfaces/bug.py (+1/-1)
lib/lp/bugs/interfaces/bugmessage.py (+0/-2)
lib/lp/bugs/mail/bugnotificationrecipients.py (+11/-0)
lib/lp/bugs/model/bug.py (+1/-1)
lib/lp/bugs/model/bugmessage.py (+0/-1)
lib/lp/bugs/model/bugnotification.py (+11/-0)
lib/lp/bugs/model/structuralsubscription.py (+4/-3)
lib/lp/bugs/security.py (+2/-7)
lib/lp/bugs/stories/bugs/xx-bug-hidden-comments.txt (+1/-1)
lib/lp/bugs/tests/test_bug_messages_webservice.py (+1/-1)
lib/lp/code/model/tests/test_recipebuilder.py (+2/-2)
lib/lp/registry/adapters.py (+10/-0)
lib/lp/registry/browser/configure.zcml (+8/-8)
lib/lp/registry/browser/distribution.py (+75/-2)
lib/lp/registry/browser/distroseries.py (+70/-28)
lib/lp/registry/browser/tests/test_distribution_views.py (+167/-0)
lib/lp/registry/browser/tests/test_series_views.py (+127/-8)
lib/lp/registry/configure.zcml (+8/-1)
lib/lp/registry/doc/distroseries.txt (+8/-4)
lib/lp/registry/interfaces/distribution.py (+7/-2)
lib/lp/registry/interfaces/distroseries.py (+7/-2)
lib/lp/registry/interfaces/distroseriesdifference.py (+7/-3)
lib/lp/registry/model/distribution.py (+10/-5)
lib/lp/registry/model/distroseries.py (+8/-3)
lib/lp/registry/model/distroseriesdifference.py (+13/-7)
lib/lp/registry/stories/distribution/xx-distribution-launchpad-usage.txt (+24/-1)
lib/lp/registry/stories/distribution/xx-distribution-overview.txt (+3/-1)
lib/lp/registry/stories/distroseries/xx-distroseries-index.txt (+3/-1)
lib/lp/registry/stories/distroseries/xx-reassign-distroseries.txt (+0/-72)
lib/lp/registry/stories/webservice/xx-distribution.txt (+1/-0)
lib/lp/registry/stories/webservice/xx-distroseries.txt (+2/-1)
lib/lp/registry/templates/distribution-index.pt (+2/-2)
lib/lp/registry/templates/distroseries-index.pt (+2/-5)
lib/lp/registry/templates/distroseries-localdifferences.pt (+9/-0)
lib/lp/registry/templates/packagesearch-macros.pt (+3/-6)
lib/lp/registry/tests/test_distribution.py (+111/-3)
lib/lp/registry/tests/test_distributionsourcepackage.py (+2/-1)
lib/lp/registry/tests/test_distroseries.py (+9/-0)
lib/lp/registry/tests/test_pillarname_triggers.py (+10/-7)
lib/lp/scripts/garbo.py (+86/-8)
lib/lp/scripts/tests/test_garbo.py (+161/-4)
lib/lp/scripts/utilities/sanitizedb.py (+16/-3)
lib/lp/services/configure.zcml (+1/-0)
lib/lp/services/session/adapters.py (+40/-0)
lib/lp/services/session/configure.zcml (+12/-0)
lib/lp/services/session/interfaces.py (+15/-0)
lib/lp/services/session/model.py (+47/-0)
lib/lp/services/session/tests/test_session.py (+32/-0)
lib/lp/soyuz/doc/archive-dependencies.txt (+73/-73)
lib/lp/soyuz/doc/archive.txt (+8/-5)
lib/lp/soyuz/doc/distroseriesqueue-translations.txt (+30/-30)
lib/lp/soyuz/doc/publishing.txt (+5/-2)
lib/lp/soyuz/interfaces/distroarchseries.py (+3/-1)
lib/lp/soyuz/model/archive.py (+5/-4)
lib/lp/soyuz/scripts/tests/test_publishdistro.py (+8/-3)
lib/lp/soyuz/stories/distroseries/add-architecture.txt (+10/-0)
lib/lp/soyuz/tests/test_packageupload.py (+16/-8)
lib/lp/testing/factory.py (+31/-5)
lib/lp/testing/tests/test_standard_test_template.py (+5/-4)
lib/lp/translations/browser/tests/test_sharing_information.py (+6/-4)
utilities/soyuz-sampledata-setup.py (+2/-2)
tags: | added: pg83 |
Changed in launchpad: | |
importance: | High → Critical |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
summary: |
- Distribution:+bugs-index timing out in ~2% of requests + Distribution:+bugs-index time outs |
description: | updated |
tags: | removed: pg83 |
description: | updated |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Just got a timeout on https:/ /bugs.launchpad .net/ubuntu
OOPS-1839G1380