Lucas_Werkmeister_WMDE added a comment.
Unfortunately, it looks like this isn’t going to fix itself. Not only is
purging the page not enough to rewrite the page props – even edits don’t
necessarily update them. Apparently the `pp_sortkey` only becomes non-null when
the value itself changes, e.g. on L123 after I added another form:
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT pp_propname,
pp_value, pp_sortkey FROM page_props JOIN page ON pp_page = page_id WHERE
page_namespace = 146 AND page_title = 'L123';
+-------------+----------+------------+
| pp_propname | pp_value | pp_sortkey |
+-------------+----------+------------+
| wb-claims | 19 | NULL |
| wbl-forms | 1 | NULL |
| wbl-senses | 4 | NULL |
+-------------+----------+------------+
3 rows in set (0.001 sec)
mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT pp_propname,
pp_value, pp_sortkey FROM page_props JOIN page ON pp_page = page_id WHERE
page_namespace = 146 AND page_title = 'L123';
+-------------+----------+------------+
| pp_propname | pp_value | pp_sortkey |
+-------------+----------+------------+
| wb-claims | 19 | NULL |
| wbl-forms | 2 | 2 |
| wbl-senses | 4 | NULL |
+-------------+----------+------------+
3 rows in set (0.001 sec)
So I think we need some maintenance script that goes through the ~2.1 million
`page_props` rows `WHERE pp_propname IN ('wb-claims', 'wbl-forms',
'wbl-senses') AND pp_sortkey IS NULL` (in batches) and sets the sortkey based
on the value…
TASK DETAIL
https://phabricator.wikimedia.org/T350224
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: karapayneWMDE, Michael, Lucas_Werkmeister_WMDE, Danny_Benjafield_WMDE,
Astuthiodit_1, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi,
Gq86, GoranSMilovanovic, Mahir256, QZanden, LawExplorer, _jensen, rosalieper,
Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org
