Merge or block duplicate accounts on wikitech
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	bd808
	Apr 17 2019, 12:52 AM

Description

Canonical user	Duplicate(s)	Done?
Aklapper	AKlapper	[x]
AndreG-P	Andreg-p	[x]
Andrew Bogott	Andrew bogott, Andrew BOGOTT	[x]
ArielGlenn	Arielglenn	[x]
Ben Brand	Ben brand	[x]
CodeDev	Codedev	[x]
Cparle	CParle	[x]
Cstone	CStone	[x]
DamianZaremba	Damianzaremba	[x]
Dbrant	DBrant	[x]
DEXi	Dexi	[x]
DGideas	Dgideas	[x]
Fdans	FDans	[x]
FreedomFighterSparrow	Freedomfightersparrow	[x]
GWicke	Gwicke	[x]
IAlex	Ialex	[x]
Jack Phoenix	Jack phoenix	[x]
JameerBabu	Jameerbabu	[x]
Jarbot	JarBot	[x]
JAufrecht	Jaufrecht	[x]
Jaybox	JayBox	[x]
Jeroen De Dauw	Jeroen de dauw	[x]
Jforrester	JForrester	[x]
JGirault	Jgirault	[x]
Jnanaranjan Sahu	Jnanaranjan sahu	[x]
Jsalsman	JSalsman	[x]
Khaled El Mansoury	Khaled el mansoury	[x]
LA2	la2	[x]
Lmixter	LMixter	[x]
MarkAHershberger	Markahershberger	[x]
Marostegui	MArostegui	[x]
Mepps	MEpps	[x]
Mike Morearty	Mike morearty	[x]
MikeMel	Mikemel	[x]
MNeisler	Mneisler	[x]
Moritz.Finke	Moritz.finke	[x]
Nadyad	NadyaD	[x]
Neilk	NeilK	[x]
Phedenskog	PHedenskog	[x]
Qoreqyas	QoreQyaS	[x]
Quangthong81	QuangThong81	[x]
Risler	RIsler	[x]
RoySmith	Roysmith	[x]
RUYABA	Ruyaba	[x]
RV1971	Rv1971	[x]
Ryan Lane	Ryan lane	[x]
Sam0410	SAM0410	[x]
Sean Chen	Sean chen	[x]
Shikhajadoun1997	ShikhaJadoun1997	[x]
Shreyasminocha	ShreyasMinocha	[x]
Shweta Chandrakant Pawar	Shweta chandrakant pawar	[x]
Smccandlish	SMcCandlish	[x]
SmithnWesson09	Smithnwesson09	[x]
Sniedzielski	SNiedzielski	[x]
Spage	SPage	[x]
SRodlund	Srodlund	[x]
Tim Starling	Tim starling	[x]
Tparis	TParis	[x]
UltrasonicNXT	Ultrasonicnxt	[x]
VCloudernBeer	Vcloudernbeer	[x]
Vedmaka Wakalaka	Vedmaka wakalaka	[x]
Victor Vasiliev	Victor vasiliev	[x]
WebIntegrity	Webintegrity	[x]
Yasbot	YasBot	[x]
Your1	YOUR1	[x]

List created using an sql query to find unblocked duplicates and manual comparison with the cn attributes of developer account records in the backing LDAP directory.

SELECT
  LCASE(user_name),
  user_id,
  user_name
FROM user
WHERE LCASE(user_name) in (
  SELECT name from (
    SELECT LCASE(user_name) as name, COUNT(user_name) AS cnt
    FROM user u2
    WHERE user_id not in (SELECT ipb_user FROM ipblocks)
    GROUP BY LCASE(user_name)
    HAVING cnt > 1
  ) AS dups
)
ORDER BY LCASE(user_name), user_id;

Related Objects
Search...

Status	Assigned	Task
		Restricted Task
Resolved	bd808	T165795 Ldap auth extension vs. ldap vs. username Case
Resolved	bd808	T221180 Merge or block duplicate accounts on wikitech

Event Timeline

bd808 created this task.Apr 17 2019, 12:52 AM

bd808 updated the task description. (Show Details)Apr 17 2019, 12:56 AM

Merge from Gwicke (1009) to GWicke (85) is complete.

Gwicke (1009) has been deleted.

This actually took 2 tries. The first attempt halted with a DBTransactionSizeError. https://logstash.wikimedia.org/goto/c238717d6418736be27f447198acb6e1

Raising $wgMaxUserDBWriteDuration from its current value of '3' to something larger (60?) might make things go smoother at the potential cost of table locking while the merges are being performed.

bd808 triaged this task as High priority.Apr 17 2019, 1:01 AM

bd808 updated the task description. (Show Details)Apr 17 2019, 9:27 PM

Note to self: make sure to clean out the htop tables too. UserMerge likely knows nothing about them.

bd808 updated the task description. (Show Details)Apr 17 2019, 10:33 PM

MariaDB [labswiki]> select id from oathauth_users where id not in (select user_id from user);
+-------+
| id    |
+-------+
|  1170 |
|  8374 |
| 10526 |
| 11414 |
| 12148 |
+-------+
5 rows in set (0.01 sec)

MariaDB [labswiki]> delete from oathauth_users where id in (1170, 8374, 10526, 11414, 12148);
Query OK, 5 rows affected (0.00 sec)

MariaDB [labswiki]> select id from oathauth_users where id not in (select user_id from user);
Empty set (0.00 sec)

MariaDB [labswiki]> select id from oathauth_users_restore where id not in (select user_id from user);
+------+
| id   |
+------+
|  346 |
| 1170 |
+------+
2 rows in set (0.02 sec)

MariaDB [labswiki]> delete from oathauth_users_restore where id in (346, 1170);
Query OK, 2 rows affected (0.00 sec)

MariaDB [labswiki]> select id from oathauth_users_restore where id not in (select user_id from user);
Empty set (0.00 sec)

Merge or block duplicate accounts on wikitechClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Merge or block duplicate accounts on wikitech
Closed, ResolvedPublic
Actions

Related Objects
Search...