Closed Bug 508351 Opened 15 years ago Closed 15 years ago

prod mozillaservice.org deployment SQL and webcode

Categories

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

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
All
Other
Type:
task
Priority:
Not set
Severity:
major

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: ozten, Assigned: fox2mike)

References

(
URL
)

Details

(Whiteboard: 08/04/2009) 

We need to do a push to Mozilla Service Week today.

I will post instruction, but wanted to file this ticket to give a heads up.

This will require down-time of the Mozilla Service Week web app, while a SQL script is run.
Flags: needs-downtime+
Whiteboard: 08/06/2009
Deployment Plan:
1) Note production's current SVN revision
2) stop live traffic to the site
3) svn update -r48583
4) Execute database/schema_011.sql
5) allow live traffic to the site

Rollback Plan:
1) revert the effects of database/schema_011.sql
I'll provide this SQL during rollback
2) svn update to previous prod release (see Deployment Plan #1)
Please text or call me when the release is finished and I will verification. My personal number (206 area code) is in the intranet phone book. Thanks.
Assignee: server-ops → shyam
What is the status of this push?
Austin,

It's been scheduled for Thursday, 06 August as you can see on the Status Whiteboard.
Are we beyond the release window? I didn't see the whiteboard. I had a conversatin with mrz in IRC that this would happen today at 7pm.
Okay, I guess I could still push it in then. 

I didn't see an announcement and I noticed that mrz put up 08/06 on the whiteboard, so I assumed this was for Thursday.
[root@mradm02 mozillaservice.org]# svn info
Path: .
URL: http://svn.mozilla.org/projects/mozillaservice.org/trunk
Repository Root: http://svn.mozilla.org
Repository UUID: 4eb1ac78-321c-0410-a911-ec516a8615a5
Revision: 28015
Node Kind: directory
Schedule: normal
Last Changed Author: aking@mozilla.com
Last Changed Rev: 27806
Last Changed Date: 2009-06-15 11:16:54 -0700 (Mon, 15 Jun 2009)
Status: NEW → ASSIGNED
svn updated :

[root@mradm02 mozillaservice.org]# svn info
Path: .
URL: http://svn.mozilla.org/projects/mozillaservice.org/trunk
Repository Root: http://svn.mozilla.org
Repository UUID: 4eb1ac78-321c-0410-a911-ec516a8615a5
Revision: 48583
Node Kind: directory
Schedule: normal
Last Changed Author: aking@mozilla.com
Last Changed Rev: 48583
Last Changed Date: 2009-08-04 15:13:35 -0700 (Tue, 04 Aug 2009)
Database changes done :

mysql> UPDATE stories SET locale = 'en_US' WHERE locale = 'en-us';
Query OK, 26 rows affected (0.05 sec)
Rows matched: 26  Changed: 26  Warnings: 0
And pushed out to webnodes, Netscaler caches cleared.

Should be all good.
Status: ASSIGNED → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Whiteboard: 08/06/2009 → 08/04/2009
Release looks good.
(In reply to comment #5)
> Are we beyond the release window? I didn't see the whiteboard. I had a
> conversatin with mrz in IRC that this would happen today at 7pm.

I forget exactly what I said because I lose my irc session but we do not do pushes around releases.  So either I confused you or misspoke but the whiteboard was correct.
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.