483999 - Push SUMO 0.9.5 to production on Tuesday March 24th

Status: VERIFIED FIXED

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

Description

[Laura Thomson :laura]

Details to come, this is just the heads up.

Comment 1

[Laura Thomson :laura]

Renaming release for marketing purposes.

Comment 2

[Laura Thomson :laura]

Tag is http://svn.mozilla.org/projects/sumo/tags/0.9/0.9.5_20090324_r23716/

SQL changes are required, and will follow in this bug

Comment 3

[Laura Thomson :laura]

You'll also need to run 
sudo htaccess.sh
for this release as per https://bugzilla.mozilla.org/show_bug.cgi?id=479848

Comment 4

[Laura Thomson :laura]

SQL to be run.  Please run SQL before doing the svn switch.

https://bug480458.bugzilla.mozilla.org/attachment.cgi?id=364507&t=6b5bGB9Q76

https://bug481316.bugzilla.mozilla.org/attachment.cgi?id=367514 (this one might take a while)

https://bug481303.bugzilla.mozilla.org/attachment.cgi?id=366205

Comment 5

[Laura Thomson :laura]

A couple extra notes on the push.

I have been told by IT that the checkout on prod is set up slightly differently from stage.  Be aware that inside the tag the webroot/ directory is the part that needs to be the document root on apache.  I am not sure if the scripts/ directory is checked out at present but it will be needed after this release, so it would be a good time to check.

The procedure should be as follows:
1.  Update the database as per the above SQL.  The second query is an ALTER TABLE and may take some time to execute.

2.  svn switch to the new tag.

3.  Change into the webroot directory and run 
    sudo htaccess.sh
This updates all of the various htaccess files throughout the directory hierarchy.

4.  After all this is complete, you will need to purge the various caches associated with SUMO so that the push can be verified.  There are three caches that need purging.  They need to be purged in the following order:

4.1 Smarty template cache.  
In webroot/templates_c, rm *.tpl and rm *.tpl.php
In webroot/temp/cache, rm everything *except for* index.php

4.2 Memcache
We do whole page caching in memcache.  The memcache servers we use can be found listed in webroot/db/local.php

4.3 Netscaler

That should be it!  Thanks and good luck.

Comment 6

[Derek Moore [:dmoore]]

Pushed as requested.

Comment 7

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

Verified FIXED; checked several bugs like bug 482212, bug 482474, and bug 474895, among a few others.