[02:00:34] RECOVERY - WDQS high update lag on wdqs2001 is OK: (C)4.32e+04 ge (W)2.16e+04 ge 2.139e+04 https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook%23Update_lag https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [03:18:02] PROBLEM - WDQS SPARQL on wdqs1013 is CRITICAL: CRITICAL - Socket timeout after 10 seconds https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [03:36:38] RECOVERY - WDQS SPARQL on wdqs1013 is OK: HTTP OK: HTTP/1.1 200 OK - 689 bytes in 1.070 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [06:01:20] RECOVERY - Query Service HTTP Port on wdqs1004 is OK: HTTP OK: HTTP/1.1 200 OK - 448 bytes in 0.024 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service [06:01:34] RECOVERY - WDQS high update lag on wdqs2004 is OK: (C)3600 ge (W)1200 ge 505.3 https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook%23Update_lag https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen [06:02:22] RECOVERY - WDQS SPARQL on wdqs1004 is OK: HTTP OK: HTTP/1.1 200 OK - 689 bytes in 1.076 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [07:45:23] Hi, any admin who can block the IP 5.90.37.88 for LTA and cross-wiki? [09:39:56] Hi, for some perf evaluation I'm looking for few very big items (overall json size), anyone has one or two to share? Thanks! [10:03:49] til https://www.wikidata.org/wiki/Special:LongPages :) [11:17:43] dcausse: "oh wow... they're HOW BIG!?" [14:41:29] PROBLEM - Check systemd state on wdqs1003 is CRITICAL: CRITICAL - degraded: The following units failed: prometheus-blazegraph-exporter-wdqs-blazegraph.service,wdqs-updater.service,wmf_auto_restart_prometheus-blazegraph-exporter-wdqs-blazegraph.service https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [15:11:53] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The following units failed: prometheus-blazegraph-exporter-wdqs-blazegraph.service,wdqs-updater.service https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [16:01:11] PROBLEM - WDQS SPARQL on wdqs1008 is CRITICAL: CRITICAL - Socket timeout after 10 seconds https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [16:04:13] RECOVERY - WDQS SPARQL on wdqs1008 is OK: HTTP OK: HTTP/1.1 200 OK - 688 bytes in 1.061 second response time https://wikitech.wikimedia.org/wiki/Wikidata_query_service/Runbook [20:08:32] Hello, I'm doing a project about gender visibility in the home page of every wikipedia, but I'm quite new to SPARQL, so I'm wondering if anyone here could help me with a query. I need to get the Qs of a given set of article names or page_id of a given language. Thank you in advance! [20:21:54] Hello, I'm doing a project about gender visibility in the home page of every wikipedia, but I'm quite new to SPARQL, so I'm wondering if anyone here could help me with a query. I need to get the Qs of a given set of article names or page_id of a given language. Thank you in advance! [20:23:18] Hi! Sorry, I'm quite new to IRC, I just registered but I don't know if anyone can read me. Can anyone read me? Thank you! [20:30:20] Hi! Sorry, I'm quite new to IRC, I just registered but I don't know if anyone can read me. Can anyone read me? Thank you! [20:48:52] hi! [20:49:06] Hello [20:50:01] Hello, I'm doing a project about gender visibility in the home page of every wikipedia, but I'm quite new to SPARQL, so I'm wondering if anyone here could help me with a query. I need to get the Qs of a given set of article names or page_id of a given language. Thank you in advance! [22:04:44] [mattermost] Destokado: you probably want to get the `wikibase_item` page prop via the API? e.g. https://en.wikipedia.org/w/api.php?action=query&format=json&prop=pageprops&titles=Douglas%20Adams&ppprop=wikibase_item [22:04:59] [mattermost] (I used `titles` but you could also use `pageids` or a generator) [22:07:40] And could you instruct me on how to write that query? thanks [22:09:29] Yes sorry, I want to get the wikibase items QXXX of each page_id or page_title introduced [22:11:01] I cannot see the query, I just see the result (batchcomplete......) by using the link you provided [22:11:14] [mattermost] well, it’s an API request, not a SPARQL query [22:11:21] [mattermost] because it sounds like you don’t actually need SPARQL for this? [22:11:32] [mattermost] you would just change the parameters for that API request [22:11:50] [mattermost] I used `titles=Douglas Adams` (URL-encoded, so `%20` instead of ` `) as an example [22:12:04] [mattermost] you could put other titles there (separated by `|`) [22:12:16] [mattermost] or page IDs [22:12:28] [mattermost] the API Sandbox can be very useful to experiment with the API https://en.wikipedia.org/wiki/Special:ApiSandbox [22:12:50] Oh thank you so much! I need the Q to check if its a person and check its gender, but i didnt know i could do that with the API [22:39:12] PROBLEM - puppet last run on wdqs2001 is CRITICAL: CRITICAL: Puppet last ran 6 hours ago https://wikitech.wikimedia.org/wiki/Monitoring/puppet_checkpuppetrun [22:39:54] PROBLEM - puppet last run on wdqs2008 is CRITICAL: CRITICAL: Puppet last ran 6 hours ago https://wikitech.wikimedia.org/wiki/Monitoring/puppet_checkpuppetrun [22:51:52] RECOVERY - puppet last run on wdqs2001 is OK: OK: Puppet is currently enabled, last run 4 minutes ago with 0 failures https://wikitech.wikimedia.org/wiki/Monitoring/puppet_checkpuppetrun [22:58:52] RECOVERY - puppet last run on wdqs2008 is OK: OK: Puppet is currently disabled (transferring wikidata journal following reload from dumps - ryankemper@cumin2001 - T267927), not alerting. Last run 5 minutes ago with 0 failures https://wikitech.wikimedia.org/wiki/Monitoring/puppet_checkpuppetrun [23:03:10] sorry to bother you again Lucas. Is there a way to directly make an SQL query instead of using the REST languages? thank you. My query is like this https://quarry.wmflabs.org/query/54121 [23:04:50] [mattermost] Destokado: not without Toolforge access, I think (see https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database and related pages) [23:05:10] [mattermost] I’m not aware of Quarry having a non-interactive interface [23:05:13] [mattermost] at least [23:05:51] Hmm okay i'll check that out. I'm waiting for my member request to be accepted. THank you again! you saved me lots of wasted hours [23:20:20] [mattermost] glad to be of service ;) [23:52:49] Quiero retirar mi direccion ip de la pagina [23:53:02] como lo hago}