ArielGlenn (ariel)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Oct 8 2014, 7:09 PM (509 w, 3 d)
Availability
Available
IRC Nick
apergos
LDAP User
ArielGlenn
MediaWiki User
ArielGlenn [ Global Accounts ]

Recent Activity

Fri, Jul 12

Dzahn awarded T368911: Request for Kerb credentials for Ariel Glenn a Like token.
Fri, Jul 12, 3:22 PM · SRE, SRE-Access-Requests, Data-Engineering
ArielGlenn closed T368911: Request for Kerb credentials for Ariel Glenn as Resolved.

Hey Daniel, I'd just assumed that getting added to the analytics-privatedata-users group would be redundant so thanks for catching that.

Fri, Jul 12, 11:07 AM · SRE, SRE-Access-Requests, Data-Engineering

Tue, Jul 9

ArielGlenn added a comment to T368911: Request for Kerb credentials for Ariel Glenn.

What are the next steps on this? Any information I need to provide, or anyone I should nudge?

Tue, Jul 9, 1:33 PM · SRE, SRE-Access-Requests, Data-Engineering

Mon, Jul 1

ArielGlenn created T368911: Request for Kerb credentials for Ariel Glenn.
Mon, Jul 1, 1:11 PM · SRE, SRE-Access-Requests, Data-Engineering

Fri, Jun 28

ArielGlenn moved T368230: Investigate missing loginwiki accounts from Inbox, needs triage to Current Sprint on the MediaWiki-Platform-Team board.
Fri, Jun 28, 1:19 PM · MediaWiki-Platform-Team, SUL3, MediaWiki-extensions-CentralAuth
ArielGlenn claimed T368230: Investigate missing loginwiki accounts.
Fri, Jun 28, 1:18 PM · MediaWiki-Platform-Team, SUL3, MediaWiki-extensions-CentralAuth

Mon, Jun 24

ArielGlenn added a comment to T348388: Use central login wiki for login (SUL3).

Actually, I don't think unattached accounts can log in at all. That was disabled way back in rOMWC165ecbfaba66: Set $wgCentralAuthStrict = true;.

So it would be the time to remove support for unattached accounts (i.e. assume all accounts are mergable) in CentralAuth.

Mon, Jun 24, 7:52 AM · SUL3, Stewards-and-global-tools, MediaWiki-Platform-Team, MediaWiki-Core-AuthManager, MediaWiki-extensions-CentralAuth

Jun 12 2024

ArielGlenn added a comment to T239378: Disable parent task metadata by default for new sub tasks.

I don't mind if subscribers aren't copied, as long as there's an easy way for subscribers to the parent task to be notified about children created if they like, with a one click add or something. Basically, I don't want to have to actively monitor a pile of parent tasks to see if any child tasks of interest were created that I want also to subscribe to.

Jun 12 2024, 8:59 AM · Patch-For-Review, User-brennen, Release-Engineering-Team, Phabricator, Developer Productivity

May 27 2024

ArielGlenn added a comment to T365260: sonarcloud.io build failures reported but the results are not accessible.

...

@ArielGlenn I don't think there is much we can do about this. I don't think it's possible to avoid posting a comment back on Gerrit if the job fails. If the syntax errors in the patch are fixed, the Sonarcloud link will work.

May 27 2024, 10:40 AM · User-ArielGlenn, Release-Engineering-Team, Quality-and-Test-Engineering-Team (SonarCloud Admin)
ArielGlenn added a project to T365260: sonarcloud.io build failures reported but the results are not accessible: User-ArielGlenn.
May 27 2024, 9:06 AM · User-ArielGlenn, Release-Engineering-Team, Quality-and-Test-Engineering-Team (SonarCloud Admin)
ArielGlenn reopened T365260: sonarcloud.io build failures reported but the results are not accessible as "Open".

Just seen again on https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CentralAuth/+/1035722 with result 404 and

Screenshot from 2024-05-27 12-03-50.png (473×619 px, 37 KB)

May 27 2024, 9:05 AM · User-ArielGlenn, Release-Engineering-Team, Quality-and-Test-Engineering-Team (SonarCloud Admin)
ArielGlenn reopened T365260: sonarcloud.io build failures reported but the results are not accessible, a subtask of T282893: Various CI jobs failing after "mkdir: cannot create directory ‘log’: Permission denied", as Open.
May 27 2024, 9:04 AM · Patch-For-Review, Upstream, Jenkins, Release-Engineering-Team (Priority Backlog 📥), ci-test-error, Continuous-Integration-Infrastructure
ArielGlenn moved T354701: Enable migration of WebAuthn credentials to loginwiki from Inbox, needs triage to Current Sprint on the MediaWiki-Platform-Team board.
May 27 2024, 6:48 AM · MW-1.43-notes (1.43.0-wmf.8; 2024-06-04), MediaWiki-Platform-Team, SUL3, MediaWiki-extensions-OATHAuth
ArielGlenn added a project to T354701: Enable migration of WebAuthn credentials to loginwiki: MediaWiki-Platform-Team.
May 27 2024, 6:48 AM · MW-1.43-notes (1.43.0-wmf.8; 2024-06-04), MediaWiki-Platform-Team, SUL3, MediaWiki-extensions-OATHAuth
ArielGlenn claimed T354701: Enable migration of WebAuthn credentials to loginwiki.

