425293 - Deploy AMO 3.2

Status: VERIFIED FIXED

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

Description

[Michael Morgan [:morgamic]]

Tracking bug for 3.2 deployment.

Comment 1

[Michael Morgan [:morgamic]]

We have tagged prodexternal at 11623, and it's ready to go with an SVN.

For this run-through:
1) update SVN first!
2) do database updates below

Alright, so there are a list of db changes to be made here:
http://wiki.mozilla.org/Update:Developers/Database_Changes

In short:
UPDATE `reviews` SET `rating` = `rating`/2 WHERE `rating` > 0 AND `rating` IS NOT NULL;
UPDATE `LUM_Discussion` SET `Closed`=1;

Comment 2

[Wil Clouser [:clouserw]]

Justin's got a database change on there from 2008-03-05 that is marked as "To be run in production" - what about that one?

Comment 3

[Michael Morgan [:morgamic]]

That's for log parsing, don't have to push that right now - so just the two queries in comment #1.

Comment 4

[Jeremy Orem [:oremj]]

Updated and

mysql> UPDATE `reviews` SET `rating` = `rating`/2 WHERE `rating` > 0 AND `rating` IS
    -> NOT NULL;
Query OK, 15165 rows affected (0.24 sec)
Rows matched: 15165  Changed: 15165  Warnings: 0

mysql> UPDATE `LUM_Discussion` SET `Closed`=1;
Query OK, 9410 rows affected (0.13 sec)
Rows matched: 9410  Changed: 9410  Warnings: 0

Comment 5

[Michael Morgan [:morgamic]]

Need help tracking down the nagios checks, or do you have that under control?

Comment 6

[Michael Morgan [:morgamic]]

Also we need an apache restart for gettext changes.

Comment 7

[Michael Morgan [:morgamic]]

Need apache restart, this is probably causing the string failures in nagios...

Comment 8

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

Verified FIXED; deployed.