Page MenuHomePhabricator

Ladsgroup (Amir Sarabadani)
Shah of Bugs, Emir of database architecture, World-renowned rubber duckAdministrator

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Wednesday

  • Clear sailing ahead.

User Details

User Since
Oct 6 2014, 9:53 PM (380 w, 6 d)
Roles
Administrator
Availability
Available
IRC Nick
Amir1
LDAP User
Ladsgroup
MediaWiki User
Ladsgroup [ Global Accounts ]

Staff Database Architect in SRE data persistence team in WMF. Used to be Wikidata software engineer in WMDE

I'm also open source enthusiast, mediawiki volunteer developer, and long-term Wikipedian.

All edits on tickets about databases are in my work capacity and anything else is in my volunteer capacity unless mentioned otherwise.

Babel: fa-N, en-4, de-2, tr-1, hu-1

Recent Activity

Today

Ladsgroup added a comment to T297633: <Tech Initiative> Improving Databases in MediaWiki.

I was asked to break this down to work that can be done in a quarter. It depends on the number of people being put on this but I give it a try here:

Mon, Jan 24, 8:02 PM · Foundational Technology Requests
Ladsgroup added a comment to T299951: Normalize categorylinks table.

Possibly edit conflict. My bad :(((

Mon, Jan 24, 7:07 PM · Platform Engineering, MediaWiki-Page-derived-data
Ladsgroup created T299954: Write code for handing write and read of rev_comment_id.
Mon, Jan 24, 6:55 PM · Platform Team Initiatives (Revision Storage Schema Improvements), Technical-Debt
Ladsgroup renamed T299951: Normalize categorylinks table from Normalize categorylinks table to Normalize categoyrlinks table.
Mon, Jan 24, 6:44 PM · Platform Engineering, MediaWiki-Page-derived-data
Ladsgroup created T299953: Normalize imagelinks table.
Mon, Jan 24, 6:43 PM · Platform Engineering, MediaWiki-Page-derived-data
Ladsgroup created T299951: Normalize categorylinks table.
Mon, Jan 24, 6:41 PM · Platform Engineering, MediaWiki-Page-derived-data
Ladsgroup created T299947: Normalize pagelinks table.
Mon, Jan 24, 6:40 PM · Platform Engineering, MediaWiki-Page-derived-data
Ladsgroup awarded T299147: Retire WatchMouse (CA DX APP) a Like token.
Mon, Jan 24, 6:16 PM · Patch-For-Review, SRE Observability (FY2021/2022-Q3)
Ladsgroup closed T299908: Change "Worst response time" graph after migrating to Bullseye, a subtask of T298585: Upgrade WMF database-and-backup-related hosts to bullseye, as Resolved.
Mon, Jan 24, 2:29 PM · DBA
Ladsgroup closed T299908: Change "Worst response time" graph after migrating to Bullseye as Resolved.
Mon, Jan 24, 2:29 PM · User-Ladsgroup, observability, DBA
Ladsgroup moved T286694: Drop legacy cruft arising from introduction of ResultWrapper from Triage to Blocked on the DBA board.

Blocked until 1.39 branch cut.

Mon, Jan 24, 10:29 AM · User-Ladsgroup, DBA, MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Performance-Team, Technical-Debt (Deprecation process), Wikimedia-Rdbms, Patch-For-Review
Ladsgroup claimed T286694: Drop legacy cruft arising from introduction of ResultWrapper.
Mon, Jan 24, 10:28 AM · User-Ladsgroup, DBA, MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Performance-Team, Technical-Debt (Deprecation process), Wikimedia-Rdbms, Patch-For-Review
Ladsgroup added a comment to T299827: Add gb_by_central_id column to globalblocks table.

Does centralauth get replicated to the cloud? I doubt that, let me check

Mon, Jan 24, 9:52 AM · GlobalBlocking, Blocked-on-schema-change, DBA

Yesterday

Ladsgroup merged T296595: UI of Schulze method is hard to understand and vote into T289388: Create a drag-drop solution for ranked choice voting.
Sun, Jan 23, 2:12 AM · MediaWiki-extensions-SecurePoll
Ladsgroup added a comment to T296595: UI of Schulze method is hard to understand and vote.

I think this is duplicate of T289388, no?

Sun, Jan 23, 2:12 AM · MediaWiki-extensions-SecurePoll
Ladsgroup merged task T296595: UI of Schulze method is hard to understand and vote into T289388: Create a drag-drop solution for ranked choice voting.
Sun, Jan 23, 2:12 AM · MediaWiki-extensions-SecurePoll

Sat, Jan 22

Ladsgroup lowered the priority of T299244: Deleted pages are not being removed from links tables, which also messes up category counts from Unbreak Now! to High.

True but since it's not a production issue anymore, I removed it as a subtask of train blocker + reduced its priority to High.

Sat, Jan 22, 12:54 PM · MW-1.38-notes (1.38.0-wmf.18; 2022-01-17), MediaWiki-Page-deletion, Wikimedia-production-error, Wikimedia-Incident, MediaWiki-Categories
Ladsgroup removed a parent task for T299244: Deleted pages are not being removed from links tables, which also messes up category counts: T293959: 1.38.0-wmf.18 deployment blockers.
Sat, Jan 22, 12:53 PM · MW-1.38-notes (1.38.0-wmf.18; 2022-01-17), MediaWiki-Page-deletion, Wikimedia-production-error, Wikimedia-Incident, MediaWiki-Categories
Ladsgroup removed a subtask for T293959: 1.38.0-wmf.18 deployment blockers: T299244: Deleted pages are not being removed from links tables, which also messes up category counts.
Sat, Jan 22, 12:53 PM · Patch-For-Review, Release-Engineering-Team (Next), Release, Train Deployments

Fri, Jan 21

Ladsgroup added a comment to T298900: ToC: Interaction between ToC and collabsible sidebar.

I enabled the addon to try the new TOC to give feedback. It generally looks nice but the interaction with sidebar is quite annoying atm, I was struggling to find TOC for a while until I realized it's fully hidden behind the sidebar that I keep open almost all the time (and I think it's my default).

Fri, Jan 21, 5:48 PM · Readers-Web-Backlog (Kanbanana-FY-2021-22), Desktop Improvements
Ladsgroup added a comment to T299713: MediaWiki core QUnit test (mw.now) is failing in PageTriage CI.

Since the branch is not cut yet. I think we are out of the woods wrt the train but PageTriage being broken is something that needs fixing.

Fri, Jan 21, 4:46 PM · Growth-Team, PageCuration, ci-test-error
Ladsgroup added a comment to T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory.

pingAll can be possibly cleaned up.

Fri, Jan 21, 4:38 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, User-Ladsgroup, Wikimedia-Rdbms
Ladsgroup added a comment to T299713: MediaWiki core QUnit test (mw.now) is failing in PageTriage CI.

I can force-merge it later once there is no patch in CI (during weekend and quiet time) to avoid too much disruptions.

Fri, Jan 21, 4:08 PM · Growth-Team, PageCuration, ci-test-error
Ladsgroup reopened T273179: Update the front-page of Wikimedia projects as "Open".

Sorry. https://www.wikibooks.org/ and the rest are not migrated to the new system and still use these terrible meta pages: https://meta.wikimedia.org/wiki/Www.wikibooks.org_template

Fri, Jan 21, 10:49 AM · Google-Summer-of-Code (2021), Wikimedia-Portals, Outreach-Programs-Projects
Ladsgroup updated the task description for T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory.
Fri, Jan 21, 10:42 AM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, User-Ladsgroup, Wikimedia-Rdbms
Ladsgroup updated the task description for T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory.
Fri, Jan 21, 10:41 AM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, User-Ladsgroup, Wikimedia-Rdbms

Thu, Jan 20

Ladsgroup added a comment to T255493: Consider phasing out ILoadBalancer::getConnectionRef in favour of ILoadBalancer::getLazyConnectionRef.

I'm a big fan of this. This has been brought up as a confusing logic basically every time I ask developers what they find suboptimal in rdbms code.

Thu, Jan 20, 10:58 PM · Performance-Team, Platform Engineering Roadmap Decision Making, Developer Productivity, Wikimedia-Rdbms
Ladsgroup triaged T299698: Move out transaction management out of Database class as Medium priority.
Thu, Jan 20, 8:32 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering, Performance-Team, Wikimedia-Rdbms
Ladsgroup created T299698: Move out transaction management out of Database class.
Thu, Jan 20, 8:29 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering, Performance-Team, Wikimedia-Rdbms
Ladsgroup added a parent task for T286694: Drop legacy cruft arising from introduction of ResultWrapper: T299691: Break down monster class: Database.
Thu, Jan 20, 7:45 PM · User-Ladsgroup, DBA, MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Performance-Team, Technical-Debt (Deprecation process), Wikimedia-Rdbms, Patch-For-Review
Ladsgroup added a subtask for T299691: Break down monster class: Database: T286694: Drop legacy cruft arising from introduction of ResultWrapper.
Thu, Jan 20, 7:45 PM · Performance-Team (Radar), Platform Engineering, Epic, Wikimedia-Rdbms, Data-Persistence
Ladsgroup updated the task description for T299691: Break down monster class: Database.
Thu, Jan 20, 7:45 PM · Performance-Team (Radar), Platform Engineering, Epic, Wikimedia-Rdbms, Data-Persistence
Ladsgroup created T299691: Break down monster class: Database.
Thu, Jan 20, 7:44 PM · Performance-Team (Radar), Platform Engineering, Epic, Wikimedia-Rdbms, Data-Persistence
Ladsgroup placed T299655: [regression] Cannot globally suppress any global account up for grabs.

My part for now is done.

Thu, Jan 20, 6:12 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), SecTeam-Processed, Data-Persistence (Consultation), MediaWiki-Blocks, User-Ladsgroup, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, Security, Security-Team
Ladsgroup closed T299659: PHP Deprecated: Use of Wikimedia\Rdbms\DBConnRef::numRows was deprecated in MediaWiki 1.37. [Called from FlaggedRevsStats::getEditReviewTimes] as Resolved.

There are probably some more deprecation warnings here and there. I took note and will make patches against in the parent ticket, FlaggedRevs is cleaned now.

Thu, Jan 20, 5:59 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), User-Ladsgroup, DBA, Unstewarded-production-error, MediaWiki-extensions-FlaggedRevs, Wikimedia-production-error
Ladsgroup closed T299659: PHP Deprecated: Use of Wikimedia\Rdbms\DBConnRef::numRows was deprecated in MediaWiki 1.37. [Called from FlaggedRevsStats::getEditReviewTimes], a subtask of T293960: 1.38.0-wmf.19 deployment blockers, as Resolved.
Thu, Jan 20, 5:58 PM · User-brennen, Release-Engineering-Team (Next), Release, Train Deployments
Ladsgroup added a comment to T299655: [regression] Cannot globally suppress any global account.