Claiming this for now, as I'm working on the alternative proposed in T354701#9753206

May 27 2024, 6:47 AM · MW-1.43-notes (1.43.0-wmf.8; 2024-06-04), MediaWiki-Platform-Team, SUL3, MediaWiki-extensions-OATHAuth

May 26 2024

ArielGlenn closed T316303: Check global rights during autocreation as Resolved.

It was saying I am globally IP blocked. idk why but now everything is fine and I am able to autocreate accounts. I created a couple of local accounts and it worked fine. Thanks!

May 26 2024, 3:20 PM · MW-1.43-notes (1.43.0-wmf.11; 2024-06-25), User-notice, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Core-AuthManager
ArielGlenn added a comment to T316303: Check global rights during autocreation.

Not for me on en wikivoyage and wikiversity. But seems working on most small wikis.

May 26 2024, 3:11 PM · MW-1.43-notes (1.43.0-wmf.11; 2024-06-25), User-notice, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Core-AuthManager
ArielGlenn moved T316303: Check global rights during autocreation from Current Sprint to Blocked/waiting on the MediaWiki-Platform-Team board.
May 26 2024, 2:47 PM · MW-1.43-notes (1.43.0-wmf.11; 2024-06-25), User-notice, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Core-AuthManager
ArielGlenn moved T348486: Migrate CentralAuth to use a virtual database domain from Blocked/waiting to Current Sprint on the MediaWiki-Platform-Team board.
May 26 2024, 2:46 PM · MW-1.43-notes (1.43.0-wmf.13; 2024-07-09), MW-1.42-notes (1.42.0-wmf.10; 2023-12-19), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth
ArielGlenn added a comment to T316303: Check global rights during autocreation.

Hey @bd808 are you in the position to check whether autocreate is now working for you from a blocked IP range, or did you work around this issue via stewards or whatnot?

May 26 2024, 2:45 PM · MW-1.43-notes (1.43.0-wmf.11; 2024-06-25), User-notice, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Core-AuthManager

May 24 2024

ArielGlenn added a comment to T364939: Provide a JavaScript library for logging in / signing up to MediaWiki via a popup.

Based on the design review, would it make sense to also add an iframe-in-a-modal version?

On the one hand, for wikis which are on a single second-level domain, the cookie-handling-related benefits of a popup don't exist, and a modal is much nicer UX.

On the other hand, currently we disallow opening the login page in an iframe, even if the parent is same-origin; it can be used to elevate an XSS into password theft via clickjacking. (See T255881 and related tasks.)

May 24 2024, 7:46 AM · MW-1.43-notes (1.43.0-wmf.8; 2024-06-04), MediaWiki-Platform-Team, SUL3, MediaWiki-User-login-and-signup, MediaWiki-extensions-CentralAuth

May 20 2024

DAlangi_WMF awarded T348486: Migrate CentralAuth to use a virtual database domain a Party Time token.
May 20 2024, 8:05 PM · MW-1.43-notes (1.43.0-wmf.13; 2024-07-09), MW-1.42-notes (1.42.0-wmf.10; 2023-12-19), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Apr 30 2024

ArielGlenn reassigned T138919: Create intro/summary for Special:GlobalRenameUser from ArielGlenn to Paladox.

Giving this back to Paladox, as he did most of the actual work. I just did a little tweak to that.

Apr 30 2024, 3:47 AM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, Patch-For-Review, good first task, GlobalRename, MediaWiki-extensions-CentralAuth
ArielGlenn closed T138919: Create intro/summary for Special:GlobalRenameUser as Resolved.
Apr 30 2024, 3:45 AM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, Patch-For-Review, good first task, GlobalRename, MediaWiki-extensions-CentralAuth
ArielGlenn closed T305338: Strip User: prefix from user creation log for forced-created accounts as Resolved.

Looks ok in deployment-prep, so I'm just gonna close this.

Apr 30 2024, 3:43 AM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Apr 29 2024

ArielGlenn added a comment to T305338: Strip User: prefix from user creation log for forced-created accounts.

With the latest patch, local testing renders a log entry for forced user creation as

Screenshot from 2024-04-29 14-11-20.png (272×1 px, 33 KB)

Will that do? Admittedly that adds links for talk and contribs, which was not requested in the bug report. But it does bring the log entry format in line with other user creation log entries.

Apr 29 2024, 11:14 AM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Apr 28 2024

ArielGlenn added a comment to T363643: Logging into a different account does not work on Wikimedia wikis.

What third party cookie testing etc flags might you have enabled or disabled? Anything possibly interfering from there? I took a fresh install of Chrome, did the steps described, and at step 4 I was still logged in on loginwiki as the second user. Returning to en.wp after that, I was still logged in there as well. Chrome version 124, linux, not logged into Google or my WMF account when using the browser. I was in an incognito window, and the Privacy and Security settings say "Third-party cookies are blocked in Incognito mode".

Apr 28 2024, 3:02 PM · Regression, MediaWiki-extensions-CentralAuth, MediaWiki-Platform-Team

Apr 25 2024

ArielGlenn claimed T305338: Strip User: prefix from user creation log for forced-created accounts.
Apr 25 2024, 4:52 PM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth
ArielGlenn moved T305338: Strip User: prefix from user creation log for forced-created accounts from Inbox, needs triage to Current Sprint on the MediaWiki-Platform-Team board.
Apr 25 2024, 4:51 PM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Apr 24 2024

ArielGlenn claimed T138919: Create intro/summary for Special:GlobalRenameUser.

Reviving this old patch, let's see what happens.

Apr 24 2024, 2:14 PM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, Patch-For-Review, good first task, GlobalRename, MediaWiki-extensions-CentralAuth
ArielGlenn moved T138919: Create intro/summary for Special:GlobalRenameUser from Inbox, needs triage to Current Sprint on the MediaWiki-Platform-Team board.
Apr 24 2024, 2:14 PM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, Patch-For-Review, good first task, GlobalRename, MediaWiki-extensions-CentralAuth
ArielGlenn added a project to T138919: Create intro/summary for Special:GlobalRenameUser: MediaWiki-Platform-Team.
Apr 24 2024, 2:14 PM · MW-1.43-notes (1.43.0-wmf.3; 2024-04-30), MediaWiki-Platform-Team, Patch-For-Review, good first task, GlobalRename, MediaWiki-extensions-CentralAuth

Apr 23 2024

Krinkle awarded T348486: Migrate CentralAuth to use a virtual database domain a Love token.
Apr 23 2024, 3:17 PM · MW-1.43-notes (1.43.0-wmf.13; 2024-07-09), MW-1.42-notes (1.42.0-wmf.10; 2023-12-19), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Apr 9 2024

ArielGlenn added a comment to T316303: Check global rights during autocreation.

The above patch fails CI for three tests not in the Database group. All three call User::isAllowed() at some point, which now would require database access. Two tests are in ConfirmEdit and one is in core (DumpableObjectsTest). I could add al lthree to @group Database or I could mock out CentralAuthHooks and have the onUserGetRights method always return true in those tests, or maybe there's some better approach. Poking @Tgr for advice or a pointer.

Apr 9 2024, 3:45 PM · MW-1.43-notes (1.43.0-wmf.11; 2024-06-25), User-notice, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Core-AuthManager

Mar 14 2024

ArielGlenn added a comment to T359957: Enroll in Chrome third-party cookies deprecation trial.

Note that for any of those issue links in the task description, I get "Access is denied to this issue". But the issue linked to in T359957#9625065 is visible at least.

Mar 14 2024, 5:33 AM · Patch-For-Review, WMF-General-or-Unknown, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Mar 12 2024

ArielGlenn claimed T359947: Test cross-domain authentication with Federated Credentials Management API.
Mar 12 2024, 4:12 PM · MediaWiki-extensions-CentralAuth, MediaWiki-Platform-Team

Mar 6 2024

ArielGlenn added a watcher for MediaWiki-extensions-CentralAuth: ArielGlenn.
Mar 6 2024, 10:05 AM

Feb 27 2024

ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

Yes I agree but that is inside a public git repository (from what I'm seeing) which means it'll be confusing will be potentially removed again. That's why I didn't put it there. It needs a better solution.

Feb 27 2024, 12:35 PM · Beta-Cluster-Infrastructure
ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

I had to reclone it again from db11, it's usually better to set the db to read only before doing the cloning (read only if you cloning from master, "stop slave" if you're cloning from another replica.) even though binlog can be replayed, there are statements happening that wouldn't be written to binlogs. Regardless, that's fixed now.

Regarding password, it's just a user on master with that password, you can just change its password. I did exactly that, the password is in my home directory on db11 and only readable by root.

Feb 27 2024, 11:35 AM · Beta-Cluster-Infrastructure

Feb 26 2024

ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

Hi 👋 I suggest stopping to touch this. I will take a look soon. Regarding databases, if you're not 100% sure what you're doing, you usually end up making things worse. Trust me, been there done that

Feb 26 2024, 5:28 PM · Beta-Cluster-Infrastructure
ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

