636799 - [amo] Update zamboni to 5.12.11.4

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Jeff Balogh (:jbalogh)]

This is a code update + rewrite changes + manual sql.

1) Make the RewriteCond changes we worked out on preview.

2) Run this SQL:

ALTER TABLE `approvals`
    DROP FOREIGN KEY `approvals_ibfk_3`;

ALTER TABLE `approvals` ADD CONSTRAINT `approvals_ibfk_3`
    FOREIGN KEY `approvals_ibfk_3` (`addon_id`)
    REFERENCES `addons` (`id`)
    ON DELETE CASCADE;

3) # ./bin/zamboni_quick_update.sh 5.12.11.4
    Disable cron? [y/n]: n
    Update locales? [y/n]: n
    Compress assets? [y/n]: n
    Run schematic? [y/n]: n
    Push live? [y/n]: y
    Push and restart celeryd? [y/n]: y
    Clear redis/memcache? [y/n]: n
    Enable cron? [y/n]: y

Thanks!

Comment 1

[Jeremy Orem [:oremj]]

1) Done.

mysql> ALTER TABLE `approvals`
    ->     DROP FOREIGN KEY `approvals_ibfk_3`;
Query OK, 37629 rows affected (2.16 sec)
Records: 37629  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `approvals` ADD CONSTRAINT `approvals_ibfk_3`
    ->     FOREIGN KEY `approvals_ibfk_3` (`addon_id`)
    ->     REFERENCES `addons` (`id`)
    ->     ON DELETE CASCADE;
Query OK, 37629 rows affected (1.55 sec)
Records: 37629  Duplicates: 0  Warnings: 0

[root@mradm02 ~]# ./bin/zamboni_quick_update.sh 5.12.11.4
Disable cron? [y/n]: n
+ update_code
+ git_checkout_tag 5.12.11.4
+ TAG=5.12.11.4
+ git fetch -t origin
remote: Counting objects: 47, done.
remote: Compressing objects: 100% (30/30), done.
remote: Total 32 (delta 24), reused 0 (delta 0)
Unpacking objects: 100% (32/32), done.
From git://github.com/jbalogh/zamboni
 * [new tag]         5.12.11.4  -> 5.12.11.4
+ git checkout 5.12.11.4
Previous HEAD position was 046713d... ignore collections with an addon_index, they were created by zamboni
HEAD is now at 5c35679... bug 626625, redirect feed/all to feed/
+ git submodule update --init
+ [[ 0 == 1 ]]
+ [[ ! -z '' ]]
+ set +x
Update locales? [y/n]: n
Compress assets? [y/n]: n
Run schematic? [y/n]: n
Push live? [y/n]: y
Push and restart celeryd? [y/n]: y