518148 - Prod mozillaservice.org database schema migration, cron and webcode update

Status: RESOLVED FIXED

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

Description

[Austin King [:ozten]]

On Production mozillaservice.org
Please do the following steps:

This procedure is very quick, but may require downtime...

1) Put up a site wide (maintance page)
2) disable the cron job trunk/bin/update-metrics.sh 
3) svn up on trunk
4) Run trunk/database/schema_012.sql
5) re-enable the cron job trunk/bin/update-metrics.sh 
6) clear memcached and NS caches
7) Put site back into production

Please paste an error output here. Stage tested these instructions in Bug#517981

Comment 1

[Mary]

Hi there:  Would it be possible to get this pushed during tonight's window?

Comment 2

[Shyam Mani [:fox2mike]]

Yup, I'll get it tonight.

Comment 3

[Shyam Mani [:fox2mike]]

1) Cron disabled
2) [root@mradm02 mozillaservice.org]# svn up
U    bin/update-metrics.py
U    web/application/models/metric.php
U    web/application/controllers/layout.php
U    web/application/views/template.php
Updated to revision 52182.

3) mysql> ALTER TABLE metrics ADD COLUMN hours_completed_total INT(11) UNSIGNED NOT NULL AFTER hours_pledged_total;
Query OK, 1 row affected (0.25 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> UPDATE metrics SET hours_completed_total = (
    ->     SELECT SUM(hours_completed) FROM pledges WHERE processed = true
    -> ), updated = UNIX_TIMESTAMP();
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

4) Cron re-enabled.

5) Caches flushed.

Done.

Comment 4

[Austin King [:ozten]]

This looks good.