The cloning procedure is done for db14 but we are currently hunting around for the replication password, not where the docs ( https://wikitech.wikimedia.org/wiki/Nova_Resource:Deployment-prep/Databases#Starting_Replication ) say it should be, not anywhere in that repo ever, apparently.

Feb 26 2024, 5:20 PM · Beta-Cluster-Infrastructure
ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

In the end @TheresNoTime figured it out: puppet was starting mariadb automatically when we didn't want it running and hence creating that file complained of in the error above. The cloning process looks like it's going ok at the moment.

Feb 26 2024, 4:32 PM · Beta-Cluster-Infrastructure
ArielGlenn added a comment to T358329: beta-update-databases-eqiad job times out / beta databases are having issues.

Just to explain to folks who might be following along, what's happening: the primary server (db13) will be cloned (via mariabackup --innobackupex) to the new replica; a new instance is bring created now for that. While that is happening, replication will be stopped and the primary will remain read-only. I am guessing that this will be a matter of some hours rather than a day. More updates as available.

Feb 26 2024, 2:56 PM · Beta-Cluster-Infrastructure

Feb 22 2024

ArielGlenn added a comment to T353787: Decom dumpsdata100[1-2].

1 and 2 are both role dumps::generation::server::spare and have been so since at least last July. See https://gerrit.wikimedia.org/r/c/operations/puppet/+/936379 and https://gerrit.wikimedia.org/r/c/operations/puppet/+/893265
While any nfs spare could in theory be swapped in for any production host, we have other newer spares with decent size filesystems for that; these are idle and can go at any time.

Feb 22 2024, 9:41 AM · Patch-For-Review, Data-Platform-SRE (2024.03.25 - 2024.04.14), Dumps-Generation

Feb 21 2024

ArielGlenn added a comment to T355281: Set up some beta cluster wikis with different registrable domain.

I'd prefer the beta be kept in the name, making it clear that these are wikis on the deployment cluster.

Feb 21 2024, 6:21 PM · SUL3, MediaWiki-Platform-Team, Beta-Cluster-Infrastructure

Feb 15 2024

ArielGlenn added a comment to T343882: Make wikidata dumps use two snapshot hosts to complete quicker.

This is in progress still, notes so I don't forget:

  • we run 7zs after the bz2 history files, that job will remain untouched
  • need to adjust the script that does history backfil to not move files into place if there is a temp or bz2 file that appeared in the meantime (protection in case the fillin script and the main worker both reach the same files)
  • could do md5s of these files as we go but let's see how much we gain without, it would be safer as far as avoiding overlaps
Feb 15 2024, 9:00 PM · Patch-For-Review, Dumps-Generation

Feb 13 2024

ArielGlenn added a comment to T355281: Set up some beta cluster wikis with different registrable domain.

We may want to test the behaviour when going from logged in on a wiki on beta.wmflabs.org (let's say en.wikipedia) and then visiting some-language.some-wiki.beta.wmcloud.org which is not designated as the "representative wiki" for that wiki family, and see if the behaviour is different from visiting the "representative wiki" immediately after login on en.wp.beta.wmflabs.org. These scenarios behave differently for me in production.

Feb 13 2024, 3:59 PM · SUL3, MediaWiki-Platform-Team, Beta-Cluster-Infrastructure

Feb 5 2024

ArielGlenn added a comment to T355281: Set up some beta cluster wikis with different registrable domain.

As I try to help plan this out, I have accumulated some questions.

Feb 5 2024, 5:25 PM · SUL3, MediaWiki-Platform-Team, Beta-Cluster-Infrastructure

Jan 29 2024

ArielGlenn added a comment to T61702: Examine which extensions are installed on login.wikimedia.org (loginwiki) and vote.wikimedia.org (votewiki).

Listing more extensions not named above that appear in Special:Versions and seem to me to not be needed at loginwiki:

  • 3D
  • CodeEditor
  • CodeMirror
  • ElectronPdfService
  • Global Usage
  • Kartographer
  • MediaModeration
  • RevisionSlider
  • TemplateStyles
  • TextExtracts
  • TwoColConflict

and maybe others.

Jan 29 2024, 10:35 AM · Stewards-and-global-tools, Wikimedia-Site-requests

Jan 23 2024

ArielGlenn added a project to T355450: mediawiki support for one-click unsubscribe: User-ArielGlenn.
Jan 23 2024, 8:52 AM · MediaWiki-Platform-Team, User-ArielGlenn, MediaWiki-Engineering, Growth-Team, Notifications, MediaWiki-Email

Jan 17 2024

ArielGlenn added a comment to T345249: Mitigate phase-out of third-party cookies in CentralAuth.

Verified for Firefox: I logged out, deleted all *wik*org cookies except for non SUL sites (phab, etherpad and so on), set Enhanced Tracking Protection to "custom" and chose "All cross-site cookies" (see image below). After login at en.wikipedia, after the end of the redirect/session creation chain for commons.wikimedia.org, I have session cookies for commons with session id, UserId, UserName stored locally. When I go to visit commons,wm.o, these cookies are sent to the web server and I am logged in as a result.
Firefox version: 121.0, linux.

Screenshot from 2024-01-17 13-32-27.png (659×873 px, 55 KB)

Jan 17 2024, 11:43 AM · MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Jan 10 2024

ArielGlenn added a comment to T326937: Prepare CentralAuth extension for IP Masking.

While T17294 seems stalled, is there anything do be done for CentralAuth in the meantime?

Jan 10 2024, 10:28 AM · Trust and Safety Product Team, MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, Temporary accounts

Jan 4 2024

ArielGlenn added a comment to T354318: Next steps for MediaWiki deployment training program.

Sounds good to me, I'll lurk until input is called for :-)

Jan 4 2024, 4:51 PM · Release-Engineering-Team (Deployment Training Requests), User-ArielGlenn
brennen awarded T354318: Next steps for MediaWiki deployment training program a Love token.
Jan 4 2024, 4:46 PM · Release-Engineering-Team (Deployment Training Requests), User-ArielGlenn
ArielGlenn created T354318: Next steps for MediaWiki deployment training program.
Jan 4 2024, 8:07 AM · Release-Engineering-Team (Deployment Training Requests), User-ArielGlenn

Dec 18 2023

ArielGlenn closed T205992: Allusers query auprop=rights does not include global rights (and is possibly wrong in other ways) as Resolved.

The one thing I didn't think to check. Of course it works fine on other accounts. Closing!

Dec 18 2023, 5:21 PM · MW-1.42-notes (1.42.0-wmf.9; 2023-12-12), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Action-API
ArielGlenn added a comment to T205992: Allusers query auprop=rights does not include global rights (and is possibly wrong in other ways).

Seems to work fine for me.

Dec 18 2023, 4:54 PM · MW-1.42-notes (1.42.0-wmf.9; 2023-12-12), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Action-API
ArielGlenn added a comment to T205992: Allusers query auprop=rights does not include global rights (and is possibly wrong in other ways).

The above patch went out with last week's train, and is on all wikis (1.42.0-wmf.9) but the behaviour is unchanged so I'll need to look into this further.

Dec 18 2023, 4:41 PM · MW-1.42-notes (1.42.0-wmf.9; 2023-12-12), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Action-API

Dec 14 2023

ArielGlenn added a comment to T353383: Deployment training request for ssastry.

I wonder why I thought he was in mine? Wishful thinking maybe. Hope it all goes well!

Dec 14 2023, 9:51 AM · Release-Engineering-Team (Deployment Training Requests)
ArielGlenn added a comment to T353383: Deployment training request for ssastry.

We missed you, I'm guessing that you got notice of this too late to make the training? We can reschedule in any case.

Dec 14 2023, 8:38 AM · Release-Engineering-Team (Deployment Training Requests)

Dec 11 2023

ArielGlenn added a comment to T349761: Consider naming and usage conventions of new DatabaseVirtualDomains/VirtualDomainsMapping config.

I get confused by the name 'domain' every time. 'database' or 'dbname' is much clearer imo.

Dec 11 2023, 5:28 PM · API Platform, MediaWiki-Platform-Team (Radar), Documentation, DBA, MediaWiki-libs-Rdbms

Nov 14 2023

ArielGlenn added a comment to T349761: Consider naming and usage conventions of new DatabaseVirtualDomains/VirtualDomainsMapping config.

We ought to decide about the rest of the name too, i.e. "virtual-whatgoeshere?" I liked Tim's use of the extension name with case preserved (see https://gerrit.wikimedia.org/r/c/mediawiki/extensions/LoginNotify/+/968800) but maybe you all have other preferences.

Nov 14 2023, 10:19 AM · API Platform, MediaWiki-Platform-Team (Radar), Documentation, DBA, MediaWiki-libs-Rdbms
ArielGlenn updated subscribers of T348485: Migrate OAuth to use a virtual database domain.

Change 973857 had a related patch set uploaded (by ArielGlenn; author: ArielGlenn):

[mediawiki/extensions/OATHAuth@master] Use virtual domain for OATHAuth database

https://gerrit.wikimedia.org/r/973857

Nov 14 2023, 8:24 AM · MediaWiki-extensions-OAuth

Nov 13 2023

ArielGlenn added a comment to T268526: Use a dedicated mechanism to track page dependencies.

Native speaker chiming in to say I agree: dependency means literally that A depends on B, relation is vague and can mean all kinds of things. Not going to weigh in on other aspects of the name though, carry on :-)

Nov 13 2023, 3:19 PM · Schema-change, MediaWiki-Page-derived-data, Epic, MediaWiki-Parser
ArielGlenn added a comment to T205992: Allusers query auprop=rights does not include global rights (and is possibly wrong in other ways).

What do folks think of something like the above? (Untested)

Nov 13 2023, 10:39 AM · MW-1.42-notes (1.42.0-wmf.9; 2023-12-12), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Action-API

Nov 7 2023

ArielGlenn added a comment to T205992: Allusers query auprop=rights does not include global rights (and is possibly wrong in other ways).

I note that User::getRights() was deprecated in 1.34 and removed in 1.38. Apparently we are intended to use PermissionManager::getUserPermissions() instead.

Nov 7 2023, 2:51 PM · MW-1.42-notes (1.42.0-wmf.9; 2023-12-12), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth, MediaWiki-Action-API

Nov 6 2023

ArielGlenn added a comment to T348486: Migrate CentralAuth to use a virtual database domain.

Took a stab at the GlobalBlocking change first, as it's smaller and simpler to my eyes. Not tested whatsoever.

Nov 6 2023, 2:59 PM · MW-1.43-notes (1.43.0-wmf.13; 2024-07-09), MW-1.42-notes (1.42.0-wmf.10; 2023-12-19), MediaWiki-Platform-Team, MediaWiki-extensions-CentralAuth

Oct 5 2023

ArielGlenn added a comment to T347089: Deployment training request for dr0ptp4kt.

Um there is no Thurs Oct 8. There is Thurs Oct 5 (today) and Thurs Oct 12, 19, 26... wonder if you meant any of these?

Oct 5 2023, 6:03 AM · Release-Engineering-Team (Deployment Training Requests)

Oct 2 2023

ArielGlenn added a comment to T347347: Make "Quick" MW install a thing.

If this is partly for ease of installation by first-time patch submitters, we should bear in mind that the new developer also has to jump through the gerrit setup and wikitech account creation hoops, and setting up an ssh key etc. If one already has these things, then we can indeed get the install time down to something very short.

Oct 2 2023, 1:59 PM · MW-1.42-notes (1.42.0-wmf.12; 2024-01-02), User-zeljkofilipin, MediaWiki-Platform-Team, MediaWiki-Documentation

Sep 25 2023

ArielGlenn added a project to T319432: Migrate WMF production from PHP 7.4 to PHP 8.1: Dumps-Generation.
Sep 25 2023, 1:19 PM · Dumps-Generation, MediaWiki-Platform-Team, serviceops
ArielGlenn added a project to T281325: Text rows containing DB://cluster20/0, causing RevisionAccessException when the affected pages are viewed: User-ArielGlenn.
Sep 25 2023, 1:03 PM · User-ArielGlenn, MediaWiki-Platform-Team, Wikimedia-maintenance-script-run, Wikimedia-database-issue (Bad data)

Sep 19 2023

ArielGlenn added a comment to T346279: [Spike] Figure out what are good indicators for dumps data quality.

Just a note that sometimes size/page count/visible rev count might go down, if a large batch of pages are deleted for e.g. copyvio (more likely to occur on a small wiki).

Sep 19 2023, 4:36 AM · Data Products (Sprint 02), Dumps 2.0

Sep 13 2023

ArielGlenn added a comment to T336573: PHP Warning: XMLReader::read(): Memory allocation failed : growing input buffer.

We could make sure that for commonswiki, the setting config "sevenzipprefetch" is 0. I'll need to check that this is one of the settings that can be overriden, and that the code will recognize 0 as a 'false' value. This should get done before next month's full run.

Sep 13 2023, 7:32 AM · Unstewarded-production-error, Dumps-Generation, Wikimedia-production-error
ArielGlenn moved T341045: Get Data Engineering folks access to hosts and systems needed for maintenance of the existing dumps system from Active to Blocked/Stalled/Waiting for event on the Dumps-Generation board.
Sep 13 2023, 7:28 AM · Data-Engineering, Dumps-Generation
ArielGlenn added a comment to T341045: Get Data Engineering folks access to hosts and systems needed for maintenance of the existing dumps system.

There's one item in the checklist left before this task can be closed. And basically the holdup is just about getting the signoff from Tyler that the deployment trainings were completed; then we can get the rest of that item done.

Sep 13 2023, 7:28 AM · Data-Engineering, Dumps-Generation

Sep 12 2023

ArielGlenn added a comment to T336573: PHP Warning: XMLReader::read(): Memory allocation failed : growing input buffer.

To expand on this a bit more: we saw the same error and stack trace on a slightly different page range, but with the identical symptoms. Logstash link here: https://logstash.wikimedia.org/goto/62b164dd91e2763a0a402d02087be836 Running the job hangs at the same point every time, even if nothing else is happening on the host; there aren't a particularly large number of revisions for the problem page, and their size isn't very large either. As before, using bz2 prfetch files permits the job to run to completion.

Sep 12 2023, 9:31 AM · Unstewarded-production-error, Dumps-Generation, Wikimedia-production-error
ArielGlenn added a comment to T345874: XMLDumps broken on deployment-mwmaint02 due to Jade Extension related content.

So the patches went around and I checked that they are on snapshot03, but unfortunately I still see the error:

2023-09-12 05:20:33: enwiki (ID 14793) 683 pages (694.3|694.3/sec all|curr), 1000 revs (1016.6|1016.6/sec all|curr), ETA 2023-09-12 05:30:22 [max 600437]
MWUnknownContentModelException from line 192 of /srv/mediawiki/php-master/includes/content/ContentHandlerFactory.php: The content model 'JadeJudgment' is not registered on this wiki.
See https://www.mediawiki.org/wiki/Content_handlers to find out which extensions handle this content model.
#0 /srv/mediawiki/php-master/includes/content/ContentHandlerFactory.php(247): MediaWiki\Content\ContentHandlerFactory->validateContentHandler('JadeJudgment', NULL)
#1 /srv/mediawiki/php-master/includes/content/ContentHandlerFactory.php(181): MediaWiki\Content\ContentHandlerFactory->createContentHandlerFromHook('JadeJudgment')
#2 /srv/mediawiki/php-master/includes/content/ContentHandlerFactory.php(93): MediaWiki\Content\ContentHandlerFactory->createForModelID('JadeJudgment')
#3 /srv/mediawiki/php-master/includes/export/XmlDumpWriter.php(474): MediaWiki\Content\ContentHandlerFactory->getContentHandler('JadeJudgment')
#4 /srv/mediawiki/php-master/includes/export/XmlDumpWriter.php(402): XmlDumpWriter->writeSlot(Object(MediaWiki\Revision\SlotRecord), 1)
#5 /srv/mediawiki/php-master/includes/export/WikiExporter.php(554): XmlDumpWriter->writeRevision(Object(stdClass), Array)
#6 /srv/mediawiki/php-master/includes/export/WikiExporter.php(492): WikiExporter->outputPageStreamBatch(Object(Wikimedia\Rdbms\MysqliResultWrapper), Object(stdClass))
#7 /srv/mediawiki/php-master/includes/export/WikiExporter.php(316): WikiExporter->dumpPages('page_id >= 1900...', false)
#8 /srv/mediawiki/php-master/includes/export/WikiExporter.php(208): WikiExporter->dumpFrom('page_id >= 1900...', false)
#9 /srv/mediawiki/php-master/maintenance/includes/BackupDumper.php(355): WikiExporter->pagesByRange(190001, 195001, false)
#10 /srv/mediawiki/php-master/maintenance/dumpBackup.php(82): BackupDumper->dump(1, 1)
#11 /srv/mediawiki/php-master/maintenance/includes/MaintenanceRunner.php(685): DumpBackup->execute()
#12 /srv/mediawiki/php-master/maintenance/run.php(51): MediaWiki\Maintenance\MaintenanceRunner->run()
#13 /srv/mediawiki/multiversion/MWScript.php(159): require_once('/srv/mediawiki/...')
#14 {main}

Perhaps the override isn't being respected, or the usage isn't quite right?

Sep 12 2023, 9:20 AM · Dumps-Generation, MediaWiki-ContentHandler, Beta-Cluster-Infrastructure

Sep 8 2023

ArielGlenn added a comment to T345907: Alert for snapshot101[4567] not in mediawiki-installation dsh group.

the ops-dumps email alias ought to get notified about things like this; that way all the right people will see it.

Sep 8 2023, 1:28 PM · Data-Platform-SRE, Dumps-Generation, Data-Engineering

Sep 7 2023

ArielGlenn added a comment to T345874: XMLDumps broken on deployment-mwmaint02 due to Jade Extension related content.

Just a quick note that this breaks testing of dumps for enwiki in deployment-prep. We can work around it by testing only on other wikis, but it would be nice for this to be cleaned up.

Sep 7 2023, 5:43 PM · Dumps-Generation, MediaWiki-ContentHandler, Beta-Cluster-Infrastructure
ArielGlenn added a project to T345874: XMLDumps broken on deployment-mwmaint02 due to Jade Extension related content: Dumps-Generation.
Sep 7 2023, 5:42 PM · Dumps-Generation, MediaWiki-ContentHandler, Beta-Cluster-Infrastructure
ArielGlenn added a comment to T345186: Deployment training request for mabualruz.

We missed you today for the training. I'm guessing that something came up? Go ahead and reschedule, if you are still interested!

Sep 7 2023, 7:42 AM · Release-Engineering-Team (Deployment Training Requests)

Aug 31 2023

ArielGlenn moved T345176: {Investigation} Different file sizes for dumps from Backlog to Other teams on the Dumps-Generation board.
Aug 31 2023, 10:01 AM · Wikimedia Enterprise (sprint 53), Dumps-Generation

Aug 29 2023

ArielGlenn closed T344147: Puppet broken on mediawiki instances in deployment-prep as Resolved.

Thanks for the fix(es), everything is working as expected now.

Aug 29 2023, 3:43 PM · User-ArielGlenn, Beta-Cluster-Infrastructure

Aug 28 2023

ArielGlenn moved T143870: Some mw snapshot hosts are accessing main db servers from Blocked/Stalled/Waiting for event to Done on the Dumps-Generation board.
Aug 28 2023, 9:57 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), Dumps-Generation
ArielGlenn moved T295909: <Platform Initiative> Dumps + WME Gap Analysis from Blocked/Stalled/Waiting for event to Done on the Dumps-Generation board.
Aug 28 2023, 9:57 AM · Platform Engineering, Dumps-Generation, Foundational Technology Requests
ArielGlenn moved T331129: cleanup_xmldumps is failing on dumpsdata1005 from Backlog to Done on the Dumps-Generation board.
Aug 28 2023, 9:57 AM · Dumps-Generation
ArielGlenn moved T318849: analytics-dumps-fetch-unique_devices.service failing on dumps servers from Other teams to Done on the Dumps-Generation board.
Aug 28 2023, 9:57 AM · Data-Engineering-Icebox, cloud-services-team, Analytics, Dumps-Generation
ArielGlenn moved T332562: Don't expose partial dumpfiles from Other teams to Done on the Dumps-Generation board.
Aug 28 2023, 9:57 AM · Dumps-Generation, Wikimedia Enterprise
ArielGlenn moved T341058: Failures for Cirrus Search dumps for wikidatawiki, zhwiki, enwiki for the 20230703 run from Other teams to Done on the Dumps-Generation board.
Aug 28 2023, 9:56 AM · Wikidata, MW-1.41-notes (1.41.0-wmf.19; 2023-07-25), Chinese-Sites, Dumps-Generation, Discovery-Search (Current work)
ArielGlenn added a comment to T336573: PHP Warning: XMLReader::read(): Memory allocation failed : growing input buffer.

Verified that with those same files from the above command the error is still present, nothing in the MW codebase has changed whatever the underlying issue is.

Aug 28 2023, 9:10 AM · Unstewarded-production-error, Dumps-Generation, Wikimedia-production-error
ArielGlenn added a comment to T249310: TextPassDumper.php messages on retry of fetch of content have extra junk in them.

Related: T324463

Aug 28 2023, 8:45 AM · Platform Team Workboards (Clinic Duty Team), Dumps-Generation
ArielGlenn added a comment to T306629: PHP Warning: failed to get text for revid [id] [Called from AbstractFilter::getText in /srv/mediawiki/php-1.39.0-wmf.7/extensions/ActiveAbstract/includes/AbstractFilter.php at line 195].

Who runs the findBadBlobs.php script in cases like this? It would be nice to get that done.

Aug 28 2023, 8:32 AM · User-brennen, Dumps-Generation, Wikimedia-production-error
ArielGlenn closed T133547: set up automated HTML (restbase) dumps on francium as Declined.

Not doing this, since we now have WME (Enterprise) dumps in HTML format available for public download.

Aug 28 2023, 8:26 AM · Platform Team Legacy (Watching / External), Services (watching), Datasets-Archiving, Dumps-Generation
ArielGlenn moved T186801: Flow page content dumps not resilient when database goes away from Backlog to Other teams on the Dumps-Generation board.
Aug 28 2023, 8:24 AM · Growth-Team-Filtering, Growth-Team, StructuredDiscussions, Dumps-Generation
ArielGlenn closed T331129: cleanup_xmldumps is failing on dumpsdata1005 as Resolved.