The patch has been deployed. It should be fixed for now.

Thu, Jan 20, 5:20 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), SecTeam-Processed, Data-Persistence (Consultation), MediaWiki-Blocks, User-Ladsgroup, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, Security, Security-Team
Ladsgroup triaged T299659: PHP Deprecated: Use of Wikimedia\Rdbms\DBConnRef::numRows was deprecated in MediaWiki 1.37. [Called from FlaggedRevsStats::getEditReviewTimes] as High priority.
Thu, Jan 20, 4:40 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), User-Ladsgroup, DBA, Unstewarded-production-error, MediaWiki-extensions-FlaggedRevs, Wikimedia-production-error
Ladsgroup moved T299659: PHP Deprecated: Use of Wikimedia\Rdbms\DBConnRef::numRows was deprecated in MediaWiki 1.37. [Called from FlaggedRevsStats::getEditReviewTimes] from Triage to In progress on the DBA board.
Thu, Jan 20, 4:40 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), User-Ladsgroup, DBA, Unstewarded-production-error, MediaWiki-extensions-FlaggedRevs, Wikimedia-production-error
Ladsgroup claimed T299659: PHP Deprecated: Use of Wikimedia\Rdbms\DBConnRef::numRows was deprecated in MediaWiki 1.37. [Called from FlaggedRevsStats::getEditReviewTimes].
Thu, Jan 20, 4:40 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), User-Ladsgroup, DBA, Unstewarded-production-error, MediaWiki-extensions-FlaggedRevs, Wikimedia-production-error
Ladsgroup edited projects for T299655: [regression] Cannot globally suppress any global account, added: Data-Persistence (Consultation); removed DBA.
Thu, Jan 20, 4:28 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), SecTeam-Processed, Data-Persistence (Consultation), MediaWiki-Blocks, User-Ladsgroup, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, Security, Security-Team
Ladsgroup claimed T299655: [regression] Cannot globally suppress any global account.

