Ok, next week it is.  Let's plan for this to happen on Tuesday, March 28th.

On Tue, Mar 21, 2017 at 1:22 PM, Mikhail Popov <[email protected]> wrote:

> Hiya! Also! We're turning off an A/B test this Thursday afternoon and it
> would make our lives easier for this renaming thing to happen next week :)
> please and thank you.
>
> - Mikhail
>
> *Imagine a world in which every single human being can freely share in the
> **sum of all knowledge. That's our commitment.* Donate
> <https://donate.wikimedia.org/>.
>
> On Tue, Mar 21, 2017 at 10:57 AM, Nuria Ruiz <[email protected]> wrote:
>
>>
>> Team:
>>
>> We need to do some maintenance work to the evenlogging database that
>> requires renaming  and archiving of all tables that are currently receiving
>> events.
>>
>> Tables will be renamed from, for example: WikipediaZeroUsage_14574251 to
>> WikipediaZeroUsage_14574251_15423246;
>>
>> 15423246 is the capsule schema version.
>>
>> As new events are come for 'WikipediaZeroUsage' schema with schema
>> version 14574251 the table WikipediaZeroUsage_14574251 will get recreated
>> again, the only difference is that this new table will have different
>> column length for varchar fields.
>>
>> Details of this change are here: https://phabricator.wiki
>> media.org/T160454
>>
>> We will start our maintenance event on Thursday morning  around 11 am PST
>> time and it would last couple hours, no data loss on eventlogging will
>> happen as part of this event.
>>
>> Reportupdater queries that use eventlogging would need to be updated to
>> select from the newly renamed tables (and we will take care of doing that)
>> but other than those we do not think there are any other automated scripts
>> that would need updating.  Please let us know otherwise.
>>
>> Also, please be so kind to let us know if this renaming is disruptive in
>> any way. We can also do this changes at a later time next week.
>>
>> Thanks,
>>
>> Nuria
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Analytics mailing list
>> [email protected]
>> https://lists.wikimedia.org/mailman/listinfo/analytics
>>
>>
>
> _______________________________________________
> Analytics mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/analytics
>
>
_______________________________________________
Analytics mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/analytics

Reply via email to