Closed Bug 602998 Opened 14 years ago Closed 14 years ago

Push input.mozilla.com to production on Thursday, 10/14

Categories

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

task
Not set
normal

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: aakashd, Assigned: jabba)

References

Details

(Whiteboard: 10/14/2010 @ 4pm)

We need a push of input.stage.mozilla.com to production on Thursday, 10/14, at 4pm.

The only step to perform now (thanks to the amazing shyam) is to run:

/root/bin/input_update.sh
Flags: needs-downtime+
Whiteboard: 10/14/2010 @ 4pm
Assignee: server-ops → jdow
@aakash - can you quantify the end user impact?  Any downtime?  Or is this hitless? 

I suspect the latter but would like confirmation.
The major change here past some security bugs (that have not been felt in the wild) are that input.mozilla.com/sites and input.mozilla.com/themes can differentiate by product. They did not before. Both are new features, but will affect the current pages. 

So, there is downtime involved here, but only 5 minutes at the minimum and 15 minutes at the maximum (if all hell breaks loose and we're forced to revert). 

If I've missed anything, wenzel and davedash will be able to fill in the rest.
Aakash, I was not aware that there is any downtime.  There's no time when the service will be unavailable unless there are huge data changes.
Ah, my apologies. Dave is right here. There is no downtime involved with this release.
Ok, Stephen says we're QA complete. Dave is going to branch and tag for the release.
Prod is at b0326bc and ready to go.
[root@mradm02 ~]# bin/input_update.sh 
Updating vendor...
remote: Counting objects: 18, done.
remote: Compressing objects: 100% (14/14), done.
remote: Total 14 (delta 10), reused 0 (delta 0)
Unpacking objects: 100% (14/14), done.
From git://github.com/fwenzel/reporter-lib
   5344e11..3915af2  master     -> origin/master
Updating 5344e11..3915af2
Fast-forward
 .gitmodules    |    8 +++++++-
 reporter.pth   |    2 ++
 src/commonware |    1 +
 src/nuggets    |    1 +
 4 files changed, 11 insertions(+), 1 deletions(-)
 create mode 160000 src/commonware
 create mode 160000 src/nuggets
Submodule 'src/commonware' (git://github.com/jsocol/commonware.git) registered for path 'src/commonware'
Submodule 'src/nuggets' (git://github.com/mozilla/nuggets.git) registered for path 'src/nuggets'
Cloning into src/commonware...
remote: Counting objects: 81, done.
remote: Compressing objects: 100% (78/78), done.
remote: Total 81 (delta 36), reused 0 (delta 0)
Receiving objects: 100% (81/81), 11.47 KiB, done.
Resolving deltas: 100% (36/36), done.
Submodule path 'src/commonware': checked out 'd52ee98d95f3ffa0d3114deedaf27f2f220aab24'
Cloning into src/nuggets...
remote: Counting objects: 19, done.
remote: Compressing objects: 100% (18/18), done.
remote: Total 19 (delta 6), reused 0 (delta 0)
Receiving objects: 100% (19/19), 8.89 KiB, done.
Resolving deltas: 100% (6/6), done.
Submodule path 'src/nuggets': checked out 'c628eec49f844fae7bb8ba321f182a94f610eae8'
Updating reporter...
remote: Counting objects: 306, done.
remote: Compressing objects: 100% (132/132), done.
remote: Total 228 (delta 123), reused 181 (delta 88)
Receiving objects: 100% (228/228), 45.40 KiB, done.
Resolving deltas: 100% (123/123), completed with 23 local objects.
From git://github.com/fwenzel/reporter
   012097a..45ebdff  master     -> origin/master
   012097a..b0326bc  prod       -> origin/prod
M	locale
Previous HEAD position was 012097a... Messages from a maemo device are noted as "Linux" on dashboard - Bug 595373
HEAD is now at b0326bc... L10n update (automatic commit)
remote: Counting objects: 339, done.
remote: Compressing objects: 100% (153/153), done.
remote: Total 281 (delta 97), reused 190 (delta 48)
Receiving objects: 100% (281/281), 304.94 KiB, done.
Resolving deltas: 100% (97/97), completed with 4 local objects.
From git://github.com/fwenzel/reporter-locales
   fffbbf8..dfb703e  master     -> origin/master
Submodule path 'locale': checked out 'dfb703ec4849e0e87667c6c7a44887214a5773d5'
Running migration 6:
DROP TABLE theme;

CREATE TABLE `theme` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `pivot_id` integer NOT NULL,
    `num_opinions` integer NOT NULL,
    `feeling` varchar(20) NOT NULL,
    `product` smallint UNSIGNED NOT NULL,
    `platform` varchar(255) NOT NULL,
    `created` datetime NOT NULL
)
;
ALTER TABLE `theme` ADD CONSTRAINT `pivot_id_refs_id_d3ca7add` FOREIGN KEY (`pivot_id`) REFERENCES `feedback_opinion` (`id`);

That took 0.62 seconds
################################################## 

Running migration 7:
ALTER TABLE feedback_opinion ADD KEY `cpvp` (`created`, `product`,`version`,
`positive`);
ALTER TABLE feedback_opinion ADD KEY `product` (`product`,`version`);
ALTER TABLE feedback_opinion ADD KEY `cpv` (`created`, `product`, `version`);
CREATE INDEX p ON theme (platform);
CREATE INDEX np ON theme (num_opinions, product);
CREATE INDEX ts ON theme_item (theme_id, score);


That took 32.99 seconds
################################################## 

/data/input/www /data/input
[master e1a2488] deploy input
 123 files changed, 6418 insertions(+), 3926 deletions(-)
 create mode 100644 django/input.mozilla.com/reporter/apps/feedback/templates/feedback/index.html
 create mode 100644 django/input.mozilla.com/reporter/apps/feedback/templates/feedback/mobile/index.html
 create mode 100644 django/input.mozilla.com/reporter/apps/website_issues/README.md
 rewrite django/input.mozilla.com/reporter/apps/website_issues/forms.py (64%)
 rewrite django/input.mozilla.com/reporter/lib/product_details_json/firefox_beta_builds.json (96%)
 rewrite django/input.mozilla.com/reporter/lib/product_details_json/firefox_primary_builds.json (92%)
 rewrite django/input.mozilla.com/reporter/lib/product_details_json/thunderbird_primary_builds.json (71%)
 rewrite django/input.mozilla.com/reporter/locale/ar/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/bg/LC_MESSAGES/messages.mo (92%)
 rewrite django/input.mozilla.com/reporter/locale/bg/LC_MESSAGES/messages.po (71%)
 rewrite django/input.mozilla.com/reporter/locale/ca/LC_MESSAGES/messages.mo (97%)
 rewrite django/input.mozilla.com/reporter/locale/cs/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/da/LC_MESSAGES/messages.mo (97%)
 rewrite django/input.mozilla.com/reporter/locale/de/LC_MESSAGES/messages.mo (97%)
 rewrite django/input.mozilla.com/reporter/locale/el/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/en_US/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/es/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/fr/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/fy/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/gl/LC_MESSAGES/messages.mo (91%)
 rewrite django/input.mozilla.com/reporter/locale/he/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/hu/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/id/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/it/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/ko/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/nb_NO/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/nl/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/pl/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/pt_PT/LC_MESSAGES/messages.mo (95%)
 rewrite django/input.mozilla.com/reporter/locale/ru/LC_MESSAGES/messages.mo (94%)
 rewrite django/input.mozilla.com/reporter/locale/sk/LC_MESSAGES/messages.mo (97%)
 rewrite django/input.mozilla.com/reporter/locale/sq/LC_MESSAGES/messages.mo (97%)
 rewrite django/input.mozilla.com/reporter/locale/uk/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/vi/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/zh_CN/LC_MESSAGES/messages.mo (96%)
 rewrite django/input.mozilla.com/reporter/locale/zh_TW/LC_MESSAGES/messages.mo (95%)
 create mode 100644 django/input.mozilla.com/reporter/media/css/admin.css
 create mode 100644 django/input.mozilla.com/reporter/migrations/06-themes.sql
 create mode 100644 django/input.mozilla.com/reporter/migrations/07-indexes.sql
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/LICENSE
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/MANIFEST.in
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/README.rst
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/commonware/__init__.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/commonware/log.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/commonware/middleware.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/commonware/setup.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/LICENSE
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/README.rst
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/async_signals.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/celeryutils.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/csrf_context.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/dictconfig.py
 create mode 100644 django/input.mozilla.com/reporter/vendor/src/nuggets/setup.py
/data/input
From git://mradm02/data/input/www
   e5fe19b..e1a2488  master     -> origin/master
===pp-app-input02===

===pp-app-input01===

Restart Apache? [y/n] y
Warning: DocumentRoot [/data/www/default] does not exist
Warning: DocumentRoot [/data/www/default] does not exist
httpd: Could not reliably determine the server's fully qualified domain name, using pp-app-input02.phx.mozilla.com for ServerName
===pp-app-input02===

===pp-app-input01===

Warning: DocumentRoot [/data/www/default] does not exist
Warning: DocumentRoot [/data/www/default] does not exist
[root@mradm02 ~]#
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Verified FIXED, thanks!  1.9 is alive and well.
Status: RESOLVED → VERIFIED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.