1087525 - Move mozilla.org::Server Operations: Desktop Issues to Infrastructure and Operations::Servicedesk

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: Administration, task)

Description

[Shyam Mani [:fox2mike]]

We'd like to move the Server Operations: Desktop Issues from under mozilla.org to Infrastructure and Operations::Servicedesk before Oct 27, if possible. 

The description, default QA etc will remain the same. We'd like all existing bugs moved over as well and flags retained. 

Let me know if you have any questions, Thanks!

Comment 1

[Dylan Hardison [:dylan] (he/him)]

Admin, Please run the following 2 scripts from the production webhead.
Assign this ticket back to me when completed.

# cd /path/to/bugzilla/root

# perl contrib/reorg-tools/syncmsandversions.pl mozilla.org 'Infrastructure & Operations'
# perl contrib/reorg-tools/movecomponent.pl mozilla.org 'Infrastructure & Operations' 'Server Operations: Desktop Issues'

Comment 2

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

Error:

bugzillaadm.private.scl3# time perl contrib/reorg-tools/movecomponent.pl mozilla.org 'Infrastructure & Operations' 'Server Operations: Desktop Issues'
About to move the component 'Server Operations: Desktop Issues'
From 'mozilla.org'
To 'Infrastructure & Operations'

Press <Ctrl-C> to stop or <Enter> to continue...

Moving 'Server Operations: Desktop Issues' from 'mozilla.org' to 'Infrastructure & Operations'...

DBD::mysql::db do failed: Duplicate entry '707-107-600' for key 'flaginclusions_type_id_idx' [for Statement "UPDATE flaginclusions SET product_id = ? WHERE component_id = ?"] at contrib/reorg-tools/movecomponent.pl line 104.

Comment 3

[Dylan Hardison [:dylan] (he/him)]

Attachment: movecomp.patch

Add check to avoid adding duplicate entry to flaginclusions/flagexclusions.

Comment 4

[Dylan Hardison [:dylan] (he/him)]

Attachment: movecomponent.pl

Here is the revised movecomponent.pl script. Please run the commands in Comment #1, replacing that movecomponent.pl script the attached.

Comment 5

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

for the record, same error.

Moving 'Server Operations: Desktop Issues' from 'mozilla.org' to 'Infrastructure & Operations'...

DBD::mysql::db do failed: Duplicate entry '707-107-600' for key 'flaginclusions_type_id_idx' [for Statement "UPDATE flaginclusions SET product_id = ? WHERE component_id = ? "] at /home/klibby/movecomponent.pl line 118.

Comment 6

[Dylan Hardison [:dylan] (he/him)]

Attachment: bug-1087525-v2.patch

I think it is too risky to run this code without another review, so :fubar, if you're reading this -- I'll see you on Monday.

Comment 7

[David Lawrence [:dkl]]

Comment on attachment 8511418 [details] [diff] [review]
bug-1087525-v2.patch

Review of attachment 8511418 [details] [diff] [review]:
-----------------------------------------------------------------

Code looks sane and it tests OK locally. With anything that has some slight potential for data loss, I would feel better if one other person
gave a quick glance as well.

Comment 8

[Dylan Hardison [:dylan] (he/him)]

Per Comment #7, :glob said in IRC he will try to get it reviewed before tomorrow's push.

Comment 9

[:glob ✱]

Comment on attachment 8511418 [details] [diff] [review]
bug-1087525-v2.patch

Review of attachment 8511418 [details] [diff] [review]:
-----------------------------------------------------------------

r=glob

Comment 10

[:glob ✱]

To ssh://[e-mail]/webtools/bmo/bugzilla.git
   83eac0c..37bd66c  master -> master

Comment 11

[Dylan Hardison [:dylan] (he/him)]

Admin, please proceed as in Comment #1. The script has been pushed to production. There should not be any errors now.

Comment 12

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

great success. \o/

bugzillaadm.private.scl3# time perl contrib/reorg-tools/syncmsandversions.pl mozilla.org 'Infrastructure & Operations'

real	0m1.008s
user	0m0.904s
sys	0m0.075s

bugzillaadm.private.scl3# time perl contrib/reorg-tools/movecomponent.pl mozilla.org 'Infrastructure & Operations' 'Server Operations: Desktop Issues'
About to move the component 'Server Operations: Desktop Issues'
From 'mozilla.org'
To 'Infrastructure & Operations'

Press <Ctrl-C> to stop or <Enter> to continue...

Moving 'Server Operations: Desktop Issues' from 'mozilla.org' to 'Infrastructure & Operations'...

Touching user profile data for 11464 bugs.
Updated 47344 users.

real	2m7.982s
user	0m15.169s
sys	0m5.519s

Comment 13

[Dylan Hardison [:dylan] (he/him)]

Renamed.