912222 - Please merge [e-mail] into [e-mail]

Status: VERIFIED FIXED

(Developer Services :: General, task)

Description

[Dave Miller [:justdave]]

Please merge the [e-mail] account into [e-mail]

Too much hassle to keep them separate anymore.

Thanks!

Comment 1

[Dave Miller [:justdave]]

Posting from the other account.  I concur. :)

Comment 2

[Dave Miller [:justdave]]

Actually, reverse that, make bugzilla.org be the surviving account.  I'll rename it to mozilla.com after it's merged. ;)    (it has the older creation date/lower userid so the age of the account will be more accurate that way)

Comment 3

[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 4

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

Ruh-roh:

bugzillaadm.private.scl3#time perl -T ./contrib/merge-users.pl [e-mail] [e-mail]
OK, old user account [e-mail] found; user ID: 198524.
OK, new user account [e-mail] found; user ID: 10297.
OK, records in the 'user_id' column of the 'user_group_map' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'user_group_map' table
have been migrated to the new user account.
OK, records in the 'who' column of the 'longdescs' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'profile_setting' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'profile_setting' table
have been migrated to the new user account.
OK, records in the 'initialowner' column of the 'components' table
have been migrated to the new user account.
OK, records in the 'initialqacontact' column of the 'components' table
have been migrated to the new user account.
OK, records in the 'watch_user' column of the 'components' table
have been migrated to the new user account.
OK, records in the 'user_id' column of the 'profile_search' table
have been migrated to the new user account.
DBD::mysql::st execute failed: Duplicate entry '10297-' for key 'profiles_statistics_products_idx' [for Statement "UPDATE profiles_statistics_products
                                           SET user_id = ?
                                         WHERE user_id = ?" with ParamValues: 0=10297, 1=198524] at ./contrib/merge-users.pl line 213.

Comment 5

[:glob ✱]

i've filed bug 912479 to fix the script.

these updates happen within a transaction which would have been rolled back, so nothing should be broken (or merged!).

Comment 6

[Dave Miller [:justdave]]

confirmed, my permissions are still intact, which was one of the first tables "merged" in the output.

Comment 7

[Dave Miller [:justdave]]

Given the delay, I'd appreciate a heads-up on IRC before you actually run this once it's ready to go again, just so I know where to look for my bugmail :)  thanks

Comment 8

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

Sure thing! (Do we have an idea when the next bmo push will be?)

Comment 9

[:glob ✱]

(In reply to Kendall Libby [:fubar] from comment #8)
> Sure thing! (Do we have an idea when the next bmo push will be?)

tricky :)  normally ashish does them, but he's on leave.  hopefully early next week.

Comment 10

[David Lawrence [:dkl]]

(In reply to Kendall Libby [:fubar] from comment #8)
> Sure thing! (Do we have an idea when the next bmo push will be?)

Ok, the fix for this is live now. Please proceed with trying this merge again.

thanks
dkl

Comment 11

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

All set!

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

real	0m18.425s
user	0m0.968s
sys	0m0.334s

Comment 12

[Dave Miller [:justdave]]

confirmed, logged in with the new account and email address changed back, everything looks pretty except for my profile page being blank.