Magnus (Magnus Manske)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Oct 23 2014, 3:02 PM (169 w, 1 d)
Availability
Available
LDAP User
Magnus Manske
MediaWiki User
Unknown

Recent Activity

Wed, Jan 10

Magnus created T184596: [Bug] Selector dropdowns favor mouse hover over actual selection.
Wed, Jan 10, 10:20 AM · Need-volunteer, MediaWiki-extensions-WikibaseRepository, Wikidata

Wed, Jan 3

Magnus added a comment to T182995: heavy queries from s51205, unlikely to finish?.

This is from the "wikidata-terminator" tool (which you could probably have found out quicker than I).

Wed, Jan 3, 7:05 PM · Tools
Magnus added a comment to T182867: "Login to Wikidata as QuickStatementsBot from a computer you have not recently used".

@Niharika I have turned off notifications as per suggesestion

Wed, Jan 3, 4:05 PM · MediaWiki-extensions-LoginNotify, Community-Tech, User-notice, MediaWiki-Email, MediaWiki-User-login-and-signup, Toolforge

Dec 15 2017

Magnus added a comment to T182867: "Login to Wikidata as QuickStatementsBot from a computer you have not recently used".

Yes, ListeriaBot (which edits Wikipedia) does not cause those (so far), so only Wikidata.

Dec 15 2017, 1:31 PM · MediaWiki-extensions-LoginNotify, Community-Tech, User-notice, MediaWiki-Email, MediaWiki-User-login-and-signup, Toolforge
Magnus added a comment to T182867: "Login to Wikidata as QuickStatementsBot from a computer you have not recently used".

Dec 15 2017, 1:20 PM · MediaWiki-extensions-LoginNotify, Community-Tech, User-notice, MediaWiki-Email, MediaWiki-User-login-and-signup, Toolforge
Magnus added a comment to D911: Send quantities as strings.

As this is my first patch accept in Differential, how do I merge this here? No "merge" button that I can see on this page. Probably not "commandeer", whatever that is?

Dec 15 2017, 9:15 AM
Magnus added a comment to T182867: "Login to Wikidata as QuickStatementsBot from a computer you have not recently used".

Both bots use the Addwiki lib, not sure if that uses OAuth:
https://phabricator.wikimedia.org/project/profile/1490/

Dec 15 2017, 9:07 AM · MediaWiki-extensions-LoginNotify, Community-Tech, User-notice, MediaWiki-Email, MediaWiki-User-login-and-signup, Toolforge

Dec 14 2017

Magnus created T182867: "Login to Wikidata as QuickStatementsBot from a computer you have not recently used".
Dec 14 2017, 12:55 PM · MediaWiki-extensions-LoginNotify, Community-Tech, User-notice, MediaWiki-Email, MediaWiki-User-login-and-signup, Toolforge

Dec 12 2017

Magnus triaged T182722: Ferm changes on the host node break networking for Kubernetes pods as Unbreak Now! priority.

Several of my tools appear to be affected as well, example:

Dec 12 2017, 10:46 PM · Patch-For-Review, PAWS, cloud-services-team (Kanban), Kubernetes, Toolforge

Dec 11 2017

Magnus committed R2010:68f47bdc1a56: fixing errors after patch merge (authored by Magnus).
fixing errors after patch merge
Dec 11 2017, 12:41 PM

Dec 8 2017

Magnus committed R2010:d8cd69786ee8: Merge branch 'master' of https://github.com/lucaswerkmeister/quickstatements (authored by Magnus).
Merge branch 'master' of https://github.com/lucaswerkmeister/quickstatements
Dec 8 2017, 9:25 AM
Magnus committed R2010:81cb7cc846df: misc (authored by Magnus).
misc
Dec 8 2017, 9:25 AM

Nov 28 2017

Magnus added a comment to T181486: Missing terms in wb_terms table.

@jcrespo OK, but that only means the rows were missing since the last edit, presumably, on 5 August 2017‎.

