462429 - Update AMO and SAMO tonight 10/30

Status: RESOLVED FIXED

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

Description

[Michael Morgan [:morgamic]]

We need to update AMO and SAMO tonight.  It is mostly a code push, but we have some instructions for database and cron jobs coming shortly.  No downtime expected.

Comment 1

[Justin Scott [:fligtar]]

As part of the new compatibility dashboard, please do the following after SVN up:

1. There were several new variables/constants added to config.php. They are here: http://pastebin.mozilla.org/565016 Please add them to production config.php. NETAPP_STORAGE should be a writable location where a file can be read from all web servers.
2. Setup a cron to run this script every hour.
/bin/compatibility_report.php
If this is on dm-stats01, please make sure the above config changes are made there as well, as it will be creating the file in NETAPP_STORAGE that is read by the web servers.

That should be all to get the compatibility dashboard running.

Comment 2

[Michael Morgan [:morgamic]]

We also need to run this SQL to delete spam user accounts:
delete from reviews where user_id in ( select id from users where email like
"%bugmenot.com" );
delete from users where email like "%bugmenot.com" and email !=
"[e-mail]";

Comment 3

[Michael Morgan [:morgamic]]

BTW - previous SQL is from bug 454953.

We also need to run this sql from another spam bug (bug 462449):

delete from translations where id in (248080, 248082, 260926, 260928, 260930,
260932, 260934, 260936, 260938, 260940, 260942, 260946, 260948, 260950, 260952,
260954, 260956, 260958, 260960, 260962, 260964, 260966, 260968, 260970, 260972,
260974, 260976, 260978, 260981, 260983, 260985, 260987, 260989, 260991, 260993,
260995, 260997, 260999, 261001, 261003, 261005, 261007, 261009, 261011, 261013,
261019, 261021);
delete from reviews where body in (248080, 248082, 260926, 260928, 260930,
260932, 260934, 260936, 260938, 260940, 260942, 260946, 260948, 260950, 260952,
260954, 260956, 260958, 260960, 260962, 260964, 260966, 260968, 260970, 260972,
260974, 260976, 260978, 260981, 260983, 260985, 260987, 260989, 260991, 260993,
260995, 260997, 260999, 261001, 261003, 261005, 261007, 261009, 261011, 261013,
261019, 261021);

Comment 4

[Michael Morgan [:morgamic]]

For the config constants, make sure to include everything here:
http://pastebin.mozilla.org/565016

If we don't add the last two items to the config it makes AMO sad.

Comment 5

[Michael Morgan [:morgamic]]

AMO and SAMO are both tagged at r19429.

Comment 6

[Jeremy Orem [:oremj]]

mysql> delete from reviews where user_id in ( select id from users where email like
    -> "%bugmenot.com" );
Query OK, 33 rows affected (0.86 sec)

delete from users where email like "%bugmenot.com" and email !=
    -> "[e-mail]";
Query OK, 439 rows affected (13.82 sec)


mysql> delete from reviews where body in (248080, 248082, 260926, 260928, 260930,
    -> 260932, 260934, 260936, 260938, 260940, 260942, 260946, 260948, 260950, 260952,
    -> 260954, 260956, 260958, 260960, 260962, 260964, 260966, 260968, 260970, 260972,
    -> 260974, 260976, 260978, 260981, 260983, 260985, 260987, 260989, 260991, 260993,
    -> 260995, 260997, 260999, 261001, 261003, 261005, 261007, 261009, 261011, 261013,
    -> 261019, 261021);
Query OK, 43 rows affected (0.05 sec)

delete from translations where id in (248080, 248082, 260926, 260928, 260930,    -> 260932, 260934, 260936, 260938, 260940, 260942, 260946, 260948, 260950, 260952,    -> 260954, 260956, 260958, 260960, 260962, 260964, 260966, 260968, 260970, 260972,    -> 260974, 260976, 260978, 260981, 260983, 260985, 260987, 260989, 260991, 260993,
    -> 260995, 260997, 260999, 261001, 261003, 261005, 261007, 261009, 261011, 261013,
    -> 261019, 261021);
Query OK, 47 rows affected (0.57 sec)


Updated and cache cleared as well.