[00:37:44] mutante: thanks! [00:46:54] lucaswerkmeister: I'm sure there is a field somewhere that stores the actual title of an article. I'm sure this happens because, for example, the URL for the article in Wikipedia English of "wpa_supplicant" is "https://en.wikipedia.org/wiki/Wpa_supplicant" and the underscore is not replaced with an space. However, the URL for "GNU IceCat" is "https://en.wikipedia.org/wiki/GNU_IceCat" and [00:46:56] the underscore is replaced in the title. [00:50:37] that would be the DISPLAYTITLE parser function in the wikitext, I believe [00:50:51] it might be in the page_props, I can't look it up right now [00:52:29] it is https://quarry.wmcloud.org/query/60281 [03:11:36] Thanks! [03:40:22] [Q] Is there any way I can know the date in which the Wiki replica presented at Quarry started exiting? What I mean with this is that I assume that the databases at Quarry are snapshots (i.e. they are not the actual databases that the Wikimedia projects use) and that's why I want to know the date in which the snapshot was created. [03:42:12] s/exiting/existing/ [03:47:42] the databases used by Quarry are replicas that (most of the time) are updated in real time [03:48:10] occasionally the replication will lag, which you can see at https://replag.toolforge.org/ [04:40:41] AntiComposite: You are right. I just confirmed it by querying the "revision" table and seeing that the timestamps are from December 2021 [04:42:22] I tought it was similar to what happens in Stack Exchange Data Explorer where the data is updated once per quarter. [04:42:41] thought* [05:22:55] the databases do get dumped out every two weeks or so https://dumps.wikimedia.org/backup-index.html [05:23:31] but the live replication is so very useful for building all kinds of cool tools [05:29:50] (I should also mention that it wasn't always like this, and we're very thankful for the hard work from several people that it took to build the current system) [06:06:28] :) [11:36:38] !log paws deploying lsof pr-76 a378845f87ff57427b44b8a8f4b616a0a74cfbf4 [11:36:40] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Paws/SAL [13:13:24] anyone from WMDE around? I would like to confirm this Toolforge membership request is legit https://toolsadmin.wikimedia.org/tools/membership/status/1162 [13:13:39] cc Lucas_WMDE MichaelG_WMDE [13:13:57] I can confirm that an Ollie Shotton has recently started working here [13:14:29] I can ask if that’s really his Wikitech account if you want to be absolutely sure [13:14:53] thanks! I think that's enough [13:15:04] ah, https://phabricator.wikimedia.org/T296715 already has the Wikitech username [13:16:15] thanks Lucas_WMDE !! [13:17:22] np :) [13:32:55] !log capacity-exchange created new project, requested in T296556 [13:32:58] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Capacity-exchange/SAL [13:32:58] T296556: Request creation of capacity-exchange VPS project - https://phabricator.wikimedia.org/T296556 [16:18:08] !log tools.tool-db-usage Investigating crash during rendering [16:18:10] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.tool-db-usage/SAL [16:24:26] !log tools.tool-db-usage Live hacked app.py to fix None bug in processing user information [16:24:28] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.tool-db-usage/SAL [16:33:36] Can OpenRefine add sitelinks to items in the schema? I'm creating items for some categories and I would like to add sitelink to those categories. If that's not possible, is there any automated way for doing this? [16:38:08] According to https://docs.openrefine.org/manual/wikibase/overview > "With OpenRefine, you can edit the terms (labels, aliases, descriptions, or sitelinks) of Wikidata entities". However, I don't see a button for adding that information. [16:38:37] Also, I have found this feature request https://github.com/OpenRefine/OpenRefine/issues/1788 but, apparently, it hasn't been created yet. [16:41:16] rdrg109: if you don't get any responses from folks who use OpenRefine here, you might try in the #wikidata channel. [16:43:50] bd808: Ok, thanks! [16:46:07] well, from the issue you linked, it sounds like you have your answer, sitelinks aren’t supported yet… [21:25:01] !log tools.tool-db-usage Migrated from python2.5 to python3.9! [21:25:04] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.tool-db-usage/SAL [21:28:21] oops I guess it was only py3.4 before the migration I just did. [21:31:14] 2.5 would be more impressive but I think 3.4 is also out of support so still yay [21:31:41] the 3.4 container is Jessie, so yeah very stale [22:53:02] debian 8! wow! [23:24:12] that feeling when you edit a phab task and then get pinged by wikibugs in 6 different irc channels [23:24:24] heh [23:24:57] but will we stop Gerrit or Differential first 🤔 [23:25:21] (I guess it’s arguable whether Differential is being *used* for code review at the moment) [23:27:28] @lucaswerkmeister: in this particular case my only goal is to not be the last blocker to both :) [23:27:37] :D [23:53:41] !log admin adding spare cloudvirts 1044 and 1055 to the 'ceph' pool in order to make space for future juggling around T296790 and T296792 [23:53:46] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [23:53:46] T296790: decommission cloudvirt1018.eqiad.wmnet - https://phabricator.wikimedia.org/T296790 [23:53:46] T296792: decommission cloudvirt10[2,3,4].eqiad.wmnet - https://phabricator.wikimedia.org/T296792 [23:54:43] !log admin *correction* adding spare cloudvirts 1044 and 1045 to the 'ceph' pool in order to make space for future juggling around T296790 and T296792 [23:54:46] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [23:59:17] !log admin Draining 'cloudvirt1021.eqiad.wmnet'. (T296790) - cookbook ran by andrew@buster [23:59:17] !log admin Setting cloudvirt 'cloudvirt1021.eqiad.wmnet' maintenance. - cookbook ran by andrew@buster [23:59:22] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [23:59:24] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL