Page MenuHomePhabricator

Pathoschild (Jesse P)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Oct 25 2014, 1:13 AM (256 w, 1 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Pathoschild [ Global Accounts ]

Recent Activity

Sat, Sep 7

Pathoschild added a comment to T232262: Add support for mobile websites global js and global css.

The current workaround is to import scripts from global-mobile.css/js on Meta into each local minerva.css/js page using Synchbot. When global CSS/JS becomes available on mobile, you'll need another Synchbot run to remove the manual imports.

Sat, Sep 7, 9:04 PM · Mobile, User-DannyS712, Readers-Web-Backlog, Advanced Mobile Contributions, GlobalCssJs

Aug 21 2019

ToBeFree awarded T17294: Allow blocking of global accounts a Like token.
Aug 21 2019, 5:31 PM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Mar 8 2019

Pathoschild added a comment to T217853: tools.meta was creating high cpu load on wikireplicas, rate-limited.

I reversed the update temporarily. That should solve the high CPU usage if it's due to the query changes (rather than some other change on Toolforge), but the tools will break with the upcoming comment change.

Mar 8 2019, 7:05 PM · Tools
Pathoschild added a comment to T217853: tools.meta was creating high cpu load on wikireplicas, rate-limited.

Thanks! Could it be related to the comment view?

  • The old query performs a simple select on all ipblocks rows. It's not ideal, but I don't know of a more optimal way and it didn't cause issues before. The WHERE can be simplified to ipb_range_start = ? AND ipb_range_end = ? in this case, but it doesn't affect the query plan.
  • The new query is identical, but adds a left join on comment. Besides the expected eq_ref join, this also adds ten dependent subqueries on tables like revision and image. This version apparently causes high CPU.
Mar 8 2019, 4:59 PM · Tools
Pathoschild added a comment to T217853: tools.meta was creating high cpu load on wikireplicas, rate-limited.

I asked about this in #wikimedia-cloud, but unfortunately never got an answer. The only recent change is updating queries for T166732. The above query had two changes: (a) changed ipb_reason to comment_text AS ipb_reason, and (b) added LEFT JOIN comment ON ipb_reason_id = comment_id. I'm not sure why that makes the query so much slower, and it's hard to experiment without EXPLAIN access. Suggestions are welcome! I'd rather not revert the update entirely, since the ipb_reason column will be removed soon.

Mar 8 2019, 3:53 PM · Tools

Dec 3 2018

Pathoschild added a comment to T206777: Create Wikipedia Shan.

@Urbanecm Yep, it's there now. Thanks!

Dec 3 2018, 3:54 PM · Wiki-Setup, Patch-For-Review, User-Urbanecm

Nov 28 2018

Pathoschild added a comment to T206777: Create Wikipedia Shan.

It doesn't seem to be added yet:

MariaDB [metawiki_p]> SELECT * FROM meta_p.wiki WHERE dbname = 'shnwiki' OR url = 'https://shn.wikipedia.org';
Empty set (0.01 sec)
Nov 28 2018, 5:26 PM · Wiki-Setup, Patch-For-Review, User-Urbanecm
Pathoschild added a comment to T206777: Create Wikipedia Shan.

Thanks!

Nov 28 2018, 3:35 PM · Wiki-Setup, Patch-For-Review, User-Urbanecm
Pathoschild added a comment to T206777: Create Wikipedia Shan.

The wiki isn't available in the Toolforge database yet; is that expected?

Nov 28 2018, 3:30 PM · Wiki-Setup, Patch-For-Review, User-Urbanecm

Oct 8 2018

Pathoschild added a comment to T138727: Global modules are not loaded on mobile.

Can we enable this or add a separate global-mobile.js? I got a request to create a user's minerva.js on all wikis with Synchbot, but it feels like a step backward after all the work to migrate to global.js in the first place.

Oct 8 2018, 3:14 AM · GlobalCssJs

Feb 15 2018

Honischboy awarded T17294: Allow blocking of global accounts a Love token.
Feb 15 2018, 6:50 AM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Jan 8 2018

Pathoschild added a comment to T184433: Deletion of als and mo wikis causes halting errors in https://tools.wmflabs.org/meta/userpages.

@bd808 I don't get an error with userpages/Evolution+and+evolvability. It may have been a cache issue; can you retry and post the error text if it still happens?

Jan 8 2018, 7:25 PM · Tools, Data-Services

Nov 23 2017

Vituzzu awarded T17294: Allow blocking of global accounts a Like token.
Nov 23 2017, 3:24 PM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Nov 14 2017

Liuxinyu970226 awarded T17294: Allow blocking of global accounts a Like token.
Nov 14 2017, 12:52 AM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Jul 6 2017

Pathoschild added a comment to T160464: Investigate global usergroup "Cabal" (which was created as a joke/test when global user rights got installed).

Global user #99 was me, until I accidentally deleted my global account. I'd love to get that ID back, if you want to fix it that way. ;)

Jul 6 2017, 5:17 PM · MediaWiki-extensions-CentralAuth
Pathoschild closed T169854: [stalktoy] sixxs.net WHOIS link is down, requesting replacement as Resolved.

I switched to a different service. Thanks for pointing that out!

Jul 6 2017, 3:09 PM · Tools

Jul 4 2017

Pathoschild added a comment to T169667: Stalktoy not working.

Nope, the tool just caches wiki metadata temporarily. I purged the cache, so the error should be gone. :)

Jul 4 2017, 7:18 PM · Tools

Feb 15 2017

EddieGP awarded T17294: Allow blocking of global accounts a Like token.
Feb 15 2017, 6:22 PM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Jul 16 2016