Adding DBA due to the error message. Which is really odd since the rest of metawiki (that I can see) seems fine.

Thu, Jan 20, 4:15 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), SecTeam-Processed, Data-Persistence (Consultation), MediaWiki-Blocks, User-Ladsgroup, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, Security, Security-Team
Ladsgroup added a comment to T286694: Drop legacy cruft arising from introduction of ResultWrapper.

I might be missing some new updates but CN doesn't follow the train IIRC.

Thu, Jan 20, 1:14 PM · User-Ladsgroup, DBA, MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Performance-Team, Technical-Debt (Deprecation process), Wikimedia-Rdbms, Patch-For-Review
Ladsgroup added a comment to T299590: Create zhltawiki.

General notes:

  • This can be a fishbowl wiki but if people really want to.
    • Or this can pull a foundationwiki, connected to SUL but edit rights being limited.
    • Anything else is not possible at the moment and possibly require developer time.
  • This needs an extra approval or consultation with T&S on how it should look like.
Thu, Jan 20, 12:25 PM · Chinese-Sites, Community-consensus-needed, User-Urbanecm, Wiki-Setup (Create)
Ladsgroup added a comment to T299590: Create zhltawiki.

I suggest going with zh-lta.wikimedia.org instead. That is more aligned with how we set DNS for misc projects.

