DB privilege error: poimport on TranslationMessage

Bug #878115 reported by Jeroen T. Vermeulen
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Jeroen T. Vermeulen

Bug Description

Just saw a permission-denied error from the translations importer, on TranslationMessage: http://paste.ubuntu.com/713107/

That may seem surprising, since the importer already has SELECT / INSERT / UPDATE on that table. But it makes sense. With translations message sharing, in rare cases, we may have to delete translation messages. We never thought to grant the DELETE privilege though, because it's so rarely needed and we don't normally delete data from this table.

When would we need to delete a TranslationMessage? When a current, diverged TM converges, but can't be updated because there's already an identical non-diverged message in the way. It may have happened before, but the appserver has all the privileges it needs.

Related branches

Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

Fixed in stable r14177 (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/14177) by a commit, but not testable.

tags: added: qa-untestable
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant)
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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