Last Comment Bug 621486 - Update addons.mozilla.org on 12/28 @ 1600
: Update addons.mozilla.org on 12/28 @ 1600
Status: VERIFIED FIXED
12/28/2010 @ 4pm
:
Product: Infrastructure & Operations
Classification: Other
Component: WebOps: Other (show other bugs)
: other
: All Other
: -- normal (vote)
: ---
Assigned To: Jeremy Orem [:oremj]
: matthew zeier [:mrz]
Mentors:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-12-26 22:43 PST by Wil Clouser [:clouserw]
Modified: 2013-10-09 10:29 PDT (History)
8 users (show)
mzeier: needs‑downtime+
See Also:
Due Date:
QA Whiteboard:
Iteration: ---
Points: ---
Cab Review: ServiceNow Change Request (use flag)


Attachments

Description Wil Clouser [:clouserw] 2010-12-26 22:43:13 PST
Please update AMO.  This might not be code, but it will involve some database changes which will read+write lock a couple of tables.  cm-webdev01-master01 took 20-100 seconds for each table (4 tables I think) to finish.  The most popular of these tables is `reviews`.  Your call on whether production is fast enough to not need downtime for this.  Other than those queries, nothing else would need downtime.
Comment 1 Wil Clouser [:clouserw] 2010-12-28 16:04:11 PST
0) Run this migration before pushing out the new code (will take a few minutes): 

    http://pastebin.mozilla.org/902958

    INSERT INTO download_sources (name, type, created) VALUES ('mozcom-', 'prefix', NOW());

    https://bug617963.bugzilla.mozilla.org/attachment.cgi?id=499484

1) [root@mradm02 ~]# ./bin/zamboni_quick_update.sh 5.12.5.5
Compess assets? [y/n]: y
Run schematic? [y/n]: n
Push live? [y/n]: y
Push and restart celeryd? [y/n]: y
2) apply on remora: 

    http://viewvc.svn.mozilla.org/vc?view=revision&revision=79978
Comment 2 Jeremy Orem [:oremj] 2010-12-28 16:07:59 PST
curl 'http://pastebin.mozilla.org/?dl=902958' | python26 manage.py dbshell

mysql> INSERT INTO download_sources (name, type, created) VALUES ('mozcom-',
    -> 'prefix', NOW());
Query OK, 1 row affected (0.02 sec)

[root@mradm02 zamboni]# curl -s 'https://bug617963.bugzilla.mozilla.org/attachment.cgi?id=499484' | python26 manage.py dbshell
[root@mradm02 zamboni]# 

[root@mradm02 ~]# ./bin/zamboni_quick_update.sh 5.12.5.5
+ git fetch -t origin
remote: Counting objects: 51, done.
remote: Compressing objects: 100% (21/21), done.
remote: Total 34 (delta 23), reused 22 (delta 11)
Unpacking objects: 100% (34/34), done.
From git://github.com/jbalogh/zamboni
 * [new tag]         5.12.5.5   -> 5.12.5.5
+ git checkout 5.12.5.5
Previous HEAD position was 74567b7... oops
HEAD is now at cd68cc7...       more padding
+ git submodule update --init
+ set +x
+ git fetch -t origin
remote: Counting objects: 51, done.
remote: Compressing objects: 100% (21/21), done.
remote: Total 34 (delta 23), reused 22 (delta 11)
Unpacking objects: 100% (34/34), done.
From git://github.com/jbalogh/zamboni
 * [new tag]         5.12.5.5   -> 5.12.5.5
+ git checkout 5.12.5.5
Previous HEAD position was 74567b7... oops
HEAD is now at cd68cc7...       more padding
+ git submodule update --init
+ set +x
Compess assets? [y/n]: y
Run schematic? [y/n]: n
Push live? [y/n]: y
Push and restart celeryd? [y/n]: y
Comment 3 Jeremy Orem [:oremj] 2010-12-28 16:09:51 PST
[root@mradm02 addons.mozilla.org-remora]# curl -s 'http://viewvc.svn.mozilla.org/vc/addons/trunk/site/app/controllers/admin_controller.php?r1=79978&r2=79977&pathrev=79978&view=patch' | patch -p 2 
patching file site/app/controllers/admin_controller.php
Hunk #4 succeeded at 289 (offset -2 lines).
Hunk #6 succeeded at 2554 (offset -2 lines).
Hunk #8 succeeded at 2738 (offset -2 lines).
[root@mradm02 addons.mozilla.org-remora]# curl -s 'http://viewvc.svn.mozilla.org/vc/addons/trunk/site/app/controllers/components/audit.php?r1=79978&r2=79977&pathrev=79978&view=patch' | patch -p 2
patching file site/app/controllers/components/audit.php
Comment 4 krupa raj[:krupa] 2010-12-28 16:32:26 PST
* Deleting users works as per fligtar and jorgev
* Restartless badges are available for Jetpacks. See https://addons.mozilla.org/en-US/firefox/addon/256993/

Note You need to log in before you can comment on or make changes to this bug.