Page MenuHomePhabricator

database / search / user interface inconsistency in Wikidata object
Closed, ResolvedPublicBUG REPORT

Description

Q137041536#P8322 complains about that Q18755525 violates the uniqueness constraint for property P8322. Even after purging, the constraint violation persists. Even more, using sparql to find objects https://w.wiki/GLRg (restricted to find only the one in question), Q18755525 is still listed although the user interface does not show the property P8322 any more.

a property that does not show up in the User Interface, but is flagged as a constraint violation, is difficult to delete. Using qs 3.0 deleting the property also fails as not existing.

Event Timeline

I undid my edits that lead to the inconsistent state and redid them and the problem seems to be gone now. The overall diff: https://www.wikidata.org/w/index.php?title=Q18755525&diff=2452982420&oldid=2434733815&diffmode=source

I undid my edits that lead to the inconsistent state and redid them and the problem seems to be gone now. The overall diff: https://www.wikidata.org/w/index.php?title=Q18755525&diff=2452982420&oldid=2434733815&diffmode=source

Hey @Herzi.Pinki ,
Thanks for reaching out and apologies for the lag. The fact the issue went away after re-doing the edit makes be assume this is the same class of bug as of T407702: Multiple deleted items still available in Wikidata Query Service (cc . @lerickson). It's a by-product of the change propagation from wikidata.org to WDQS than lead to drift.

There's manual steps to fix this, and what you did is something we'd suggest. There's also work to do on our end, that we'll surface and document in T407702: Multiple deleted items still available in Wikidata Query Service.

I'll be bold and resolve, since the issue has been fixed (cc @BTracy-WMF), but please do feel free to reach out T407702 if there's any further question.

gmodena claimed this task.