[amo] Update zamboni to 5.12.11.4

RESOLVED FIXED

Status

--
minor
RESOLVED FIXED
8 years ago
5 years ago

People

(Reporter: jbalogh, Assigned: oremj)

Tracking

Details

(Reporter)

Description

8 years ago
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!
(Reporter)

Updated

8 years ago
Assignee: server-ops → jeremy.orem+bugs
(Assignee)

Comment 1

8 years ago
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
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.