[03:40:10] 10DBA, 10Core Platform Team, 10Growth-Team, 10MediaWiki-Watchlist: Purge unused watchlist rows - https://phabricator.wikimedia.org/T258098 (10JJMC89) > * **Deleted pages**: Users typically don't think to unwatch pages after they've been deleted. There are legitimate reasons to continue watching these title... [05:05:59] 10DBA: pl_namespace index on pagelinks is unique only in s8 - https://phabricator.wikimedia.org/T256685 (10Marostegui) [05:18:23] 10DBA, 10Data-Services: Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Marostegui) p:05Triage→03Medium Let us know when the database is created [05:25:22] 10DBA, 10Data-Services: Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Urbanecm) Sure. Should I add different project when creating this task? I added this one according to the Add a wiki doc page at Wikitech. [07:03:20] 10DBA, 10Data-Services: Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Marostegui) I believe the one to add is #data-services instead of #cloud-services , but @bd808 or @Bstorm will know better [07:23:38] 10DBA, 10OTRS, 10Operations, 10serviceops: Create a parallel OTRS database with a frozen snapshot of the production one - https://phabricator.wikimedia.org/T257928 (10jcrespo) 05Open→03Resolved Credentials have been setup and shared on client root dir, feel free to productionize as you see adequate: `... [07:23:41] 10DBA: Upgrade m2 to Buster and Mariadb 10.4 - https://phabricator.wikimedia.org/T257540 (10jcrespo) [07:25:16] 10DBA, 10Gerrit, 10Patch-For-Review: Make sure both `reviewdb-test` (used forgerrit upgrade testing) and `reviewdb` (formerly production) databases get torn down - https://phabricator.wikimedia.org/T255715 (10Marostegui) `reviewdb` last modification made to the data files: ` root@db1132:/srv/sqldata/reviewdb... [07:27:45] 10DBA, 10Gerrit, 10Patch-For-Review: Make sure both `reviewdb-test` (used forgerrit upgrade testing) and `reviewdb` (formerly production) databases get torn down - https://phabricator.wikimedia.org/T255715 (10Marostegui) ` root@db1132.eqiad.wmnet[(none)]> drop database if exists `reviewdb-test`; Query OK, 3... [07:30:46] 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: Degraded RAID on db1131 - https://phabricator.wikimedia.org/T257253 (10Marostegui) 05Open→03Resolved This is all done, host fully back in production Pending: what was exactly replaced on this host on-site, so we can track that just in case this host... [08:10:38] 10DBA, 10Epic: Upgrade WMF database-and-backup-related hosts to buster - https://phabricator.wikimedia.org/T250666 (10ops-monitoring-bot) Script wmf-auto-reimage was launched by marostegui on cumin1001.eqiad.wmnet for hosts: ` ['db2081.codfw.wmnet'] ` The log can be found in `/var/log/wmf-auto-reimage/20200716... [08:31:09] 10DBA, 10Epic: Upgrade WMF database-and-backup-related hosts to buster - https://phabricator.wikimedia.org/T250666 (10ops-monitoring-bot) Completed auto-reimage of hosts: ` ['db2081.codfw.wmnet'] ` and were **ALL** successful. [09:14:33] 10DBA, 10Patch-For-Review, 10User-Kormat: Switchover es4 master from es1020 to es1021 - https://phabricator.wikimedia.org/T257847 (10Marostegui) [09:15:07] 10DBA, 10Patch-For-Review, 10User-Kormat: Switchover es4 master from es1020 to es1021 - https://phabricator.wikimedia.org/T257847 (10Marostegui) [09:19:14] 10DBA, 10Patch-For-Review, 10User-Kormat: Switchover es4 master from es1020 to es1021 - https://phabricator.wikimedia.org/T257847 (10Marostegui) [09:20:51] 10DBA, 10Patch-For-Review, 10User-Kormat: Switchover es4 master from es1020 to es1021 - https://phabricator.wikimedia.org/T257847 (10Marostegui) [09:23:26] 10DBA, 10Patch-For-Review, 10User-Kormat: Switchover es4 master from es1020 to es1021 - https://phabricator.wikimedia.org/T257847 (10Marostegui) [10:51:53] 10DBA, 10Cognate, 10ContentTranslation, 10Growth-Team, and 9 others: Upgrade x1 databases to Buster and Mariadb 10.4 - https://phabricator.wikimedia.org/T254871 (10Johan) [11:12:25] I need to do some recovering performance tests [11:12:43] I will take over db2075 and db2111 [11:40:29] 10DBA, 10Patch-For-Review: Create more tests for transferpy package - https://phabricator.wikimedia.org/T257600 (10jcrespo) Not a huge priority, but check if you can rebase cleanly the extra units tests to HEAD, after the latest merges, and they still validate. It doesn't let me do it automatically, but I am g... [12:59:27] there's another alert for s4 backups growth, 177GB vs 164GB [13:01:54] yeah, roughly space on disk on /srv has grown 1% in the last week [13:02:49] so we have 99 weeks left :-P [13:02:50] * volans hides [13:04:41] XDD [13:29:26] jynus: zarcillo is now replicating from db1115 to db2093. currently dbprov2002 is backing up the zarcillo db from db2093 - should i be changing that? [13:30:27] sure, send a patch [13:30:59] we can backup on both dcs now [13:31:10] ok cool [14:02:50] 10DBA, 10Patch-For-Review: Create more tests for transferpy package - https://phabricator.wikimedia.org/T257600 (10Privacybatm) Sure, I will do the rebasing! Thank you for mentioning it. [14:22:20] 10DBA, 10Operations, 10Patch-For-Review, 10User-Kormat: Set up replication for zarcillo - https://phabricator.wikimedia.org/T257816 (10Kormat) Replication is in place, but monitoring is not. [14:33:23] 10DBA, 10Data-Services: Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Bstorm) Sounds like the wikitech page needs an update! I'll go do that. #data-services is the main one for tracking, and #wmcs-kanban is what you want to get my team to be sure to see it. [14:37:54] 10DBA, 10Data-Services: Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Bstorm) The tags on the wikitech page are updated! [14:38:16] 10DBA, 10Data-Services, 10cloud-services-team (Kanban): Prepare and check storage layer for avkwiki - https://phabricator.wikimedia.org/T258077 (10Bstorm)