Page MenuHomePhabricator
Create Task
Maniphest T291609

Deleted Wikidata items still returned by WQS
Closed, ResolvedPublic1 Estimated Story PointsBUG REPORT
Actions

Description

List of steps to reproduce (step by step, including full links if applicable):

Try a WQS query looking for Q531659 and Q21504507 (where I noticed the problem).

What happens?

The query returns a lot of claims for those two items.

What should have happened instead?

The query should have found nothing, these two items have been deleted three days ago: https://www.wikidata.org/wiki/Q531659, https://www.wikidata.org/wiki/Q21504507

(Note that when testing the query, once it returned just two rows with one wikibase:timestamp claim for each item; no idea if the result depends on the serving server from a cluster or what.)

Event Timeline

Mormegil created this task.Sep 23 2021, 8:40 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 23 2021, 8:40 AM
Maintenance_bot added a project: Wikidata.Sep 23 2021, 8:45 AM
• MPhamWMF moved this task from Incoming to Current work on the Wikidata-Query-Service board.Sep 27 2021, 3:20 PM
• MPhamWMF added a project: Discovery-Search (Current work).
• MPhamWMF set the point value for this task to 1.Sep 27 2021, 3:23 PM
• MPhamWMF moved this task from Incoming to Ready for Dev -- SWE on the Discovery-Search (Current work) board.
• dcausse claimed this task.Sep 27 2021, 4:12 PM
• dcausse moved this task from Ready for Dev -- SWE to Needs Reporting on the Discovery-Search (Current work) board.
• dcausse subscribed.

Ran the script to remove deleted items on the production wdqs machines (these items should disappear from wdqs results in a couple of hours).
Checked that these deleted items do not show up on query-preview.

@Mormegil thanks for the report, I manually synced these items using a script. It is a workaround we use while we wait for the new updating system (testable on https://query-preview.wikidata.org) that is going live mid-october. Please do not use nor rely on wikibase:timestamp it is an artifact of the current system and is not part of the wikibase RDF.

Mormegil added a comment.Oct 1 2021, 3:29 PM

Yep, the claims disappeared, thanks! The timestamps remain but I don’t care about those and if you say this is OK, no problem for me. (I guess this task can be closed as resolved?)

Gehel closed this task as Resolved.Oct 28 2021, 8:10 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits