[06:04:06] 10DBA, 06Operations, 10ops-codfw: Degraded RAID on db2058 - https://phabricator.wikimedia.org/T165629#3283373 (10Marostegui) 05Open>03Resolved All good! Thank you! ``` logicaldrive 1 (3.3 TB, RAID 1+0, OK) physicaldrive 1I:1:3 (port 1I:box 1:bay 3, SAS, 600 GB, OK) ``` [06:18:25] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 4 others: Concerns about ores_classification table size on enwiki - https://phabricator.wikimedia.org/T159753#3283375 (10Marostegui) 05Open>03Resolved I have finished optimizing `enwiki` master, db1052: ``` roo... [06:22:23] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3281974 (10Marostegui) Hi! Thanks for the patch to realm.pp - it looks good (I have commented on the gerrit patch). From our side I believe we only need to merg... [06:23:47] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3283379 (10Marostegui) `enwiki` master is done (db1052): ``` root@neodymium:~# mysql --skip-ssl -hdb1... [06:24:52] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283380 (10Dereckson) Thanks for the quick review. Yes, you can merge the change, I've a deployment access, not ops access, so I can't merge it. [06:28:16] 10DBA, 13Patch-For-Review: Unify revision table on s2 - https://phabricator.wikimedia.org/T162611#3283381 (10Marostegui) db1018 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# for i in `cat /home/marostegui/T162611`; do echo $i; mysql --skip-ssl -hdb1018 $i -e "show create table revision\G";... [06:34:11] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3283383 (10Marostegui) [07:33:42] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283446 (10Florian) [07:43:00] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3283456 (10Marostegui) `wikidatawiki` is done on all the hosts (dbstore2001 will get it tomorrow as i... [07:46:18] 10DBA, 13Patch-For-Review: Unify revision table on s2 - https://phabricator.wikimedia.org/T162611#3283457 (10Marostegui) The rc slaves (db1036 and db2035) have been also fixed: ``` root@neodymium:/home/marostegui/git/software/dbtools# for i in bgwiktionary eowiki idwiki; do echo $i; mysql --skip-ssl -hdb1036... [08:04:07] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3283477 (10Marostegui) db2029 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb2029.codfw.wmnet frwiktionary -e "show create table revision\... [08:04:43] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3283478 (10Marostegui) [08:32:45] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283487 (10jcrespo) Marostegui, you can deploy and restart if you want, Dereckson cannot do that. [08:33:28] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3283488 (10Marostegui) db1069 (and downstream) done: ``` root@neodymium:/home/marostegui/git/software... [09:02:47] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283554 (10Marostegui) Both sanitarium hosts have been restarted and they have the new wiki replication filters like: ``` techconductwiki.% ``` db1095 (which... [09:03:48] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283557 (10Marostegui) a:05jcrespo>03None [09:16:15] 10DBA, 10Analytics, 10Analytics-EventLogging: Drop table MediaWikiInstallPingback_15732959 from EventLogging DB - https://phabricator.wikimedia.org/T165836#3283610 (10Marostegui) 05Open>03Resolved a:03Marostegui Thanks for the ticket. I have removed this table from: db1046, db1047 and dbstore1002. The... [09:22:33] 10DBA, 10Beta-Cluster-Infrastructure, 06Operations, 13Patch-For-Review, 06Release-Engineering-Team (Backlog): Better mysql command prompt info for Beta - https://phabricator.wikimedia.org/T157714#3283618 (10jcrespo) I also use colors, check my bashrc if you want them: {F8158232} [09:32:25] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283633 (10jcrespo) Let's also schedule a custom check of check_private_data when it gets added to the private wiki list. [09:34:05] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283634 (10Marostegui) >>! In T165977#3283633, @jcrespo wrote: > Let's also schedule a custom check of check_private_data when it gets added to the private wiki... [09:37:37] I have been 3 hours reading emails, phabricator tasks and gerrit commits [09:37:54] I am sure I am guilty for quite some of that spam [09:37:57] nope [09:38:00] all Vienna [09:38:02] pheeew [09:38:02] I would assume [09:38:32] 3 hours of emails and a meeting in a bit, happy monday Jaime! [11:10:39] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3283820 (10tomasz) @Dereckson: I've uploaded an example logo at https://commons.wikimedia.org/wiki/File:Code_of_Conduct_Committee_logo.svg - can you have a look? [11:37:31] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 13Patch-For-Review, and 2 others: Usage tracking: record which statement group is used - https://phabricator.wikimedia.org/T151717#3283836 (10hoo) I ran the numbers briefly and both `kowiki` and `trwiki` don't look as interesting to me. Therefore I... [13:36:07] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3284104 (10Marostegui) db1026 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysq... [13:36:11] 07Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Scoring-platform-team, and 2 others: Deploy uniqueness constraints on ores_classification table - https://phabricator.wikimedia.org/T164530#3284105 (10Marostegui) [13:42:52] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284125 (10Marostegui) db1039 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1039 frwiktionary -e "show create table revision\G" **********... [13:42:57] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284127 (10Marostegui) [13:53:41] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 13Patch-For-Review, and 2 others: Usage tracking: record which statement group is used - https://phabricator.wikimedia.org/T151717#3284141 (10Hall1467) @hoo: elwiki sounds good to me. [14:18:46] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284241 (10Marostegui) db1028 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1028 frwiktionary -e "show create table revision\G" **********... [14:18:54] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284242 (10Marostegui) [14:20:39] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3275703 (10Marostegui) dbstore2001 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdbstore2001.codfw.wmnet frwiktionary -e "show create table... [14:21:23] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284245 (10Marostegui) [14:48:10] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284285 (10Marostegui) db1079 done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1079 frwiktionary -e "show create table revision\G" *************... [14:48:14] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284286 (10Marostegui) [14:52:17] jynus: editing on wikitech is throwing a weird db error on save, can we help look at this? not sure where to look, bryan said that wikitech runs off of a db on localhost which even that for me is TIL [14:53:11] I think is a bryan deploy [14:53:14] mysql is up [14:53:26] it is trying to connect to the wrong servers, though [14:53:49] or could be a config changed affecting wikitech [14:53:56] look what he said, it is trying to write to db1034 :≤ [14:53:58] :| [14:54:17] I say to revert latest change [14:54:31] jynus: ok told bryan that and he is going to roll back [14:55:00] it is only on edit that that happens [14:55:07] agreed, same behavior for me [14:55:09] other things can write to the database well [14:55:27] which points to an extension trying to do something that should be disabled or different on wikitech [15:40:18] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284390 (10Marostegui) db1086 is done: ``` root@neodymium:/home/marostegui/git/software/dbtools# mysql --skip-ssl -hdb1086 frwiktionary -e "show create table revision\G" **********... [15:40:25] 10DBA, 13Patch-For-Review: frwiktionary on s7 still needs fixing on the revision table - https://phabricator.wikimedia.org/T165743#3284391 (10Marostegui) [17:41:37] 10DBA, 06Operations, 10Wikimedia-Site-requests, 13Patch-For-Review: Create CoC committee private wiki - https://phabricator.wikimedia.org/T165977#3284770 (10Dereckson) Looks good to me. I've cc to the task some other members, so we'll get perhaps more feedback. [21:11:29] 10DBA, 06Labs: Labs database corruption - https://phabricator.wikimedia.org/T166091#3285070 (10Dispenser) [22:52:26] 10DBA, 07Schema-change: Drop titlekey table from all wmf databases - https://phabricator.wikimedia.org/T164949#3285211 (10demon) Here's the fully accurate list: [[ /source/mediawiki-config/browse/master/all.dblist;8751de60bf2d7c5918abe56c45a9c244e7d3dea2 | all.dblist when Cirrus turn-off was removed ]]. If an... [23:00:16] 10DBA: Drop Gather tables from wmf wikis - https://phabricator.wikimedia.org/T166097#3285215 (10demon) [23:00:40] 10DBA, 07Epic, 07Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#2430601 (10demon) [23:01:51] 10DBA, 07Epic, 07Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#2432024 (10demon) For `flagged*` tables, we need to compare against `flaggedrevs.dblist` -- only wikis in that dblist need the tables.