[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Smalyshev added a comment. Yes, if there's an RC record and revision number increase, it will reload.TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Lucas_Werkmeister_WMDE, Liuxinyu970226, Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Lucas_Werkmeister_WMDE added a comment. But will a null edit also cause the WDQS updater to reload the entity?TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Lucas_Werkmeister_WMDECc: Lucas_Werkmeister_WMDE, Liuxinyu970226, Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Smalyshev added a comment. @Multichill no, the TTL export matches the data. But the data (the page_props table) does not match the actual counts in the item. Null edit would trigger the recount of page props, which will update the table.TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Liuxinyu970226, Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Multichill added a comment. In T145712#4029085, @Smalyshev wrote: So the data is not up to data in wikidata properties tables. Not sure why and how this can be fixed. Editing the item seems to fix it, so maybe there should be some bot that null-edits such items periodically? Interesting. So https://www.wikidata.org/wiki/Special:EntityData/Q1965957.ttl?flavor=dump is somehow cached and not generated from live data? Where is it cached? How does this work? If we would do null edits, what would trigger the query engine to update the data?TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: MultichillCc: Liuxinyu970226, Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Smalyshev added a comment. Looks like it's a Wikidata issue. E.g. see https://www.wikidata.org/wiki/Q1900338 - it has a statement with an identifier. However, the dump at https://www.wikidata.org/wiki/Special:EntityData/Q1900338.ttl?flavor=dump shows both wikibase:statements and wikibase:identifiers as zero. Checking the database I see: >select * from page_props where pp_page = 1830394; +-++--++ | pp_page | pp_propname| pp_value | pp_sortkey | +-++--++ | 1830394 | wb-claims | 0| 0 | | 1830394 | wb-identifiers | 0| 0 | | 1830394 | wb-sitelinks | 1| 1 | +-++--++ So the data is not up to data in wikidata properties tables. Not sure why and how this can be fixed.TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Liuxinyu970226, Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T145712: Statement counts from pageprops do not match actual ones ( wikibase:statements and wikibase:sitelinks )
Sjoerddebruin added a comment. Users will probably run into this far more often now due to the drop of wb_entity_per_page. Pages like https://www.wikidata.org/wiki/Wikidata:Database_reports/without_claims_by_site/nlwiki will feature false positives for example.TASK DETAILhttps://phabricator.wikimedia.org/T145712EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SjoerddebruinCc: Sjoerddebruin, MisterSynergy, Tgr, MZMcBride, aaron, Multichill, hoo, Esc3300, Pasleim, thiemowmde, daniel, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
