Push contents of input.stage to production on 7/29

VERIFIED FIXED

Status

mozilla.org Graveyard
Server Operations
--
major
VERIFIED FIXED
8 years ago
3 years ago

People

(Reporter: aakashd, Assigned: fox2mike)

Tracking

Details

(Whiteboard: 07/29/2010 @ 8am)

(Reporter)

Description

8 years ago
We need to update Input production for our 1.6 release. We
really need to push this out on Thursday, 7/28. Anytime from 12AM - 10AM PST
should suffice on that day.

Things to do:

Ran git pull and git submodule update --init on vendor and reporter directories
and then kicked apache.

1. Wait for Fwenzel's "go"
2. git pull and git submodule update --init on vendor and reporter directories
3. Kick the Apache

Fred can add more if there's anything to mention here.
you'll also need to run the migration tasks:

schematic migrations

in the reporter repo root.  See zamboni, this is being done automatically on staging there, and as part of the regular push.  Oremj can help.
(Assignee)

Updated

8 years ago
Assignee: server-ops → shyam
Whiteboard: 07/28/2010 @ 1am
(In reply to comment #0)
> We need to update Input production for our 1.6 release. We
> really need to push this out on Thursday, 7/28. Anytime from 12AM - 10AM PST
> should suffice on that day.

Do you want 7/28 or Thursday?
(Reporter)

Comment 3

8 years ago
Thursday, 7/29. Pre-morning-tea-typing-fail. Sorry guys.
(Assignee)

Comment 4

8 years ago
And I didn't even check to see the date. late-night-still-waiting-for-sc2-fail.
Summary: Push contents of input.stage to production on 7/28 → Push contents of input.stage to production on 7/29
Whiteboard: 07/28/2010 @ 1am → 07/29/2010 @ 1am
(Reporter)

Updated

8 years ago
Depends on: 582600
(Assignee)

Comment 5

8 years ago
Have some issues with the cronjob on Bug 582600, so pushing back on the push time.
Whiteboard: 07/29/2010 @ 1am → 07/29/2010 @ 8am
All right, I tagged the release, and made a new branch "prod".

Let's do the following:

- git fetch origin
- git checkout prod
- git submodule update --init
- schematic migrations/

and that should be it.
Like we set up m.input.stage, we also need m.input.mozilla.com now. Cf. bug 580597.
(Assignee)

Comment 8

8 years ago
[root@mradm02 reporter]# git fetch origin
remote: Counting objects: 183, done.
remote: Compressing objects: 100% (67/67), done.
remote: Total 136 (delta 70), reused 130 (delta 66)
Receiving objects: 100% (136/136), 23.73 KiB, done.
Resolving deltas: 100% (70/70), completed with 8 local objects.
From git://github.com/fwenzel/reporter
   127ff4b..9627fb5  master     -> origin/master
 * [new branch]      prod       -> origin/prod
   3485ca0..34e1a40  prod-1.5   -> origin/prod-1.5
 * [new tag]         1.6        -> 1.6
[root@mradm02 reporter]# git checkout prod
M       locale
Branch prod set up to track remote branch prod from origin.
Switched to a new branch 'prod'
[root@mradm02 reporter]# git submodule update --init
remote: Counting objects: 731, done.
remote: Compressing objects: 100% (214/214), done.
remote: Total 693 (delta 328), reused 672 (delta 307)
Receiving objects: 100% (693/693), 313.12 KiB | 521 KiB/s, done.
Resolving deltas: 100% (328/328), done.
From git://github.com/fwenzel/reporter-locales
   1c87bca..bbc67b8  master     -> origin/master
Submodule path 'locale': checked out 'c5be085a146daaaee8594ae0c112ce03653101f7'

[root@mradm02 reporter]# cd /data/generic/www/django/input.mozilla.com/reporter/
[root@mradm02 reporter]# schematic migrations
Running migration 1:
ALTER TABLE feedback_opinion ENGINE=InnoDB;

DROP TABLE IF EXISTS feedback_cluster;
DROP TABLE IF EXISTS feedback_clusteritem ;
DROP TABLE IF EXISTS feedback_clustertype;

CREATE TABLE `feedback_cluster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `pivot_id` int(11) NOT NULL,
  `num_opinions` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_cluster_777d41c8` (`type_id`),
  KEY `feedback_cluster_c360d361` (`pivot_id`),
  KEY `feedback_cluster_af507caf` (`num_opinions`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `feedback_clusteritem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cluster_id` int(11) NOT NULL,
  `opinion_id` int(11) NOT NULL,
  `score` double NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_clusteritem_2777883f` (`cluster_id`),
  KEY `feedback_clusteritem_ac81e047` (`opinion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `feedback_clustertype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feeling` varchar(20) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `frequency` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feeling` (`feeling`,`platform`,`version`,`frequency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `feedback_cluster`
  ADD CONSTRAINT FOREIGN KEY (`pivot_id`) REFERENCES `feedback_opinion` (`id`),
  ADD CONSTRAINT FOREIGN KEY (`type_id`) REFERENCES `feedback_clustertype` (`id`);

ALTER TABLE `feedback_clusteritem`
  ADD CONSTRAINT FOREIGN KEY (`cluster_id`) REFERENCES `feedback_cluster` (`id`),
  ADD CONSTRAINT FOREIGN KEY (`opinion_id`) REFERENCES `feedback_opinion` (`id`);


That took 46.55 seconds
################################################## 

Running migration 2:
UPDATE feedback_opinion
    SET os='winxp' WHERE os='win' AND user_agent LIKE '%Windows NT 5.1%';
UPDATE feedback_opinion
    SET os='vista' WHERE os='win' AND user_agent LIKE '%Windows NT 6.0%';
UPDATE feedback_opinion
    SET os='win7' WHERE os='win' AND user_agent LIKE '%Windows NT 6.1%';


That took 29.05 seconds
##################################################

All done, apache kicked.
(Assignee)

Comment 9

8 years ago
So, we didn't update vendor *cough* (thanks Wenzel :p)

[root@mradm02 reporter]# cd -
/data/generic_python/src/input.mozilla.com/reporter
[root@mradm02 reporter]# cd vendor/
[root@mradm02 vendor]# git pull
remote: Counting objects: 35, done.
remote: Compressing objects: 100% (28/28), done.
remote: Total 30 (delta 11), reused 3 (delta 0)
Unpacking objects: 100% (30/30), done.
From git://github.com/fwenzel/reporter-lib
   82e97c7..e657569  master     -> origin/master
Updating 82e97c7..e657569
Fast-forward
 .gitmodules                                        |    6 +
 packages/stemming/PKG-INFO                         |   57 ++
 packages/stemming/pip-delete-this-directory.txt    |    5 +
 .../pip-egg-info/stemming.egg-info/PKG-INFO        |   57 ++
 .../pip-egg-info/stemming.egg-info/SOURCES.txt     |   11 +
 .../stemming.egg-info/dependency_links.txt         |    1 +
 .../pip-egg-info/stemming.egg-info/top_level.txt   |    1 +
 .../pip-egg-info/stemming.egg-info/zip-safe        |    1 +
 packages/stemming/setup.cfg                        |    8 +
 packages/stemming/setup.py                         |   73 +++
 packages/stemming/stemming.egg-info/PKG-INFO       |   57 ++
 packages/stemming/stemming.egg-info/SOURCES.txt    |   12 +
 .../stemming.egg-info/dependency_links.txt         |    1 +
 packages/stemming/stemming.egg-info/top_level.txt  |    1 +
 packages/stemming/stemming.egg-info/zip-safe       |    1 +
 packages/stemming/stemming/lovins.py               |  542 ++++++++++++++++++++
 packages/stemming/stemming/paicehusk.py            |  246 +++++++++
 packages/stemming/stemming/porter.py               |  188 +++++++
 packages/stemming/stemming/porter2.py              |  284 ++++++++++
 reporter.pth                                       |    3 +
 src/django-cronjobs                                |    1 +
 src/textcluster                                    |    1 +
 22 files changed, 1557 insertions(+), 0 deletions(-)
 create mode 100644 packages/stemming/PKG-INFO
 create mode 100644 packages/stemming/pip-delete-this-directory.txt
 create mode 100644 packages/stemming/pip-egg-info/stemming.egg-info/PKG-INFO
 create mode 100644 packages/stemming/pip-egg-info/stemming.egg-info/SOURCES.txt
 create mode 100644 packages/stemming/pip-egg-info/stemming.egg-info/dependency_links.txt
 create mode 100644 packages/stemming/pip-egg-info/stemming.egg-info/top_level.txt
 create mode 100644 packages/stemming/pip-egg-info/stemming.egg-info/zip-safe
 create mode 100644 packages/stemming/setup.cfg
 create mode 100644 packages/stemming/setup.py
 create mode 100644 packages/stemming/stemming.egg-info/PKG-INFO
 create mode 100644 packages/stemming/stemming.egg-info/SOURCES.txt
 create mode 100644 packages/stemming/stemming.egg-info/dependency_links.txt
 create mode 100644 packages/stemming/stemming.egg-info/top_level.txt
 create mode 100644 packages/stemming/stemming.egg-info/zip-safe
 create mode 100644 packages/stemming/stemming/__init__.py
 create mode 100644 packages/stemming/stemming/lovins.py
 create mode 100644 packages/stemming/stemming/paicehusk.py
 create mode 100644 packages/stemming/stemming/porter.py
 create mode 100644 packages/stemming/stemming/porter2.py
 create mode 160000 src/django-cronjobs
 create mode 160000 src/textcluster
[root@mradm02 vendor]# git submodule update --init
Submodule 'src/django-cronjobs' (git://github.com/jsocol/django-cronjobs) registered for path 'src/django-cronjobs'
Submodule 'src/textcluster' (git://github.com/davedash/textcluster) registered for path 'src/textcluster'
Cloning into src/django-cronjobs...
remote: Counting objects: 19, done.
remote: Compressing objects: 100% (17/17), done.
Receiving objects: 100% (19/19), done.
remote: Total 19 (delta 2), reused 0 (delta 0)
Resolving deltas: 100% (2/2), done.
Submodule path 'src/django-cronjobs': checked out 'fa411be81d26619c973ec281c5cce2ce5219bd9c'
Cloning into src/textcluster...
remote: Counting objects: 55, done.
remote: Compressing objects: 100% (48/48), done.
remote: Total 55 (delta 20), reused 0 (delta 0)
Receiving objects: 100% (55/55), 7.69 MiB | 597 KiB/s, done.
Resolving deltas: 100% (20/20), done.
Submodule path 'src/textcluster': checked out '6f5684ce3464f53b6b3ab6b4acdd951aeb682c37'
(Assignee)

Comment 10

8 years ago
All done here, cron is live as well.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
(In reply to comment #7)
> Like we set up m.input.stage, we also need m.input.mozilla.com now. Cf. bug
> 580597.

The mobile URL is still missing, I think?
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Assignee)

Comment 12

8 years ago
m.input.mozilla.com is now live.
Status: REOPENED → RESOLVED
Last Resolved: 8 years ago8 years ago
Resolution: --- → FIXED
Verified FIXED:

* http://m.input.mozilla.com/en-US/
* http://input.mozilla.com/en-US/
Status: RESOLVED → VERIFIED
For the record, https://m.input.mozilla.com throws:

m.input.mozilla.com uses an invalid security certificate.

The certificate is only valid for the following names:
  *.mozilla.com , mozilla.com  

(Error code: ssl_error_bad_cert_domain)


-- I'll file a bug to get this set up, with lower priority.

Updated

8 years ago
Blocks: 583011
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.