Closed Bug 1021105 Opened 10 years ago Closed 10 years ago

Please merge bugzilla accounts

Categories

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

Product:
bugzilla.mozilla.org
Component:
Infrastructure
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED

People

(Reporter: jbeich, Assigned: fubar)

References

Details

(Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/173] ) 

+++ 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 jbeich@tormail.org rewritten to jbeich@vfemail.net ?
Confirming from the second account.
Assignee: server-ops-webops → nobody
Component: WebOps: Bugzilla → Administration
Product: Infrastructure & Operations → bugzilla.mozilla.org
QA Contact: nmaul
Admin. Please run the following script from the production webhead

1. # cd /path/to/bugzilla/root
2. # perl ./contrib/merge-users.pl jbeich@tormail.org jbeich@vfemail.net

Thanks
dkl
Assignee: nobody → server-ops-webops
Component: Administration → WebOps: Bugzilla
Product: bugzilla.mozilla.org → Infrastructure & Operations
QA Contact: nmaul
Uh-oh, error:

bugzillaadm.private.scl3# time perl -T ./contrib/merge-users.pl jbeich@tormail.org jbeich@vfemail.net
OK, old user account jbeich@tormail.org found; user ID: 447677.
OK, new user account jbeich@vfemail.net 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.
Assignee: server-ops-webops → klibby
Flags: needinfo?(dkl)
Depends on: 1021218
Will need to wait til bug 1021218 is resolved, ported to BMO, and pushed to production before we can finish this bug out.

dkl
Flags: needinfo?(dkl)
Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/173]
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 jbeich@tormail.org jbeich@vfemail.net

Thanks
dkl
\o/ all set.

bugzillaadm.private.scl3# time perl -T ./contrib/merge-users.pl jbeich@tormail.org jbeich@vfemail.net
OK, old user account jbeich@tormail.org found; user ID: 447677.
OK, new user account jbeich@vfemail.net 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
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Thanks but I've accidentally created jbeich@tormail.org again (out of habit). Should I file another bug? It can be killed without merging.

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

I have disabled the jbeich@tormail.org account.

dkl
Component: WebOps: Bugzilla → Infrastructure
Product: Infrastructure & Operations → bugzilla.mozilla.org
You need to log in before you can comment on or make changes to this bug.