Last Comment Bug 487217 - Update AMO on 4/9
: Update AMO on 4/9
Product: Infrastructure & Operations
Classification: Other
Component: WebOps: Other (show other bugs)
: other
: All Other
-- normal (vote)
: ---
Assigned To: Aravind Gottipati [:aravind]
: matthew zeier [:mrz]
Depends on:
  Show dependency treegraph
Reported: 2009-04-07 07:40 PDT by Wil Clouser [:clouserw]
Modified: 2013-10-09 10:29 PDT (History)
9 users (show)
See Also:
Due Date:
QA Whiteboard:
Iteration: ---
Points: ---
Cab Review: ServiceNow Change Request (use flag)


Description User image Wil Clouser [:clouserw] 2009-04-07 07:40:45 PDT
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 .  

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 User image Wil Clouser [:clouserw] 2009-04-07 16:22:25 PDT
5) Add a cron job to maintenance.php to run "expired_resetcode" once a day
Comment 2 User image Stephen Donner [:stephend] 2009-04-09 16:51:35 PDT
Wil: this looks ready to go from QA's side; a=stephend
Comment 3 User image Wil Clouser [:clouserw] 2009-04-09 16:56:42 PDT
Thanks Stephen.  We're tagged and ready to go in r24324.
Comment 4 User image Jeff Balogh (:jbalogh) 2009-04-09 18:22:50 PDT
6) Run bin/compatibility_report.php
Comment 5 User image Aravind Gottipati [:aravind] 2009-04-09 19:46:19 PDT
Here is the output.

Step 1:
[root@mradm02 config]# pwd
[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>  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


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/
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.

Step 4: Done - All files deleted from /data/www/, 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/ ; php -f maintenance.php expired_resetcode
[root@mradm02 cron.d]#
Comment 6 User image Stephen Donner [:stephend] 2009-04-09 20:26:28 PDT
Verified FIXED; checked, the experimental add-ons' override checkbox, and (add-on age renaming (and other, smaller fixes)).

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