Wikidata:Report a technical problem/WDQS and Search/Archive/2021

This is a subindex of archived discussions from Wikidata:Report a technical problem/WDQS and Search. To place a page in Category:WDQS and Search archive, place {{Archive|category=WDQS and Search archive}} at the top of the page.

id missing in result

# Mandals in Andhra pradesh with district and tewiki page_title

SELECT ?mandal ?mandalLabel ?districtLabel ?page_titleTE  WHERE {
  ?mandal wdt:P31 wd:Q817477;
        p:P131 ?districtstate.
  ?districtstate ps:P131 wd:Q15394.

  MINUS {?districtstate pq:P582 ?endTime.}
  ?article schema:about ?mandal;
           schema:isPartOf <https://te.wikipedia.org/>;
           schema:name ?page_titleTE.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "te,en".}

}

Try it!

should show 43 results, but only shows 42, with Q59902712 missing. This id was restored after it was redirected a week back, as it is used in OSM. --Arjunaraoc (talk) 11:22, 21 July 2021 (UTC)

@Arjunaraoc: Should be fixed now - diff. Q59902712 had an old value for tehsil - Q13005188, which had not been updated to the current value of Q817477. --Tagishsimon (talk) 12:07, 21 July 2021 (UTC)

Problem with the buttons "Search(results)" and "hide/show pagination"

Good morning from Vienna,

numerous times I tried to enter the following query:

"SELECT ?item WHERE {

 ?item wdt:P31 wd:Q3305213.
 FILTER NOT EXISTS  {?item wdt:P1257 ?icon}
 }"

Results appeared after 12 up to 45 seconds(average: 23).

The list starts with "Q72650". I noticed that there are several paintings without the attribute of iconclass with a qualifier lower than 72650, e.g. Q23912. Therefore I wanted to search for that other item in the panel, or to press the button hide/show pagination. In either case the warning was displayed "page(site) does not respond. you can wait or leave". The problem was not solved by waiting, so I had to skip. What could be the reason for that issue? Regards, Christoph

Cross posted to Request a Query, where it's being dealt with. Please raise issues in one place only. --Tagishsimon (talk) 10:19, 21 August 2021 (UTC)

No me trae la propiedad pseudonym wdt:P742 y el isni

   SELECT distinct  ?author ?authorLabel ?dob ?dod ?birthplaceLabel ?goodreads ?countryLabel  ?workLabel ?isniLabel

(GROUP_CONCAT(?occupationLabel; separator = ", ") as ?occupationLabels) (GROUP_CONCAT(?educatedLabel; separator = ", ") as ?educatedLabels ) (GROUP_CONCAT(?nomineeLabel; separator = ", ") as ?nomineeLabels) (GROUP_CONCAT(?awardLabel; separator = ", ") as ?awareLabels ) (GROUP_CONCAT(?genreLabel; separator = ", ") as ?genreLabels ) (GROUP_CONCAT(?pseudonymLabel; separator = ", ") as ?pseudonymLabels )

WHERE { ?author rdfs:label "Jorge Luis Borges"@es .?author rdfs:label ?authorLabel filter (lang(?authorLabel)='es').

       OPTIONAL {?author wdt:P569 ?dob } .
        OPTIONAL {?author wdt:P570 ?dod } .
       OPTIONAL {?author wdt:P19 ?birthplace .?birthplace rdfs:label ?birthplaceLabel filter (lang(?birthplaceLabel) = "es")}.

OPTIONAL {?author wdt:P2963 ?goodreads } . OPTIONAL {?author wdt:P27 ?country .?country rdfs:label ?countryLabel filter (lang(?countryLabel) = "es")}. OPTIONAL {?author wdt:P742 ?pseudonym .?pseudonym rdfs:label ?pseudonymLabel }. OPTIONAL {?author wdt:P106 ?occupation .?occupation rdfs:label ?occupationLabel filter (lang(?occupationLabel) = "es")} . OPTIONAL {?author wdt:P101 ?work .?work rdfs:label ?workLabel filter (lang(?workLabel) = "es")}. OPTIONAL {?author wdt:P1411 ?nominee .?nominee rdfs:label ?nomineeLabel filter (lang(?nomineeLabel) = "es")}. OPTIONAL {?author wdt:P69 ?educated .?educated rdfs:label ?educatedLabel filter (lang(?educatedLabel) = "es")}. OPTIONAL {?author wdt:166 ?award .?award rdfs:label ?awardLabel}. OPTIONAL {?author wdt:213 ?isni .?isni rdfs:label ?isniLabel}. OPTIONAL {?author wdt:136 ?genre .?genre rdfs:label ?genreLabel filter (lang(?genreLabel) = "es")}. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]" }} GROUP BY ?author ?authorLabel ?dob ?dod ?birthplaceLabel ?goodreads ?countryLabel ?workLabel ?isniLabel

Various things to change. ISNI and Pseudonym do not have labels. Various predicates were missing the letter P. Please consider using Wikidata:Request a query for this sort of question in future; thx.