Thu, Jan 20, 12:20 PM · Chinese-Sites, Community-consensus-needed, User-Urbanecm, Wiki-Setup (Create)
Ladsgroup added a comment to T297696: Create ipinfo_ip_changes table [M].

LoadExtensionSchemaUpdatesHook hooks into update.php but we don't run update.php in production (it would bring everything down). That's for third party systems. We need to deploy this manually but Thalia done that before (you can do that on your own for creation of tables but for the rest a DBA has to do it, an example: T285149). If you need help in deploying it, let me know.

Thu, Jan 20, 10:48 AM · Data-Persistence (Consultation), Patch-For-Review, Anti-Harassment (The Letter Song), IP Info
Ladsgroup added a comment to T297696: Create ipinfo_ip_changes table [M].
  • Since this table is intended for the wikishared database, do we need to do anything to prevent it also being added to each wiki's database? (The application will only add to and read from wikishared, which will be controlled by a config.)

I defer to DBA on this. In the (default?) case where the table is created in all databases, all but wikishared.ipinfo_ip_changes would be empty. Is that a problem?

Thu, Jan 20, 2:16 AM · Data-Persistence (Consultation), Patch-For-Review, Anti-Harassment (The Letter Song), IP Info

Wed, Jan 19

Ladsgroup added a comment to T239814: Automate DB upgrades.

I ran the automatic upgrades in two eqiad hosts in s5, for one the db simply just refused to get back but that seemed to be the issue of the host being old/etc. but a powercycle seemed to fix the issue. The second one went fully smoothly and no issues so far.

Wed, Jan 19, 7:04 PM · User-Ladsgroup, Patch-For-Review, DBA
Ladsgroup added a comment to T273179: Update the front-page of Wikimedia projects.

GSoC 2021 is long over. Is there anything remaining in this task before it can be resolved? Please consider moving the leftovers to a new task and close this one. Thank you!

Wed, Jan 19, 6:10 AM · Google-Summer-of-Code (2021), Wikimedia-Portals, Outreach-Programs-Projects

