Addshore added a comment.
Checked 0-10million in SQL
addshore@stat1007:~$ analytics-mysql wikidatawiki -e "SELECT DISTINCT
wbit_item_id as id FROM wbt_item_terms LEFT JOIN wbt_term_in_lang ON
wbit_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_ id = wby_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text
ON wbxl_text_id = wbx_id WHERE wbx_text IS NULL AND wbit_item_id < 10000000 AND
wbit_item_id > 0000000;" -N -B > 0to10holes-20feb0652
addshore@stat1007:~$
addshore@stat1007:~$
addshore@stat1007:~$ wc -l 0to10holes-20feb0652
90299 0to10holes-20feb0652
90k holes to double re fill, I'll start doing that now...
time mwscript extensions/Wikibase/repo/maintenance/rebuildItemTerms.php
--wiki=wikidatawiki --batch-size=50 --sleep=1 --file=0to10holes-20feb0652
TASK DETAIL
https://phabricator.wikimedia.org/T219123
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup, Addshore
Cc: Ladsgroup, Addshore, Jdforrester-WMF, ArielGlenn, Aklapper, alaa_wmde,
Iflorez, darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden,
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude,
Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
