[09:19:39] <Emperor>	 Could I get a +1 to https://gerrit.wikimedia.org/r/c/operations/puppet/+/929642 please, removing the old eqiad nodes from the swift rings?
[09:20:04] <marostegui>	 checking
[09:21:59] <Emperor>	 TY :)
[09:49:58] <Amir1>	 marostegui: hi, sorry if it's stupid question: Can we drop a large table with replication? i.e. is it fast?
[09:51:31] <Amir1>	 Context T338284
[09:51:32] <stashbot>	 T338284: Drop revision_comment_temp in production - https://phabricator.wikimedia.org/T338284
[09:53:15] <marostegui>	 Amir1: I wouldn't do it, to be on the safe side
[09:53:35] <Amir1>	 so one replica by replica?
[09:53:37] <marostegui>	 I would just do it with replication disabled on a per host basis (without depooling)
[09:53:57] <Amir1>	 okay, auto_schema even supports that now
[09:53:59] <Amir1>	 awesome
[09:54:04] <marostegui>	 then let's play it safe
[10:29:55] <Amir1>	 https://grafana.wikimedia.org/d/000000377/host-overview?orgId=1&var-server=db2114&var-datasource=thanos&var-cluster=wmcs&from=1686650331781&to=1686652183333&viewPanel=28
[10:30:05] <Amir1>	 30GB in s6, each replica
[12:03:32] <jynus>	 Amir1: I am going to rollback db1139 to the 10th- that means all per-host maintenance since then will be lost
[12:04:04] <Amir1>	 sure, let me know once done
[12:28:13] <Amir1>	 moveToExternal.php is running on a lot of wikis, in commons, this thing haven't even started properly yet and already moved 600K edits out of text table
[12:31:00] <Reedy>	 #techdebt
[12:31:56] <Amir1>	 hopefully after today we can drop cur tables that should have been dropped 18 years ago :P
[12:34:48] <Amir1>	 (and for enwiki, it was 5m edits being moved out of text table)
[13:07:00] <jynus>	 going for lunch while the transfers finish
[13:38:21] <Amir1>	 testwiki in some hosts (so far only db2109) has a table called cl_errors and that's breaking my script because it think there is an error in the query...
[13:38:49] <Amir1>	 codesearch yields nothing for this table
[13:59:36] <Emperor>	 "yay"
[14:08:07] <Amir1>	 afk for an appointment I can't miss, will be back soon 
[16:42:40] <Emperor>	 do we have a tag / similar for "new data storage requests"? T335491 has just come my way
[16:42:41] <stashbot>	 T335491: Provide better long-term storage for translation models - https://phabricator.wikimedia.org/T335491
[16:58:33] <Amir1>	 hewiki text migration has started strong as 180K of first 400K edits needed to be moved out of text table to ES