MetaWiki autocreated, detached accounts
See T31234: Prevent creation of new (unattached?) SUL accounts with already unified names, T37792: SUL account recently created with no attached or unattached accounts, and undeletable, T41060: Can't login to some local attached accounts, said not to exist, T41996: Accounts magically unattached despite being recently created, T41997: Please give me my accounts back and friends for context.
One example silly query one can run e.g. on toolserver (sql metawiki_p):
SELECT
log_title, log_user, log_timestamp
FROM logging
JOIN user ON logging.log_action = 'autocreate' /*
AND log_timestamp > 20130431000000 */
AND logging.log_user = user.user_id
WHERE user.user_name NOT IN (
SELECT lu_name FROM centralauth_p.localuser lu WHERE lu.lu_wiki = 'metawiki'
);
15k results on Meta-Wiki only.
An actual query needs to be made slightly faster, I suppose, and actually check for the validity of the local account (it can be attached but nevertheless unusable, with password and email not working) and of its global username (which might have been deleted, or detached on purpose).
Note, at some point James said this would be done as part of the work for bug 35707.
Version: unspecified
Severity: normal
Attached: