Wikidata talk:History Query Service

From Wikidata
Jump to navigation Jump to search

Oversighted data[edit]

I wonder how this tool handles oversighted data, where for example the username has been hidden. Sjoerd de Bruin (talk) 16:29, 13 February 2019 (UTC)[reply]

@Sjoerddebruin: Sorry, I completely forgot to monitor the talk page. This tool ingests data from the XML revision dumps, so it follows what is done for dumps regarding overstight. I do not know exactly what is done for XML dumps. Tpt (talk) 16:57, 9 April 2019 (UTC)[reply]

502 bad gateway[edit]

Hi,

Not sure if this is the best place to report it ; but I just noticed that https://wdhqs.wmflabs.org/ goes in 502. @Tpt:

Hope that helps, Jean-Fred (talk) 13:47, 27 June 2019 (UTC)[reply]

Thanks a lot. I have restared the server (the Java VM failed). Tpt (talk) 08:38, 28 June 2019 (UTC)[reply]
This looks very interesting and I would like to try it out. Unfortunately, the service gives a 502 again. Acka47 (talk) 14:37, 25 October 2019 (UTC)[reply]

Thank you for keeping this service up[edit]

I just noticed that https://wdhqs.wmflabs.org/ results in a 502.

Thank you for keeping this service available. I find it very helpful

YULdigitalpreservation (talk) 13:00, 24 September 2019 (UTC)[reply]

Thank you for the notification. It should be running again. Tpt (talk) 16:22, 26 September 2019 (UTC)[reply]

502 Bad Gateway[edit]

Hi, I am not sure where to report this but https://wdhqs.wmflabs.org/ ; https://wdhqs.wmflabs.org/sparql are giving 502 bad gateway.  – The preceding unsigned comment was added by 83.86.129.73 (talk • contribs). Thanks

@Tpt: I confirm, both pages give 502 Bad Gateway. Could you have a look? Thanks, --Epìdosis 08:13, 2 March 2020 (UTC)[reply]
The service should be back. Sorry for the problem. Tpt (talk) 09:14, 2 March 2020 (UTC)[reply]
It is currently giving "502 Bad Gateway". Could you please have a look? @Tpt:. Thanks a lot in advance. Cristina Sarasua (talk) 09:58, 20 August 2020 (UTC)[reply]
@Tpt: Same here :( Vojtěch Dostál (talk) 19:36, 9 September 2020 (UTC)[reply]
It should be back now. Sorry. Tpt (talk) 21:51, 9 September 2020 (UTC)[reply]

Query does not terminate[edit]

I ran the below example query from the WDQHS paper 

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX schema: <http://schema.org/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX hist: <http://wikiba.se/history/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>

SELECT ?addedGender ?deletedGender (COUNT(?revision) AS ?count) WHERE {
  GRAPH ?addGraph { ?s wdt:P21 ?addedGender }
  ?revision hist:additions ?addGraph ; hist:deletions ?delGraph .
  GRAPH ?delGraph { ?s wdt:P21 ?deletedGender }
} GROUP BY ?addedGender ?deletedGender ORDER BY DESC(?count) LIMIT 10

While the paper indicates that the time-out is set to 5 min, I have not seen an indication that the query terminates (or even starts) within about an hour, neither were there any error messages — the progress indicator just keeps spinning. --Research Bot (talk) 20:28, 13 August 2020 (UTC)[reply]

Bad gateway[edit]

Hello, is there a chance that this service will be available? All the best. M.roszkowski (talk) 12:28, 12 February 2021 (UTC)[reply]

Bad gateway still[edit]

Hello. I'm getting the following....could this be fixed, please? 

In[2]:= endpoint = "https://wdhqs.wmflabs.org/sparql"

Out[2]= "https://wdhqs.wmflabs.org/sparql"

In[3]:= SPARQLExecute[endpoint, "PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX hist: <http://wikiba.se/history/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>

SELECT (COUNT(DISTINCT ?item) AS ?count) WHERE {
  ?globalState hist:globalStateAt \"2015-01-01T00:00:00Z\"^^xsd:dateTime .
  GRAPH ?globalState {
    ?item wdt:P31 wd:Q5
  }
}
"]

Out[3]= "502 Bad Gateway  

nginx/1.13.6"

Thanks for providing this service!

@Tpt: could you take a look? could we do something to help you maintain this tool? (it was mentionned during the WikidataCon as an important need). Cheers, VIGNERON (talk) 12:15, 31 October 2021 (UTC)[reply]
It's fixed. Sorry for the delay. I have setup a systemd module to automaticaly rerun the tool. This tool maintainance and data update is a complicated topic. Not sure where to start. Tpt (talk) 15:21, 1 November 2021 (UTC)[reply]

unclaimed projects on cloud vps are in danger of shutdown on February 1st, 2022[edit]

Hi @Tpt! wikidata-history-query-service appears to have not been claimed yet. Do you mind talking a look? News/Cloud_VPS_2021_Purge . -Mohammed Sadat (WMDE) (talk) 10:27, 11 January 2022 (UTC)[reply]

SPARQL endpoint appears to be down[edit]

This looks really useful, but the SPARQL endpoint is down. @drjwbaker Drjwbaker (talk) 16:09, 20 September 2022 (UTC)[reply]

I can confirm: I am getting "502 bad gateway" when trying to query this service. Rnnrght (talk) 19:39, 20 September 2022 (UTC)[reply]
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata_talk:History_Query_Service&oldid=1733100035"