Push SUMO 1.5 to production on Thursday 12/3

VERIFIED FIXED

Status

Infrastructure & Operations
WebOps: Other
VERIFIED FIXED
8 years ago
4 years ago

People

(Reporter: jsocol, Assigned: chizu)

Tracking

other
All
Other
Bug Flags:
needs-downtime +

Details

(Whiteboard: 12/03/2009 @ 6pm)

(Reporter)

Description

8 years ago
This is a slightly more complex push:

We'll need to move production's search onto the Sphinx cluster, update some related configuration, and make sure that Aspell, Pspell, and the Aspell dictionaries are installed. And of course the SVN switch. (We don't have a tag yet, I'll update the bug.)

And I'll double check but I don't believe there are any SQL changes.
(Reporter)

Updated

8 years ago
Depends on: 532511

Updated

8 years ago
Flags: needs-downtime+
Whiteboard: 12/03/2009 @ 8pm

Comment 1

8 years ago
Is there enough detail in comment #0 to do this push?
(Reporter)

Comment 2

8 years ago
(In reply to comment #1)
> Is there enough detail in comment #0 to do this push?

Tagging and collecting the additional info right now.

Updated

8 years ago
Whiteboard: 12/03/2009 @ 8pm → 12/03/2009 @ 6pm
(Assignee)

Updated

8 years ago
Assignee: server-ops → thardcastle
(Reporter)

Comment 3

8 years ago
Tag is:
https://svn.mozilla.org/projects/sumo/tags/1.5/1.5_r52715_20091203

SQL patches:
https://bugzilla.mozilla.org/attachment.cgi?id=400141
https://bugzilla.mozilla.org/attachment.cgi?id=393952

Other changes:
Move to Sphinx cluster
Ensure Aspell, Aspell dictionaries, Pspell are available

Non-IT checks (things we need to do post push):
Settings in bug 529029
Updated content block in bug 530195
Update search weights from bug 529681
Turn on pref from bug 506166
Edit modules from bug 526638
Change pref from bug 527959 comment 4
Change pref from bug 520941

After those changes, we'll probably need to flush caches.
(Assignee)

Comment 4

8 years ago
php-pspell, aspell, and the dictionaries installed.
(Assignee)

Comment 5

8 years ago
New sphinx daemon deployed and tested. Rotates every 15 minutes.
(Assignee)

Comment 6

8 years ago
Switched to:
URL: https://svn.mozilla.org/projects/sumo/tags/1.5/1.5_r52715_20091203
Repository Root: https://svn.mozilla.org
Repository UUID: 4eb1ac78-321c-0410-a911-ec516a8615a5
Revision: 57251

mysql> INSERT INTO users_permissions (`permName`, `permDesc`, `level`, `type`) values('tiki_p_newsearch_advanced', 'Can use advanced newsearch', 'editors', 'search');
Query OK, 1 row affected (0.01 sec)

mysql> CREATE TABLE `events_event` (
    ->  `event_id` int(11) NOT NULL auto_increment,
    ->  `event_name` varchar(255) NOT NULL,
    ->  `event_date` timestamp NULL default NULL,
    ->  `event_signuptext` blob NOT NULL,
    ->  `event_canceltext` blob NOT NULL,
    ->  `event_validfrom` timestamp NULL default NULL,
    ->  `event_validto` timestamp NULL default NULL,
    ->  `event_signupbefore` blob,
    ->  PRIMARY KEY  (`event_id`),
    ->  UNIQUE KEY `event_name` (`event_name`),
    ->  KEY `event_validfrom` (`event_validfrom`),
    ->  KEY `event_validto` (`event_validto`),
    ->  KEY `event_date` (`event_date`)
    -> );
Query OK, 0 rows affected (0.07 sec)

mysql> 
mysql> CREATE TABLE `events_signup` (
    ->  `signup_id` int(11) NOT NULL auto_increment,
    ->  `event_id` int(11) NOT NULL,
    ->  `signup_user` varchar(255) NOT NULL,
    ->  `signup_email` varchar(255) NOT NULL,
    ->  `signup_date` datetime NOT NULL,
    ->  `signup_hash` varchar(255) default NULL,
    ->  PRIMARY KEY  (`signup_id`),
    ->  UNIQUE KEY `signup_hash` (`signup_hash`)
    -> );
Query OK, 0 rows affected (0.00 sec)
(Assignee)

Comment 7

8 years ago
Firewall rule for sphinx needed fixing. It's all live.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED

Comment 8

8 years ago
All pref changes in comment 3 done!
http://support.mozilla.com/1/windows7-support doesn't redirect (it should, per the .htaccess changes in bug 510329); Chizu, can you re-run the .htaccess script?
(Assignee)

Comment 10

8 years ago
(In reply to comment #9)
> http://support.mozilla.com/1/windows7-support doesn't redirect (it should, per
> the .htaccess changes in bug 510329); Chizu, can you re-run the .htaccess
> script?

htaccess.sh rerun.
http://support.mozilla.com/1/windows7-support now redirects to http://support.mozilla.com/en-US/kb/Firefox+Help?style_mode=inproduct.

Chizu re-ran htaccess.sh, and Vishal and I tested a plethora of bugs (the critical ones), as well as ran Selenium IDE tests.

Verified FIXED (push).
Status: RESOLVED → VERIFIED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.