Tue, Jan 18

Ladsgroup added a comment to T298782: Linter seems to be not cleaning up after page deletion.

Would it be worth to optimize the table? I haven't checked its current size.

Tue, Jan 18, 8:31 PM · MediaWiki-extensions-Linter, Data-Persistence (Consultation)
Ladsgroup triaged T299446: Allow setting section and instances using cmd as Low priority.
Tue, Jan 18, 8:21 PM · DBA, Auto schema
Ladsgroup created T299446: Allow setting section and instances using cmd.
Tue, Jan 18, 8:21 PM · DBA, Auto schema
Ladsgroup triaged T299444: Capture errors in db name as Medium priority.
Tue, Jan 18, 8:20 PM · DBA, Auto schema
Ladsgroup triaged T299445: Add tests to auto schema as Medium priority.
Tue, Jan 18, 8:20 PM · Auto schema, DBA
Ladsgroup created T299445: Add tests to auto schema.
Tue, Jan 18, 8:20 PM · Auto schema, DBA
Ladsgroup created T299444: Capture errors in db name.
Tue, Jan 18, 8:18 PM · DBA, Auto schema
Ladsgroup triaged T299442: Avoid depooling hosts (or ask for confirmation) that are the only one in a group as Medium priority.
Tue, Jan 18, 8:17 PM · DBA, Auto schema
Ladsgroup created T299442: Avoid depooling hosts (or ask for confirmation) that are the only one in a group.
Tue, Jan 18, 8:16 PM · DBA, Auto schema
Ladsgroup triaged T299441: Avoid depooling hosts if the schema change has been applied before as Low priority.
Tue, Jan 18, 8:15 PM · DBA, Auto schema
Ladsgroup created T299441: Avoid depooling hosts if the schema change has been applied before.
Tue, Jan 18, 8:15 PM · DBA, Auto schema
Ladsgroup triaged T299440: Release auto schema in pypi and package it for production as Medium priority.
Tue, Jan 18, 8:14 PM · DBA, Auto schema
Ladsgroup updated the task description for T299440: Release auto schema in pypi and package it for production.
Tue, Jan 18, 8:12 PM · DBA, Auto schema
Ladsgroup created T299440: Release auto schema in pypi and package it for production.
Tue, Jan 18, 8:12 PM · DBA, Auto schema
Ladsgroup added a project to T288235: Basic automation of schema changes: Auto schema.
Tue, Jan 18, 8:11 PM · Auto schema, User-Ladsgroup, Patch-For-Review, DBA
Ladsgroup added a watcher for Auto schema: Ladsgroup.
Tue, Jan 18, 8:10 PM
Ladsgroup created Auto schema.
Tue, Jan 18, 8:10 PM
Ladsgroup added a comment to T297696: Create ipinfo_ip_changes table [M].

I don't know how those work on top of my head but check how url shortener does it, it's also on x1. HTH.

Tue, Jan 18, 6:30 PM · Data-Persistence (Consultation), Patch-For-Review, Anti-Harassment (The Letter Song), IP Info
jcrespo awarded T299416: New table: title table a Like token.
Tue, Jan 18, 6:28 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering
Ladsgroup added a comment to T299416: New table: title table.

public table as links tables are public as well.