Nemo_bis awarded T17294: Allow blocking of global accounts a Doubloon token.
Jul 16 2016, 8:01 AM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Apr 2 2016

Pathoschild renamed T90978: Redirects to global user pages are broken, and added to Special:BrokenRedirects from Redirects to global user pages are broken show up on Special:BrokenRedirects to Redirects to global user pages are broken, and added to Special:BrokenRedirects.
Apr 2 2016, 10:35 PM · Patch-For-Review, GlobalUserPage, MediaWiki-Special-pages

Feb 6 2016

TerraCodes awarded T17294: Allow blocking of global accounts a Like token.
Feb 6 2016, 9:28 PM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Jan 10 2016

Pathoschild added a comment to T104799: lighttpd does not correctly close connections (CLOSE_WAIT).

This happened for tools.meta today.

Jan 10 2016, 9:23 PM · Toolforge, Cloud-Services

Nov 22 2015

Pathoschild awarded T16950: [Epic] Support global preferences on Wikimedia wikis a Love token.
Nov 22 2015, 10:23 PM · User-notice, Community-Wishlist-Survey-2016, Wikimedia-Developer-Summit (2017), Community-Tech, MediaWiki-extensions-GlobalPreferences, MediaWiki-extension-requests, Epic

Sep 12 2015

Pathoschild created T112388: Static server returns HTTP 403 Forbidden for valid files in some cases.
Sep 12 2015, 3:35 PM · cloud-services-team (Kanban), Toolforge

Aug 30 2015

Luke081515 awarded T17294: Allow blocking of global accounts a Like token.
Aug 30 2015, 7:35 PM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth

Aug 24 2015

Restricted Application updated subscribers of T35355: Provide interface for gadget usage statistics.
Aug 24 2015, 5:21 AM · JavaScript, MediaWiki-Special-pages

Aug 22 2015

Pathoschild awarded T71489: Expose mwgrep functionality on-wiki a Like token.
Aug 22 2015, 1:02 AM · Discovery-Search, Discovery, CirrusSearch
Pathoschild awarded T71489: Expose mwgrep functionality on-wiki a Dislike token.
Aug 22 2015, 1:02 AM · Discovery-Search, Discovery, CirrusSearch

Aug 18 2015

Pathoschild added a comment to T73041: Replica MySQL: Views completely missing from some wiki's.

This seems to be resolved.

Aug 18 2015, 3:17 AM · Cloud-Services, Cloud-VPS

Aug 9 2015

Pathoschild renamed T108149: "insource" search doesn't find matches in js/css pages from insource on en.wikipedia.org seems to be missing lots of results to Search on en.wikipedia.org doesn't find all matches.
Aug 9 2015, 4:48 PM · Discovery, CirrusSearch
Pathoschild added a comment to T108149: "insource" search doesn't find matches in js/css pages.

Sample affected page: en:User:Fæ/monobook.js contains rmflinks, but en:Special:Search/rmflinks doesn't show the page. This makes script maintenance difficult.

Aug 9 2015, 2:42 PM · Discovery, CirrusSearch
Restricted Application updated subscribers of T27962: Add support for URLs to mw.loader.using.

This would be useful for on-wiki user scripts. While we can do it with jQuery alone, it's not pretty:

$.ajax('//tools-static.wmflabs.org/meta/scripts/pathoschild.templatescript.js', { dataType:'script', cache:true }).then(function() {
    ...
});
Aug 9 2015, 4:03 AM · MW-1.33-notes (1.33.0-wmf.20; 2019-03-05), Notice, Performance-Team, MediaWiki-ResourceLoader

Jul 27 2015

Pathoschild added a comment to T106963: SiteMatrix API returns unexpected null for 'wiki.url' field of Wikipedia project.

This also breaks Synchbot, which has been disabled until this is fixed.

Jul 27 2015, 6:53 PM · WMF-deploy-2015-07-28_(1.26wmf16), WMF-deploy-2015-07-21_(1.26wmf15), Regression, Patch-For-Review, MediaWiki-Configuration, SiteMatrix

Jun 5 2015

Pathoschild added a comment to T57014: Let bots use canonical namespaces.

That too! Though we'll still need it for a while yet to clean up local pages for the transition to global accounts and user pages.

Jun 5 2015, 5:23 PM · Pywikibot, Pywikibot-compat
Pathoschild added a comment to T57014: Let bots use canonical namespaces.

Great! It sounds like we can close this ticket. Synchbot is running fine on mwclient, but I'll look into pywikibot again as a possible future change. :)

Jun 5 2015, 5:05 PM · Pywikibot, Pywikibot-compat
Pathoschild added a comment to T57014: Let bots use canonical namespaces.

@jayvdb This patch addressed an issue which affects crosswiki bots like Synchbot. Since the family files aren't always up to date, the bot would sometimes add user pages to the main namespace (because pywikibot replaced "User:" with an outdated namespace translation not recognised by MediaWiki). This didn't happen often, but it was difficult to notice because the bot edits so many wikis. The patch let you optionally use the canonical namespace which MediaWiki automatically translates, eliminating the possibility of outdated translations.

Jun 5 2015, 3:51 PM · Pywikibot, Pywikibot-compat
Pathoschild added a comment to T57014: Let bots use canonical namespaces.

This is an issue in core too as @jayvdb mentioned above. However I've moved away from using pywikibot, so I don't personally need this anymore.

Jun 5 2015, 3:00 PM · Pywikibot, Pywikibot-compat

Dec 12 2014

Nemo_bis awarded T17294: Allow blocking of global accounts a Like token.
Dec 12 2014, 8:01 AM · MediaWiki-User-management, Goal, Epic, Stewards-and-global-tools, GlobalBlocking, MediaWiki-extensions-CentralAuth