504267 - Update addons.mozilla.org on July 15

Status: VERIFIED FIXED

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

Description

[Wil Clouser [:clouserw]]

Please update AMO tomorrow (7/15) and paste all output from all commands into
this bug.  Steps to update:

1) Add the new PAYPAL_* config variables to config.php.  This is confidential stuff.  I can email it to you (who?), or...?

2) Run the SQL in the attachment called 5.0.7.sql.  This may take 10 minutes or so.  Also note that you'll need SUPER privileges as there are two additional triggers.

3) `svn up` addons.mozilla.org.  Note that there are local changes in production from several bugs.  Make sure this merges smoothly.

4) `svn up` services.addons.mozilla.org

5) Restart apache to pick up gettext changes

6) Clear all caches (Zeus, memcache, local cake cache) on both AMO and SAMO.

I still need to tag the site so this bug is serving as advanced notice for now.
Please wait for a comment from me here before updating.  Thanks.

Comment 1

[matthew zeier [:mrz]]

Wednesday night (tonight) right, and not Thursday?  Since it's outside the normal push windows does it need to be announced?

Comment 2

[Wil Clouser [:clouserw]]

Yes, tonight with an announcement please.  Thanks!

Comment 3

[Phong Tran [:phong]]

I will be doing the push tonight.  Can you send me the list of users and attach the sql commands

Comment 4

[Jeremy Orem [:oremj]]

Step 1 is done.

Phong, once the SQL is attached you'll just need to pipe it to MySQL as root.

Comment 5

[Wil Clouser [:clouserw]]

Attachment: 5.0.7.sql

Here is the SQL.  I don't know what you mean by list of users?

Comment 6

[Wil Clouser [:clouserw]]

I was just talking to Jeremy on IRC - between the time the database is updated and the time the code is updated things will be 100% broken on the site.  It may be a good idea to put up a maintenance page for AMO.

We currently have a DISABLE_AMO flag which will redirect all traffic to https://addons.mozilla.org/disabled.php if enabled.  That page looks more like "something is broken and we're panicking" than "updating the site in regular maintenance" but it's better than a blank page.  Perhaps we could tweak the message slightly ahead of time?  What do you think, IT?

Comment 7

[Phong Tran [:phong]]

Did we announce what time we are going to do this tonight?

Comment 8

[Wil Clouser [:clouserw]]

After discussion on IRC:

- We're doing this at 5pm (10 minutes)
- We should redirect AMO/SAMO to status.mozilla.com while we're upgrading

Also, AMO/SAMO are now tagged at r29824 and ready to go.  a=clouserw.  Thanks.

Comment 9

[Phong Tran [:phong]]

Fetching external item into 'bin'
D    bin/schemas
A    bin/font-pack.ttf.zip
U    bin/update-search-views.php
A    bin/run_once/tags2categories.sql
U    bin/maintenance.php
 U   bin
Updated external to revision 29823.


Fetching external item into 'site/vendors/product-details'
U    site/vendors/product-details/localeDetails.class.php
U    site/vendors/product-details/productDetails.class.php
U    site/vendors/product-details/history/thunderbirdHistory.class.php
U    site/vendors/product-details/history/firefoxHistory.class.php
U    site/vendors/product-details/firefoxDetails.class.php
U    site/vendors/product-details/thunderbirdDetails.class.php
Updated external to revision 29822.

Updated to revision 29824.
[root@mradm02 addons.mozilla.org-remora]#

Comment 10

[Phong Tran [:phong]]

updated.

Comment 11

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

QA tested:

* PayPal contributions
* Tagging
* Collections management
* Bug 504129
* Bug 504188

As well as ad-hoc tested; calling this successfully deployed.

Verified FIXED.

Comment 12

[Phong Tran [:phong]]

[root@mradm02 addons.mozilla.org-remora]# svn info
Path: .
URL: http://svn.mozilla.org/addons/tags/prodexternal
Repository Root: http://svn.mozilla.org
Repository UUID: 4eb1ac78-321c-0410-a911-ec516a8615a5
Revision: 29825
Node Kind: directory
Schedule: normal
Last Changed Author: [e-mail]
Last Changed Rev: 29824
Last Changed Date: 2009-07-15 16:49:31 -0700 (Wed, 15 Jul 2009)