[07:00:14] marostegui: hey, any plans for dropping/renaming the "which-must-not-be-named" table in other replicas? [07:00:22] I'm just too excited :D [07:11:43] Amir1: sure, I am waiting for your orders! [07:12:03] Amir1: it is up to you guys! [07:12:21] if there's no errors, we can move on. The labs replica is a different story though [07:12:36] specially I want to see if there are reads happening on it in production [07:14:10] CCing addshore :D [07:35:06] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10Ladsgroup) Overview of s8 in eqiad: `lang=json { "s8": { "api": { "db1092": 200, "db1104": 100 }, "contributions... [07:38:32] Amir1: I can rename the table on all the replicas on monday if you like [07:39:01] Sure, I let you know once I have the green light from my boss [07:39:30] sounds good! [07:39:49] Keep in mind that the replica we renamed is one of the most accessed ones [07:40:13] And we haven't seen any errors on logstash [07:40:16] for "wb_terms" [07:40:41] actually [07:40:44] I just saw [07:41:26] https://logstash.wikimedia.org/goto/c9fc250a43bbe761485e1961bfcc13e0 [07:41:42] Is that expected? [07:49:49] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [07:50:02] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [08:03:29] marostegui: it's fine, someone just put "wb_terms" in a WDQS query and it failed :P [08:03:41] ok :) [08:42:40] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) [09:18:59] 10Blocked-on-schema-change, 10DBA: Schema change: Make page.page_restrictions column NULL - https://phabricator.wikimedia.org/T248333 (10Marostegui) s7 eqiad [] labsdb1012 [] labsdb1011 [] labsdb1010 [] labsdb1009 [x] dbstore1003 [] db1136 [] db1125 [] db1116 [] db1101 [] db1098 [] db1094 [] db1090 [] db1086... [09:31:05] * addshore reads up [10:33:08] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10Addshore) [12:46:07] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10Ladsgroup) So the plan is to rename wb_terms in all replicas except the ones for labs (db1124 and anything it replicates to) on Monday. Does that soun... [13:27:06] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10WMDE-leszek) The generally sounds good. Labs should stay, as you said. What about the researcher replicas (i.e. dbstore1005) - this one will also be e... [13:35:17] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10Ladsgroup) >>! In T248086#6026278, @WMDE-leszek wrote: > What about the researcher replicas (i.e. dbstore1005) - this one will also be excluded, right... [13:52:44] 10DBA: Drop wb_terms in production from s4 (commonswiki, testcommonswiki), s3 (testwikidatawiki), s8 (wikidatawiki) - https://phabricator.wikimedia.org/T248086 (10WMDE-leszek) For the record: @Ladsgroup is going to give a heads up to the researchers about the rename, and with that the renaming could also happen... [15:13:13] 10DBA, 10MediaWiki-General: Create MW Schema Diff maintenance script - https://phabricator.wikimedia.org/T174648 (10Krinkle) [17:31:10] hi [17:32:07] Can someone help me out with a quick ERD question?