[05:40:21] 10DBA, 10Epic, 10Tracking: Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) - https://phabricator.wikimedia.org/T54921#4185501 (10Marostegui) [05:40:23] 10DBA: Drop old devwikiinternal and rel13testwiki from s3 - https://phabricator.wikimedia.org/T118764#4185498 (10Marostegui) 05stalled>03Resolved a:03Marostegui Dropped [06:27:54] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185661 (10Marostegui) 05Open>03Resolved For T191715: there are no records for any wiki For T190639: https://phabricator.wikimedia.org/P7088 F... [07:15:45] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185700 (10Daimona) @Marostegui Many thanks, exactly what we needed! Just one more thing: could you please provide the last one for thwiki? It sho... [07:17:10] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185702 (10Marostegui) ``` root@db2035.codfw.wmnet[thwiki]> select * from text where old_id=4626692; +---------+---------------+-----------+------... [07:25:51] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185706 (10Daimona) @Marostegui sounds like we really need fetchText.php, since this way the data is unreadable. Could you please try with it? Tha... [07:26:34] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185707 (10Marostegui) @Daimona that should be run with a developer with rights for that. We do not normally do those ;-) Sorry! [07:36:04] 10DBA, 10AbuseFilter, 10Wikimedia-Site-requests: Run listed queries for all wikis in order to unblock existing changes - https://phabricator.wikimedia.org/T193894#4185711 (10Daimona) Oh, sorry, I wasn't aware of it. Thanks anyway for the nice job :-) [07:38:00] 10DBA, 10Patch-For-Review: Decommission db1060 - https://phabricator.wikimedia.org/T193732#4185714 (10Marostegui) [07:38:23] 10DBA, 10Patch-For-Review: Decommission db1060 - https://phabricator.wikimedia.org/T193732#4178195 (10Marostegui) db1060 is no longer db1102's master. Let's give it 24h before proceeding with the decommissioning tasks [09:14:16] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review, 10User-Ladsgroup, 10Wikidata-Ministry-Of-Magic: Schema change for rc_namespace_title_timestamp index - https://phabricator.wikimedia.org/T191519#4185849 (10Marostegui) [09:14:40] 10Blocked-on-schema-change, 10DBA, 10Multi-Content-Revisions, 10Patch-For-Review, 10User-Addshore: Change DEFAULT 0 for rev_text_id on production DBs - https://phabricator.wikimedia.org/T190148#4185850 (10Marostegui) [09:15:13] 10Blocked-on-schema-change, 10DBA, 10Data-Services, 10MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018), 10Patch-For-Review: Schema change for refactored actor storage - https://phabricator.wikimedia.org/T188299#4185852 (10Marostegui) [10:13:05] 10DBA, 10Datasets-General-or-Unknown, 10Dumps-Generation, 10MW-1.28-release (WMF-deploy-2016-06-21_(1.28.0-wmf.7)), and 3 others: Select of revisions for stub history files does not explicitly order revisions - https://phabricator.wikimedia.org/T29112#4185949 (10ArielGlenn) Tested: ``` for wikiname in $lis... [11:11:18] jynus: I have written a first quickly draft of the steps for x1 failover on our etherpad [11:11:34] ok, I will look at it later [11:11:35] Still to be completed with more acurated commands  [13:51:08] https://wikitech.wikimedia.org/wiki/Deployments#Tuesday,_May_08 [13:51:29] I was just seeing that :) [13:51:30] thanks [13:51:49] I have completed a lot more the steps now [13:54:19] I wanted to script those [13:54:45] ah :) [14:14:32] btw. I've been deleting the logging actions for a month now, It has been deleting around 50M rows a day in different wikis, once I'm done. It'd be amazing to shrink it (I will make a phabricator ticket but since it's not finished, let's wait until it's done) [14:15:18] also, I started picking up https://phabricator.wikimedia.org/T185355 which means several big alter tables on lots of wikis (sorry, I'm changing the database too much :D) [14:16:40] Amir1: I am doing an alter table on logging table on commons and I realized it went from around 220G to 150G [14:17:06] not sure if you've done commons already or it is just fragmentation [14:17:09] yeah, I've been deleting it for a while now, I told you about commons [14:17:28] It's already almost halfway done [14:17:35] should I stop it? [14:17:37] Yeah, so many stuff going on, so I couldn't remember :) [14:17:50] Amir1: No, I was just giving you some info :) [14:18:28] cool, thanks. I think it will go to around 100GB once I'm done with all of the table [14:18:35] awesome [14:18:35] commons is the slowest wiki [14:19:12] Delete all the things! [14:22:37] yay [17:13:11] 10DBA, 10Operations, 10decommission, 10ops-eqiad, 10Patch-For-Review: Decommission db1039 - https://phabricator.wikimedia.org/T184262#4187512 (10Cmjohnson) [17:13:28] 10DBA, 10Operations, 10decommission, 10Goal: Decommission old coredb machines (<=db1050) - https://phabricator.wikimedia.org/T134476#4187514 (10Cmjohnson) [17:13:35] 10DBA, 10Operations, 10decommission, 10ops-eqiad, 10Patch-For-Review: Decommission db1039 - https://phabricator.wikimedia.org/T184262#3877626 (10Cmjohnson) 05Open>03Resolved [17:14:37] 10DBA, 10Operations, 10decommission, 10Goal: Decommission old coredb machines (<=db1050) - https://phabricator.wikimedia.org/T134476#3297517 (10Cmjohnson) [17:14:40] 10DBA, 10Operations, 10decommission, 10ops-eqiad: Decommission db1034 - https://phabricator.wikimedia.org/T182556#4187527 (10Cmjohnson) 05Open>03Resolved [17:14:59] 10DBA, 10Operations, 10decommission, 10ops-eqiad: Decommission db1034 - https://phabricator.wikimedia.org/T182556#3827026 (10Cmjohnson) [17:46:46] 10DBA, 10Operations, 10decommission, 10ops-eqiad: Decommission db1029 and db1031 - https://phabricator.wikimedia.org/T184054#4187651 (10Cmjohnson) [22:57:57] 10DBA, 10Multi-Content-Revisions, 10Schema-change: Schema change to drop archive.ar_text and archive.ar_flags - https://phabricator.wikimedia.org/T192926#4188636 (10Bstorm)