I would love to add "Eilidh McAdam <eilidh.mcadam@gmail.com>" as a reviewer, but am cruelly denied with an "application error".
(also the account shows up twice in the autocomplete popup.)
Looks like its solved now. Would be great to have this "linking accounts" stuff documented somewhere easy to find though (Yes, I _should_ know how this works, but I fail hard on the 'easy to find' part.)
This a known issue in Gerrit, which is tracked under the issue: https://code.google.com/p/gerrit/issues/detail?id=567 Moreover there is a script on Gerrit Wiki to handle the user merge: https://code.google.com/p/gerrit/wiki/SqlMergeUserAccounts Unfortunately there is currently no way to do it from the UI and messing around with the underlying Gerrit database is necessary.
Created attachment 89135 [details] load_merge.sql Thanks David. Dumping the current script here as 'our' backup copy. Here is the blurb that comes with it: "Sometimes users wind up with two accounts on a Gerrit server, this is especially common with OpenID installations when the user forgets which OpenID provider he had used, and opens yet another account with a different OpenID identity... but the site administrator knows they are the same person. Unfortunately this has happened often enough on review.source.android.com that I've developed a set of PostgreSQL scripts to handle merging the accounts. The first script, load_merge.sql, creates a temporary table called "links" which contains a mapping of source account_id to destination account_id. This mapping tries to map the most recently created account for a user to the oldest account for the same user, by comparing email addresses and registration dates. Administrators can (and probably should) edit this temporary table before running the second script. The second script, merge_accounts.sql, performs the merge by updating all records in the database in a transaction, but does not commit it at the end. This allows the administrator to double check any records by query before committing the merge result for good."
Removing Eilidh from CC, specific problem is solved, just docing the general case.
Created attachment 89136 [details] merge_accounts.sql attaching second script as local backup.