Freeze Break Request: Fedora Tagger Schema

Kevin Fenzi kevin at scrye.com
Thu May 16 16:33:38 UTC 2013


On Thu, 16 May 2013 11:27:44 -0400
Ralph Bean <rbean at redhat.com> wrote:

> This is a second freeze break request for Fedora Tagger.  I haven't
> actually carried out the first one yet, but Kevin's mention of the
> broken bodhi sqlitebuildtags url took us down a rabbit hole.
> 
> This is the traceback that tagger logs when the bodhi masher tries to
> pull down its sqlitebuildtags:

...snip...

> The problem is that the schema upgrade from tagger1 to tagger2 didn't
> go smoothly in production, and we didn't notice.  There is supposed to
> be a DB constraint that disallows duplicate tags on packages, but it
> is absent.
> 
> We can't just apply that new constraint, because there are now two
> duplicate tags in the DB.
> 
> We need to:
> 
>   1) Remove the duplicates
>   2) Apply the constraint so it doesn't happen again

Can we test this in stg first? Then if all goes well do it in prod? 

+1 if we can do that to make sure there's no thinkos in the script,
etc. 

(we should be able to dump/restore the db over to stg from prod so it
has the same data too, right?)

kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.fedoraproject.org/pipermail/infrastructure/attachments/20130516/cb123648/attachment-0001.sig>


More information about the infrastructure mailing list