Going ahead and closing this.

Aug 28 2023, 8:20 AM · Dumps-Generation

Aug 24 2023

ArielGlenn added a comment to T344929: Maintenance script appservers running code from wmf.20 when version not live.

grep on mwmaint1002 for php, looking for long running stuff, gives me only

Jul11   0:00 /bin/bash /usr/local/bin/mwscript eval.php --wiki=commonswiki

The others are all Aug 22 or 23rd just fyi.

Aug 24 2023, 3:43 PM · Scap, Release-Engineering-Team, Wikimedia-production-error
ArielGlenn added a comment to T332562: Don't expose partial dumpfiles.

I"m presuming you didn't see any instances of this in the meantime, @awight ? Can we close this?

Aug 24 2023, 2:21 PM · Dumps-Generation, Wikimedia Enterprise
ArielGlenn added a comment to T320722: Deployment training request for Sergio Gimeno.

Hey @Sgs we missed you this morning at the deployment window for training. Or were you going to do the UTC late window this time?

Aug 24 2023, 7:31 AM · Release-Engineering-Team (Deployment Training Requests)

Aug 22 2023

ArielGlenn added a comment to T343325: Develop Dumps Triage Runbook.

I can try to dust off and restructure the troubleshooting guide on wikitech for the sql/xml dumps, if that would be helpful. This would by no means be a replacement for the runbook, but more of a minimal guide if people get stuck. Having a document specifically for dumps newcomers is great and I hope it will be expanded over time!

Aug 22 2023, 12:54 PM · Data Products (Sprint 00), Dumps 2.0, Data-Engineering

Aug 17 2023

ArielGlenn added a comment to T344409: Clarify whether config patches need reviews before being scheduled for deployment.

Counterpoint: knowing the config settings doesn't mean understanding the code activated by those changes or its possible impacts. At least, not for me. Some areas I know, and some I don't.

Aug 17 2023, 7:38 AM · Wikimedia-Site-requests, Release-Engineering-Team