909878 - Downtime required to deploy/execute the migration script to move Tracking Flags from custom fields to the new style table structure

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Infrastructure, defect)

Description

[David Lawrence [:dkl]]

We'll need to schedule some downtime to deploy the code to run the TrackingFlag migration from old to new style. The steps needed to execute the migration are outlined here:

https://bmo.etherpad.mozilla.org/tracking-flags-migration

Bug 880829 is the bug for tracking the actual migration code implementation and code review.

We only expect ~20 minutes needed but will need to occur during the next IT outage window in 6 weeks from now. A cab review bug should be filed as well by the IT person who will be performing the migration.

Thanks
dkl

Comment 1

[Brandon Burton [:solarce]]

I've opened https://bugzilla.mozilla.org/show_bug.cgi?id=914745 to herd this through CAB for 2013-10-12 tree closure maintenance window

I've put myself down to perform the webops maintenance

:sheeri, can you provide me details on the database actions or would someone from your team perform them?

Thanks

Comment 2

[Sheeri Cabral [:sheeri]]

Someone from my team can perform them, but FYI they're all in the etherpad dkl linked - https://bmo.etherpad.mozilla.org/tracking-flags-migration under DBA.

Comment 3

[Brandon Burton [:solarce]]

:dkl / :glob , when should we add a banner to bmo announcing the maintenance?

Comment 4

[David Lawrence [:dkl]]

(In reply to Brandon Burton [:solarce] from comment #3)
> :dkl / :glob , when should we add a banner to bmo announcing the maintenance?

I think a week would be acceptable.

Comment 5

[Brandon Burton [:solarce]]

(In reply to David Lawrence [:dkl] from comment #4)
> (In reply to Brandon Burton [:solarce] from comment #3)
> > :dkl / :glob , when should we add a banner to bmo announcing the maintenance?
> 
> I think a week would be acceptable.

Ok, should I file a bug about this? Ping someone on 10/5?

Thanks

Comment 6

[:glob ✱]

(In reply to Brandon Burton [:solarce] from comment #5)
> Ok, should I file a bug about this? Ping someone on 10/5?

probably simplest to ping someone on oct 5th (or thereabouts -- summit).

as per our recent outages, the primary means of notifying should be email (ask shyam for the template and target audiences).

Comment 7

[Brandon Burton [:solarce]]

I'll get a maintenance notification sent out to everyone@ shortly

:dkl or :glob, can of you add a banner to bmo when you have a chance?

Thanks

Comment 8

[Brandon Burton [:solarce]]

Notification sent to all@ and posted to https://status.mozilla.org/en-US/detail/12/

Comment 9

[David Lawrence [:dkl]]

(In reply to Brandon Burton [:solarce] from comment #7)
> I'll get a maintenance notification sent out to everyone@ shortly
> 
> :dkl or :glob, can of you add a banner to bmo when you have a chance?
> 
> Thanks

Done

Comment 10

[David Lawrence [:dkl]]

Migration complete. Took the whole 2 hours as we also did stage before prod which added a small amount of time. 

Encountered the normal errors due to the cf_blocking_192 and cf_status192 tables but after manual clean up everything seemed to be fine.

I did quite a bit of sanity checking and all seemed well so far so we will hear soon if anything is not right. 

Closing this for now.

Thanks for everyone's help!

dkl