https://bugzilla.wikimedia.org/show_bug.cgi?id=66101
Bug ID: 66101
Summary: Multiple user_ids per username in account creation
events from ServerSideAccountCreation log
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: EventLogging
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected],
[email protected]
Web browser: ---
Mobile Platform: ---
There are ca. 14K account creation events generated in April (from both the
mobile and the desktop site) with the same user_name associated to multiple
user_id's in ServerSideAccountCreation:
SELECT event_userName, COUNT(event_userId) AS dupe, MIN(timestamp),
MAX(timestamp) FROM ServerSideAccountCreation_5487345 WHERE event_isSelfMade =
1 AND LEFT(timestamp, 6) = '201404' GROUP BY 1 HAVING dupe > 1 ORDER BY dupe
DESC;
(all events for April seem to have been generated between April 4 and April 24)
The problem goes back to the very beginning of the log (June 2013) and
continues until now, for a total of 200K entries with multiple user_ids over
the course of a year.
I haven't done any further investigation but this affects anyone counting
usernames as opposed to distinct user_ids.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
