Steps to replicate the issue (include links if applicable):
SELECT ?staff ?staffId WHERE {
VALUES ?staff { wd:Q27151108 }.
?staff wdt:P11227 ?staffId.
}What happens?:
No result.
What should have happened instead?:
One result with a value of 126193
I added this property to the entity yesterday: Special:Diff/2314334969
Software version (on Special:Version page; skip for WMF-hosted wikis like Wikipedia):
Other information (browser name/version, screenshots, etc.):
Mentioned in SAL (#wikimedia-operations) [2025-03-04T10:00:30Z] <dcausse> wdqs: reconciled Q27151108 on both eqiad & codfw wdqs endpoints (T386998)
Thanks for reporting this issue, unfortunately I think this event got lost.
I can't find it in both mediawiki_page_change and mediawiki_revision_create event tables:
hive (event)> select * from mediawiki_page_change_v1 where year = 2025 and month = 2 and day = 20 and revision.rev_id = 2314334969; OK _schema changelog_kind comment created_redirect_page dt meta page page_change_kind performer prior_state revision wiki_id is_wmf_domain normalized_host datacenter year month day hour Time taken: 1.847 seconds hive (event)> select * from mediawiki_revision_create where year = 2025 and month = 2 and day = 20 and rev_id = 2314334969; OK comment database meta page_id page_is_redirect page_namespace page_title parsedcomment performer rev_content_changed rev_content_format rev_content_model rev_id rev_len rev_minor_edit rev_parent_id rev_sha1 rev_timestamp chronology_id _schema rev_is_revert rev_revert_details is_wmf_domain normalized_host rev_slots dt datacenter year month day hour Time taken: 0.238 seconds
Missing events is a known issue that is being discussed in T120242.
Sure no worries, I just reconciled it.
For others I don't have great tools at hand to detect them but if they happen to be edited again they should fix themselves.
I wish we had better options to run these reconciliations (possibly something like T237502?) but the hard part is detecting them I guess...