Activity log for bug #474874

Date Who What changed Old value New value Message
2009-11-04 23:15:00 Данило Шеган bug added bug
2009-11-04 23:58:20 Launchpad Janitor branch linked lp:~danilo/launchpad/bug-474874
2009-11-04 23:59:11 Данило Шеган summary Missing permission to access validpersoncache in fix_translations_credits script Missing DB permissions in fix_translations_credits script
2009-11-05 00:02:19 Данило Шеган description During QA of bug #459132, the script ran for a while before erroring out with: Traceback (most recent call last): File "./scripts/rosetta/fix_translation_credits.py", line 28, in ? script.lock_and_run() File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/services/scripts/base.py", line 290, in lock_and_run implicit_begin=implicit_begin, isolation=isolation) File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/services/scripts/base.py", line 248, in run self.main() File "./scripts/rosetta/fix_translation_credits.py", line 22, in main fixer.run() File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/translations/scripts/fix_translation_credits.py", line 98, in run DBLoopTuner(loop, 5).run() File "/srv/staging.launchpad.net/staging/launchpad/lib/canonical/launchpad/utilities/looptuner.py", line 107, in run self.operation(chunk_size) File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/translations/scripts/fix_translation_credits.py", line 74, in __call__ potmsgset.setTranslationCreditsToTranslated(pofile) 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/translations/model/potmsgset.py", line 625, in _makeTranslationMessageCurrent sourcepackagename=pofile.potemplate.sourcepackagename) File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/registry/model/person.py", line 1073, in assignKarma if (not self.is_valid_person File "/srv/staging.launchpad.net/staging/launchpad/lib/lp/registry/model/person.py", line 1061, in is_valid_person ValidPersonCache.get(self.id) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/sqlobject.py", line 321, in get obj = store.get(cls, id) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/store.py", line 179, in get result = self._connection.execute(select) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/databases/postgres.py", line 249, in execute return Connection.execute(self, statement, params, noresult) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 217, in execute raw_cursor = self.raw_execute(statement, params) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/databases/postgres.py", line 259, in raw_execute return Connection.raw_execute(self, statement, params) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 299, in raw_execute self._check_disconnect(raw_cursor.execute, *args) File "/srv/staging.launchpad.net/staging/launchpad/eggs/storm-0.15-py2.4-linux-x86_64.egg/storm/database.py", line 342, in _check_disconnect return function(*args, **kwargs) psycopg2.ProgrammingError: permission denied for relation validpersoncache 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.
2009-11-05 00:02:26 Данило Шеган rosetta: status Triaged In Progress
2009-11-05 16:00:57 Данило Шеган rosetta: importance High Critical
2009-11-05 16:46:17 Ursula Junque tags current-rollout-blocker
2009-11-05 19:27:36 Ursula Junque rosetta: status In Progress Fix Committed
2009-11-05 19:27:39 Ursula Junque tags current-rollout-blocker current-rollout-blocker qa-needstesting
2009-11-09 13:34:12 Данило Шеган rosetta: status Fix Committed Fix Released
2009-11-09 13:34:14 Данило Шеган rosetta: milestone 3.1.10
2009-11-09 13:34:24 Данило Шеган tags current-rollout-blocker qa-needstesting current-rollout-blocker qa-ok