Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:29:02Z] Synchronized wmf-config/db-codfw.php: Repool db2050 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Marostegui added a comment.
Table imported on testwikidatawiki on eqiad hosts:
root@db1075.eqiad.wmnet[testwikidatawiki]> show create table wbqc_constraints;
+--+---
|
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:16:51Z] Synchronized wmf-config/db-codfw.php: Depool db2050 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-14T05:16:59Z] Stop replication in sync on db1075 and db2050 - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Marostegui,
gerritbot added a comment.
Change 460470 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Depool db2050
https://gerrit.wikimedia.org/r/460470TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
gerritbot added a comment.
Change 460470 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Depool db2050
https://gerrit.wikimedia.org/r/460470TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Marostegui added a comment.
The table has been imported in eqiad hosts.
root@neodymium:/home/marostegui# mysql.py -hdb1071 wikidatawiki -e "show create table wbqc_constraints\G"
*** 1. row ***
Table: wbqc_constraints
Create Table: CREATE
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-13T13:03:32Z] Synchronized wmf-config/db-codfw.php: Repool db2085:3318 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-13T12:55:15Z] Stop db1071 (s8 eqiad master) and db2085:3318 in sync - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To:
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-13T12:54:50Z] Synchronized wmf-config/db-codfw.php: Depool db2085:3318 - T189101 (duration: 00m 49s)TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
gerritbot added a comment.
Change 460342 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Depool db2085:3318
https://gerrit.wikimedia.org/r/460342TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
gerritbot added a comment.
Change 460342 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Depool db2085:3318
https://gerrit.wikimedia.org/r/460342TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
gerritbot added a comment.
Change 457363 merged by Marostegui:
[operations/puppet@production] filtered_tables: Add constraint_id column
https://gerrit.wikimedia.org/r/457363TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Marostegui added a comment.
I have done this on codfw (testwikidatawiki and wikidatawiki).
So once eqiad is passive we will reimport the tables there and we'll be able to close this task.
This is how the table looks like now:
root@db2045.codfw.wmnet[wikidatawiki]> show create table
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-03T07:39:43Z] Deploy schema change on s8.wikidatawiki on codfw master - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To:
Stashbot added a comment.
Mentioned in SAL (#wikimedia-operations) [2018-09-03T07:34:29Z] Deploy schema change on s3.testwikidatawiki on codfw master - T189101TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To:
gerritbot added a comment.
Change 457363 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] filtered_tables: Add constraint_id column
https://gerrit.wikimedia.org/r/457363TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Marostegui added a comment.
Thanks! We will try to get this done today or tomorrow!TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MarosteguiCc: jcrespo, Marostegui, Ladsgroup, Aklapper, Jonas, hoo, aude,
gerritbot added a comment.
Change 456607 merged by jenkins-bot:
[mediawiki/extensions/WikibaseQualityConstraints@master] Make index on constraint_guid unique
https://gerrit.wikimedia.org/r/456607TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
gerritbot added a comment.
Change 456607 had a related patch set uploaded (by Lucas Werkmeister (WMDE); owner: Lucas Werkmeister (WMDE)):
[mediawiki/extensions/WikibaseQualityConstraints@master] Make index on constraint_guid unique
https://gerrit.wikimedia.org/r/456607TASK
jcrespo added a comment.
Please if you could give this a lot of priority, because if we miss this "train" (switchover) we could be waiting for a full extra year. Thanks. PK changes are not easy to do normally.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Lucas_Werkmeister_WMDE added a comment.
constraint_guid should be kept. The SQL patch above re-adds the index on it, but not the UNIQUE constraint, so we’ll have to fix that. Thanks!TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
jcrespo added a comment.
@Lucas_Werkmeister_WMDE What is the plan with constraint_guid? Will you drop it? Shouldn't it keep the UNIQUE constraint while it is in use (and by extension, the index)? We need a quick answer if this is to be done in September.TASK
Marostegui added a comment.
Just an update: we might go for a DC failover during Q1. Still to be confirmed, but if it is the case, we could try to go for the approach described at: T189101#4031549TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Lucas_Werkmeister_WMDE added a comment.
Okay, thanks :) waiting for that seems totally okay to me.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lucas_Werkmeister_WMDECc: Marostegui, Ladsgroup, Aklapper,
Ladsgroup added a comment.
WMF fiscal and annual year starts from July, so it's April-June thing and not October-December. The DC failovers happens around June-July all the time.TASK DETAILhttps://phabricator.wikimedia.org/T189101EMAIL
Marostegui added a comment.
This is not an easy change as it needs to be done directly on the master, or otherwise ids will not match.
The table is pretty small (23M on disk - 16224 rows) so it can probably be done directly on the master. I would still prefer to go for the approach we took for
27 matches
Mail list logo
