[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Gehel added a parent task: T267927: Reload wikidata journal from fresh dumps. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko, Gehel Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Gehel closed this task as "Resolved". TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko, Gehel Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper, matej_suchanek, Vojtech.dostal,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

gerritbot added a comment. Change 635547 **abandoned** by ZPapierski: [wikidata/query/rdf@master] Add logging of suspicious statements Reason: Since the original issue probably happened because opcache issue, makes no sense to leave this log in Munger.

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. I wonder if this is related to T255657 , a different “strange values” bug. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. I suppose that’s possible, but I can’t think of a way to confirm it (unless we have some log that records which appserver the entity data came from). TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko added a comment. @Lucas_Werkmeister_WMDE little follow up to this - is it possible that this could be the result with opcache issues, like described here - https://phabricator.wikimedia.org/T255282 ? Date matches so we are wondering if those could be related. TASK DETAIL

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko added a comment. Little bit more on what I found: - Both eqiad and codfw were affected, but list of Q-entities was greatly different - While almost all issues were reported for truthy and reified statements, there was a single case for a reference. Interestingly, that case was

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

gerritbot added a project: Patch-For-Review. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko, gerritbot Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper, matej_suchanek,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

gerritbot added a comment. Change 635547 had a related patch set uploaded (by ZPapierski; owner: ZPapierski): [wikidata/query/rdf@master] Add logging of suspicious statements https://gerrit.wikimedia.org/r/635547 TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Vojtech.dostal added a comment. Thank you @Zbyszko TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko, Vojtech.dostal Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. I checked a few places but didn’t find anything noteworthy on that day. No idea where those came from. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To:

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko added a comment. All the entities affected were refreshed and this: SELECT ?p (COUNT(*) AS ?count) WHERE { ?s ?p . } GROUP BY ?p ORDER BY DESC(?count) no longer returns any results. All affected

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko added a comment. According to this query: SELECT DISTINCT ?item ?rev ?date WHERE { { ?st ps:P50|ps:P106|ps:P136|ps:P275|pq:P512|pq:P106 . ?item ?p ?st } UNION {

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko added a comment. First look at the issue - usual culpruits don't seem to apply here: - Munged dump is correct for one of the affected entitites - query, after loading the data into blazegraph is fine,too Interestingly, every single entity I found with this, was updated on

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper, matej_suchanek, Vojtech.dostal, Akuckartz, darthmon_wmde,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko removed Zbyszko as the assignee of this task. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko Cc: Zbyszko, CBogen, Lucas_Werkmeister_WMDE, Aklapper, matej_suchanek,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Zbyszko claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Zbyszko Cc: CBogen, Lucas_Werkmeister_WMDE, Aklapper, matej_suchanek, Vojtech.dostal, Akuckartz, darthmon_wmde, Nandana,

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

CBogen added a comment. We will time box the investigation here to 1 day of work (plus monitoring time) and then reevaluate if it is complex. TASK DETAIL https://phabricator.wikimedia.org/T264042 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To:

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

CBogen moved this task from All WDQS-related tasks to Current work on the Wikidata-Query-Service board. CBogen added a project: Discovery-Search (Current work). TASK DETAIL https://phabricator.wikimedia.org/T264042 WORKBOARD https://phabricator.wikimedia.org/project/board/891/ EMAIL

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. The affected properties are mostly “author”, but not exclusively: SELECT ?p (COUNT(*) AS ?count) WHERE { ?s ?p . } GROUP BY ?p ORDER BY DESC(?count) | p |

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. In the Wikidata output, the author looks normal – or at least, it does now: $ curl -s 'https://www.wikidata.org/wiki/Special:EntityData/Q41190637.ttl?flavor=dump=1205887158' | grep -A5 Q41190637-17758AA9-341A-48E6-89B8-C043F035FC5B

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Lucas_Werkmeister_WMDE added a comment. The results, as displayed by the WDQS UI: | item | statement1 | statement2 | autor| | | -- |

[Wikidata-bugs] [Maniphest] T264042: Query service returns weird Commons links when asking for P50 (author) statement value

Vojtech.dostal created this task. Vojtech.dostal added a project: Wikidata-Query-Service. Restricted Application added a subscriber: Aklapper. Restricted Application added a project: Wikidata. TASK DESCRIPTION Please fell free to rename the bug... also please excuse my layman reporting of