[09:17:27] PROBLEM - Check no envoy runtime configuration is left persistent on wdqs1009 is CRITICAL: connect to address 127.0.0.1 and port 9631: Connection refused https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy [09:18:01] PROBLEM - Check that envoy is running on wdqs1009 is CRITICAL: CRITICAL - Expecting active but unit envoyproxy.service is inactive https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy [14:40:27] Hi, I am trying to write a query to find a list of all female singers who are from France, are alive -- but I am struggling to write a query -- even though it seems trivial. [14:45:33] https://w.wiki/35h2 [14:45:45] https://w.wiki/35h4 [14:45:57] As soon as I add P21: is female -- it gives an error. [14:46:14] (In filter) [14:47:15] acagastya: the commented-out line is missing a P in ps:21 [14:47:46] more inclusive version of the query I posted above: https://w.wiki/35h6 [14:48:21] Oof -- can't believe a P has been the problem all along. Argh. Thanks, Lucas_WMDE. [14:49:10] What is the meaning of 'wdt:P21/wdt:P279* wd:Q6581072;' though? [14:49:27] includes “transgender female”, which is a subclass of “female” [14:49:58] the /wdt:P279* means that there can be any number of P279 (subclass of) links between the P21 value and the Q6581072 item [14:50:46] here’s another version that includes some more singers btw: https://w.wiki/35h8 [14:50:55] (by allowing both “occupation: singer” and “instrument: voice”) [14:51:41] All right -- though, in the case, I am specifically looking for a singer who isn't transgender female. I am not sure if she is alive anymore -- so I would have to search who was born no more than 50 years ago. [14:52:00] Or in the worst scenario, didn't have a correct wd entry :/ [14:58:27] alright, here’s a version with people born after 1970 https://w.wiki/35hH [15:04:17] Lucas_WMDE: What is happening with wdt:P572 in that query? P572 seems to be a deleted property. [15:04:40] I might have misremembered the ID [15:04:45] it’s supposed to be date of death [15:04:55] ah, oops, that would be P570 [15:05:55] fixed version (ping acagastya) https://w.wiki/35hL [15:05:57] thanks whym ^^ [15:06:18] no problem [15:06:24] Got it! [15:06:48] Changed occupation to recording artist and the first result was the person I was looking for. [15:07:00] Thanks a lot, Lucas_WMDE! Really appreciate the help! [15:07:07] yay \o/ [15:30:47] Lucas_WMDE: it also includes "cisgender female", so it's relevant even when people don't care about including trans women [15:31:02] true, but is that item used in practice? [15:31:09] a few, not that many though [15:31:17] 16 right now [15:31:24] hrm [15:31:32] some of them were me... but not all of them [15:31:38] I’m looking at the list via Special:WhatLinksHere [15:31:44] first one is Caster Semenya, then Mara Wilson [15:32:24] Annunziata Rees-Mogg? [15:32:29] is that, like, Jacob’s cooler sister [15:32:56] apparently [15:32:59] meh, Brexit Party MEP, not that cool I guess [15:33:41] you can be cooler than jacob and still totally uncool [15:33:48] that’s true [15:33:56] it’s a pretty low bar ^^ [15:34:04] exactly :D [22:31:09] PROBLEM - Check no envoy runtime configuration is left persistent on wdqs1010 is CRITICAL: connect to address 127.0.0.1 and port 9631: Connection refused https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy [22:42:43] PROBLEM - Check no envoy runtime configuration is left persistent on wdqs1009 is CRITICAL: connect to address 127.0.0.1 and port 9631: Connection refused https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy [22:50:44] ACKNOWLEDGEMENT - Check no envoy runtime configuration is left persistent on wdqs1009 is CRITICAL: connect to address 127.0.0.1 and port 9631: Connection refused Ryan Kemper Related to https://phabricator.wikimedia.org/T266470, will revert soon if root cause isnt found quickly https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy [22:50:44] ACKNOWLEDGEMENT - Check no envoy runtime configuration is left persistent on wdqs1010 is CRITICAL: connect to address 127.0.0.1 and port 9631: Connection refused Ryan Kemper Related to https://phabricator.wikimedia.org/T266470, will revert soon if root cause isnt found quickly https://wikitech.wikimedia.org/wiki/Application_servers/Runbook%23Envoy