Dispenser
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Apr 12 2015, 12:29 AM (174 w, 3 d)
Availability
Available
IRC Nick
Dispenser
LDAP User
Dispenser
MediaWiki User
Dispenser [ Global Accounts ]

Recent Activity

Tue, Aug 7

Dispenser added a comment to T200350: Impossibility to use Ping project on projects over 50 participants.

{{Ping project}} uses a Hidden Structure which causes issues for bots, web scrapers, and screen readers. The proper fix is to add the functionality to Echo.

Tue, Aug 7, 2:28 AM · Notifications, Growth-Team, Wikidata

Tue, Jul 17

Dispenser added a comment to T199756: Phabricator task T200000 announcement.

Is there a conpherence for watching the milestone?

Tue, Jul 17, 1:08 AM · Phabricator

Jun 16 2018

Dispenser added a comment to T191941: Gadget CSS should be applied after Site styles.

From the Green on black skin, it was brought up at Village Pump (screenshot) after I removed the workaround for T147667. Apparently locals styles in MediaWikiMonobook.css are applied after gadget styles.

Jun 16 2018, 7:48 PM · Regression, MediaWiki-ResourceLoader, Performance-Team, Gadgets

Jun 5 2018

Dispenser updated subscribers of T191941: Gadget CSS should be applied after Site styles.

@Krinkle Could you look into this? Hopefully the fix is a simple modification of T147667: Site and Gadget CSS should apply after core and skin CSS

Jun 5 2018, 4:11 AM · Regression, MediaWiki-ResourceLoader, Performance-Team, Gadgets

May 19 2018

Dispenser removed a project from T100448: [Migrated] Subset regex: Security.
May 19 2018, 5:55 PM · WorkType-NewFunctionality, AutoWikiBrowser

Apr 16 2018

MarcoAurelio awarded T181932: Add SUL/CentralAuth variables to AbuseFilter a Like token.
Apr 16 2018, 3:53 PM · MediaWiki-extensions-CentralAuth, AbuseFilter, Commons

Apr 13 2018

Dispenser updated subscribers of T192127: Enable global abuse filter for idwiki.

@Pentachlorphenol may have volunteered in getting community consensus ;-)

Apr 13 2018, 3:31 AM · Community-consensus-needed, Wikimedia-Site-requests, AbuseFilter, Zero
Dispenser triaged T192127: Enable global abuse filter for idwiki as Normal priority.
Apr 13 2018, 3:30 AM · Community-consensus-needed, Wikimedia-Site-requests, AbuseFilter, Zero

Apr 10 2018

Dispenser renamed T191941: Gadget CSS should be applied after Site styles from Gadget CSS should be applied after Common.css to Gadget CSS should be applied after Site styles.
Apr 10 2018, 11:47 PM · Regression, MediaWiki-ResourceLoader, Performance-Team, Gadgets
Dispenser created T191941: Gadget CSS should be applied after Site styles.
Apr 10 2018, 11:44 PM · Regression, MediaWiki-ResourceLoader, Performance-Team, Gadgets

Mar 23 2018

Dispenser added a comment to T190488: Possibly a big update going to: u2815__p`.`all_articles.

That would be cool, thank you! I can remove the filter and reimport the table to the (hidden) replica when you are done. I will claim it meanwhile for other related breakages on replication.

Mar 23 2018, 11:22 AM · Patch-For-Review, DBA, Toolforge, Data-Services
Dispenser added a comment to T190488: Possibly a big update going to: u2815__p`.`all_articles.

@jcrespo I was developing the script last night, so something might have gone astray. I'll add a PRIMARY KEY so it doesn't happen in the future.

Mar 23 2018, 11:03 AM · Patch-For-Review, DBA, Toolforge, Data-Services
Dispenser added a comment to T190488: Possibly a big update going to: u2815__p`.`all_articles.

Kill it and drop the table. The script should only take 10 minutes for LOAD DATA

Mar 23 2018, 10:48 AM · Patch-For-Review, DBA, Toolforge, Data-Services

Mar 19 2018

Dispenser moved T190054: Pipermail on lists.wikimedia.org is not mobile friendly from Backlog to Shell/site on the Wikimedia-Mailing-lists board.
Mar 19 2018, 3:40 PM · Wikimedia-Mailing-lists, Mobile
Dispenser moved T190055: Mailman on lists.wikimedia.org is not mobile friendly from Backlog to Mailman v3 on the Wikimedia-Mailing-lists board.
Mar 19 2018, 3:40 PM · Wikimedia-Mailing-lists, Mobile
Dispenser moved T190061: Pipermail uses background color without foreground colors from Backlog to Shell/site on the Wikimedia-Mailing-lists board.
Mar 19 2018, 3:40 PM · Wikimedia-Mailing-lists, Accessibility
Dispenser moved T190061: Pipermail uses background color without foreground colors from Unsorted to Colors on the Accessibility board.
Mar 19 2018, 3:37 PM · Wikimedia-Mailing-lists, Accessibility
Dispenser created T190061: Pipermail uses background color without foreground colors.
Mar 19 2018, 3:36 PM · Wikimedia-Mailing-lists, Accessibility
Dispenser created T190055: Mailman on lists.wikimedia.org is not mobile friendly.
Mar 19 2018, 3:19 PM · Wikimedia-Mailing-lists, Mobile
Dispenser created T190054: Pipermail on lists.wikimedia.org is not mobile friendly.
Mar 19 2018, 3:19 PM · Wikimedia-Mailing-lists, Mobile
Dispenser closed T160654: exim breaks if current directory doesn't exist as Resolved.

Fixed upstream

Mar 19 2018, 2:53 PM · Upstream, Cloud-Services, Toolforge

Mar 6 2018

Quiddity awarded T167026: Add bash completion to sql a Love token.
Mar 6 2018, 12:22 AM · Patch-For-Review, Toolforge
Harej awarded T167026: Add bash completion to sql a Love token.
Mar 6 2018, 12:08 AM · Patch-For-Review, Toolforge
Chicocvenancio awarded T167026: Add bash completion to sql a Love token.
Mar 6 2018, 12:00 AM · Patch-For-Review, Toolforge

Mar 4 2018

Dispenser changed the status of T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas from Invalid to Resolved.

I talked with @jcrespo on IRC and with some digging (P6782) to eventually find out the index I was using wb_ips_site_page was dropped without updating the documentation (T179793#4018800).

Mar 4 2018, 10:06 PM · Regression, Data-Services, Performance, Wikidata

Feb 24 2018

Dispenser awarded T18068: New page: Special:Whois / Special:AboutIP a Like token.
Feb 24 2018, 8:32 PM · MediaWiki-extension-requests

Feb 15 2018

Dispenser updated the task description for T166025: Once it's not patent-encumbered, enable AAC-LC support for Commons uploads and TMH/etc. playback.
Feb 15 2018, 2:31 AM · UploadWizard, TimedMediaHandler, WMF-Legal, Commons, Multimedia
Dispenser added a comment to T166025: Once it's not patent-encumbered, enable AAC-LC support for Commons uploads and TMH/etc. playback.

According to MPEG-LA, MPEG-2 is patent free in the United States now.

Feb 15 2018, 2:04 AM · UploadWizard, TimedMediaHandler, WMF-Legal, Commons, Multimedia
Dispenser added a comment to T166024: Once it's not patent-encumbered, enable MPEG-2 support for Commons uploads and TMH/etc. playback.

According to MPEG-LA, MPEG-2 is patent free in the United States now.

Feb 15 2018, 2:03 AM · Patch-For-Review, UploadWizard, TimedMediaHandler, WMF-Legal, Commons, Multimedia

Feb 14 2018

Dispenser added a comment to T180890: Icons not visible in Windows' high contrast dark mode.

Similar problem in Internet Explorer 11 and Firefox, but those browsers remove background-image so it affects all high contrast modes.

Feb 14 2018, 2:30 AM · OOUI, VisualEditor, Accessibility

Feb 13 2018

RandomDSdevel awarded T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki a Like token.
Feb 13 2018, 2:44 AM · User-notice, MW-1.31-release-notes (WMF-deploy-2018-02-06 (1.31.0-wmf.20)), Easy, MediaWiki-File-management, Multimedia, Commons

Feb 12 2018

Dispenser added a comment to T186678: Improve Media Viewer in High Contrast mode..

@Volker_E I tested it, it works. Empty green boxes are better than invisible buttons.

Feb 12 2018, 7:27 PM · MediaWiki-extensions-MultimediaViewer, Multimedia, Accessibility
Dispenser added a comment to T186678: Improve Media Viewer in High Contrast mode..

A workaround if we're unable to render icons is to draw boxes when in high contrast mode with border:1px solid transparent;. The transparent color will be forced to the visible foreground color.

Feb 12 2018, 6:43 PM · MediaWiki-extensions-MultimediaViewer, Multimedia, Accessibility

Feb 7 2018

Dispenser moved T186678: Improve Media Viewer in High Contrast mode. from Unsorted to High Contrast mode on the Accessibility board.
Feb 7 2018, 3:04 AM · MediaWiki-extensions-MultimediaViewer, Multimedia, Accessibility
Dispenser created T186678: Improve Media Viewer in High Contrast mode..
Feb 7 2018, 3:01 AM · MediaWiki-extensions-MultimediaViewer, Multimedia, Accessibility

Feb 6 2018

Dispenser added a comment to T182822: Generate a list of files that are supposed to exist but 404s.

@Aklapper I'm currently analyzing SVGs files for problems 404 file, missing xmlns=, font issues, etc. In a month or two, I will download all thumbnails on Commons again for several projects of mine.

Feb 6 2018, 7:02 PM · User-ArielGlenn, Operations, Multimedia, media-storage, Commons
Dispenser updated the task description for T186621: Improve Video Player in High Contrast mode.
Feb 6 2018, 5:27 PM · Accessibility, TimedMediaHandler-Player
Dispenser moved T186621: Improve Video Player in High Contrast mode from Unsorted to High Contrast mode on the Accessibility board.
Feb 6 2018, 5:25 PM · Accessibility, TimedMediaHandler-Player
Dispenser created T186621: Improve Video Player in High Contrast mode.
Feb 6 2018, 5:24 PM · Accessibility, TimedMediaHandler-Player

Feb 5 2018

Dispenser moved T37200: <math> unreadable on high contrast theme from Unsorted to High Contrast mode on the Accessibility board.
Feb 5 2018, 3:33 PM · Accessibility, Math
Dispenser moved T54675: VisualEditor: In Firefox's High Contrast mode, buttons on the toolbar are unidentifiable from Unsorted to High Contrast mode on the Accessibility board.
Feb 5 2018, 3:33 PM · VisualEditor, Accessibility, VisualEditor-ContentEditable, Browser-Support-Firefox
Dispenser moved T180890: Icons not visible in Windows' high contrast dark mode from Unsorted to High Contrast mode on the Accessibility board.
Feb 5 2018, 3:26 PM · OOUI, VisualEditor, Accessibility

Feb 4 2018

Dispenser added a comment to T167000: Extract video encoder metadata from WebM videos.

File:An Itch in Time.webm is a recent upload with the encoder metadata extracted:

Feb 4 2018, 8:39 PM · MW-1.31-release-notes (WMF-deploy-2017-10-10 (1.31.0-wmf.3)), Patch-For-Review, TimedMediaHandler, Commons, Multimedia

Jan 31 2018

Dispenser added a comment to T43174: Many SVG files without namespace (xmlns) attribute have stopped rendering.

I've compiled a list of SVGs missing the xmlns tag for anyone who wants to fix them.

Jan 31 2018, 12:19 AM · Shell, Wikimedia-SVG-rendering

Jan 26 2018

Dispenser updated subscribers of T185673: Add base36 functions to ToolForge database.
Jan 26 2018, 1:17 PM · Data-Services, DBA

Jan 25 2018

Dispenser created T185673: Add base36 functions to ToolForge database.
Jan 25 2018, 4:29 AM · Data-Services, DBA
Dispenser reopened T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki as "Open".

@RazeSoldier has done nice work with the patch, but it should be in hexadecimal to be consistent with the API (and every sha1sum tool).

Jan 25 2018, 2:39 AM · User-notice, MW-1.31-release-notes (WMF-deploy-2018-02-06 (1.31.0-wmf.20)), Easy, MediaWiki-File-management, Multimedia, Commons

Jan 6 2018

zhuyifei1999 awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Jan 6 2018, 1:31 PM · Reading-Infrastructure-Team-Backlog, Patch-For-Review, User-Tgr, Operations, Traffic, media-storage, Commons, Multimedia, Zero

Dec 29 2017

Dispenser updated the task description for T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki.
Dec 29 2017, 11:36 AM · User-notice, MW-1.31-release-notes (WMF-deploy-2018-02-06 (1.31.0-wmf.20)), Easy, MediaWiki-File-management, Multimedia, Commons

Dec 28 2017

Dispenser triaged T183758: Create backups of user tables from decommissioned database servers as High priority.
Dec 28 2017, 10:41 PM · cloud-services-team (Kanban), Data-Services, DBA

Dec 24 2017

Dispenser added a subtask for T181932: Add SUL/CentralAuth variables to AbuseFilter: T130439: Add an AbuseFilter variable for global edit count of the user.
Dec 24 2017, 1:48 AM · MediaWiki-extensions-CentralAuth, AbuseFilter, Commons
Dispenser added a parent task for T130439: Add an AbuseFilter variable for global edit count of the user: T181932: Add SUL/CentralAuth variables to AbuseFilter.
Dec 24 2017, 1:48 AM · Patch-For-Review, MediaWiki-extensions-CentralAuth, AbuseFilter

Dec 16 2017

Dispenser added a comment to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.

Query just now on ToolForge's analytics cluster (labsdb1010): 13 min 24.37 sec. It seems to be getting worse.

Dec 16 2017, 3:35 AM · Regression, Data-Services, Performance, Wikidata

Dec 15 2017

Dispenser added a comment to T182948: Create method for accessing user watchlists in database queries.

I mean literally just that. You can try out the aforementioned gimped tool which only joins against dplbot 's pre-generated results table for enwiki, The tool calls watchlistraw OAuth or Watchlist Token to create a TEMPORARY TABLE with all the pages that you currently watch.

Dec 15 2017, 1:42 PM · Data-Services, DBA
Dispenser updated subscribers of T134135: Bring Wikipedia Zero to the United States.

"Net neutrality vote: FCC repeals Obama-era Internet rules". There are now no obstacles from regulators for getting this implemented

Dec 15 2017, 8:44 AM · Zero
Dispenser lowered the priority of T182948: Create method for accessing user watchlists in database queries from High to Normal.
Dec 15 2017, 6:04 AM · Data-Services, DBA
Dispenser triaged T182948: Create method for accessing user watchlists in database queries as High priority.
Dec 15 2017, 6:03 AM · Data-Services, DBA
Dispenser added a project to T21153: Enable dng uploads on Commons: WMF-Legal.

DNG support was torpedoed in the 2016 Community Wishlist Survey due to patent concerns. I'm interested in legal's opinion since the WMF hosted Commons Archive accepts them.

Dec 15 2017, 1:11 AM · WMF-Legal, MediaWiki-extensions-PagedTiffHandler, Commons, Multimedia, MediaWiki-File-management

Dec 14 2017

Dispenser added a comment to T182822: Generate a list of files that are supposed to exist but 404s.

I did something similar years ago to pre-generate thumbnails for WikiMiniAtlas with its unusual sizes (48x48). Stored the content-length and response code. This was useful in multiple ways, we were able to identify corrupt files, missing files, rendering problems, and had a list of thumbnails that somehow were 2 MB in size--Those ended up being very large ICC Profiles.

Dec 14 2017, 11:28 PM · User-ArielGlenn, Operations, Multimedia, media-storage, Commons

Dec 12 2017

Dispenser added a comment to T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.

@jcrespo The current pipeline is:

  1. A bash/python script on ToolForge which makes 275,000 MW API requests and bundles JSON responses in a .tar.gz on the last day of the month
  2. A python script on my server downloads that on the first of the month. Processes it which spits out a Tab-Separated Value then loads it into the database.
  3. (edit) The death_dabs.sql script then for 30 minutes creating a report for users to work off of. (Currently long running query)
Dec 12 2017, 7:39 PM · Data-Services, DBA

Dec 9 2017

Dispenser updated the task description for T166024: Once it's not patent-encumbered, enable MPEG-2 support for Commons uploads and TMH/etc. playback.
Dec 9 2017, 3:25 AM · Patch-For-Review, UploadWizard, TimedMediaHandler, WMF-Legal, Commons, Multimedia

Dec 4 2017

Liuxinyu970226 awarded T132650: Copyright detection (acoustic fingerprint matching) for audio files a Like token.
Dec 4 2017, 11:07 AM · Technical-Tool-Request, Commons

Dec 3 2017

Dispenser added a project to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas: Regression.
Dec 3 2017, 9:55 PM · Regression, Data-Services, Performance, Wikidata
Dispenser added a comment to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.

I forgot to mention that this is a regression. That code was executing under 1 second 6+ months ago and only in late November I noticed queries failing constantly.

Dec 3 2017, 5:09 PM · Regression, Data-Services, Performance, Wikidata
Dispenser created T181932: Add SUL/CentralAuth variables to AbuseFilter.
Dec 3 2017, 2:11 PM · MediaWiki-extensions-CentralAuth, AbuseFilter, Commons

Dec 2 2017

Dispenser updated the task description for T132650: Copyright detection (acoustic fingerprint matching) for audio files.
Dec 2 2017, 5:03 AM · Technical-Tool-Request, Commons

Nov 29 2017

Dispenser edited projects for T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki, added: MediaWiki-File-management, MediaWiki-Special-pages, Easy; removed media-storage.
Nov 29 2017, 5:36 PM · User-notice, MW-1.31-release-notes (WMF-deploy-2018-02-06 (1.31.0-wmf.20)), Easy, MediaWiki-File-management, Multimedia, Commons
Dispenser created T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki.
Nov 29 2017, 5:26 PM · User-notice, MW-1.31-release-notes (WMF-deploy-2018-02-06 (1.31.0-wmf.20)), Easy, MediaWiki-File-management, Multimedia, Commons

Nov 28 2017

Dispenser added a comment to T132650: Copyright detection (acoustic fingerprint matching) for audio files.

Rapid grant for hosting properitary tools?

Nov 28 2017, 8:55 PM · Technical-Tool-Request, Commons

Nov 27 2017

Dispenser created T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.
Nov 27 2017, 2:03 PM · Regression, Data-Services, Performance, Wikidata

Nov 21 2017

Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

@kaldari An AcoustID web interface for Commons.

Nov 21 2017, 6:32 PM · Patch-For-Review, Trust-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia

Nov 16 2017

Dispenser created T180723: Load .bashrc when using become.
Nov 16 2017, 6:20 PM · Toolforge
Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

@Aklapper The Checkuser information is irrecoverably gone and thus the task can no longer be completed and Invalid. You can change it to decline if you think that's more appropriate.

Nov 16 2017, 4:29 PM · Operations, Traffic, Phabricator, Zero
Dispenser closed T174342: Missing IP addresses for Maroc Telecom as Invalid.

The team squandered a perfect opportunity where a WP0 pirate broke the ISP blackholing, registered an account on mediawiki.org, and finally created an account on Phabricator to upload files. All on Maroc Telecom IP address missed by Wikipedia Zero Phabricator block and https://gerrit.wikimedia.org/r/#/c/368775/

Nov 16 2017, 4:18 PM · Operations, Traffic, Phabricator, Zero

Nov 15 2017

Dispenser added a comment to T180558: Include namespace IDs and their names to mysql wikireplicas (meta_p database).

I hope to see a namespace table added to meta_p. And with more thought. Domain isn't needed, dbname should lose _p per Labs convention, and maybe a gender flag to distinguish Benutzer and Benutzerin depending on future MW plans. Here's what it is currently (note: MediaWiki and MediaWiki Diskussion):

SELECT *
FROM s51892_toolserverdb_p.namespacename
WHERE dbname LIKE "dewiki_p"
ORDER BY FLOOR(ns_id/2), ns_is_favorite DESC, ns_type, ns_name;
dbnamedomainns_idns_namens_typens_is_favorite
dewiki_pde.wikipedia.org-2Mediumprimary1
dewiki_pde.wikipedia.org-1Spezialprimary1
dewiki_pde.wikipedia.org-2Mediacanonical0
dewiki_pde.wikipedia.org-1Specialcanonical0
dewiki_pde.wikipedia.org0primary1
dewiki_pde.wikipedia.org1Diskussionprimary1
dewiki_pde.wikipedia.org1Talkcanonical0
dewiki_pde.wikipedia.org2Benutzerprimary1
dewiki_pde.wikipedia.org3Benutzer Diskussionprimary1
dewiki_pde.wikipedia.org2Usercanonical0
dewiki_pde.wikipedia.org3User talkcanonical0
dewiki_pde.wikipedia.org3BDalias0
dewiki_pde.wikipedia.org2Benutzerinalias0
dewiki_pde.wikipedia.org3Benutzerin Diskussionalias0
dewiki_pde.wikipedia.org4Wikipediaprimary1
dewiki_pde.wikipedia.org5Wikipedia Diskussionprimary1
dewiki_pde.wikipedia.org4Projectcanonical0
dewiki_pde.wikipedia.org5Project talkcanonical0
dewiki_pde.wikipedia.org5WDalias0
dewiki_pde.wikipedia.org4WPalias0
dewiki_pde.wikipedia.org6Dateiprimary1
dewiki_pde.wikipedia.org7Datei Diskussionprimary1
dewiki_pde.wikipedia.org6Filecanonical0
dewiki_pde.wikipedia.org7File talkcanonical0
dewiki_pde.wikipedia.org6Bildalias0
dewiki_pde.wikipedia.org7Bild Diskussionalias0
dewiki_pde.wikipedia.org6Imagealias0
dewiki_pde.wikipedia.org7Image talkalias0
dewiki_pde.wikipedia.org9MediaWiki Diskussionprimary1
dewiki_pde.wikipedia.org8MediaWikicanonical1
dewiki_pde.wikipedia.org9MediaWiki talkcanonical0
dewiki_pde.wikipedia.org10Vorlageprimary1
dewiki_pde.wikipedia.org11Vorlage Diskussionprimary1
dewiki_pde.wikipedia.org10Templatecanonical0
dewiki_pde.wikipedia.org11Template talkcanonical0
dewiki_pde.wikipedia.org12Hilfeprimary1
dewiki_pde.wikipedia.org13Hilfe Diskussionprimary1
dewiki_pde.wikipedia.org12Helpcanonical0
dewiki_pde.wikipedia.org13Help talkcanonical0
dewiki_pde.wikipedia.org12Halias0
dewiki_pde.wikipedia.org13HDalias0
dewiki_pde.wikipedia.org14Kategorieprimary1
dewiki_pde.wikipedia.org15Kategorie Diskussionprimary1
dewiki_pde.wikipedia.org14Categorycanonical0
dewiki_pde.wikipedia.org15Category talkcanonical0
dewiki_pde.wikipedia.org100Portalcanonical1
dewiki_pde.wikipedia.org101Portal Diskussioncanonical1
dewiki_pde.wikipedia.org100Palias0
dewiki_pde.wikipedia.org101PDalias0
dewiki_pde.wikipedia.org828Modulprimary1
dewiki_pde.wikipedia.org829Modul Diskussionprimary1
dewiki_pde.wikipedia.org828Modulecanonical0
dewiki_pde.wikipedia.org829Module talkcanonical0
Nov 15 2017, 9:30 PM · Data-Services
Dispenser added a comment to T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.

@Marostegui It is needed in the middle of JOINs. Similar to the pagelinks table.

Nov 15 2017, 9:12 PM · Data-Services, DBA
Dispenser created T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.
Nov 15 2017, 8:59 PM · Data-Services, DBA
Dispenser created T180558: Include namespace IDs and their names to mysql wikireplicas (meta_p database).
Nov 15 2017, 4:22 AM · Data-Services
Dispenser added a comment to T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser.

@Dispenser Do you have a link to a code example?

missing_entries.sql

Nov 15 2017, 4:15 AM · DBA, Data-Services

Nov 13 2017

Dispenser added a comment to T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser.

An example from a recent created report:

  1. Table 1: Article titles with GROUP BY normalized titles HAVING COUNT(*) > 1
  2. Table 2: All links from disambiguation pages and set-index articles with redirects resolved, sorting and indexing by (target_page, dab_page)
  3. These tables are combined and outputted into the report

The initial version using a single query and was projected to be 12x slower (6-8 hours vs 30 minutes).

Nov 13 2017, 4:23 PM · DBA, Data-Services
Dispenser added a comment to T179922: Reports of global connection limit exhaustion for connections to labsdb1003.
SELECT @@hostname, @@version, @@max_user_connections, @@max_connections, "Notes       ";
hostnameversionmax_user_connectionsmax_connectionsNotes
labsdb100110.0.22-MariaDB01000Disk failure
labsdb100310.0.22-MariaDB01000Labsdb
labsdb100510.0.31-MariaDB01024tools.labsdb
labsdb100910.1.28-MariaDB101024analytics
labsdb101110.1.28-MariaDB101024web

Toolserver had max_user_connections set to 15. Firefox until June 2017 had 8 connection pipelining, so two users could saturate all your database connections. The new standard HTTP/2 uses no fewer than 100 streams, so eleven users could saturate all connections on the database server if there was no DB user limit.

Nov 13 2017, 12:13 AM · Data-Services, Toolforge

Nov 12 2017

Dispenser awarded T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser a Like token.
Nov 12 2017, 1:34 PM · DBA, Data-Services

Nov 6 2017

Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

7 days. In 7 days the IP information will start disappearing.

Nov 6 2017, 12:22 PM · Operations, Traffic, Phabricator, Zero

Nov 4 2017

Dispenser created T179767: Database replica drift on web and analytics clusters.
Nov 4 2017, 5:57 PM · Data-Services, DBA
Steinsplitter awarded P5972 Media files needing purging (WP0 related) a Yellow Medal token.
Nov 4 2017, 12:15 PM · media-storage

Nov 2 2017

Dispenser updated subscribers of T174342: Missing IP addresses for Maroc Telecom .

@Keegan You've got less than a fortnight!

Nov 2 2017, 7:08 PM · Operations, Traffic, Phabricator, Zero
Dispenser updated subscribers of T179599: Adoption of tb-dev Red Link Recovery tools.
Nov 2 2017, 6:46 PM · Toolforge-standards-committee
Dispenser created T179599: Adoption of tb-dev Red Link Recovery tools.
Nov 2 2017, 5:44 PM · Toolforge-standards-committee

Oct 20 2017

Dispenser added a comment to T178601: Add charset=utf-8 by default to lighttpd.

Here are the changes I made to that script on my server:

...
      # mime types
      next if $extensions{$_};
      $extensions{$_} = 1;
      if (substr($1, 0, 5) eq "text/" or $1 eq "application/javascript") {
         print "\".$_\" => \"$1; charset=utf-8\",\n";
      } else {
         print "\".$_\" => \"$1\",\n";
      }
    }
...

That still leaves out extensions .log, .conf, and README not listed in mime.types, but are covered by Bühler's script.

Oct 20 2017, 7:57 AM · Toolforge

Oct 19 2017

Dispenser created T178601: Add charset=utf-8 by default to lighttpd.
Oct 19 2017, 5:52 PM · Toolforge

Oct 13 2017

Dispenser edited P5972 Media files needing purging (WP0 related).
Oct 13 2017, 1:32 AM · media-storage

Oct 12 2017

Liuxinyu970226 awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Oct 12 2017, 11:44 AM · Reading-Infrastructure-Team-Backlog, Patch-For-Review, User-Tgr, Operations, Traffic, media-storage, Commons, Multimedia, Zero

Oct 6 2017

Dispenser added a comment to T171881: CL support for Wikipedia Zero piracy problems.

10 out of the 37 files deleted in the past 24 hours are still accessible (with the script I ran for @Keegan yesterday)

Oct 6 2017, 4:08 AM · Patch-For-Review, Community-Relations-Support (Oct-Dec 2017), Zero

Oct 5 2017

Dispenser added a comment to T167400: Disable serving unpatrolled new files to Wikipedia Zero users.

Since this seems to be impossible. Would adding interstitial for Facebook referrers be doable? I imagine that we'd want to discourage people from thinking our content comes from Facebook.

Oct 5 2017, 8:55 PM · Reading-Infrastructure-Team-Backlog, Patch-For-Review, User-Tgr, Operations, Traffic, media-storage, Commons, Multimedia, Zero
Steinsplitter awarded T174342: Missing IP addresses for Maroc Telecom a The World Burns token.
Oct 5 2017, 12:22 PM · Operations, Traffic, Phabricator, Zero

Sep 26 2017

Dispenser added a comment to T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads.

...Commons has a few filters for that, linked in the description of T129845 (unfortunately it seems that the filters are private...

Sep 26 2017, 12:23 AM · Community-Relations-Support (Oct-Dec 2017), Wikimedia-Site-requests

Sep 25 2017

Dispenser added a comment to T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads.

These are all known WP0 abusers--The persistent type. They'll wait a week, make edits, whatever to get passed the filters.

Sep 25 2017, 9:50 PM · Community-Relations-Support (Oct-Dec 2017), Wikimedia-Site-requests
Dispenser added a parent task for T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads: Unknown Object (Task).
Sep 25 2017, 9:43 PM · Community-Relations-Support (Oct-Dec 2017), Wikimedia-Site-requests

Sep 21 2017

Dispenser closed T170231: Upload spam as Resolved.
Sep 21 2017, 12:50 PM

Sep 19 2017

Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

The account was registered on August 15 and blocked on August 23. According to CheckUser policy this IP information will start to disappear on November 13 (90 days). I'm afraid of inaction loosing this opportunity.

Sep 19 2017, 8:48 PM · Operations, Traffic, Phabricator, Zero