Page MenuHomePhabricator

Rename global users with invalid characters on their usernames
Open, MediumPublic

Description

Interesting output at https://meta.wikimedia.org/wiki/Special:GlobalUsers/a doing unrelated things.

Those usernames with @ or starting in lowercase should probably be batch renamed to Invalid username~xyz as done with previous cases.

1a-giâu (unattached or doesn't exist locally)
2aalku (unattached or doesn't exist locally)
3abc123456789 (unattached or doesn't exist locally)
4acf (unattached or doesn't exist locally)
5airtrony (unattached or doesn't exist locally)
6aliconda (unattached or doesn't exist locally)
7aliundalex (unattached or doesn't exist locally)
8allo2u (unattached or doesn't exist locally)
9angelina1505 (unattached or doesn't exist locally)
10apfeldieb (unattached or doesn't exist locally)
11archambaultluc37 (unattached or doesn't exist locally)
12archeos (unattached or doesn't exist locally)
13arf (unattached or doesn't exist locally)
14ariser (unattached or doesn't exist locally)
15arobase92 (unattached or doesn't exist locally)
16asalinasci (unattached or doesn't exist locally)
17autogro (unattached or doesn't exist locally)
18bFunk (unattached or doesn't exist locally)
19baco (unattached or doesn't exist locally)
20baltic (unattached or doesn't exist locally)
21barbol (unattached or doesn't exist locally)
22baui (unattached or doesn't exist locally)
23behnaz@wikipedia.com (unattached or doesn't exist locally)
24bermal (unattached or doesn't exist locally)
25berndjochen (unattached or doesn't exist locally)
26berwein (unattached or doesn't exist locally)
27bestiarosa (unattached or doesn't exist locally)
28bilby (unattached or doesn't exist locally)
29birgitta (unattached or doesn't exist locally)
30blonkm (unattached or doesn't exist locally)
31bmille (unattached or doesn't exist locally)
32bonnie (unattached or doesn't exist locally)
33bontenbal (unattached or doesn't exist locally)
34braegel (unattached or doesn't exist locally)
35bruno (unattached or doesn't exist locally)
36bruno.lombardi (unattached or doesn't exist locally)
37bugin (unattached or doesn't exist locally)
38camoes (unattached or doesn't exist locally)
39car grégoire (unattached or doesn't exist locally)
40carbenium (unattached or doesn't exist locally)
41carebo69 (unattached or doesn't exist locally)
42carl grégoire (unattached or doesn't exist locally)
43carlosr5007 (unattached or doesn't exist locally)
44casper (unattached or doesn't exist locally)
45cecio (unattached or doesn't exist locally)
46chaturangam (unattached or doesn't exist locally)
47che (unattached or doesn't exist locally)
48chinnu (unattached or doesn't exist locally)
49cityangle (unattached or doesn't exist locally)
50ckmajor (unattached or doesn't exist locally)
51cmathaes (unattached or doesn't exist locally)
52codypandora (unattached or doesn't exist locally)
53coeurgan (unattached or doesn't exist locally)
54couyimin (unattached or doesn't exist locally)
55cronimus (unattached or doesn't exist locally)
56ctschirk (unattached or doesn't exist locally)
57cubefox (unattached or doesn't exist locally)
58d (unattached or doesn't exist locally)
59damien710 (unattached or doesn't exist locally)
60daniel.graziotin (unattached or doesn't exist locally)
61debel (unattached or doesn't exist locally)
62delight (unattached or doesn't exist locally)
63demi 84 (unattached or doesn't exist locally)
64deweerdt (unattached or doesn't exist locally)
65diba (unattached or doesn't exist locally)
66djam (unattached or doesn't exist locally)
67dlc (unattached or doesn't exist locally)
68dmgerman (unattached or doesn't exist locally)
69doenie (unattached or doesn't exist locally)
70domigarc (unattached or doesn't exist locally)
71drjackzon (unattached or doesn't exist locally)
72dubaduba (unattached or doesn't exist locally)
73ecureuil gris (unattached or doesn't exist locally)
74ecz (unattached or doesn't exist locally)
75egkaufmann (unattached or doesn't exist locally)
76ejfis (unattached or doesn't exist locally)
77elena.ross (unattached or doesn't exist locally)
78elevbe (unattached or doesn't exist locally)
79email-sc (unattached or doesn't exist locally)
80ernded (unattached or doesn't exist locally)
81espartacox (unattached or doesn't exist locally)
82estakroon (unattached or doesn't exist locally)
83estevez (unattached or doesn't exist locally)
84etk (unattached or doesn't exist locally)
85etxrge (unattached or doesn't exist locally)
86eusbarbosa (unattached or doesn't exist locally)
87fabi1 (unattached or doesn't exist locally)
88fantolino70 (unattached or doesn't exist locally)
89feigling (unattached or doesn't exist locally)
90fgb (unattached or doesn't exist locally)
91fikret56 (unattached or doesn't exist locally)
92finanzer (unattached or doesn't exist locally)
93fiona (unattached or doesn't exist locally)
94flyingbird (unattached or doesn't exist locally)
95foerster.steffi (unattached or doesn't exist locally)
96fomanita (unattached or doesn't exist locally)
97fossy (unattached or doesn't exist locally)
98francois (unattached or doesn't exist locally)
99friedmar brendel (unattached or doesn't exist locally)
100ftamminga (unattached or doesn't exist locally)
101g braad (unattached or doesn't exist locally)
102gadacz (unattached or doesn't exist locally)
103gardanus (unattached or doesn't exist locally)
104gbcausa (unattached or doesn't exist locally)
105gbz (unattached or doesn't exist locally)
106georges (unattached or doesn't exist locally)
107gerard.laine (unattached or doesn't exist locally)
108giridhar (unattached or doesn't exist locally)
109gitaarfreak (unattached or doesn't exist locally)
110goa103 (unattached or doesn't exist locally)
111goldfinger (unattached or doesn't exist locally)
112gorWik (unattached or doesn't exist locally)
113grovo (unattached or doesn't exist locally)
114grstaib (unattached or doesn't exist locally)
115guaca (unattached or doesn't exist locally)
116gue (unattached or doesn't exist locally)
117guillermolanda (unattached or doesn't exist locally)
118harobed (unattached or doesn't exist locally)
119heho (unattached or doesn't exist locally)
120helm (unattached or doesn't exist locally)
121henryII (unattached or doesn't exist locally)
122hersson (unattached or doesn't exist locally)
123hildebrandowl (unattached or doesn't exist locally)
124hippietrail (unattached or doesn't exist locally)
125hjo-b (unattached or doesn't exist locally)
126hpots (unattached or doesn't exist locally)
127ibbebergman (unattached or doesn't exist locally)
128icq628 (unattached or doesn't exist locally)
129idefix (unattached or doesn't exist locally)
130jack the shark (unattached or doesn't exist locally)
131jandd (unattached or doesn't exist locally)
132jdved (unattached or doesn't exist locally)
133jl.lesieur (unattached or doesn't exist locally)
134jmspaggi (unattached or doesn't exist locally)
135joachim karner (unattached or doesn't exist locally)
136jochem (unattached or doesn't exist locally)
137johncapistrano (unattached or doesn't exist locally)
138johnny (unattached or doesn't exist locally)
139jojo512 (unattached or doesn't exist locally)
140joni (unattached or doesn't exist locally)
141jot (unattached or doesn't exist locally)
142joterr (unattached or doesn't exist locally)
143jrm (unattached or doesn't exist locally)
144jrom (unattached or doesn't exist locally)
145jsamp (unattached or doesn't exist locally)
146juletine (unattached or doesn't exist locally)
147juliasaatmann (unattached or doesn't exist locally)
148jupo (unattached or doesn't exist locally)
149juza (unattached or doesn't exist locally)
150jvano (unattached or doesn't exist locally)
151jørgen (unattached or doesn't exist locally)
152k.lauer (unattached or doesn't exist locally)
153kamerlings (unattached or doesn't exist locally)
154karga (unattached or doesn't exist locally)
155keidor (unattached or doesn't exist locally)
156kjeker (unattached or doesn't exist locally)
157konqi (unattached or doesn't exist locally)
158kornelis (unattached or doesn't exist locally)
159krischik (unattached or doesn't exist locally)
160kst01 (unattached or doesn't exist locally)
161kurt15 (unattached or doesn't exist locally)
162kuschti (unattached or doesn't exist locally)
163kutay (unattached or doesn't exist locally)
164kwlorenz (unattached or doesn't exist locally)
165langec (unattached or doesn't exist locally)
166lena (unattached or doesn't exist locally)
167lepat (unattached or doesn't exist locally)
168libelula (unattached or doesn't exist locally)
169logarno (unattached or doesn't exist locally)
170lucemferens (unattached or doesn't exist locally)
171ludiel (unattached or doesn't exist locally)
172luna (unattached or doesn't exist locally)
173lupita lopez (unattached or doesn't exist locally)
174mac (unattached or doesn't exist locally)
175maikbirte (unattached or doesn't exist locally)
176manfred@mmoser.de (unattached or doesn't exist locally)
177mar10 (unattached or doesn't exist locally)
178marcaran (unattached or doesn't exist locally)
179maria jose (unattached or doesn't exist locally)
180marianocecowski (unattached or doesn't exist locally)
181maurooo (unattached or doesn't exist locally)
182mechasser (unattached or doesn't exist locally)
183mgautrelet (unattached or doesn't exist locally)
184michaelsy (unattached or doesn't exist locally)
185miglincit (unattached or doesn't exist locally)
186mijobe (unattached or doesn't exist locally)
187mike (unattached or doesn't exist locally)
188misterfred (unattached or doesn't exist locally)
189mmoster (unattached or doesn't exist locally)
190morkalavin (unattached or doesn't exist locally)
191mosaic700 (unattached or doesn't exist locally)
192moua (unattached or doesn't exist locally)
193mover (unattached or doesn't exist locally)
194moyogo (unattached or doesn't exist locally)
195mrotta (unattached or doesn't exist locally)
196mue (unattached or doesn't exist locally)
197murphy1966 (unattached or doesn't exist locally)
198méli (unattached or doesn't exist locally)
199nallebrean (unattached or doesn't exist locally)
200neo1203 (unattached or doesn't exist locally)
201nessie (unattached or doesn't exist locally)
202nils (unattached or doesn't exist locally)
203nixkost (unattached or doesn't exist locally)
204nnh (unattached or doesn't exist locally)
205noreea (unattached or doesn't exist locally)
206notafish (unattached or doesn't exist locally)
207nourse (unattached or doesn't exist locally)
208nudL (unattached or doesn't exist locally)
209oimoim (unattached or doesn't exist locally)
210ol (unattached or doesn't exist locally)
211olav.mueller (unattached or doesn't exist locally)
212oliezekat (unattached or doesn't exist locally)
213olivierb (unattached or doesn't exist locally)
214olrick (unattached or doesn't exist locally)
215orifiel (unattached or doesn't exist locally)
216orobert (unattached or doesn't exist locally)
217panther751 (unattached or doesn't exist locally)
218papatouille (unattached or doesn't exist locally)
219papphut (unattached or doesn't exist locally)
220pascalv (unattached or doesn't exist locally)
221pasquetm (unattached or doesn't exist locally)
222paula (unattached or doesn't exist locally)
223pefferminz (unattached or doesn't exist locally)
224phe (unattached or doesn't exist locally)
225pillese (unattached or doesn't exist locally)
226piolinfax (unattached or doesn't exist locally)
227piranhase (unattached or doesn't exist locally)
228piti (unattached or doesn't exist locally)
229pittyfusionblack (unattached or doesn't exist locally)
230poniol60 (unattached or doesn't exist locally)
231psi (unattached or doesn't exist locally)
232pulsar (unattached or doesn't exist locally)
233pyxos (unattached or doesn't exist locally)
234rackham (unattached or doesn't exist locally)
235rb-lf (unattached or doesn't exist locally)
236revolutioninme (unattached or doesn't exist locally)
237riccardo (unattached or doesn't exist locally)
238richard (unattached or doesn't exist locally)
239rickski (unattached or doesn't exist locally)
240riot (unattached or doesn't exist locally)
241rl (unattached or doesn't exist locally)
242robeere (unattached or doesn't exist locally)
243rodonea (unattached or doesn't exist locally)
244rodrigue (unattached or doesn't exist locally)
245rougier christophe (unattached or doesn't exist locally)
246rp (unattached or doesn't exist locally)
247rpawlicki (unattached or doesn't exist locally)
248rubi tulip (unattached or doesn't exist locally)
249rue (unattached or doesn't exist locally)
250sadybou (unattached or doesn't exist locally)
251sanbec (unattached or doesn't exist locally)
252sancho (unattached or doesn't exist locally)
253savec91 (unattached or doesn't exist locally)
254schuppi (unattached or doesn't exist locally)
255sdv (unattached or doesn't exist locally)
256seb.froh (unattached or doesn't exist locally)
257sei (unattached or doesn't exist locally)
258setarkos1 (unattached or doesn't exist locally)
259setschi (unattached or doesn't exist locally)
260shaihulud (unattached or doesn't exist locally)
261shannon (unattached or doesn't exist locally)
262shefk (unattached or doesn't exist locally)
263shortszene (unattached or doesn't exist locally)
264simon (unattached or doesn't exist locally)
265sirus (unattached or doesn't exist locally)
266slord (unattached or doesn't exist locally)
267smarri (unattached or doesn't exist locally)
268socket (unattached or doesn't exist locally)
269softssa (unattached or doesn't exist locally)
270sono (unattached or doesn't exist locally)
271special (unattached or doesn't exist locally)
272spitzl (unattached or doesn't exist locally)
273sschuepfer (unattached or doesn't exist locally)
274ste281 (unattached or doesn't exist locally)
275stegmueller (unattached or doesn't exist locally)
276steiner (unattached or doesn't exist locally)
277stephanie.moussaoui (unattached or doesn't exist locally)
278stretching (unattached or doesn't exist locally)
279stundenblume (unattached or doesn't exist locally)
280superdorine (unattached or doesn't exist locally)
281supermike (unattached or doesn't exist locally)
282sybilla (unattached or doesn't exist locally)
283t holz (unattached or doesn't exist locally)
284talkuvit (unattached or doesn't exist locally)
285tatjana mru (unattached or doesn't exist locally)
286thierry@marchand-lapointe.com (unattached or doesn't exist locally)
287thomas von weit oben (unattached or doesn't exist locally)
288tieno (unattached or doesn't exist locally)
289tim (unattached or doesn't exist locally)
290timdietz (unattached or doesn't exist locally)
291tithouan (unattached or doesn't exist locally)
292tommybart2000 (unattached or doesn't exist locally)
293toratora (unattached or doesn't exist locally)
294totalQM (unattached or doesn't exist locally)
295trauma (unattached or doesn't exist locally)
296trillotj (unattached or doesn't exist locally)
297tsca (unattached or doesn't exist locally)
298tux3 (unattached or doesn't exist locally)
299upperclass (unattached or doesn't exist locally)
300uz (unattached or doesn't exist locally)
301vanGore (unattached or doesn't exist locally)
302versgui (unattached or doesn't exist locally)
303vijaythakur (unattached or doesn't exist locally)
304vincent.vanderberck (unattached or doesn't exist locally)
305voglerh (unattached or doesn't exist locally)
306vrykolaka (unattached or doesn't exist locally)
307vulkan (unattached or doesn't exist locally)
308webe (unattached or doesn't exist locally)
309weiner@atlas.cz (unattached or doesn't exist locally)
310wico76 (unattached or doesn't exist locally)
311winzkling (unattached or doesn't exist locally)
312wolfgang1018 (unattached or doesn't exist locally)
313wolfgangvonfreeden (unattached or doesn't exist locally)
314wotan (unattached or doesn't exist locally)
315wpopp (unattached or doesn't exist locally)
316wwwtoppointdelutz (unattached or doesn't exist locally)
317x-x5198 (unattached or doesn't exist locally)
318xmlizer (unattached or doesn't exist locally)
319yann (unattached or doesn't exist locally)
320yolgie (unattached or doesn't exist locally)
321youssefsan (unattached or doesn't exist locally)
322zlatko (unattached or doesn't exist locally)
323zuirdj (unattached or doesn't exist locally)
324[[Special:CentralAuth/{FoM}Gurkbuster|{FoM}Gurkbuster]] (unattached or doesn't exist locally)
325[[Special:CentralAuth/}{mpf|}{mpf]] (unattached or doesn't exist locally)

Event Timeline

Well, it goes far beyond what I thought. If we search for "a" then the list is bigger. I'll update the paste.

милена (unattached or doesn't exist locally)

On this page there are two which link to [[Special:CentralAuth/]]: https://meta.wikimedia.org/w/index.php?title=Special:GlobalUsers/%E1%B8%81&offset=%E1%BD%99%CF%80%CE%B5%CF%81%CE%AE%CF%86%CE%B1%CE%BD%CE%BF%CF%82+%E1%BF%AC%CF%89%CE%BC%CE%B1%E1%BF%96%CE%BF%CF%82 and one which does not link anywhere

<globaluser id="32311475" name="                " />
<globaluser id="32311476" name=" " />
<globaluser id="27367943" name="‍" />

as the link will outdate probably.

<globaluser id="32311477" name="‪‪" />
<globaluser id="32311478" name="‪‪‪" />

Then of

<globaluser id="38039199" name="‮" />
<globaluser id="27368904" name="‮Romeo" />
<globaluser id="27368905" name="‮Tiewtew‭" />
<globaluser id="16873304" name="‮iv‭" />
<globaluser id="38039200" name="‮iv‮" />
<globaluser id="32311479" name="‮‮‮‮‮‮‮‮" />

some give link, some not, but both in API and in normal interface they mess up with direction badly

(I have to check what was initially written here)

More found today:

[[Special:CentralAuth/������������������������������|������������������������������]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�¦|�¦]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Zipfiddle|�Zipfiddle]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Vizpiddle|�Vizpiddle]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Slicklick|�Slicklick]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Nuckydoo|�Nuckydoo]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Major A|�Major A]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Kibo|�Kibo]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Grunger|�Grunger]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�DougHoales|�DougHoales]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Bung|�Bung]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Bugblatter|�Bugblatter]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�Aguilator|�Aguilator]] (unattached or doesn't exist locally)
[[Special:CentralAuth/�|�]] (unattached or doesn't exist locally)

although https://meta.wikimedia.org/wiki/Special:CentralAuth/%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0%EF%BE%A0 was the weirdest one.

There are also some with weird characters such as:

🇺🇸 (unattached or doesn't exist locally)
𝜆 (exists locally)
𝛥 (exists locally)
𝖽𝖾𝗋 𝗋𝖾𝗓𝗂𝗉𝖾𝗇𝗍 (exists locally)
𝖭𝖾𝗏𝗓𝖺𝗍 (exists locally)
𝖤𝖤𝖤𝖤𝖤𝖴𝖥𝖥𝖥 (unattached or doesn't exist locally)
𝖅𝖚𝖐𝖆𝖌𝖔𝖎 𝕬. (exists locally)
𝕹𝖆𝖕𝖙𝖔𝖗 (locked, exists locally)
𝕮𝖗𝖚𝖘𝖆𝖉𝖊𝖗 (exists locally)
𝕬𝖉𝖔𝖑𝖋 𝕳𝖎𝖊𝖉𝖑𝖊𝖗 (exists locally)
𝕬.𝖅𝖚𝖐𝖆𝖌𝖔𝖎 (unattached or doesn't exist locally)

𝕀𝓓𝒆𝓳𝓪𝓿𝓊𝕀 (exists locally)
𝔾𝕒𝕟𝕕𝕒𝕝𝕗 𝕕𝕖𝕣 𝔾𝕣𝕪𝕟𝕖 (unattached or doesn't exist locally)
𝔹𝔸𝔹𝔸𝔹𝕀𝕋𝔸 (unattached or doesn't exist locally)
𝔊𝔯𝔞𝔡𝔷𝔢𝔦𝔠𝔥𝔢𝔫 (exists locally)
𝔊 (exists locally)
𝔇𝔦𝔠𝔢 𝔏𝔏𝔐 (exists locally)
𝓼 (exists locally)
𝓢𝓮𝓲𝓽𝓮𝓷𝓵𝓮𝓮𝓻𝓶𝓪𝓬𝓱𝓮𝓻 (unattached or doesn't exist locally)
𝓙𝓽𝓽𝓲 (exists locally)
𝓔𝓷𝓽𝓵𝓮𝓮𝓻𝓮𝓷𝓭𝓮𝓻 𝓔𝓷𝓽𝓵𝓮𝓮𝓻𝓮𝓻 (exists locally)
𝓓𝓮𝓻 𝓢𝓮𝓲𝓽𝓮𝓷𝓵𝓮𝓮𝓻𝓮𝓻 (exists locally)
𝐴𝑟𝑛𝑜𝑙𝑑 𝑍𝑢𝑘𝑎𝑔𝑜𝑖 (unattached or doesn't exist locally)
𝐊𝐨𝐰𝐚𝐥𝐬𝐤𝐢 (exists locally)
𝐅𝐮𝐥𝐭𝐡 (unattached or doesn't exist locally)
𝐁𝐑𝐎𝐄𝐊𝐁𝐎𝐊 (unattached or doesn't exist locally)

We have a lot of bugged accounts like that. Some with special symbols may not be able to log in at all. Personally I would remove them since they can not be used at all due to system limitations.

I noticed on eswiki a couple of usernames that contained an @ on their usernames, so I decided to dig a bit: https://quarry.wmflabs.org/query/32380

MarcoAurelio renamed this task from More invalid usernames to Rename global users with invalid characters on their usernames.Dec 30 2018, 10:07 PM

Also (and displays as broken as below on Special:GlobalUsers):

[[Special:CentralAuth/~~~|~~~]] (unattached or doesn't exist locally)
[[Special:CentralAuth/~~~Flo~~~|~~~Flo~~~]] (unattached or doesn't exist locally)
[[Special:CentralAuth/~~~~|~~~~]] (unattached or doesn't exist locally)
[[Special:CentralAuth/~~~~~|~~~~~]] (unattached or doesn't exist locally)
[[Special:CentralAuth/~~~~~~|~~~~~~]] (unattached or doesn't exist locally)
[[Special:CentralAuth/~~~~~~~~~~|~~~~~~~~~~]] (unattached or doesn't exist locally)

https://meta.wikimedia.org/wiki/Special:CentralAuth/_59.86.41.24 is also listed in GlobalUsers but its broken.

Similarly an account whitespace (_) exists but leads to https://meta.wikimedia.org/wiki/Special:CentralAuth/ which is also broken.

Someone has to actually run rename queries, I am not sure if Operations is the right choice but hopefully some hints are made.

I think that is done by DBAs and not Operations (someone correct me if I'm wrong)

Marostegui subscribed.

No, that's not run by us, DBAs.
Maybe @Legoktm can help up?

There are 40941 global users with an @ in their username.

MariaDB [centralauth_p]> select count(*) from globaluser where gu_name like "%@%";
+----------+
| count(*) |
+----------+
|    40941 |
+----------+
1 row in set (52.99 sec)

MariaDB [centralauth_p]>

I think the number of users with invalid usernames is quite big.

Adding @sguebo_WMF.

Per T308159 and regarding accounts with potential PII on it (e.g. accounts with an that are email addresses) renaming them is probably not a good option, as it'll leave traces on the page move logs, the global rename log and the local user rename logs of every wiki the account is registered, unless you can create a method to do so silently. If they've not editted anywhere (no local/global edits) another option would be to globally suppress these via the CentralAuth lock+suppress option. If the number of accounts to be suppressed is too big, maybe this shouldn't be done via the web interface but using a maintenance script.

Accounts with edits or log actions should perhaps be renamed silently (no public traces) if that's possible, to avoid breaking authorships or leaving the DB in an inconsistent status.

For accounts with invalid usernames without possible PII, a server-side maintenance script can be run and globally rename these as it happened e.g. on T5507 or T219279.

There are 40941 global users with an @ in their username.

MariaDB [centralauth_p]> select count(*) from globaluser where gu_name like "%@%";
+----------+
| count(*) |
+----------+
|    40941 |
+----------+
1 row in set (52.99 sec)

MariaDB [centralauth_p]>

I think the number of users with invalid usernames is quite big.

Note such usernames will break BotPassword, see https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/e78541e80ff2b906bfa6a500f78f40e6054f40b7/includes/user/BotPassword.php#444