639688 - production deploy demos.mozilla.org 1.2 release aka Phase II

Status: VERIFIED FIXED

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

Description

[Austin King [:ozten]]

Hi Jeremy, we have a web code + db migration push.

We need to do this Wed night or Thursday. What time works for you?

We need it to also be a time when Paul is available.

Comment 1

[Austin King [:ozten]]

Instructions:
1) webowonder - Update from the prod branch
git pull origin prod 
2) webowonder-demos
git pull origin master
3) run db migrations
Use the update process we used for the initial release to get new CSS, JS, and db migrations. This was probably:
./bin/update-site.py -e prod

This is a small release to show the next round of demos off.

Comment 2

[Shyam Mani [:fox2mike]]

Just so you know, Jeremy is on PTO this week. So this will either be pushed by Corey or me. We'll aim for thursday.

Comment 3

[Austin King [:ozten]]

(In reply to comment #2)
Can we plan out a window of time, so we're sure Paul and others are available to debug issues? He is in France (timezone wise)

Comment 4

[Laura Mesa [:lmesa] [:lvmesa]]

(In reply to comment #3)
> (In reply to comment #2)
> Can we plan out a window of time, so we're sure Paul and others are available
> to debug issues? He is in France (timezone wise)

Also, Paul is only available after 1pm PST. Can we try and ship around that time?  We just need him available in case something breaks.

Comment 5

[Austin King [:ozten]]

CCing Infrasec and WebQA.

We'll update the bug once we're code complete, but this is an incremental change to the WoW project, release 1.2.

Comment 6

[Austin King [:ozten]]

We are dev complete. Ready for QA / Infrasec review.

Comment 7

[Austin King [:ozten]]

Production git branch updated and tagged 1.2.0.

Ready for release tomorrow @4pmish. 

Note: tainting stage with 1.3 work today.

Comment 8

[Austin King [:ozten]]

Comment #1 is still accurate, we pull from the prod branch on the Django app.

One missing step - update locales:

cd locale
svn update 
./compile_mo.sh .

Comment 9

[Corey Shields [:cshields]]

[root@pp-app-generic03 webowonder]# python2.6 vendor/src/schematic/schematic migrations
Running migration 21:
UPDATE demos_submission SET hidden = b'0' WHERE slug IN ('globetweeter', 'shadows', 'motivational', 'immersivevideo');
That took 0.02 seconds
################################################## 

Running migration 22:
UPDATE wow_demodetails SET rank=1 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'shadows');
UPDATE wow_demodetails SET rank=2 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'immersivevideo');
UPDATE wow_demodetails SET rank=3 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'globetweeter');
UPDATE wow_demodetails SET rank=4 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'motivational');
UPDATE wow_demodetails SET rank=5 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'remixingreality');
UPDATE wow_demodetails SET rank=6 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'londonproject');
UPDATE wow_demodetails SET rank=7 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'dashboard');

UPDATE auth_user SET first_name = 'Simurai', last_name = '' WHERE username = 'simurai';
That took 0.02 seconds
################################################## 

Running migration 23:

UPDATE demos_submission SET source_code_url = 'https://github.com/simurai/shadows/' WHERE slug = 'shadows';

UPDATE demos_submission SET source_code_url = 'https://github.com/paulrouget/motivational/' WHERE slug = 'motivational';

UPDATE demos_submission SET source_code_url = 'https://github.com/cedricpinson/globetweeter/' WHERE slug = 'globetweeter';

UPDATE demos_submission SET source_code_url = 'https://github.com/paulrouget/immersivevideo/' WHERE slug = 'immersivevideo';
That took 0.02 seconds
################################################## 

Running migration 24:

UPDATE demos_submission SET hidden = b'1' WHERE slug IN ('globetweeter');
That took 0.02 seconds
################################################## 

Running migration 25:

-- Phase III demos
UPDATE demos_submission SET hidden = b'0' WHERE slug IN ('runfield', 'planetarium');

-- Sort demos
UPDATE wow_demodetails SET rank=1 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'planetarium');
UPDATE wow_demodetails SET rank=2 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'runfield');
UPDATE wow_demodetails SET rank=3 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'shadows');
UPDATE wow_demodetails SET rank=4 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'immersivevideo');
UPDATE wow_demodetails SET rank=5 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'globetweeter');
UPDATE wow_demodetails SET rank=6 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'motivational');
UPDATE wow_demodetails SET rank=7 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug ='remixingreality');
UPDATE wow_demodetails SET rank=8 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'londonproject');
UPDATE wow_demodetails SET rank=9 WHERE demo_id = (SELECT id FROM demos_submission WHERE slug = 'dashboard');
That took 0.02 seconds
##################################################

Comment 10

[raymond [:retornam] (inactive)]

https://demos.mozilla.org/en-US/

Comment 11

[Austin King [:ozten]]

I've confused myself.

We should have released the code tagged 1.2.0. per Comment #7.

This is easy to fix, but will sound scary.

This is done regularly in development. There is no user generated content in the db, only migrations.

As a precaution, you may backup the prod database.

Assuming webowonder's database is named wow
1) log into mysql 
2) drop database wow; create database wow;
3) git update to the tag 1.2.0
4) re-run db migration

python2.6 vendor/src/schematic/schematic migrations/

Comment 12

[Austin King [:ozten]]

Spoke with Corey, the will cycle back to us around 9pm.

!!!My comments in 11 above... should be ignored!!!

I don't see this issue if I check out a fresh copy of the prod branch.

Production should not show planetarium and runfeild, however those are only in the master branch (migrations/25-phase-III.sql).

So let's troubleshoot at 9pm, before doing anything.

Comment 13

[Austin King [:ozten]]

UPDATE demos_submission SET hidden = b'0' WHERE slug IN ('runfield', 'planetarium');

This will hide the two demos.

Comment 14

[Austin King [:ozten]]

Production is in a happy state.

Comment 15

[raymond [:retornam] (inactive)]

verified fixed https://demos.mozilla.org/en-US/