SELECT distinct  ?author ?authorLabel ?dob ?dod ?birthplaceLabel ?goodreads ?countryLabel  ?workLabel ?isni
(GROUP_CONCAT(DISTINCT ?occupationLabel; separator = ", ") as ?occupationLabels) 
(GROUP_CONCAT(DISTINCT ?educatedLabel; separator = ", ") as ?educatedLabels ) 
(GROUP_CONCAT(DISTINCT ?nomineeLabel; separator = ", ") as ?nomineeLabels) 
(GROUP_CONCAT(DISTINCT ?awardLabel; separator = ", ") as ?awardLabels )
(GROUP_CONCAT(DISTINCT ?genreLabel; separator = ", ") as ?genreLabels )
(GROUP_CONCAT(DISTINCT ?pseudonym; separator = ", ") as ?pseudonyms )
WHERE 
{ 
  ?author rdfs:label "Jorge Luis Borges"@es .
  ?author rdfs:label ?authorLabel filter (lang(?authorLabel)='es').
  OPTIONAL {?author wdt:P569 ?dob } .
  OPTIONAL {?author wdt:P570 ?dod } .
  OPTIONAL {?author wdt:P19 ?birthplace .?birthplace rdfs:label ?birthplaceLabel filter (lang(?birthplaceLabel) = "es")}.
  OPTIONAL {?author wdt:P2963 ?goodreads } . 
  OPTIONAL {?author wdt:P27 ?country .?country rdfs:label ?countryLabel filter (lang(?countryLabel) = "es")}. 
  OPTIONAL {?author wdt:P742 ?pseudonym }. 
  OPTIONAL {?author wdt:P106 ?occupation .?occupation rdfs:label ?occupationLabel filter (lang(?occupationLabel) = "es")} . 
  OPTIONAL {?author wdt:P101 ?work .?work rdfs:label ?workLabel filter (lang(?workLabel) = "es")}. 
  OPTIONAL {?author wdt:P1411 ?nominee .?nominee rdfs:label ?nomineeLabel filter (lang(?nomineeLabel) = "es")}. 
  OPTIONAL {?author wdt:P69 ?educated .?educated rdfs:label ?educatedLabel filter (lang(?educatedLabel) = "es")}. 
  OPTIONAL {?author wdt:P166 ?award . ?award rdfs:label ?awardLabel  filter (lang(?awardLabel) = "es")}. 
  OPTIONAL {?author wdt:P213 ?isni }. 
  OPTIONAL {?author wdt:P136 ?genre .?genre rdfs:label ?genreLabel filter (lang(?genreLabel) = "es")}. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]" }
} GROUP BY ?author ?authorLabel ?dob ?dod ?birthplaceLabel ?goodreads ?countryLabel ?workLabel ?isni

Try it!

--Tagishsimon (talk) 16:37, 29 October 2021 (UTC)

query server data outdated (8 Dec 2021)

Tracked in Phabricator
Task T293862

Tracked in Phabricator
Task T279541

I seem to get data already updated yesterday. --- Jura 10:06, 8 December 2021 (UTC)

Is there anything specific you found that was not updated so that we can have deeper look at the problem? The current known problems that we are currently working on that might be related to what you've seen:

• Implement a solution to rapidly identify & restart WDQS servers hit by deadly queries (phab:T293862). Currently some servers may enter a zombie state for quite some time (several hours) possibly exposing stale results when they resurrect.
• Implement a reconciliation strategy for the streaming updater (phab:T279541). This is about being more reactive to inconsistencies between wikidata & WDQS.

Please let me know if you think that the problem you encountered is unrelated to the two items above, Thanks! DCausse (WMF) (talk) 14:46, 13 December 2021 (UTC)

Possibly T279541 solves it, but I don't really see how I could determine that.

In the meantime, it was updated on WDQS. Is there some information that I should gather when reporting this? The icon on WDQS was green.

@DCausse (WMF): --- Jura 12:47, 16 December 2021 (UTC)

As reported elsewhere the icon is sadly not a good indication, esp. if only one server is lagging. The exact time at which the problem was encountered will help to find a correlation with problematic servers if any. If the problem persists even after several hours then it might be an incoherence, reporting the wikidata item impacted will help us to debug the issue. Thanks! DCausse (WMF) (talk) 15:35, 16 December 2021 (UTC)

Is there a way for me to determine which server it may be?

@DCausse (WMF): --- Jura 17:52, 16 December 2021 (UTC)

From the query service perspective there are no ways to know if the results seen are from a server that is under lag, this is something we may address at some point and is tracked under phab:T278246.

The only way for us is to correlate reports with the lag reported in https://grafana.wikimedia.org/d/000000489/wikidata-query-service?orgId=1. DCausse (WMF) (talk) 10:48, 17 December 2021 (UTC)

Ok, so I guess it's worth reporting if it can't be found there or if it's starts getting overly long.

Looking at [1] now, it seems I could probably have found it there. --- Jura 13:56, 17 December 2021 (UTC)

Added it to the notice for this page: [2]. --- Jura 11:21, 18 December 2021 (UTC)