Permission denied for relation translationtemplatesbuild

[Jeroen T. Vermeulen]

Got this breakage in the branch scanner when trying to generate a translation templates build:

    http://paste.ubuntu.com/499072/

Some extra database privilege on TranslationTemplatesBuild seems to be needed.

[Jeroen T. Vermeulen (jtv)]

OOPS-1727SSMS1

[Launchpad QA Bot (lpqabot)]

Fixed in db-stable r9826 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/db-stable/revision/9826>.

[Jeroen T. Vermeulen (jtv)]

Finally found out why staging wasn't generating jobs for branches that production and development systems say are pottery-compatible: different URL schemes!

https://pastebin.canonical.com/37820/

We should urgently get this working on staging, or we have no production-like environment capable of testing template generation end-to-end.

[Jeroen T. Vermeulen (jtv)]

To explain what went wrong there: exceptions get swallowed somewhere along the line, without any log output that I can find. I wrote a "make harness" script that tests the underlying code, but we can't use "make harness" to test under the right database user.

[Jeroen T. Vermeulen (jtv)]

Thanks, poolie! The failure in the "make harness" script was due to bzr plugins not having been loaded.

By the way, generating TranslationTemplatesBuilds does work locally on a development system, so we can be reasonably confident that the permissions are OK for staging (which is what this bug is about).

Now to find out why we're still not getting jobs created on staging.