process-accepted, publish-distro, process-death-row, buildd-retry-depwait and generate-contents-files should use their own DB users

Bug #815753 reported by William Grant on 2011-07-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
Stuart Bishop

Bug Description

The big publication scripts (process-accepted, publish-distro, process-death-row, and generate-contents-files) should run as distinct DB users, to allow people and scripts to distinguish their DB connections.

Related branches

Stuart Bishop (stub) wrote :

https://code.launchpad.net/~stub/launchpad/db-cleanups/+merge/69038 fixes generate-contents-files and publish-ftpmaster

Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
assignee: nobody → Stuart Bishop (stub)
tags: added: qa-needstesting
Changed in launchpad:
status: Triaged → Fix Committed
William Grant (wgrant) wrote :

Note that publish-ftpmaster is not in use yet.

Stuart Bishop (stub) on 2011-07-26
Changed in launchpad:
assignee: Stuart Bishop (stub) → nobody
status: Fix Committed → Triaged
Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
assignee: nobody → Stuart Bishop (stub)
status: Triaged → Fix Committed
Stuart Bishop (stub) on 2011-08-29
Changed in launchpad:
status: Fix Committed → Triaged
assignee: Stuart Bishop (stub) → nobody
tags: removed: qa-needstesting
Francis J. Lacoste (flacoste) wrote :

Why was this set to Critical? Was it causing production issues?

tags: added: critical-analysis
Stuart Bishop (stub) wrote :

Its a fastdowntime issue. These processes where all connecting as the same user (archivepublisher), but only some of them need to be shutdown manually before a fastdowntime deployment.

tags: added: qa-untestable
Stuart Bishop (stub) wrote :

Also buildd-retry-depwait

summary: - process-accepted, publish-distro, process-death-row and generate-
- contents-files should use their own DB users
+ process-accepted, publish-distro, process-death-row, buildd-retry-
+ depwait and generate-contents-files should use their own DB users
Stuart Bishop (stub) wrote :

Also process-upload.py

Launchpad QA Bot (lpqabot) wrote :
Changed in launchpad:
assignee: nobody → Stuart Bishop (stub)
tags: added: qa-needstesting
removed: qa-untestable
Changed in launchpad:
status: Triaged → Fix Committed
William Grant (wgrant) on 2011-09-25
tags: added: qa-ok
removed: qa-needstesting
William Grant (wgrant) on 2011-09-27
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers