Community Relations support needed for a read-only window for s7 (several wikis)
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• Marostegui
	Nov 12 2019, 9:30 AM

Description

What is the problem?

We need to failover the current s7 database primary master, to a newer host (T238044)
Technical tracking task for this maintenance: T238044
For this operation we need to set up the following wiki on read-only:

arwiki
cawiki
eswiki
fawiki
frwiktionary
hewiki
huwiki
kowiki
metawiki
rowiki
ukwiki
viwiki

This also includes centralauth database, which means some operations might fail during the read-only period, such as: GlobalRenames, Changing/Confirming emails, logging into new wikis, password changes...

How can we help you?

We need to let users of the above wiki, that on Tue 26th November from 06:00 to 06:30 AM UTC that wiki will be on read-only. No writes will be allowed, reads will remain unaffected.

What does success look like?

Users will get notified and plan their work to avoid that maintenance window.
If everything goes fine, we expect the read-only window to last around 1-2 minutes, not 30.

What is your deadline?

We'd like to do this switchover by Tue 26th Nov at 06:00 AM UTC

Related Objects
Search...

Status	Assigned	Task
Resolved	RLazarus	T243314 FY2020-2021 Q1 DC switchover and switchback
Resolved	RLazarus	T243316 FY2020-2021 Q1 eqiad -> codfw switchover
Resolved	• Marostegui	T186188 Failover DB masters in row D
Resolved	• Marostegui	T217396 Decommission db1061-db1073
Resolved	• Marostegui	T238044 Switchover s7 primary database master db1062 -> db1086 - 26th Nov 06:00 - 06:30 UTC
Resolved	Trizek-WMF	T235531 Community Relations support needed for read-only windows on Q2-2019
Resolved	Trizek-WMF	T238046 Community Relations support needed for a read-only window for s7 (several wikis)

Event Timeline

• Marostegui created this task.Nov 12 2019, 9:30 AM

Restricted Application added subscribers: Strainu, Base, revi. · View Herald TranscriptNov 12 2019, 9:30 AM

• Marostegui added a parent task: T238044: Switchover s7 primary database master db1062 -> db1086 - 26th Nov 06:00 - 06:30 UTC.Nov 12 2019, 9:31 AM

Trizek-WMF triaged this task as Medium priority.Nov 13 2019, 2:22 PM

Trizek-WMF moved this task from Backlog to Started on the MoveComms-Support (Oct-Dec-2019) board.

Since this will happen just ~12 hours after Tech News is delivered on 26 November, I'll include it in the newsletter being distributed on Monday instead to give people a proper chance to see it.

Johan moved this task from To Triage to In current Tech/News draft on the User-notice board.Nov 14 2019, 12:34 PM

Banners set!

Thank you!

Johan moved this task from In current Tech/News draft to Already announced/Archive on the User-notice board.Nov 20 2019, 3:03 PM

I've sent a message to the impacted wikis, and also pinged GlobalRenamers and Stewards.

With the CentralAuth being affected, I assume global LOCKs will be unavailable, but does it also affect global BLOCKs? (Locks for account, BLocks for IPs.)

In T238046#5679375, @revi wrote:

With the CentralAuth being affected, I assume global LOCKs will be unavailable, but does it also affect global BLOCKs? (Locks for account, BLocks for IPs.)

I guess new blocks will not be able to happen. Existing ones should not be affected as read access will not be interrupted at anytimes.
@Reedy do you happen to have a more concrete answer?

Thanks!

In T238046#5680631, @Marostegui wrote:

In T238046#5679375, @revi wrote:

With the CentralAuth being affected, I assume global LOCKs will be unavailable, but does it also affect global BLOCKs? (Locks for account, BLocks for IPs.)

I guess new blocks will not be able to happen. Existing ones should not be affected as read access will not be interrupted at anytimes.
@Reedy do you happen to have a more concrete answer?

Thanks!

Yeah, existing (global)blocks should work fine, same for global locks

Both the globalblocks and the locked flag (globaluser,gu_locked) exist on s7, so both will be unable to be created/updated (or any other related user updates) during the readonly window

Strainu unsubscribed.Nov 21 2019, 11:24 AM

I have reserved a window on the Deployments page.

In T238046#5686898, @Agusbou2015 wrote:

I have reserved a window on the Deployments page.

Thank you!

Just a heads up, the banners on eswiki have the date wrong for one of the wikis:

Se realizarán tareas de mantenimiento técnico en breve. 26 noviembre - 06:00 AM UTC - 06:30 AM UTC
Mientras se realiza dicho mantenimiento, el 19 de marzo de 2019, desde las 15:00 (UTC) a las 15:15 (UTC), es posible que no puedas guardar ninguna edición.

The first sentence is correct.
The second sentence says 19 March from 15:00 UTC to 15:15 UTC, which is not correct.

frwiktionary is fine (I haven't checked the rest of the wikis)

This was done successfully.

Read only starts: 06:00:24
Read only stops: 06:01:09

Total read only time: 45 seconds

Thanks for your help!

• Elitre awarded a token.Nov 26 2019, 11:32 AM

• Elitre added a project: MoveComms-Support (Oct-Dec-2019).

• Elitre moved this task from Started to Resolved (no evaluation needed) on the MoveComms-Support (Oct-Dec-2019) board.Nov 28 2019, 5:39 PM

In T238046#5691991, @Marostegui wrote:
Just a heads up, the banners on eswiki have the date wrong for one of the wikis:
Se realizarán tareas de mantenimiento técnico en breve. 26 noviembre - 06:00 AM UTC - 06:30 AM UTC
Mientras se realiza dicho mantenimiento, el 19 de marzo de 2019, desde las 15:00 (UTC) a las 15:15 (UTC), es posible que no puedas guardar ninguna edición.
The first sentence is correct.
The second sentence says 19 March from 15:00 UTC to 15:15 UTC, which is not correct.

frwiktionary is fine (I haven't checked the rest of the wikis)

Thank you for the note. It is very likely to be a raw translation that was left there. I'm investigating.

Apparently (and very strangely), there were no message in Spanish for the current messages. Seems that the banner was using the old messages. Fixed now.

Ladsgroup edited projects, added User-notice-archive; removed User-notice.Aug 13 2022, 1:54 PM

Restricted Application added a subscriber: Huji. · View Herald TranscriptAug 13 2022, 1:54 PM

Community Relations support needed for a read-only window for s7 (several wikis)Closed, ResolvedPublicActions