Nov 28 2017, 6:21 PM · Wikidata
Magnus added a comment to T181486: Missing terms in wb_terms table.

I did ?action=purge on the item before I filed the bug.

Nov 28 2017, 1:20 PM · Wikidata
Magnus added a comment to T181486: Missing terms in wb_terms table.
MariaDB [wikidatawiki_p]> select @@hostname;
+------------+
| @@hostname |
+------------+
| labsdb1011 |
+------------+
1 row in set (0.01 sec)
Nov 28 2017, 10:58 AM · Wikidata
Magnus added a comment to T181486: Missing terms in wb_terms table.

"sql" is the recommended shell command to connect to the replicas on Toolforge, correct?

Nov 28 2017, 10:56 AM · Wikidata
Magnus added a comment to T181486: Missing terms in wb_terms table.

Addendum:

MariaDB [wikidatawiki_p]> select @@hostname;
+------------+
| @@hostname |
+------------+
| labsdb1003 |
+------------+
1 row in set (0.00 sec)
Nov 28 2017, 10:43 AM · Wikidata
Magnus created T181486: Missing terms in wb_terms table.
Nov 28 2017, 10:41 AM · Wikidata
Magnus added a comment to T173971: Get community input on tools, bots and workflows on Wikimedia Commons that will likely be affected by Structured Data on Commons..

Please note that, while https://tools.wmflabs.org/admin/tools indeed lists all Toolforge "registered tools", many of them are containers for two or more "actual", distinct tools.

Nov 28 2017, 9:30 AM · Community-Liaisons (Jan-Mar-2018), Wikidata, Structured-Data-Commons

Nov 21 2017

SandraF_WMF awarded T181062: Adapt QuickStatements2 to be able to work with structured data on Commons as well a Mountain of Wealth token.
Nov 21 2017, 4:11 PM · GLAM-Tech, Community-Liaisons, Structured-Data-Commons, Wikidata
Magnus added a comment to T181062: Adapt QuickStatements2 to be able to work with structured data on Commons as well.

I will look into this once there is a realistic test site. QS2 is designed for multiple sites, see https://phabricator.wikimedia.org/source/tool-quickstatements/browse/master/public_html/sites.json

Nov 21 2017, 3:48 PM · GLAM-Tech, Community-Liaisons, Structured-Data-Commons, Wikidata

Nov 16 2017

Magnus added a comment to T180608: Webservice failing, but not quite.

And now it's back. Something weird is going on. Is there a load record for that tools' webservice?

Nov 16 2017, 10:41 AM · Toolforge
Magnus added a comment to T180608: Webservice failing, but not quite.

@chasemp The "missing animal audio" thing should be fixed now.

Nov 16 2017, 9:04 AM · Toolforge
Magnus added a comment to T180608: Webservice failing, but not quite.

And it's stuck again...

Nov 16 2017, 9:03 AM · Toolforge

Nov 15 2017

Magnus added a comment to T180608: Webservice failing, but not quite.

It came back after the bastion reboot. Maybe slow bastion => slow filesystem => slow tool/webservice?

Nov 15 2017, 4:08 PM · Toolforge
Magnus created T180608: Webservice failing, but not quite.
Nov 15 2017, 3:43 PM · Toolforge
Magnus closed T180512: Install/upgrade toolforge to current phpunit as Resolved.

I have now set up phpunit version 4 in a single tool. Support for that version ended February 3, 2017. However, it is the latest version that can tolerate the ancient PHP 5.59 on Toolforge.

Nov 15 2017, 10:38 AM · Toolforge

Nov 14 2017

Magnus added a comment to T180512: Install/upgrade toolforge to current phpunit.

Thanks @Reedy . Is an OS upgrade planned any time soon?

Nov 14 2017, 10:42 PM · Toolforge
Magnus added a comment to T180512: Install/upgrade toolforge to current phpunit.

Unless one has dozens of tools to install that one-at-a-time...

Nov 14 2017, 6:33 PM · Toolforge
Magnus created T180512: Install/upgrade toolforge to current phpunit.
Nov 14 2017, 6:21 PM · Toolforge
Magnus added a comment to T180380: "ERROR 2006 (HY000): MySQL server has gone away" failures for a variety of queries against Wiki Replica servers.

Update: I have added some more "re-run if failed" and "check connection/reconnect" code, and the GLAM data now seem to process more fluently. Unknown if that's because of the new code, or if upstream was fixed.

Nov 14 2017, 9:11 AM · DBA, Data-Services
Magnus added a comment to T180380: "ERROR 2006 (HY000): MySQL server has gone away" failures for a variety of queries against Wiki Replica servers.

I will list some source below, just let me emphasize this is not limited to a specific query or type of query, programming language, tool, or webservice/shell. I even see this in PetScan, which is C++ and runs on its own VM, though it uses the DB replicas as well. Also, it does not seem to be reproducible in general, but tends to "cluster" time-wise, as in, there are some time periods where there is a lot of this, some where it's a rare occurrence. I have kept no log of those periods, just thought of it as the cost of doing business, especially after my initial bug report was declined.

Nov 14 2017, 8:59 AM · DBA, Data-Services

Nov 13 2017

Magnus added a comment to T180380: "ERROR 2006 (HY000): MySQL server has gone away" failures for a variety of queries against Wiki Replica servers.

And yes, I know the disconnect happened before the *** line. In all the ~2sec it took me to type the command.

Nov 13 2017, 6:24 PM · DBA, Data-Services
Magnus added a comment to T180380: "ERROR 2006 (HY000): MySQL server has gone away" failures for a variety of queries against Wiki Replica servers.

I am sure my client can handle ~800 rows, which is what I get when I use DISTINCT, as shown...

Nov 13 2017, 6:23 PM · DBA, Data-Services
Magnus created T180380: "ERROR 2006 (HY000): MySQL server has gone away" failures for a variety of queries against Wiki Replica servers.
Nov 13 2017, 5:59 PM · DBA, Data-Services

Nov 10 2017

Magnus added a comment to T180113: Support the creation and use of volunteer tools that help to convert information in Commons categories to structured data.

Trying to decompile all these into statements and/or checks:

Nov 10 2017, 2:54 PM · Wikidata, Community-Liaisons (Apr-Jun-2018), Structured-Data-Commons

Oct 23 2017

Magnus closed T133705: Multiple concurrent long running queries from s51434 overloading labsdb1003/labsdb1009 as Resolved.
Oct 23 2017, 7:59 AM · DBA, Cloud-Services

Oct 22 2017

Magnus added a comment to T133705: Multiple concurrent long running queries from s51434 overloading labsdb1003/labsdb1009.

OK, these are my old workaround for the removal of a wikidata DB table. (I did day the removal of the table will cause problems, but does anyone ever listen to me??!?)

Oct 22 2017, 4:32 PM · DBA, Cloud-Services

Oct 16 2017

Magnus closed T178155: Cloud services analytics replicas problem as Resolved.

The problem appears to have resolved itself. I have switched everything back to normal.

Oct 16 2017, 8:53 AM · Data-Services

Oct 14 2017

Magnus triaged T178228: Can't "become TOOLNAME" on Toolforge as Unbreak Now! priority.
Oct 14 2017, 4:57 PM · User-bd808, Toolforge
Magnus created T178228: Can't "become TOOLNAME" on Toolforge.
Oct 14 2017, 4:57 PM · User-bd808, Toolforge

Oct 13 2017

Sjoerddebruin awarded T178155: Cloud services analytics replicas problem a The World Burns token.
Oct 13 2017, 2:15 PM · Data-Services
Magnus created T178155: Cloud services analytics replicas problem.
Oct 13 2017, 10:59 AM · Data-Services

Sep 28 2017

Magnus committed R2010:9137b3760086: misc (authored by Magnus).
misc
Sep 28 2017, 8:31 AM

Sep 27 2017

Magnus committed R2010:fc401a059ce9: command compresion, experimental (authored by Magnus).
command compresion, experimental
Sep 27 2017, 3:31 PM
Magnus committed R2010:8edf39a8acf0: misc (authored by Magnus).
misc
Sep 27 2017, 1:36 PM
Magnus committed R2010:871745238609: improving bot speed (authored by Magnus).
improving bot speed
Sep 27 2017, 10:20 AM

Sep 8 2017

Magnus added a comment to T175300: OAuth token broken for OAuth file uploader.

I'm not sure what causes the error, but the authentication itself seems to be successful. Can you confirm that?

Sep 8 2017, 7:18 AM · MediaWiki-extensions-OAuthAuthentication

Aug 30 2017

Magnus added a comment to T174508: Surface australian monuments for participants.

Pull request merged.

Aug 30 2017, 9:07 AM · Wiki-Loves-Monuments (2017)

Aug 25 2017

Magnus added a comment to T174140: s51203__baglama2_p generating lag on tools-db.

I just started this manually, I do this once a month for the GLAM community. It should subside quickly now.

Aug 25 2017, 9:28 AM · Tools

Aug 23 2017

Magnus closed T173708: Cannot log into Tool Labs local DB via 'sql' command as Resolved.

Everything works now after renaming/removing of .my.cnf

Aug 23 2017, 7:17 AM · Toolforge

Aug 22 2017

Magnus added a comment to T173777: ListeriaBot logs in 28000 times a day.

Daily list to work through:
https://tools.wmflabs.org/listeria/botstatus.php

Aug 22 2017, 10:14 AM · Cloud-VPS, Wikidata
Magnus added a comment to T173777: ListeriaBot logs in 28000 times a day.

It was written to do single edits, so it does log in before each one. I can try and change it if it's a problem?

Aug 22 2017, 10:14 AM · Cloud-VPS, Wikidata

Aug 21 2017

Magnus added a comment to T173708: Cannot log into Tool Labs local DB via 'sql' command.

@jcrespo But I am working as the respective "tool-user"!

Aug 21 2017, 2:05 PM · Toolforge
Magnus added a comment to T173708: Cannot log into Tool Labs local DB via 'sql' command.

Addendum: With some tools, I can connect to "local", but not create a new tool database:

Aug 21 2017, 12:52 PM · Toolforge
Magnus added a comment to T173708: Cannot log into Tool Labs local DB via 'sql' command.

@jcrespo But shouldn't the sql script automatically use the replica file? There's a "proper" user name in there, and 'sql dewiki' works fine.

Aug 21 2017, 12:40 PM · Toolforge
Magnus added a comment to T173708: Cannot log into Tool Labs local DB via 'sql' command.

Also for "flickr2commons" tool.

Aug 21 2017, 12:38 PM · Toolforge
Magnus created T173708: Cannot log into Tool Labs local DB via 'sql' command.
Aug 21 2017, 12:22 PM · Toolforge

Jul 27 2017

Magnus committed R2010:3c6bc62afaea: Manually applying patch D723 by matej_suchanek (authored by Magnus).
Manually applying patch D723 by matej_suchanek
Jul 27 2017, 10:21 AM
Magnus accepted D723: Parse quantity units from input.

Applied by manual edit

Jul 27 2017, 10:20 AM
Magnus committed R2010:1b44c01a1396: misc (authored by Magnus).
misc
Jul 27 2017, 9:50 AM

Jul 26 2017

Magnus committed R2010:f6524f51bb26: Fix for Issue #72 (authored by Magnus).
Fix for Issue #72
Jul 26 2017, 9:35 AM

Jul 25 2017

Magnus added a comment to T171033: Small-displayed images false positive at wp_no_image.

@ Paucabot No. The alternative would be to use all images on a page, but that would remove too many pages because of navbar icons and irrelevant images, which cannot be filtered out automatically.

Jul 25 2017, 8:14 AM · Readers-Web-Backlog, PageImages

Jul 24 2017

Magnus added a comment to T171466: Wikidata JS interface fails with "Unknown dependency: wikibase.mobile".
Jul 24 2017, 12:47 PM · Wikidata
Magnus added a comment to T171466: Wikidata JS interface fails with "Unknown dependency: wikibase.mobile".

Example item:
https://www.wikidata.org/wiki/Q21748978

Jul 24 2017, 12:45 PM · Wikidata
Magnus added a comment to T171466: Wikidata JS interface fails with "Unknown dependency: wikibase.mobile".

Tried action=purge, didn't help

Jul 24 2017, 12:45 PM · Wikidata
Magnus triaged T171466: Wikidata JS interface fails with "Unknown dependency: wikibase.mobile" as Unbreak Now! priority.
Jul 24 2017, 12:43 PM · Wikidata
Magnus created T171466: Wikidata JS interface fails with "Unknown dependency: wikibase.mobile".
Jul 24 2017, 12:43 PM · Wikidata

Jul 21 2017

Magnus added a comment to T171033: Small-displayed images false positive at wp_no_image.

I wrote the tool. It uses the "page image" information from the respective Wikipedia. For your example, there is no such entry. Ergo, this needs to be fixed in MediaWiki core, or the respective extension.

Jul 21 2017, 11:48 AM · Readers-Web-Backlog, PageImages

Jul 14 2017

Magnus closed T169040: MediaWiki instance on Tool Labs used as a spam relay as Resolved.

Last page had a "\" in the title, maintenance script didn't remove it. Killed on DB prompt now.

Jul 14 2017, 10:21 AM · Tools

Jul 13 2017

Magnus added a comment to T169653: Redirect wdq.wmflabs.org to query.wikidata.org.

I have removed the webproxy and the instance from the wdq project.

Jul 13 2017, 8:33 AM · Cloud-VPS, cloud-services-team (Kanban), User-bd808

Jul 11 2017

Magnus added a comment to T157436: [Flickr2Commons] File uploads need to recognise urls on blacklist early in the process.

Flickr2Commons issue tracker:
https://bitbucket.org/magnusmanske/flickr2commons/issues?status=new&status=open

Jul 11 2017, 12:50 PM · Tools

Jul 6 2017

Magnus closed T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists as Resolved.

All done now, thanks :-)

Jul 6 2017, 10:37 AM · Wikidata
Magnus closed T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists, a subtask of T153439: Sunset of WDQ, as Resolved.
Jul 6 2017, 10:37 AM · Cloud-VPS, Discovery, Wikidata, Wikidata-Query-Service
Magnus closed T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists, a subtask of T153442: Listeriabot should stop accepting old style wdq syntax in Template:Wikidata list, as Resolved.
Jul 6 2017, 10:37 AM · Wikidata
Magnus closed T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists, a subtask of T153546: monitor Listeria botstatus, as Resolved.
Jul 6 2017, 10:37 AM · Need-volunteer, Wikidata-Query-Service, Wikidata, Discovery
Magnus reopened T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists as "Open".

One left, but es.wp won't let me change it:
https://es.wikipedia.org/wiki/Usuario:Aeroid/Lista_de_los_distritos_de_la_Baja_Sajonia

Jul 6 2017, 9:18 AM · Wikidata
Magnus reopened T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists, a subtask of T153439: Sunset of WDQ, as Open.
Jul 6 2017, 9:18 AM · Cloud-VPS, Discovery, Wikidata, Wikidata-Query-Service
Magnus reopened T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists, a subtask of T153442: Listeriabot should stop accepting old style wdq syntax in Template:Wikidata list, as Open.
Jul 6 2017, 9:17 AM · Wikidata

Jul 5 2017

Magnus added a comment to T153439: Sunset of WDQ.

@Multichill AFAICT it's only wdq-mm-01 left in the wdq-mm project. Switched off since April 6.

Jul 5 2017, 11:59 AM · Cloud-VPS, Discovery, Wikidata, Wikidata-Query-Service

Jul 4 2017

Magnus added a comment to T153441: Deprecate WDQ in Template:Wikidata list and switch remaining lists.

And I can't change that usage because I get caught in some spam filter. Any es admin around?

Jul 4 2017, 9:36 AM · Wikidata
Magnus closed T153623: find an alternative for bulk use of Autolist2 as Resolved.
Jul 4 2017, 7:51 AM · Discovery, Wikidata-Query-Service, Wikidata
Magnus closed T153623: find an alternative for bulk use of Autolist2, a subtask of T153439: Sunset of WDQ, as Resolved.
Jul 4 2017, 7:51 AM · Cloud-VPS, Discovery, Wikidata, Wikidata-Query-Service

Jun 29 2017

Daniel_Mietchen awarded T169210: Restarting tools after NFS issues a Piece of Eight token.
Jun 29 2017, 8:38 PM · Toolforge, Tools
Pigsonthewing awarded T169210: Restarting tools after NFS issues a Like token.
Jun 29 2017, 5:47 PM · Toolforge, Tools
Jane023 awarded T169210: Restarting tools after NFS issues a Orange Medal token.
Jun 29 2017, 1:43 PM · Toolforge, Tools
Jane023 awarded T169210: Restarting tools after NFS issues a Cookie token.
Jun 29 2017, 1:43 PM · Toolforge, Tools
Magnus created T169210: Restarting tools after NFS issues.
Jun 29 2017, 12:44 PM · Toolforge, Tools
Magnus closed T169040: MediaWiki instance on Tool Labs used as a spam relay as Resolved.

Spam deleted, database locked. The "actual" tool at https://tools.wmflabs.org/comprende/ still works in read-only mode.

Jun 29 2017, 7:36 AM · Tools

Jun 28 2017

Magnus added a comment to T169040: MediaWiki instance on Tool Labs used as a spam relay.

Running cleanup now, will lock afterwards.

Jun 28 2017, 9:29 AM · Tools

Jun 21 2017

Magnus committed R2010:4452d50e0b1e: misc (authored by Magnus).
misc
Jun 21 2017, 2:55 PM
Magnus committed R2010:d21ecb50a41f: misc (authored by Magnus).
misc
Jun 21 2017, 2:53 PM
Magnus committed R2010:b965d1d17d2e: misc (authored by Magnus).
misc
Jun 21 2017, 1:25 PM

Jun 20 2017

Magnus added a comment to T168375: Heavy 19-hour quries on labsdb1005 (tools-db) by s51203 at s51203__baglama2_p.

I have rewritten the query, should work better now I hope

Jun 20 2017, 3:25 PM · Tools
Magnus committed R2010:a229eb36c4dc: misc (authored by Magnus).
misc
Jun 20 2017, 2:07 PM

Jun 19 2017

Magnus updated the task description for T168057: create slide deck with Wikidata showcases.
Jun 19 2017, 10:06 AM · GLAM, Wikidata
Magnus added a comment to T167267: ssh-dss (DSA) keys fail for Labs instances with "debian-9.0-stretch (experimental)" image.
ssh magnus@petscan-dev.petscan.eqiad.wmflabs
Permission denied (publickey).
Killed by signal 1.
Jun 19 2017, 8:05 AM · Cloud-Services, Cloud-VPS

Jun 16 2017

Magnus added a comment to T166949: Homedir/UID info breaks after a while in Tools Kubernetes (can't read replica.my.cnf).

Yes, I have been restarting at least a dozen tools because of this over the last week or two (?).

Jun 16 2017, 3:18 PM · Kubernetes, Toolforge, Cloud-VPS, Tools-Kubernetes
Magnus updated the task description for T168057: create slide deck with Wikidata showcases.
Jun 16 2017, 12:48 PM · GLAM, Wikidata
Magnus updated the task description for T168057: create slide deck with Wikidata showcases.
Jun 16 2017, 12:47 PM · GLAM, Wikidata