Note: There are a few cases of duplicates in user autocompletion which are being worked on.

Update addons.mozilla.org on 12/28 @ 1600

VERIFIED FIXED

Status

Infrastructure & Operations
WebOps: Other
VERIFIED FIXED
7 years ago
4 years ago

People

(Reporter: clouserw, Assigned: oremj)

Tracking

other
All
Other
Bug Flags:
needs-downtime +

Details

(Whiteboard: 12/28/2010 @ 4pm)

(Reporter)

Description

7 years ago
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.

Updated

7 years ago
Flags: needs-downtime+
Whiteboard: 12/28/2010 @ 4pm
Assignee: server-ops → jeremy.orem+bugs
(Reporter)

Comment 1

7 years ago
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
(Assignee)

Comment 2

7 years ago
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
(Assignee)

Comment 3

7 years ago
[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
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED

Comment 4

7 years ago
* Deleting users works as per fligtar and jorgev
* Restartless badges are available for Jetpacks. See https://addons.mozilla.org/en-US/firefox/addon/256993/
Status: RESOLVED → VERIFIED
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.