Yes, we can do it Wednesday. On Wed, Mar 22, 2017 at 3:44 PM, Tilman Bayer <[email protected]> wrote:
> 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 <[email protected]> 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 <[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 >> >> > > > -- > Tilman Bayer > Senior Analyst > Wikimedia Foundation > IRC (Freenode): HaeB > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
