487217 - Update AMO on 4/9

Status: VERIFIED FIXED

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

Description

[Wil Clouser [:clouserw]]

Please update AMO on 4/9 and paste the output from all commands into this bug.  Steps involved:

1) There were three changes in config.php:  COMPAT_DEFAULT_VERSION, $compatibility_versions, $version_aliases.  Please make sure all three of those variables are the same as config.php.default.  I suggest just copying that whole section of code into the bottom of your config.php.

2) Run all the database updates for 5.0.4 at https://wiki.mozilla.org/Update:Developers/Database_Changes#5.0.4 .  

3) `svn up` the code

4) Clear all caches including the local cake model cache.

Depending on how long the database changes take this may or may not require downtime.  Let us know either way please.

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

Comment 1

[Wil Clouser [:clouserw]]

5) Add a cron job to maintenance.php to run "expired_resetcode" once a day

Comment 2

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

Wil: this looks ready to go from QA's side; a=stephend

Comment 3

[Wil Clouser [:clouserw]]

Thanks Stephen.  We're tagged and ready to go in r24324.

Comment 4

[Jeff Balogh (:jbalogh)]

6) Run bin/compatibility_report.php

Comment 5

[Aravind Gottipati [:aravind]]

Here is the output.

Step 1:
[root@mradm02 config]# pwd
/data/php5/www/addons.mozilla.org-remora/site/app/config
[root@mradm02 config]# tail -15 config.php
/**
 * Compatibility Center Versions
 */
define('COMPAT_DEFAULT_VERSION', '3.5');                                                                                                                                                                            
global $compatibility_versions;                                                                                                                                                                                     
$compatibility_versions = array(
    '3.0', '3.5', '3.6'
);                                                                                                                                                                                                                  
// Consider all the mapped versions to be the same as the key.
global $version_aliases;                                                                                                                                                                                            
$version_aliases = array(
    '3.5' => array('3.1', '3.5')
);                                                                                                                                                                                                                  

?>
[root@mradm02 config]#
[root@mradm02 config]#


Step 2:
mysql> ALTER TABLE addons ADD COLUMN nominationage DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';                                                                                                                 
Query OK, 9936 rows affected (2.00 sec)
Records: 9936  Duplicates: 0  Warnings: 0

mysql> UPDATE addons SET nominationage = modified;                                                                                                                                                                  
Query OK, 8520 rows affected (0.35 sec)
Rows matched: 9936  Changed: 8520  Warnings: 0

mysql>

mysql>  ALTER TABLE users
    ->  ADD COLUMN
    ->    `resetcode` VARCHAR(255) NOT NULL DEFAULT "" AFTER `confirmationcode`,
    ->  ADD COLUMN
    ->    `resetcode_expires` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `resetcode`;                                                                                                                    
Query OK, 4692804 rows affected (6 min 29.81 sec)
Records: 4692804  Duplicates: 0  Warnings: 0

mysql>


Step 3:  I did not save the entire list.

A whole bunch of updates, and then this.
U    site/app/views/api/recommend_email.thtml
D    site/app/views/elements/fyf_promotion.thtml
U    site/app/views/elements/footer.thtml
U    site/app/views/elements/addon_listitem.thtml
U    site/app/views/elements/addon_discussionheader.thtml
U    site/app/views/elements/install.thtml
Updated external to revision 24323.


Fetching external item into 'bin'
U    bin/compatibility_report.php
U    bin/clean.sh
U    bin/maintenance.php
Updated external to revision 24323.


Fetching external item into 'site/vendors/product-details'
U    site/vendors/product-details/localeDetails.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 24323.

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


Step 4: Done - All files deleted from /data/www/addons.mozilla.org-remora/site/app/tmp/cache, and cache cleared from the load balancer.

Step 5: 
[root@mradm02 cron.d]# grep expired_resetcode  addons-maint 
22 1 * * * root cd /data/php5/www/addons.mozilla.org-remora/bin ; php -f maintenance.php expired_resetcode
[root@mradm02 cron.d]#

Comment 6

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

Verified FIXED; checked https://addons.mozilla.org/en-US/firefox/compatibility, the experimental add-ons' override checkbox, and https://addons.mozilla.org/en-US/editors/queue/nominated (add-on age renaming (and other, smaller fixes)).