Tue, Jan 18, 6:26 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering
Ladsgroup moved T299417: Normalize templatelinks table from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:11 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299418: Add tl_title_id as foreign key to title_id to templatelinks from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:11 PM · Schema-change, DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299419: Write code for enabling compat writes for templatelinks and title from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:11 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299420: Turn on write both in beta cluster for templatelinks normalization from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:11 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299421: Turn on write both in production for templatelinks normalization from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299423: Write maintenance script for backfilling tl_title_id from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299424: Run maintenance script backfilling tl_title_id from Triage to Blocked on the DBA board.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup moved T299416: New table: title table from Triage to In progress on the DBA board.
Tue, Jan 18, 4:10 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering
Ladsgroup moved T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory from Triage to In progress on the DBA board.
Tue, Jan 18, 4:10 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, User-Ladsgroup, Wikimedia-Rdbms
Ladsgroup triaged T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory as Medium priority.
Tue, Jan 18, 4:10 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, Wikimedia-Rdbms, User-Ladsgroup
Ladsgroup triaged T299418: Add tl_title_id as foreign key to title_id to templatelinks as Medium priority.
Tue, Jan 18, 4:10 PM · Schema-change, DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299419: Write code for enabling compat writes for templatelinks and title as Medium priority.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299420: Turn on write both in beta cluster for templatelinks normalization as Medium priority.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299421: Turn on write both in production for templatelinks normalization as Medium priority.
Tue, Jan 18, 4:10 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299423: Write maintenance script for backfilling tl_title_id as Medium priority.
Tue, Jan 18, 4:09 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299424: Run maintenance script backfilling tl_title_id as Medium priority.
Tue, Jan 18, 4:09 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299417: Normalize templatelinks table as Medium priority.
Tue, Jan 18, 4:08 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup triaged T299416: New table: title table as Medium priority.
Tue, Jan 18, 4:08 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering
Ladsgroup created T299424: Run maintenance script backfilling tl_title_id.
Tue, Jan 18, 4:06 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299423: Write maintenance script for backfilling tl_title_id.
Tue, Jan 18, 4:06 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299421: Turn on write both in production for templatelinks normalization.
Tue, Jan 18, 4:05 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299420: Turn on write both in beta cluster for templatelinks normalization.
Tue, Jan 18, 4:05 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299419: Write code for enabling compat writes for templatelinks and title.
Tue, Jan 18, 4:04 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299418: Add tl_title_id as foreign key to title_id to templatelinks.
Tue, Jan 18, 4:03 PM · Schema-change, DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299417: Normalize templatelinks table.
Tue, Jan 18, 3:58 PM · DBA, User-Ladsgroup, Platform Engineering
Ladsgroup created T299416: New table: title table.
Tue, Jan 18, 3:56 PM · Patch-For-Review, User-Ladsgroup, DBA, Platform Engineering
Ladsgroup added a comment to T298782: Linter seems to be not cleaning up after page deletion.

Mentioned in SAL (#wikimedia-operations) [2022-01-18T08:20:35Z] <Amir1> cleaning up commons linter errors T298782

Tue, Jan 18, 2:03 PM · MediaWiki-extensions-Linter, Data-Persistence (Consultation)
Ladsgroup closed T288235: Basic automation of schema changes as Resolved.

Now we have auto_schema and it has been used quite often for schema changes (one being running as I write this). More info has been documented in https://wikitech.wikimedia.org/wiki/Auto_schema and there is a document on what would be the next steps and improvements on it https://docs.google.com/document/d/1qVinCcu4T5NkJneFKwY70giCDmP1kBhGee385LWdiwA/edit and next week we are giving a presentation about it. I think this can be closed now and we will be creating tickets for each needed improvement.

Tue, Jan 18, 1:13 PM · Auto schema, User-Ladsgroup, Patch-For-Review, DBA
Ladsgroup moved T296380: flaggedtemplates table is still too big from In progress to Blocked on the DBA board.
Tue, Jan 18, 1:00 PM · MW-1.38-notes (1.38.0-wmf.9; 2021-11-16), User-Ladsgroup, Patch-For-Review, MediaWiki-extensions-FlaggedRevs, DBA
Ladsgroup closed T213131: New ORES model relies on translatewiki.net API, which is not hosted on WMF production as Declined.

Yes. ORES is being moved to a new infra but that still doesn't fix the problem of ores not being able to talk to outside. Let's just call it declined.

Tue, Jan 18, 12:34 PM · Vuln-DoS, Security, Machine-Learning-Team, translatewiki.net, ORES
Ladsgroup created T299392: Remove unused or barely used functions of ILoadBalancer and ILBFactory.
Tue, Jan 18, 12:32 PM · MW-1.38-notes (1.38.0-wmf.19; 2022-01-24), Patch-For-Review, DBA, Performance-Team, Wikimedia-Rdbms, User-Ladsgroup