1021105 - Please merge bugzilla accounts

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Infrastructure, defect)

Description

[Jan Beich]

+++ This bug was initially created as a clone of Bug #940622 +++

Moving on from my dead mail address (if only for closed bug replies). Persona sign-in in BMO creates a new account even if they're tied to single entity on persona.org, see bug 746492.

Can I have [e-mail] rewritten to [e-mail] ?

Comment 1

[Jan Beich]

Confirming from the second account.

Comment 2

[David Lawrence [:dkl]]

Admin. Please run the following script from the production webhead

1. # cd /path/to/bugzilla/root
2. # perl ./contrib/merge-users.pl [e-mail] [e-mail]

Thanks
dkl

Comment 3

[Kendall Libby [:fubar] (he/him)]

Uh-oh, error:

bugzillaadm.private.scl3# time perl -T ./contrib/merge-users.pl [e-mail] [e-mail]
OK, old user account [e-mail] found; user ID: 447677.
OK, new user account [e-mail] found; user ID: 508500.
.
.
.
OK, records in the 'watched' column of the 'watch' table
have been migrated to the new user account.
DBD::mysql::st execute failed: Duplicate entry '508500-1021105' for key 'bug_user_last_visit_idx' [for Statement "UPDATE bug_user_last_visit
                                           SET user_id = ?
                                         WHERE user_id = ?" with ParamValues: 0=508500, 1=447677] at ./contrib/merge-users.pl line 217.

Comment 4

[David Lawrence [:dkl]]

Will need to wait til bug 1021218 is resolved, ported to BMO, and pushed to production before we can finish this bug out.

dkl

Comment 5

[David Lawrence [:dkl]]

Admin. A fix has been pushed out to fix the issue encountered previously.
Please run the following script from the production webhead:

1. # cd /path/to/bugzilla/root
2. # perl ./contrib/merge-users.pl [e-mail] [e-mail]

Thanks
dkl

Comment 6

[Kendall Libby [:fubar] (he/him)]

\o/ all set.

bugzillaadm.private.scl3# time perl -T ./contrib/merge-users.pl [e-mail] [e-mail]
OK, old user account [e-mail] found; user ID: 447677.
OK, new user account [e-mail] found; user ID: 508500.
deleting user profile statistics for 447677 and 508500
....
generating user profile statistics 508500
Done.

real	0m1.700s
user	0m0.743s
sys	0m0.093s

Comment 7

[Jan Beich]

Thanks but I've accidentally created [e-mail] again (out of habit). Should I file another bug? It can be killed without merging.

I've now removed [e-mail] from within Persona Account Manager.

Comment 8

[David Lawrence [:dkl]]

(In reply to Jan Beich from comment #7)
> Thanks but I've accidentally created [e-mail] again (out of
> habit). Should I file another bug? It can be killed without merging.
> 
> I've now removed [e-mail] from within Persona Account Manager.

I have disabled the [e-mail] account.

dkl