Hi Nuria,
as part of the Reading team's offsite meeting next week we already have
a session scheduled for that day which will involve various people running
EventLogging queries. Could we move the outage once more, to Wednesday or
later? Many thanks!
On Tue, Mar 21, 2017 at 3:22 PM, Nuria Ruiz <nuria(a)wikimedia.org> wrote:
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 <mpopov(a)wikimedia.org>
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 <nuria(a)wikimedia.org>
> 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
>> Analytics(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>
>>
>
> _______________________________________________
> Analytics mailing list
> Analytics(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/analytics
>
>
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics
--
Tilman Bayer
Senior Analyst
Wikimedia Foundation
IRC (Freenode): HaeB
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org