Maniphest T194510

Some wdqs instances are in an inconsitent state
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	hoo
	May 11 2018, 3:01 PM

Description

Query:

SELECT ?s ?sp ?so WHERE {
  wd:Q52788000 p:P5114 ?s .
  OPTIONAL { ?s ?sp ?so }
}

On wdqs1004 (incomplete):

{
  "head" : {
    "vars" : [ "s", "sp", "so" ]
  },
  "results" : {
    "bindings" : [ {
      "s" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/entity/statement/Q52788000-0EBB2082-C920-414E-89BA-8BA79EB232B1"
      }
    } ]
  }
}

On wdqs1003 (complete):

{
  "head" : {
    "vars" : [ "s", "sp", "so" ]
  },
  "results" : {
    "bindings" : [ {
      "s" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/entity/statement/Q52788000-0EBB2082-C920-414E-89BA-8BA79EB232B1"
      },
      "sp" : {
        "type" : "uri",
        "value" : "http://wikiba.se/ontology#rank"
      },
      "so" : {
        "type" : "uri",
        "value" : "http://wikiba.se/ontology#NormalRank"
      }
    }, {
      "s" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/entity/statement/Q52788000-0EBB2082-C920-414E-89BA-8BA79EB232B1"
      },
      "sp" : {
        "type" : "uri",
        "value" : "http://www.w3.org/ns/prov#wasDerivedFrom"
      },
      "so" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/reference/fa8959ba25ee302854a5700380d40129fdc49a29"
      }
    }, {
      "s" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/entity/statement/Q52788000-0EBB2082-C920-414E-89BA-8BA79EB232B1"
      },
      "sp" : {
        "type" : "uri",
        "value" : "http://www.w3.org/1999/02/22-rdf-syntax-ns#type"
      },
      "so" : {
        "type" : "uri",
        "value" : "http://wikiba.se/ontology#BestRank"
      }
    }, {
      "s" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/entity/statement/Q52788000-0EBB2082-C920-414E-89BA-8BA79EB232B1"
      },
      "sp" : {
        "type" : "uri",
        "value" : "http://www.wikidata.org/prop/statement/P5114"
      },
      "so" : {
        "type" : "literal",
        "value" : "VAEE866023"
      }
    } ]
  }
}

I didn't check the rest of the running instances…

Related Objects

Mentioned Here: T194325: Unrecognized subject messages on Updater

Event Timeline

hoo created this task.May 11 2018, 3:01 PM

Restricted Application added a project: Discovery-ARCHIVED. · View Herald TranscriptMay 11 2018, 3:01 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

AFAICT, the following query should return no results on any server, but actually returns varying results on all servers I checked:

SELECT DISTINCT ?item ?s WHERE  {
  ?item p:P5114 ?s .
  FILTER NOT EXISTS {?s ps:P5114 ?id } .
}

Related to T112397?

In T194510#4200852, @EBjune wrote:

Related to T112397?

Kind of, might both have a common root cause: This one is about to few triples existing, the other one about superfluous triples.

Floatingpurr subscribed.May 15 2018, 10:13 PM

Gehel subscribed.May 17 2018, 1:35 PM

Probably related to T194325, root cause is still unknown. This particular query is fine now though.

It seems like there is still a difference between this query (65437 items):

SELECT (count(?item) as ?c)
WHERE 
{
  ?item wdt:P5114 ?x.
}

and this one (65298 items):

SELECT ?id ?item ?mrt 
WHERE
{
  ?item p:P5114 ?s .
  ?s ps:P5114 ?id 
  OPTIONAL {?s pq:P4390 ?mrt}
}

Yes, I can see discrepancies on different servers in second query. I'll look into it.

OK, I updated broken items, queries should be in sync now. If you have any more broken ones, please post the queries here.

Thanks! : )

• Vvjjkkii renamed this task from Some wdqs instances are in an inconsitent state to 93caaaaaaa.Jul 1 2018, 1:10 AM

• Vvjjkkii reopened this task as Open.

• Vvjjkkii removed Smalyshev as the assignee of this task.

• Vvjjkkii triaged this task as High priority.

• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).

• Vvjjkkii updated the task description. (Show Details)

• Vvjjkkii removed a subscriber: Aklapper.

CommunityTechBot renamed this task from 93caaaaaaa to Some wdqs instances are in an inconsitent state.Jul 2 2018, 4:17 PM

CommunityTechBot closed this task as Resolved.

CommunityTechBot assigned this task to Smalyshev.

CommunityTechBot raised the priority of this task from High to Needs Triage.

CommunityTechBot updated the task description. (Show Details)

CommunityTechBot removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.

CommunityTechBot added a subscriber: Aklapper.

Some wdqs instances are in an inconsitent stateClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Some wdqs instances are in an inconsitent state
Closed, ResolvedPublic
Actions