[05:02:55] 10DBA: Decommission es2001, es2002, es2003, es2004 - https://phabricator.wikimedia.org/T222592 (10Marostegui) [05:24:55] 10DBA, 10DC-Ops, 10decommission, 10Patch-For-Review: decommission db2045.codfw.wmnet - https://phabricator.wikimedia.org/T228281 (10Marostegui) [05:25:51] 10DBA, 10Operations: Decommission db2043-db2069 - https://phabricator.wikimedia.org/T228258 (10Marostegui) [05:42:53] 10DBA, 10Operations: Predictive failures on disk S.M.A.R.T. status - https://phabricator.wikimedia.org/T208323 (10Marostegui) [05:48:54] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [10:30:33] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) I have altered db2116 for now, to make sure nothing writes to that column (if it does, it will break replication there, but won't impact the users). Will leave it for a few days befor... [10:30:52] 10DBA, 10AbuseFilter: Drop abuse_filter_log.afl_log_id in production - https://phabricator.wikimedia.org/T226851 (10Marostegui) [13:51:15] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Anomie) I'm not sure about the #Schema-change part. That tag claims to be about actual schema changes. Glancing through the tasks currently in the s... [14:13:39] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Marostegui) So, from my side, this is the way I read those tags: #schema-change is where a discussion about an upcoming schema change might happen... [14:36:45] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Krinkle) >>! In T228360#5345746, @Anomie wrote: > I'm not sure about the #Schema-change part. Thanks, I'm not actually very familiar with the Phabr... [14:36:54] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Krinkle) p:05Triage→03Normal [14:43:33] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10jcrespo) I personally don't have any opinion about #MediaWiki-Database I don't interact with it or need it or I am not subscribed to it. It is nice... [16:05:15] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Anomie) >>! In T228360#5345910, @Krinkle wrote: > Would using #mediawiki-maintenance-scripts and/or #mediawiki-installer be a more suitable place f... [19:38:35] 10DBA, 10User-notice, 10Wikimedia-database-error: Optimize SpecialAllPages::showChunk for large wikis - https://phabricator.wikimedia.org/T160983 (10Krinkle) [20:04:11] 10DBA, 10Tracking-Neverending, 10Wikimedia-database-error: Duplicate key errors (tracking) - https://phabricator.wikimedia.org/T106854 (10Krinkle) [20:34:24] 10DBA, 10MediaWiki-General, 10Schema-change: Convert primary key integers and references thereto from int to bigint (unsigned) - https://phabricator.wikimedia.org/T63111 (10Krinkle) [21:24:18] 10DBA, 10Growth-Team, 10MediaWiki-Watchlist, 10TechCom-RFC, 10Schema-change: RFC: Proposal to add wl_addedtimestamp attribute to the watchlist table - https://phabricator.wikimedia.org/T209773 (10Krinkle) [21:25:59] 10DBA, 10MediaWiki-Logging, 10Schema-change: Create ip_logging table to query for logged actions by IP ranges - https://phabricator.wikimedia.org/T187579 (10Krinkle) [21:27:12] 10DBA, 10MediaWiki-General, 10PostgreSQL, 10Schema-change, 10Wikimedia-database-error: Some tables lack unique or primary keys, may allow confusing duplicate data - https://phabricator.wikimedia.org/T17441 (10Krinkle) [21:30:58] 10DBA, 10Wikimedia-General-or-Unknown, 10User-Reedy, 10Wikimedia-maintenance-script-run: Run updateRestrictions.php on WMF wikis - https://phabricator.wikimedia.org/T166184 (10Krinkle) [21:52:09] 10DBA, 10MediaWiki-General, 10Operations, 10TechCom: Evaluate and decide the future of relational datastore at WMF after the upgrade of MariaDB 10.1 is finished - https://phabricator.wikimedia.org/T193224 (10Krinkle) [21:55:03] 10DBA, 10Schema-change, 10Tracking-Neverending: [DO NOT USE] Schema changes for Wikimedia wikis (tracking) [superseded by #Blocked-on-schema-change] - https://phabricator.wikimedia.org/T51188 (10Krinkle) [21:55:06] 10DBA, 10MediaWiki-File-management, 10Performance-Team (Radar), 10Schema-change: Drop filejournal table from WMF - https://phabricator.wikimedia.org/T51195 (10Krinkle) [22:13:42] 10DBA, 10MediaWiki-Page-protection, 10Schema-change: Drop page.page_restrictions column from Wikimedia wikis - https://phabricator.wikimedia.org/T60674 (10Krinkle) [23:13:25] 10DBA: Decommission old coredb machines (<=db2042) - https://phabricator.wikimedia.org/T221533 (10Papaul) [23:25:18] 10DBA, 10Core Platform Team, 10Performance-Team, 10Project-Admins: Narrow scope of MediaWiki-Database workboard - https://phabricator.wikimedia.org/T228360 (10Legoktm) From a bug filer perspective, `Wikimedia-Rdbms` is really not a great project name. We usually don't prefix library phabricator projects wi...