Reported on slack... Originally ~22K rows
SELECT * FROM centralauth.localuser WHERE lu_global_id IS NOT NULL AND lu_local_id IS NULL
Ran populateLocalAndGlobalIds.php and this is now down to 475 rows
+---------------+---------------------------------------------+-----------------------+--------------------+-------------+--------------+----------------------+ | lu_wiki | lu_name | lu_attached_timestamp | lu_attached_method | lu_local_id | lu_global_id | lu_attachment_method | +---------------+---------------------------------------------+-----------------------+--------------------+-------------+--------------+----------------------+ | commonswiki | Fooof mohd | 20160718032243 | new | NULL | 47225338 | NULL | | commonswiki | Kaypeas | 20160713201143 | new | NULL | 47191154 | NULL | | commonswiki | LucianoBaruchbenhaim | 20160714220323 | new | NULL | 47200670 | NULL | | commonswiki | Mairie bournazel 12 | 20160720161942 | new | NULL | 47248421 | NULL | | commonswiki | Manolo LHH | 20160719131643 | new | NULL | 47237988 | NULL | | commonswiki | Mehsnr5659 | 20160717071827 | new | NULL | 47218605 | NULL | | commonswiki | Sanjeeb.common | 20160719121621 | new | NULL | 47237502 | NULL | | cswiki | Frantisek juhas | 20160714070751 | new | NULL | 47194495 | NULL | | cswiki | Lucka Bednářová | 20160717191019 | new | NULL | 47222868 | NULL | | dewiki | Florian349 | 20160716185500 | new | NULL | 47215257 | NULL | | dewiki | Ludwig1963 | 20160714192447 | new | NULL | 47199762 | NULL | | dewiki | M`Konkwo | 20160718204959 | new | NULL | 47232347 | NULL | | dewiki | PSMLugano | 20160718151417 | new | NULL | 47230029 | NULL | | dewiki | Ralfprofclash | 20160718211858 | new | NULL | 47232539 | NULL | | dewiki | Taminofreshwissen | 20160720131513 | new | NULL | 47246970 | NULL | | dewiki | Users344 | 20160718141125 | new | NULL | 47229487 | NULL | | dewiki | Wasserbraunkotierer | 20160721185319 | new | NULL | 47258483 | NULL | | dewiki | Wissenswurm2000 | 20160717141947 | new | NULL | 47221012 | NULL | | dewiktionary | Seufz94 | 20160718131439 | new | NULL | 47229069 | NULL | | elwiki | Mariazamb | 20160716082556 | new | NULL | 47211427 | NULL | | elwiki | Seteee | 20160717114650 | new | NULL | 47220064 | NULL | | enwiki | Athemal Sy | 20160716002201 | new | NULL | 47209358 | NULL | | enwiki | Billericay37 | 20160717063132 | new | NULL | 47218361 | NULL | | enwiki | CABBIE7363 | 20160719061926 | new | NULL | 47235068 | NULL | | enwiki | Chouhaw | 20160716045046 | new | NULL | 47210354 | NULL | | enwiki | Cohen's c | 20160714162639 | new | NULL | 47198565 | NULL | | enwiki | Dgnair1986 | 20160717065821 | new | NULL | 47218494 | NULL | | enwiki | DoItGoodFortWayne | 20160715101557 | new | NULL | 47204222 | NULL | | enwiki | Erica Foo | 20160714081911 | new | NULL | 47194984 | NULL | | enwiki | Factonid | 20160718093525 | new | NULL | 47227519 | NULL | | enwiki | Fahim0890 | 20160720025643 | new | NULL | 47243073 | NULL | | enwiki | FandomTrashcan | 20160719231535 | new | NULL | 47242064 | NULL | | enwiki | Farhad149 | 20160715002701 | new | NULL | 47201307 | NULL | | enwiki | FawziaXu | 20160720085605 | new | NULL | 47245089 | NULL | | enwiki | Filmdude1737 | 20160714094631 | new | NULL | 47195636 | NULL | | enwiki | Filmdude1995 | 20160714094525 | new | NULL | 47195626 | NULL | | enwiki | FriendsLover9 | 20160715090503 | new | NULL | 47203810 | NULL | | enwiki | Gabbyjimene | 20160718072500 | new | NULL | 47226556 | NULL | | enwiki | George boiteux | 20160721170627 | new | NULL | 47257722 | NULL | | enwiki | Ghostmen101 | 20160718153303 | new | NULL | 47230184 | NULL | | enwiki | Gkikez | 20160718025447 | new | NULL | 47225212 | NULL | | enwiki | Gontardd | 20160719124521 | new | NULL | 47237741 | NULL | | enwiki | Gracebardell | 20160718183953 | new | NULL | 47231510 | NULL | | enwiki | Gubbybubby | 20160721181854 | new | NULL | 47258251 | NULL | | enwiki | Gurusamymuthuraj | 20160716092908 | new | NULL | 47211757 | NULL | | enwiki | Gyamana | 20160720135005 | new | NULL | 47247213 | NULL | | enwiki | HMonnn | 20160720085516 | new | NULL | 47245083 | NULL | | enwiki | HadiSalameh | 20160715234526 | new | NULL | 47209231 | NULL | | enwiki | HazzaIsYeBoi | 20160716154231 | new | NULL | 47214036 | NULL | | enwiki | Hemanth hiremath hemu | 20160714213924 | new | NULL | 47200537 | NULL | | enwiki | HeyParis | 20160719153144 | new | NULL | 47239095 | NULL | | enwiki | Heyitsmelauren | 20160720085414 | new | NULL | 47245075 | NULL | | enwiki | Highsix | 20160714225040 | new | NULL | 47200875 | NULL | | enwiki | Hiliyeh Ho | 20160721100543 | new | NULL | 47254413 | NULL | | enwiki | HolidayTidings | 20160715055932 | new | NULL | 47202790 | NULL | | enwiki | Hoodinfoong | 20160721143022 | new | NULL | 47256401 | NULL | | enwiki | Hossain20835 | 20160718150823 | new | NULL | 47229983 | NULL | | enwiki | Howardjmc | 20160717222851 | new | NULL | 47224024 | NULL | | enwiki | HuiShang1987 | 20160720195903 | new | NULL | 47249983 | NULL | | enwiki | Hunterk30 | 20160719214513 | new | NULL | 47241577 | NULL | | enwiki | IPhauumout | 20160720062340 | new | NULL | 47244115 | NULL | | enwiki | Iansousabreker | 20160719223858 | new | NULL | 47241846 | NULL | | enwiki | Idmd786 | 20160715183243 | new | NULL | 47207602 | NULL | | enwiki | Ihiddhh | 20160720213051 | new | NULL | 47250509 | NULL | | enwiki | Ijime-dame-zettai | 20160714144432 | new | NULL | 47197794 | NULL | | enwiki | Imagecomer | 20160715004544 | new | NULL | 47201390 | NULL | | enwiki | Indrapooja creation | 20160721102104 | new | NULL | 47254528 | NULL | | enwiki | Ishdesai95 | 20160718032818 | new | NULL | 47225369 | NULL | | enwiki | Jadinelovers | 20160721092641 | new | NULL | 47254144 | NULL | | enwiki | Jamesalexcurtis | 20160718065036 | new | NULL | 47226371 | NULL | | enwiki | Jamica16 | 20160714104636 | new | NULL | 47196063 | NULL | | enwiki | JamieLayfield | 20160715171139 | new | NULL | 47207086 | NULL | | enwiki | Janiayah2002 | 20160719193121 | new | NULL | 47240796 | NULL | | enwiki | Jawadi12 | 20160720190710 | new | NULL | 47249656 | NULL | | enwiki | Jay Prakash parmar | 20160718040912 | new | NULL | 47225550 | NULL | | enwiki | Jchats | 20160720070809 | new | NULL | 47244423 | NULL | | enwiki | Jeannesuh | 20160716134348 | new | NULL | 47213258 | NULL | | enwiki | Jeetkhan12 | 20160719053540 | new | NULL | 47234874 | NULL | | enwiki | Jenina Roncejero | 20160717111114 | new | NULL | 47219819 | NULL | | enwiki | Jeonminah | 20160714071902 | new | NULL | 47194576 | NULL | | enwiki | Jessica.lowell | 20160715173547 | new | NULL | 47207233 | NULL | | enwiki | Jeydi sartorius | 20160720171947 | new | NULL | 47248871 | NULL | | enwiki | JihadistAkbar | 20160720040414 | new | NULL | 47243416 | NULL | | enwiki | Jimmp1952 | 20160714100012 | new | NULL | 47195731 | NULL | | enwiki | Jiro6325 | 20160717201857 | new | NULL | 47223320 | NULL | | enwiki | JmChapin | 20160719194518 | new | NULL | 47240882 | NULL | | enwiki | Jonncarlsen | 20160719132830 | new | NULL | 47238081 | NULL | | enwiki | Joypadua | 20160716041409 | new | NULL | 47210204 | NULL | | enwiki | Justamymyselfni | 20160721012035 | new | NULL | 47251587 | NULL | | enwiki | Justinngo12345 | 20160717115412 | new | NULL | 47220106 | NULL | | enwiki | Justintest | 20160719202854 | new | NULL | 47241135 | NULL | | enwiki | Kai333243434 | 20160715080850 | new | NULL | 47203479 | NULL | | enwiki | Kaishfahadxd | 20160719182437 | new | NULL | 47240366 | NULL | | enwiki | Kangeorge | 20160717030440 | new | NULL | 47217419 | NULL | | enwiki | Kashira 1234 | 20160718015953 | new | NULL | 47224932 | NULL | | enwiki | KateSpasic | 20160713230957 | new | NULL | 47192163 | NULL | | enwiki | Kdc32401 | 20160715020751 | new | NULL | 47201783 | NULL | | enwiki | Kelvinkinoti | 20160719030917 | new | NULL | 47234245 | NULL | | enwiki | Keziah mcphee | 20160714014539 | new | NULL | 47192891 | NULL | | enwiki | Khuskumar | 20160721083645 | new | NULL | 47253817 | NULL | | enwiki | Kiingbreezy | 20160720025007 | new | NULL | 47243030 | NULL | | enwiki | KrystalVargas | 20160721012715 | new | NULL | 47251619 | NULL | | enwiki | Kumaran arun | 20160718111305 | new | NULL | 47228174 | NULL | | enwiki | Kxjineexp | 20160719204925 | new | NULL | 47241271 | NULL | | enwiki | Kyle B. Lawrence | 20160718121851 | new | NULL | 47228615 | NULL | | enwiki | Lauraprusk | 20160721113810 | new | NULL | 47255056 | NULL | | enwiki | Lawrencelucky | 20160720103210 | new | NULL | 47245785 | NULL | | enwiki | LeidsonG | 20160717101537 | new | NULL | 47219494 | NULL | | enwiki | Leonardoedwardstark | 20160718105232 | new | NULL | 47228041 | NULL | | enwiki | Liljaysavage15 | 20160718012941 | new | NULL | 47224799 | NULL | | enwiki | Lilyazevedo | 20160718063423 | new | NULL | 47226280 | NULL | | enwiki | LindseyCarter | 20160715023012 | new | NULL | 47201870 | NULL | | enwiki | Lingam1944 | 20160717184409 | new | NULL | 47222725 | NULL | | enwiki | Lit JayC | 20160718082433 | new | NULL | 47226973 | NULL | | enwiki | LittleLachy2004 | 20160718143821 | new | NULL | 47229739 | NULL | | enwiki | Loke badshans | 20160720223548 | new | NULL | 47250845 | NULL | | enwiki | Lolabanana1007 | 20160717091823 | new | NULL | 47219213 | NULL | | enwiki | Lolacavvy | 20160717142650 | new | NULL | 47221056 | NULL | | enwiki | Ltaperalta16 | 20160718071923 | new | NULL | 47226529 | NULL | | enwiki | Mahima setty | 20160718144130 | new | NULL | 47229758 | NULL | | enwiki | Malik Abdul Qayyum | 20160721114342 | new | NULL | 47255093 | NULL | | enwiki | Manonmani.R | 20160719021308 | new | NULL | 47233963 | NULL | | enwiki | Masterofuniverse666 | 20160720143244 | new | NULL | 47247575 | NULL | | enwiki | Mathiassta00 | 20160721124017 | new | NULL | 47255521 | NULL | | enwiki | Matsaarr | 20160714000635 | new | NULL | 47192424 | NULL | | enwiki | Maximax000 | 20160721133732 | new | NULL | 47255987 | NULL | | enwiki | Mc Bigdick | 20160718110101 | new | NULL | 47228089 | NULL | | enwiki | Memaxb | 20160717213828 | new | NULL | 47223761 | NULL | | enwiki | MemeStar69 | 20160714184705 | new | NULL | 47199538 | NULL | | enwiki | Mickeymousemyass | 20160716025439 | new | NULL | 47209895 | NULL | | enwiki | MikeDddddd | 20160721035007 | new | NULL | 47252307 | NULL | | enwiki | Mohammed momo4072 | 20160715051226 | new | NULL | 47202580 | NULL | | enwiki | Moideen muhammed | 20160719074159 | new | NULL | 47235545 | NULL | | enwiki | Mozakesmahn | 20160721123105 | new | NULL | 47255447 | NULL | | enwiki | Mugzysteven1 | 20160716180626 | new | NULL | 47214956 | NULL | | enwiki | Muqahid | 20160715200658 | new | NULL | 47208176 | NULL | | enwiki | Nalaehong | 20160719010727 | new | NULL | 47233621 | NULL | | enwiki | Natalka7113 | 20160717021206 | new | NULL | 47217213 | NULL | | enwiki | Navrrd | 20160720204831 | new | NULL | 47250271 | NULL | | enwiki | Naymaravilha | 20160718211301 | new | NULL | 47232501 | NULL | | enwiki | Nikhitha smily | 20160718120704 | new | NULL | 47228528 | NULL | | enwiki | Ninazurash | 20160721070853 | new | NULL | 47253290 | NULL | | enwiki | Nippleslapyourmumwithmysausage | 20160720190211 | new | NULL | 47249618 | NULL | | enwiki | Niyahbomb$$$ | 20160718144929 | new | NULL | 47229820 | NULL | | enwiki | Nrfriesen | 20160714204704 | new | NULL | 47200260 | NULL | | enwiki | O482 | 20160721045248 | new | NULL | 47252571 | NULL | | enwiki | Omkar Shankar Kokane | 20160720101631 | new | NULL | 47245674 | NULL | | enwiki | Omoloyeade | 20160716231700 | new | NULL | 47216554 | NULL | | enwiki | OrangejUice27 | 20160718123147 | new | NULL | 47228715 | NULL | | enwiki | Ostojić | 20160716140717 | new | NULL | 47213406 | NULL | | enwiki | Parsifal252 | 20160716170918 | new | NULL | 47214603 | NULL | | enwiki | Patricktlawrence | 20160715050918 | new | NULL | 47202565 | NULL | | enwiki | Paul V.Pancoast | 20160720221503 | new | NULL | 47250740 | NULL | | enwiki | Paulette Yager | 20160720000004 | new | NULL | 47242283 | NULL | | enwiki | PauloMorgado813 | 20160719134025 | new | NULL | 47238192 | NULL | | enwiki | Personnew | 20160717134552 | new | NULL | 47220779 | NULL | | enwiki | Phoenixkoratty | 20160719063901 | new | NULL | 47235184 | NULL | | enwiki | Picstagram | 20160714121939 | new | NULL | 47196653 | NULL | | enwiki | Pinnacle Industries Limited | 20160716080558 | new | NULL | 47211315 | NULL | | enwiki | Pissypuffin111 | 20160720105909 | new | NULL | 47245953 | NULL | | enwiki | Pldobbs0513 | 20160716022234 | new | NULL | 47209765 | NULL | | enwiki | Poopisadream | 20160719205720 | new | NULL | 47241316 | NULL | | enwiki | Pranaey Rao | 20160717151140 | new | NULL | 47221356 | NULL | | enwiki | Praveens75 | 20160715054922 | new | NULL | 47202735 | NULL | | enwiki | Prich1988 | 20160719173143 | new | NULL | 47239996 | NULL | | enwiki | Punkpink2002 | 20160719231418 | new | NULL | 47242053 | NULL | | enwiki | Pussyeater911 | 20160717003410 | new | NULL | 47216850 | NULL | | enwiki | Putra46kil | 20160720103657 | new | NULL | 47245818 | NULL | | enwiki | Quizzin | 20160719012156 | new | NULL | 47233697 | NULL | | enwiki | RABINDRA NATH PAL | 20160714121813 | new | NULL | 47196638 | NULL | | enwiki | Racheltungtwu | 20160720232318 | new | NULL | 47251081 | NULL | | enwiki | Rafia Razzaq | 20160719162223 | new | NULL | 47239488 | NULL | | enwiki | Rahul81711 | 20160715204003 | new | NULL | 47208358 | NULL | | enwiki | Realsocialproperty | 20160716030126 | new | NULL | 47209930 | NULL | | enwiki | Reaper montana | 20160717183242 | new | NULL | 47222664 | NULL | | enwiki | Reddevil169 | 20160720120450 | new | NULL | 47246414 | NULL | | enwiki | Reglena pariol | 20160721140844 | new | NULL | 47256231 | NULL | | enwiki | Rehansth | 20160718061030 | new | NULL | 47226144 | NULL | | enwiki | Rezajo80 | 20160718105137 | new | NULL | 47228033 | NULL | | enwiki | Rhquant | 20160719191515 | new | NULL | 47240679 | NULL | | enwiki | Rigsang1 | 20160717025424 | new | NULL | 47217372 | NULL | | enwiki | Rohit.babar511 | 20160717082540 | new | NULL | 47218954 | NULL | | enwiki | Rosalinda Aguilar | 20160721101137 | new | NULL | 47254454 | NULL | | enwiki | Rscharland | 20160720213837 | new | NULL | 47250552 | NULL | | enwiki | RyanDenverCo | 20160721142729 | new | NULL | 47256369 | NULL | | enwiki | Saisanath sunny | 20160716184926 | new | NULL | 47215228 | NULL | | enwiki | SakshatL | 20160718142727 | new | NULL | 47229635 | NULL | | enwiki | Samansuman | 20160720085410 | new | NULL | 47245074 | NULL | | enwiki | Saravanainstruz | 20160721065136 | new | NULL | 47253187 | NULL | | enwiki | Scarlett lord | 20160716093534 | new | NULL | 47211788 | NULL | | enwiki | Scg216 | 20160719192237 | new | NULL | 47240735 | NULL | | enwiki | Shekhsabir2000 | 20160716125935 | new | NULL | 47212987 | NULL | | enwiki | Sherrijohnson0823 | 20160720172712 | new | NULL | 47248923 | NULL | | enwiki | Shillenm | 20160721172848 | new | NULL | 47257904 | NULL | | enwiki | ShinyStoned | 20160715015553 | new | NULL | 47201729 | NULL | | enwiki | Shragge | 20160720082313 | new | NULL | 47244869 | NULL | | enwiki | Shubhanshoo jain | 20160719203834 | new | NULL | 47241209 | NULL | | enwiki | Sid12399 | 20160715134316 | new | NULL | 47205583 | NULL | | enwiki | Siya gujral | 20160714132649 | new | NULL | 47197139 | NULL | | enwiki | Smarret | 20160719225901 | new | NULL | 47241958 | NULL | | enwiki | Sorry flack | 20160720124341 | new | NULL | 47246698 | NULL | | enwiki | Sr. El Boogie | 20160715202209 | new | NULL | 47208257 | NULL | | enwiki | Ssail89 | 20160720074440 | new | NULL | 47244645 | NULL | | enwiki | Ssoummane | 20160718233405 | new | NULL | 47233201 | NULL | | enwiki | Stevieknight | 20160721035124 | new | NULL | 47252312 | NULL | | enwiki | Street48man | 20160717003249 | new | NULL | 47216846 | NULL | | enwiki | Suba dhiyaadhu shree | 20160721172546 | new | NULL | 47257873 | NULL | | enwiki | Sumerzxr | 20160721055801 | new | NULL | 47252879 | NULL | | enwiki | Super Avenger | 20160716114603 | new | NULL | 47212573 | NULL | | enwiki | Sydsyd0123 | 20160717234101 | new | NULL | 47224352 | NULL | | enwiki | SylviaYasmine | 20160718204924 | new | NULL | 47232346 | NULL | | enwiki | Syssitia | 20160714060201 | new | NULL | 47194133 | NULL | | enwiki | Tejas sunil shinde | 20160720034218 | new | NULL | 47243307 | NULL | | enwiki | Thatballerkid | 20160715021752 | new | NULL | 47201822 | NULL | | enwiki | The Metal Chick999 | 20160720165920 | new | NULL | 47248718 | NULL | | enwiki | TheBossIsNorthA | 20160717213642 | new | NULL | 47223750 | NULL | | enwiki | Thegodofgaming24680 | 20160717183518 | new | NULL | 47222675 | NULL | | enwiki | Titan64064 | 20160717111925 | new | NULL | 47219874 | NULL | | enwiki | TomBarnes2016 | 20160715234759 | new | NULL | 47209240 | NULL | | enwiki | Tony52103 | 20160719154948 | new | NULL | 47239234 | NULL | | enwiki | Tony52103123 | 20160719155040 | new | NULL | 47239240 | NULL | | enwiki | Ulihediudgu | 20160718221823 | new | NULL | 47232843 | NULL | | enwiki | VERNER LARSEN | 20160715210654 | new | NULL | 47208501 | NULL | | enwiki | Vk1052013 | 20160719003523 | new | NULL | 47233482 | NULL | | enwiki | Vminboo | 20160715054130 | new | NULL | 47202707 | NULL | | enwiki | Volthemort | 20160721081500 | new | NULL | 47253671 | NULL | | enwiki | Vsmancuso | 20160720033220 | new | NULL | 47243239 | NULL | | enwiki | Walfreda | 20160714211817 | new | NULL | 47200432 | NULL | | enwiki | Walisongofmpkl | 20160717100359 | new | NULL | 47219437 | NULL | | enwiki | Whatiswrongwithmyusername | 20160720135203 | new | NULL | 47247232 | NULL | | enwiki | Williamtipton1021 | 20160714043045 | new | NULL | 47193656 | NULL | | enwiki | Wireal94 | 20160718124337 | new | NULL | 47228812 | NULL | | enwiki | XxCandyFlossGirl403Xx | 20160717112526 | new | NULL | 47219910 | NULL | | enwiki | Xxowinteroxx123 | 20160715173231 | new | NULL | 47207217 | NULL | | enwiki | Xxtuasonxx | 20160721130317 | new | NULL | 47255708 | NULL | | enwiki | Yashwantpatwal | 20160720054105 | new | NULL | 47243858 | NULL | | enwiki | YellowWidoW | 20160715173135 | new | NULL | 47207210 | NULL | | enwiki | Yoga Orpi | 20160715132931 | new | NULL | 47205489 | NULL | | enwiki | Yonkers2021 | 20160719234444 | new | NULL | 47242205 | NULL | | enwiki | Zaitonlover | 20160720055056 | new | NULL | 47243928 | NULL | | enwiki | Zileftw95 | 20160718134654 | new | NULL | 47229318 | NULL | | enwiki | Zisuina | 20160716003915 | new | NULL | 47209414 | NULL | | enwiki | DZoo | 20211104205856 | admin | NULL | 0 | NULL | | enwiki | Ԯ | 20211104205107 | admin | NULL | 0 | NULL | | enwiki | Ɪksplosɪv kæŋgəʃæn | 20211104205833 | admin | NULL | 0 | NULL | | enwiki | Ʞ | 20211104205534 | admin | NULL | 0 | NULL | | enwiki | Ʞɔ | 20211104205510 | admin | NULL | 0 | NULL | | enwiki | Ʞɔnɟ | 20211104205443 | admin | NULL | 0 | NULL | | enwiki | Ʞɔnɥɔ | 20211104205419 | admin | NULL | 0 | NULL | | enwiki | Ʞəʇɹɐq | 20211104205400 | admin | NULL | 0 | NULL | | enwiki | Ʇ | 20211104205812 | admin | NULL | 0 | NULL | | enwiki | Ʇdɯoɹdɥsɐq | 20211104205746 | admin | NULL | 0 | NULL | | enwiki | Ʝ | 20211104205625 | admin | NULL | 0 | NULL | | enwiki | Ʝɑɕƙ ʛɩƛɛȿƿɨɘ | 20211104205559 | admin | NULL | 0 | NULL | | enwikivoyage | LMendenhall | 20160715045110 | new | NULL | 47202490 | NULL | | enwiktionary | Tandhjulsfabrikken | 20160714112912 | new | NULL | 47196312 | NULL | | enwiktionary | Ykouchaki | 20160717061225 | new | NULL | 47218260 | NULL | | eswiki | Carlitosvillagran02 | 20160718023952 | new | NULL | 47225146 | NULL | | eswiki | Estefani Reategui Murrieta | 20160715030616 | new | NULL | 47202027 | NULL | | eswiki | Facu block | 20160715011103 | new | NULL | 47201505 | NULL | | eswiki | Fanny Lopez Fernandez. | 20160720141426 | new | NULL | 47247430 | NULL | | eswiki | Hit040man | 20160717224310 | new | NULL | 47224100 | NULL | | eswiki | Hugosanchez1234 | 20160718215158 | new | NULL | 47232718 | NULL | | eswiki | Hugosanchez20004 | 20160718215248 | new | NULL | 47232721 | NULL | | eswiki | Huhyyg | 20160718020801 | new | NULL | 47224969 | NULL | | eswiki | Isadora floras | 20160721062454 | new | NULL | 47253035 | NULL | | eswiki | Iset cabrera | 20160719155608 | new | NULL | 47239287 | NULL | | eswiki | Jagobaapalategi | 20160714181015 | new | NULL | 47199292 | NULL | | eswiki | Jass242003 | 20160714113104 | new | NULL | 47196320 | NULL | | eswiki | Jhosyra | 20160720165043 | new | NULL | 47248653 | NULL | | eswiki | Josegonzz | 20160718171411 | new | NULL | 47230902 | NULL | | eswiki | Juanjosebayo | 20160720194558 | new | NULL | 47249915 | NULL | | eswiki | JuuanchiQ | 20160716014124 | new | NULL | 47209633 | NULL | | eswiki | King170813 | 20160718062902 | new | NULL | 47226240 | NULL | | eswiki | Kloe Kardashian | 20160716200126 | new | NULL | 47215641 | NULL | | eswiki | Lasbandidas | 20160717030227 | new | NULL | 47217407 | NULL | | eswiki | Lazogabriela | 20160720004057 | new | NULL | 47242452 | NULL | | eswiki | Leo leonardo cristaldo | 20160714133042 | new | NULL | 47197169 | NULL | | eswiki | Lian Mamo | 20160714125012 | new | NULL | 47196857 | NULL | | eswiki | Lian Mariné Monteiro | 20160714125157 | new | NULL | 47196867 | NULL | | eswiki | Lucero FS | 20160721162824 | new | NULL | 47257437 | NULL | | eswiki | Luis Daniel4014 | 20160715230745 | new | NULL | 47209085 | NULL | | eswiki | Magdatula | 20160714223305 | new | NULL | 47200801 | NULL | | eswiki | Marckoszg3 | 20160721025743 | new | NULL | 47252073 | NULL | | eswiki | Marcos41209 | 20160719112536 | new | NULL | 47237099 | NULL | | eswiki | Mariybuel | 20160719062436 | new | NULL | 47235103 | NULL | | eswiki | Mary preciosa | 20160716102738 | new | NULL | 47212107 | NULL | | eswiki | Mateo Willy | 20160714171030 | new | NULL | 47198874 | NULL | | eswiki | Mónica Tete Cramer-Ayos | 20160718071048 | new | NULL | 47226479 | NULL | | eswiki | Natikaa19 | 20160715232520 | new | NULL | 47209154 | NULL | | eswiki | Paula Vignoly | 20160718000522 | new | NULL | 47224452 | NULL | | eswiki | Pecosita7 | 20160721020647 | new | NULL | 47251833 | NULL | | eswiki | PeterPoter777 | 20160715233051 | new | NULL | 47209182 | NULL | | eswiki | Roxana. arteaga | 20160715051247 | new | NULL | 47202584 | NULL | | eswiki | Samantasueca | 20160718163818 | new | NULL | 47230647 | NULL | | eswiki | Santiago7u | 20160719005531 | new | NULL | 47233576 | NULL | | eswiki | Sara sepulveda arango | 20160715005215 | new | NULL | 47201424 | NULL | | eswiki | Ssalomon311 | 20160718194917 | new | NULL | 47231965 | NULL | | eswiki | TheXL18 | 20160717154741 | new | NULL | 47221633 | NULL | | eswiki | ULISES GARCÍA BAEZ | 20160716055139 | new | NULL | 47210644 | NULL | | fawiki | Greecereza | 20160716202419 | new | NULL | 47215758 | NULL | | fawiki | Habibshamlou | 20160720163921 | new | NULL | 47248560 | NULL | | fawiki | Mohamad parsesh | 20160716201013 | new | NULL | 47215691 | NULL | | fawiki | Mohammad5318 | 20160720083548 | new | NULL | 47244945 | NULL | | fawiki | Mohsen sorosh | 20160716075340 | new | NULL | 47211251 | NULL | | fawiki | Mortezaghamari | 20160719171110 | new | NULL | 47239850 | NULL | | fawiki | Muhamad amin kmalpour | 20160717195910 | new | NULL | 47223186 | NULL | | fawiki | ابراهیم المنفلوطی | 20160720174859 | new | NULL | 47249084 | NULL | | fawiki | احمدرضاامیریان | 20160720061942 | new | NULL | 47244096 | NULL | | fawiki | اردشیر هادوی لولتی | 20160721083853 | new | NULL | 47253835 | NULL | | fiwiki | Vaappukkamehumies3000 | 20160720064803 | new | NULL | 47244286 | NULL | | frwiki | Colomiès s | 20160720173556 | new | NULL | 47248982 | NULL | | frwiki | Fresnel2000 | 20160716093631 | new | NULL | 47211798 | NULL | | frwiki | HypnoKus | 20160715231007 | new | NULL | 47209101 | NULL | | frwiki | Ilias Abbou | 20160720225017 | new | NULL | 47250923 | NULL | | frwiki | JB MOBATISI | 20160715210823 | new | NULL | 47208508 | NULL | | frwiki | Jean Cotier | 20160721110222 | new | NULL | 47254816 | NULL | | frwiki | Jeanshako | 20160715200836 | new | NULL | 47208182 | NULL | | frwiki | Louise nilavo | 20160714083635 | new | NULL | 47195113 | NULL | | frwiki | Louisonbaude | 20160716074811 | new | NULL | 47211220 | NULL | | frwiki | Louisonbaudecroux | 20160716074953 | new | NULL | 47211230 | NULL | | frwiki | Madene hafs | 20160717114834 | new | NULL | 47220071 | NULL | | frwiki | Mattéo dermenjian | 20160716161852 | new | NULL | 47214294 | NULL | | frwiki | Medina ngassaki | 20160716200134 | new | NULL | 47215642 | NULL | | frwiki | Mm047 | 20160717215324 | new | NULL | 47223841 | NULL | | frwiki | Nacktugo072 | 20160716180656 | new | NULL | 47214962 | NULL | | frwiki | Oll.jaz | 20160719113207 | new | NULL | 47237157 | NULL | | frwiki | Roland kaswadi | 20160716193644 | new | NULL | 47215511 | NULL | | frwiki | Slovius | 20160719171602 | new | NULL | 47239897 | NULL | | frwiki | TIEGBE EMMANUEL OUATTARA | 20160719072648 | new | NULL | 47235453 | NULL | | guwiki | VIJAY19891212 | 20160714094255 | new | NULL | 47195611 | NULL | | hewiki | Meravel100 | 20160720044439 | new | NULL | 47243582 | NULL | | hewiki | ידהמהמיק | 20160716101218 | new | NULL | 47212020 | NULL | | hewiki | ירין המלך האלוף | 20160714112853 | new | NULL | 47196310 | NULL | | hewiki | שמוליק123445 | 20160718142443 | new | NULL | 47229610 | NULL | | hewiki | שמוליק12344519394939201 | 20160718142605 | new | NULL | 47229623 | NULL | | hiwiki | Khushi3856 | 20160718094147 | new | NULL | 47227566 | NULL | | hiwiki | Mnahesha nand juyal | 20160716020315 | new | NULL | 47209695 | NULL | | hrwiki | Prigorac | 20160721062549 | new | NULL | 47253040 | NULL | | huwiki | Janos.fazekas56 | 20160717154142 | new | NULL | 47221575 | NULL | | huwiki | Xara19640221 | 20160717093344 | new | NULL | 47219286 | NULL | | hywiki | GevorGGevu | 20160714161350 | new | NULL | 47198486 | NULL | | idwiki | Fernando syahputra wijaya | 20160719190931 | new | NULL | 47240640 | NULL | | idwiki | Gabriel paskah | 20160718184752 | new | NULL | 47231575 | NULL | | idwiki | Ipan arwah | 20160716134606 | new | NULL | 47213276 | NULL | | idwiki | Lilimegawe | 20160721153414 | new | NULL | 47256989 | NULL | | idwiki | Marselinus Muda | 20160720140340 | new | NULL | 47247341 | NULL | | idwiki | Sezavx | 20160714125754 | new | NULL | 47196909 | NULL | | idwiki | Vesmardeli | 20160721081400 | new | NULL | 47253668 | NULL | | incubatorwiki | Ⲫⲟⲩⲁⲙⲁⲣⲁⲃⲟⲥ | 20211104204955 | admin | NULL | 0 | NULL | | itwiki | Firpo iris | 20160718132835 | new | NULL | 47229173 | NULL | | itwiki | Gaiaerucci | 20160719132027 | new | NULL | 47238014 | NULL | | itwiki | Greenhunter132 | 20160714081140 | new | NULL | 47194935 | NULL | | itwiki | Gualtiero Laurenti | 20160719133602 | new | NULL | 47238150 | NULL | | itwiki | Ltmntlbn33 | 20160718114639 | new | NULL | 47228401 | NULL | | itwiki | Mr.xlunico | 20160720090321 | new | NULL | 47245144 | NULL | | itwiki | Pio Orto | 20160716082020 | new | NULL | 47211394 | NULL | | itwiki | Rodolfo de Carvalho de Moraes de Puppi | 20160720113511 | new | NULL | 47246193 | NULL | | itwiki | Simonesd95 | 20160716205658 | new | NULL | 47215925 | NULL | | itwiki | Susanna bosoni 1 | 20160720123940 | new | NULL | 47246669 | NULL | | itwiki | Susanna bosoni 123 | 20160720124409 | new | NULL | 47246702 | NULL | | itwikivoyage | Gianluca Pettinao | 20160718141138 | new | NULL | 47229489 | NULL | | jawiki | Hot fats 2001 | 20160718004913 | new | NULL | 47224629 | NULL | | jawiki | Matsuda munehide | 20160719195002 | new | NULL | 47240914 | NULL | | jawiki | Neetone | 20160721170352 | new | NULL | 47257696 | NULL | | jawiki | Peanut butter233 | 20160720031929 | new | NULL | 47243168 | NULL | | jawiki | Satomisrimi | 20160714154204 | new | NULL | 47198267 | NULL | | jawiki | Wakuwakuland10 | 20160715110353 | new | NULL | 47204537 | NULL | | jawiki | シハキイサム | 20160718060513 | new | NULL | 47226115 | NULL | | jawiki | 和紙身広政 | 20160715160303 | new | NULL | 47206608 | NULL | | jawiki | 小田キヨシ | 20160721171807 | new | NULL | 47257812 | NULL | | jawiki | 山本いづみ | 20160715093523 | new | NULL | 47203985 | NULL | | jawiki | 成和建装（株） | 20160715064710 | new | NULL | 47203042 | NULL | | jawiki | 永井 元貴 | 20160717104927 | new | NULL | 47219704 | NULL | | kawiki | მარიამ შენგელია | 20160721083137 | new | NULL | 47253777 | NULL | | kawiki | ტალანტი | 20160720112814 | new | NULL | 47246153 | NULL | | kowiki | Jyparadise | 20160718062855 | new | NULL | 47226238 | NULL | | mediawikiwiki | Micheal Bramdon | 20160716062611 | new | NULL | 47210804 | NULL | | mediawikiwiki | Ⲫⲟⲩⲁⲙⲁⲣⲁⲃⲟⲥ | 20211104204944 | admin | NULL | 0 | NULL | | metawiki | Khale ghezi | 20160719232040 | new | NULL | 47242091 | NULL | | metawiki | Ⲫⲟⲩⲁⲙⲁⲣⲁⲃⲟⲥ | 20211104204856 | admin | NULL | 0 | NULL | | metawiki | Ʇdɯoɹdɥsɐq | 20211104205720 | admin | NULL | 0 | NULL | | metawiki | Ʇsıdɐɹ ʇʇnq | 20211104205706 | admin | NULL | 0 | NULL | | mlwiki | Nkrragbabu | 20160716163807 | new | NULL | 47214398 | NULL | | mrwiki | Mayuri Amburle | 20160715094841 | new | NULL | 47204068 | NULL | | mswiki | Zareenqistina | 20160721130135 | new | NULL | 47255698 | NULL | | mywiki | Htet Hein 111 | 20160717021818 | new | NULL | 47217242 | NULL | | mywiki | Popgodpopgod | 20160716050733 | new | NULL | 47210423 | NULL | | mywiki | Thura Zaw 1986 | 20160716111324 | new | NULL | 47212345 | NULL | | mywiki | Thura Zaw31 | 20160716112318 | new | NULL | 47212405 | NULL | | nlwiki | GamesVSPranks | 20160716110807 | new | NULL | 47212317 | NULL | | nlwiki | Inge Pinge | 20160714191940 | new | NULL | 47199729 | NULL | | nlwiki | MC4U2 | 20160717082629 | new | NULL | 47218959 | NULL | | nlwiki | Moulay-ilias | 20160715144149 | new | NULL | 47206020 | NULL | | nlwiki | Stop peste | 20160720160533 | new | NULL | 47248314 | NULL | | nlwiki | Thaminto | 20160717132811 | new | NULL | 47220656 | NULL | | nlwiki | That's just the way it is | 20160721101202 | new | NULL | 47254458 | NULL | | plwiki | Oliviakko | 20160718222027 | new | NULL | 47232853 | NULL | | ptwiki | Gustavo Esteves | 20160720172356 | new | NULL | 47248907 | NULL | | ptwiki | Jacinto satula | 20160718154340 | new | NULL | 47230257 | NULL | | ptwiki | Josimar Alberto José | 20160718175754 | new | NULL | 47231203 | NULL | | ptwiki | Manilson da Cunha | 20160717203752 | new | NULL | 47223424 | NULL | | ptwiki | Maria luiza honorato | 20160721023735 | new | NULL | 47251971 | NULL | | ptwiki | Nikolas Krzyzanoski | 20160720003807 | new | NULL | 47242440 | NULL | | ptwiki | PASCOAL SAPALO NGALA | 20160721134844 | new | NULL | 47256076 | NULL | | ptwiki | Renatta Dias Ogunhê | 20160721171421 | new | NULL | 47257785 | NULL | | ptwiki | RicardoCassiano5 | 20160714162443 | new | NULL | 47198552 | NULL | | ptwiki | Rosimar Girbrasil | 20160718194252 | new | NULL | 47231926 | NULL | | ptwiki | Rvgevev | 20160718074904 | new | NULL | 47226722 | NULL | | ptwiki | Shrek folhados | 20160718135204 | new | NULL | 47229341 | NULL | | ptwiki | Soraia Ribeiro | 20160721082305 | new | NULL | 47253721 | NULL | | ptwiki | Tadeu Mouzinho Gomes | 20160714184532 | new | NULL | 47199526 | NULL | | ptwiki | TiagoVasconcelos003 | 20160714214935 | new | NULL | 47200585 | NULL | | ptwikibooks | Kauanny Vieira | 20160714231919 | new | NULL | 47201010 | NULL | | rowiki | Nagato-Ashura | 20160716112647 | new | NULL | 47212433 | NULL | | ruwiki | Anatoli51 | 20160719184121 | new | NULL | 47240471 | NULL | | ruwiki | Eugene Wilde | 20160720220554 | new | NULL | 47250697 | NULL | | ruwiki | GolDStorM | 20160720115920 | new | NULL | 47246373 | NULL | | ruwiki | Ismailovamadi | 20160717083338 | new | NULL | 47219000 | NULL | | ruwiki | KMpasquarelli | 20160718102911 | new | NULL | 47227882 | NULL | | ruwiki | LiariaGoods | 20160719102739 | new | NULL | 47236691 | NULL | | ruwiki | Melestean | 20160716225611 | new | NULL | 47216479 | NULL | | ruwiki | Mr ilyasoff | 20160719031820 | new | NULL | 47234289 | NULL | | ruwiki | Nastasia Burtseva | 20160717212018 | new | NULL | 47223656 | NULL | | ruwiki | Ontree | 20160721111750 | new | NULL | 47254907 | NULL | | ruwiki | Petrgydin | 20160714211342 | new | NULL | 47200394 | NULL | | ruwiki | Rolexen | 20160715122909 | new | NULL | 47205097 | NULL | | ruwiki | Sofiraaa | 20160717214913 | new | NULL | 47223823 | NULL | | ruwiki | Vaaslep | 20160719204620 | new | NULL | 47241254 | NULL | | ruwiki | Z1b0 | 20160718101232 | new | NULL | 47227783 | NULL | | ruwiki | Ажибек уулу | 20160720033632 | new | NULL | 47243270 | NULL | | ruwiki | Даун Дарик | 20160715145605 | new | NULL | 47206115 | NULL | | ruwiki | Сергей Эпифоров | 20160719155306 | new | NULL | 47239264 | NULL | | srwiki | Markosftw | 20160720151710 | new | NULL | 47247945 | NULL | | srwiki | Necamoderadotor | 20160720140523 | new | NULL | 47247364 | NULL | | svwiki | ISRA SALAD NOR IBRAHIM | 20160717121123 | new | NULL | 47220201 | NULL | | tawiki | Saleemyousuf | 20160720120802 | new | NULL | 47246441 | NULL | | thwiki | Okmrrr | 20160714151348 | new | NULL | 47198023 | NULL | | thwiki | Pattaraphum | 20160720202853 | new | NULL | 47250167 | NULL | | thwiki | Preyachn | 20160717111824 | new | NULL | 47219865 | NULL | | trwiki | KillerTheJG | 20160717105052 | new | NULL | 47219711 | NULL | | trwiki | Kösemist | 20160714194331 | new | NULL | 47199874 | NULL | | trwiki | Latif Demir | 20160719152955 | new | NULL | 47239079 | NULL | | trwiki | OutFier | 20160719092738 | new | NULL | 47236258 | NULL | | trwiki | SAT Ccommander | 20160715002627 | new | NULL | 47201301 | NULL | | trwiki | Sait1903 | 20160715123013 | new | NULL | 47205107 | NULL | | trwiki | Serkansetkaya | 20160718232650 | new | NULL | 47233162 | NULL | | trwiki | Thisisperfect | 20160720124124 | new | NULL | 47246677 | NULL | | trwiki | UzmanMakina 44 | 20160714195028 | new | NULL | 47199930 | NULL | | urwiki | Farooq wighio | 20160716162701 | new | NULL | 47214336 | NULL | | urwiki | Sani gul | 20160721110400 | new | NULL | 47254832 | NULL | | urwiki | نعمان گل | 20160719065930 | new | NULL | 47235300 | NULL | | viwiki | Gundamastrayred | 20160716020413 | new | NULL | 47209697 | NULL | | viwiki | Iloveyoonasnsd | 20160718014124 | new | NULL | 47224857 | NULL | | viwiki | Jokerbustle | 20160719144911 | new | NULL | 47238762 | NULL | | viwiki | Llyen20 | 20160721050933 | new | NULL | 47252636 | NULL | | viwiki | MunMunTrần | 20160719074547 | new | NULL | 47235580 | NULL | | viwiki | Quiphan | 20160719145521 | new | NULL | 47238821 | NULL | | viwiki | Tumgmeo | 20160714200242 | new | NULL | 47199999 | NULL | | viwiktionary | Đô hà | 20160716071653 | new | NULL | 47211053 | NULL | | wuuwiki | 农14 | 20160719035532 | new | NULL | 47234447 | NULL | | zhwiki | Hu Yishan | 20160715034418 | new | NULL | 47202202 | NULL | | zhwiki | Jay99451 | 20160715072847 | new | NULL | 47203241 | NULL | | zhwiki | Kk910729 | 20160716092423 | new | NULL | 47211725 | NULL | | zhwiki | Lcetchina | 20160715161650 | new | NULL | 47206710 | NULL | | zhwiki | Lfan23 | 20160716172357 | new | NULL | 47214686 | NULL | | zhwiki | Windy Mok | 20160721012600 | new | NULL | 47251611 | NULL | | zhwiki | Xavier7699 | 20160717041641 | new | NULL | 47217704 | NULL | | zhwiki | YAIZD | 20160721102803 | new | NULL | 47254563 | NULL | | zhwiki | ㄓㄓ | 20160720180243 | new | NULL | 47249198 | NULL | | zhwiki | 冀霖 | 20160716073435 | new | NULL | 47211137 | NULL | | zhwiki | 向日本進發的我 | 20160718141322 | new | NULL | 47229506 | NULL | | zhwiki | 妖风灬夜游蛋 | 20160717180729 | new | NULL | 47222506 | NULL | | zhwiki | 苏枫瑾 | 20160721040323 | new | NULL | 47252357 | NULL | | zhwiki | 鐘宥茵 | 20160719063414 | new | NULL | 47235161 | NULL | +---------------+---------------------------------------------+-----------------------+--------------------+-------------+--------------+----------------------+ 475 rows in set (5 min 0.758 sec)
However, trying to individually fix those doesn't seem to work:
reedy@deploy2002:/srv/mediawiki-staging$ mwscript extensions/CentralAuth/maintenance/populateLocalAndGlobalIds.php --wiki=cswiki DEPRECATION WARNING: Maintenance scripts are moving to Kubernetes. See https://wikitech.wikimedia.org/wiki/Maintenance_scripts for the new process. Maintenance hosts will be going away; please submit feedback promptly if maintenance scripts on Kubernetes don't work for you. (T341553) Populating fields for wiki cswiki... Updated 2 records. Last user: 47222868; Wiki: cswiki Completed cswiki reedy@deploy2002:/srv/mediawiki-staging$ mwscript extensions/CentralAuth/maintenance/populateLocalAndGlobalIds.php --wiki=cswiki DEPRECATION WARNING: Maintenance scripts are moving to Kubernetes. See https://wikitech.wikimedia.org/wiki/Maintenance_scripts for the new process. Maintenance hosts will be going away; please submit feedback promptly if maintenance scripts on Kubernetes don't work for you. (T341553) Populating fields for wiki cswiki... Updated 2 records. Last user: 47222868; Wiki: cswiki Completed cswiki reedy@deploy2002:/srv/mediawiki-staging$ mwscript extensions/CentralAuth/maintenance/populateLocalAndGlobalIds.php --wiki=cswiki DEPRECATION WARNING: Maintenance scripts are moving to Kubernetes. See https://wikitech.wikimedia.org/wiki/Maintenance_scripts for the new process. Maintenance hosts will be going away; please submit feedback promptly if maintenance scripts on Kubernetes don't work for you. (T341553) Populating fields for wiki cswiki... Updated 2 records. Last user: 47222868; Wiki: cswiki Completed cswiki
^ something clearly isn't updating properly
See also: T303590: Fix localuser rows with lu_local_id or lu_global_id that aren't correctly set