SPARQL query for all painting stopped returning results
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Multichill
	May 7 2021, 9:10 AM

Description

Today I noticed some of my reports were empty like https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_sum_of_all_paintings/Image_suggestions/Creator,_institution_and_inventory_number_match&oldid=1416064318 and https://commons.wikimedia.org/w/index.php?title=User:Multichill/Same_image_without_Wikidata/Wikidata_creator,_institution_and_inventory_number_match&oldid=558322060 . After a bit of investigation I noticed a SPARQL query returning zero results.

The query https://w.wiki/3HvC used to run just fine (last successful run Thu May 6 15:00:25 UTC 2021). But stopped returning any results today. Just a minor change to the query (like removing the dots) will make it work again. What is going on here?

Related Objects

Mentioned In: T280382: WDQS hosts low on /srv disk space
Mentioned Here: T280382: WDQS hosts low on /srv disk space

Event Timeline

Multichill created this task.May 7 2021, 9:10 AM

When I run the query, I get the header:

x-served-by: wdqs1012

wdqs1012 has 0 triples according to Grafana; it’s probably supposed to be depooled?

CC @RKemper according to the wdqs1012 SAL (related to T280382 apparently)

Mentioned in SAL (#wikimedia-operations) [2021-05-07T09:55:34Z] <dcausse> depooling wdqs1012 T280382, T282222

The above log message notwithstanding, this still seems to be happening (and still with x-served-by: wdqs1012). I assume it’s not related to any particular query, but in case it is, I last saw it with https://w.wiki/3H$A (source).

My bad, the depool command I ran this morning did not work due to an error running the command (I ran sudo depool wdqs1012 instead of sudo depool so it depooled the service wdqs1012 which is nonexistent).

For the record I ran the proper command now:

dcausse@wdqs1012:~$ sudo depool
Depooling all services on wdqs1012.eqiad.wmnet
eqiad/wdqs/wdqs/wdqs1012.eqiad.wmnet: pooled changed yes => no
eqiad/wdqs/wdqs-heavy-queries/wdqs1012.eqiad.wmnet: pooled changed yes => no
eqiad/wdqs/wdqs-ssl/wdqs1012.eqiad.wmnet: pooled changed yes => no

This server should stop receiving traffic now.

In T282222#7069792, @dcausse wrote:
My bad, the depool command I ran this morning did not work due to an error running the command (I ran sudo depool wdqs1012 instead of sudo depool so it depooled the service wdqs1012 which is nonexistent).

For the record I ran the proper command now:
dcausse@wdqs1012:~$ sudo depool
Depooling all services on wdqs1012.eqiad.wmnet
eqiad/wdqs/wdqs/wdqs1012.eqiad.wmnet: pooled changed yes => no
eqiad/wdqs/wdqs-heavy-queries/wdqs1012.eqiad.wmnet: pooled changed yes => no
eqiad/wdqs/wdqs-ssl/wdqs1012.eqiad.wmnet: pooled changed yes => no
This server should stop receiving traffic now.

Thanks for the quick reply. I just assume that this solved it. I'll close this task. It can always be re-opened.

SPARQL query for all painting stopped returning resultsClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

SPARQL query for all painting stopped returning results
Closed, ResolvedPublic
Actions