Status

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

People

(Reporter: clouserw, Assigned: aravind)

Tracking

Details

(Reporter)

Description

8 years ago
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.
(Reporter)

Comment 1

8 years ago
5) Add a cron job to maintenance.php to run "expired_resetcode" once a day
(Assignee)

Updated

8 years ago
Assignee: server-ops → aravind
Wil: this looks ready to go from QA's side; a=stephend
(Reporter)

Comment 3

8 years ago
Thanks Stephen.  We're tagged and ready to go in r24324.
6) Run bin/compatibility_report.php
(Assignee)

Comment 5

8 years ago
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]#
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
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)).
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.