The Nonce model needs an index

[Alberto Donato]

The Nonce model needs a (ideally unique) index on (token_key, consumer_key, key).

Aside from granting there to be only one entry for each combination, the index will speed up search for nonces when API calls are performed.

Given Nonce entries are never deleted, the table can grow quite big, and doing a full scan to find if there's a matching entry becomes increasingly more costly.

[Alberto Donato (ack)]

The patch adds the index to the Nonce model

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "diff.diff" seems to be a debdiff. The ubuntu-sponsors team has been subscribed to the bug report so that they can review and hopefully sponsor the debdiff. If the attachment isn't a patch, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are member of the ~ubuntu-sponsors, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issue please contact him.]

[Simon Quigley (tsimonq2)]

Hi Alberto! Apologies for the delay in reviewing your patch.

According to LP #1882949, it seems this package has been removed from Groovy. If you feel this should be SRU'ed, please update the bug description to follow the Stable Release Update guidelines, which can be found here: https://wiki.ubuntu.com/StableReleaseUpdates#SRU_Bug_Template

I have unsubscribed ~ubuntu-sponsors, as there is nothing left to do here. Please resubscribe us if you would like to get this in a stable release.

[Alberto Donato (ack)]

We don't really need this fix SRU'd. maas carries a database patch for the index, and as mentioned the package has been dropped from the archive (and maas has a fixed version in PPAs).

Thanks.