Thanks! Was it the same username across those wikis that was invalid? It just seems odd that there is exactly 1 invalid name on each wiki you tried.

Are you planning to run migratePass0 to make sure localnames has all of the local names too?

(In reply to Chris Steipp from comment #1)

Thanks! Was it the same username across those wikis that was invalid? It
just seems odd that there is exactly 1 invalid name on each wiki you tried.

To clarify, I ran the script on 524 wikis, and the above lines were just the ones that had invalid localnames. I grabbed it manually from the scripts output, and apparently I missed some.

I re-ran it and saved the output this time (/home/legoktm/bad_local_names.txt on terbium). There are 111 entries in total.

Glancing through it, it looks like most of the users are different except for one which stands out. [[m:Special:CentralAuth/Saerahb]] which has invalid entries on 14 wikis.

Are you planning to run migratePass0 to make sure localnames has all of the
local names too?

Yeah, that's a good idea.

542 invalid localnames rows, and 498 invalid localuser rows.

Most of the bad users in localuser are also present in localnames.

I'll first clean out the bad localnames/localuser rows and then run migratePass0 across all wikis.

We should also check the globalnames table once localnames is fixed.

[12:37:38 AM] <legoktm> !log started running checkLocalNames.php --delete=1 on all CentralAuth wikis for bug 67350
[12:39:20 AM] <legoktm> !log started running checkLocalUser.php --delete=1 on all CentralAuth wikis for bug 67350

I'm guestimating that will take a full day, maybe even the weekend.

Created attachment 15924
counts of deletions by of checkLocalNames.php

Attached:

Created attachment 15925
counts of deletions by checkLocalUser.php

Attached:

I attached the final counts of how many rows were deleted. I have complete logs including which specific rows were deleted in my home on terbium.

(In reply to Kunal Mehta (Legoktm) from comment #5)

I'm guestimating that will take a full day, maybe even the weekend.

Or not! I'll start migratePass0 now.

(In reply to Kunal Mehta (Legoktm) from comment #8)

Or not! I'll start migratePass0 now.

Done.

Now that we know localnames is consistent, we just need to check/fix globalnames. Will need a new script for that.

Curious that wikidata and nsowiki had so many:

$ grep -E "[0-9]{2,} invalid" attachment.cgi\?id\=15925
enwiki: 2014-07-12 12:08:07 found 50 invalid localuser, 50 (100.0%) deleted
metawiki: 2014-07-12 17:29:59 found 52 invalid localuser, 52 (100.0%) deleted
nsowiki: 2014-07-12 17:43:53 found 84 invalid localuser, 84 (100.0%) deleted
wikidatawiki: 2014-07-12 19:26:20 found 119 invalid localuser, 119 (100.0%) deleted