Missing DB permissions in fix_translations_credits script

Bug #474874 reported by Данило Шеган
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Данило Шеган

Bug Description

During QA of bug #459132, the script ran for a while before erroring out with:

Traceback (most recent call last):
...
  File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/translations/model/potmsgset.py", line 1062, in setTranslationCreditsToTranslated
    lock_timestamp=datetime.datetime.now(pytz.UTC))
  File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/translations/model/potmsgset.py", line 856, in updateTranslation
    force_shared=force_shared, force_diverged=force_diverged)
...
  File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/registry/model/person.py", line 1073, in assignKarma
    if (not self.is_valid_person
...
psycopg2.ProgrammingError: permission denied for relation validpersoncache

Apparently, we are also missing karma SELECT, INSERT, karmaaction SELECT permissions, and potranslation INSERT (for the new automated translation message) permissions, apart from already identified SELECT on teamparticipation and SELECT on validpersoncache.

Related branches

summary: - Missing permission to access validpersoncache in
- fix_translations_credits script
+ Missing DB permissions in fix_translations_credits script
description: updated
Changed in rosetta:
status: Triaged → In Progress
Changed in rosetta:
importance: High → Critical
Ursula Junque (ursinha)
tags: added: current-rollout-blocker
Revision history for this message
Ursula Junque (ursinha) wrote : A commit mentioned this bug
Changed in rosetta:
status: In Progress → Fix Committed
tags: added: qa-needstesting
Changed in rosetta:
status: Fix Committed → Fix Released
milestone: none → 3.1.10
tags: added: qa-ok
removed: qa-needstesting
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.