584546 - Update addons.mozilla.org on 8/5 @ 1600

Status: VERIFIED FIXED

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

Description

[Wil Clouser [:clouserw]]

Placeholder for tomorrow.  I'll add steps soon.  I don't expect any downtime.

Comment 1

[Jeff Balogh (:jbalogh)]

1. UPDATE reviews SET addon_id=(SELECT addon_id FROM versions WHERE id=version_id);

Comment 2

[matthew zeier [:mrz]]

User facing downtime?  Duration?

Comment 3

[Wil Clouser [:clouserw]]

> I don't expect any downtime.

60 minute duration is fine - I expect it to take less.

Comment 4

[Wil Clouser [:clouserw]]

Ignore comment 1, we'll take care of that.


0) Add the PIL package to boxes (bug 582432).  I guess "run puppet" ?

1) git fetch && git co -f origin/5.11.7

2) git submodule update --init

3) cd vendor; git co -f origin/5.11.7; git submodule update --init; cd ..

4) whack any .pyc files

5) ./manage.py compress_assets

6) schematic migrations

7) Push the new site to the webhead (AMO + SAMO)

8) Clear memcache

9) Restart celeryd

10) New pages for zamboni (copy the regex's from PAMO, ask if there are questions):
- /featured
- /addon/:id/reviews
- /addon/:id/reviews/format:rss

11) import scripts/crontab/prod to crontab

The faster steps 7-10 can be done, the better.

Comment 5

[Wil Clouser [:clouserw]]

if HERA isn't configured in production, we should do that too (as step 12 is fine).  We'll need to set up whatever rules we need to let the production boxes access zeus.

Comment 6

[Jeff Balogh (:jbalogh)]

Hera config requires a push + celeryd restart.

Comment 7

[Jeremy Orem [:oremj]]

+ git fetch -t origin
remote: Counting objects: 931, done.
remote: Compressing objects: 100% (409/409), done.
remote: Total 772 (delta 552), reused 462 (delta 316)
Receiving objects: 100% (772/772), 127.50 KiB, done.
Resolving deltas: 100% (552/552), completed with 100 local objects.
From git://github.com/jbalogh/zamboni
 * [new tag]         5.11.7     -> 5.11.7
+ git checkout 5.11.7
M	locale
Previous HEAD position was 5e4c8e8... make sure we have urls to flush
HEAD is now at 8548e4c... use Translation objects in the tests
+ git submodule update --init
remote: Counting objects: 445, done.
remote: Compressing objects: 100% (147/147), done.
remote: Total 371 (delta 210), reused 371 (delta 210)
Receiving objects: 100% (371/371), 7.77 MiB | 2.60 MiB/s, done.
Resolving deltas: 100% (210/210), completed with 35 local objects.
From git://github.com/clouserw/amo-locales
   d587343..0e838ad  master     -> origin/master
Submodule path 'locale': checked out '0e838ad7aef6d3b50d7739829622a6d6af942679'
+ set +x
+ pushd vendor
+ git fetch -t origin
remote: Counting objects: 30, done.
remote: Compressing objects: 100% (22/22), done.
remote: Total 22 (delta 13), reused 0 (delta 0)
Unpacking objects: 100% (22/22), done.
From git://github.com/jbalogh/zamboni-lib
 * [new tag]         5.11.7     -> 5.11.7
+ git checkout 5.11.7
M	src/django-cache-machine
M	src/hera
M	src/jingo
Previous HEAD position was eab8b58... patch celery to let rabbit fail silently
HEAD is now at a142f7a... updating hera
+ git submodule update --init
remote: Counting objects: 7, done.
remote: Compressing objects: 100% (4/4), done.
remote: Total 4 (delta 3), reused 0 (delta 0)
Unpacking objects: 100% (4/4), done.
From git://github.com/jbalogh/django-cache-machine
   c8af021..989ea31  redis      -> origin/redis
error: You have local changes to 'caching/invalidation.py'; cannot switch branches.
Unable to checkout '989ea31a7e0b372df492d77d4a57bd207e1839de' in submodule path 'src/django-cache-machine'
+ popd vendor
+ set +x
Compess assets? [y/n]: y
Run schematic? [y/n]: y
Running migration 56:
ALTER TABLE `collections`
    ADD `all_personas` bool DEFAULT False;

That took 5.93 seconds
################################################## 

Running migration 57:
CREATE INDEX slug_idx ON collections (slug);

That took 4.91 seconds
################################################## 

Running migration 58:
ALTER TABLE reviews
    CHANGE COLUMN `title` `title` int(11) unsigned NULL,
    CHANGE COLUMN `body` `body` int(11) unsigned NULL;

That took 13.43 seconds
################################################## 

Running migration 59:
CREATE INDEX statuschanged_idx ON files (datestatuschanged, version_id);
CREATE INDEX created_idx ON files (created, version_id);

That took 13.19 seconds
################################################## 

Running migration 60:
DELETE FROM download_sources WHERE id=17 AND name='userprofile';

INSERT INTO download_sources (name, type, created)
    VALUES
    ('version-history', 'full', NOW()),
    ('addon-detail-version', 'full', NOW());

That took 0.10 seconds
################################################## 

Running migration 61:
UPDATE reviews SET addon_id=(SELECT addon_id FROM versions WHERE id=version_id);

That took 1.39 seconds
##################################################

Comment 8

[Jeremy Orem [:oremj]]

Done.

Comment 9

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED.