Bug 435667

Tony, for these just go to the three bugs in question on the live site and
change the rep_platform values to the following:

arm -> arm7
PC -> i386

Since there are only three then it is easy just to change the bugs.
And then close this out.

Thanks
Dave

Dave,

I have updated three bugs that have arm as rep_platform value.

There are 433 bugs that have PC as rep_platform value and we can use the
following sql query to change them to i386

UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc';


Tony

(In reply to comment #2)
> Dave,
> 
> I have updated three bugs that have arm as rep_platform value.
> 
> There are 433 bugs that have PC as rep_platform value and we can use the
> following sql query to change them to i386
> 
> UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc';

Hmm, I didn't realize there were so many. We will need to write a script that
does the bugs table update as you mention but I think we also need to insert the
changes into the bugs_activity log. I originally thought there were only a few
which we could have just changed through the UI which does the activity for us.

Tony, can you create a script for this?

Thanks
Dave

(In reply to comment #3)
> (In reply to comment #2)
> > Dave,
> > 
> > I have updated three bugs that have arm as rep_platform value.
> > 
> > There are 433 bugs that have PC as rep_platform value and we can use the
> > following sql query to change them to i386
> > 
> > UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc';
> 
> Hmm, I didn't realize there were so many. We will need to write a script that
> does the bugs table update as you mention but I think we also need to insert the
> changes into the bugs_activity log. I originally thought there were only a few
> which we could have just changed through the UI which does the activity for us.
> 
> Tony, can you create a script for this?
> 
> Thanks
> Dave
> 
> 

Please see attachment for the script.

Thanks,
Tony

Created attachment 297560 [details]
change bugs.rep_platform's value from "PC" to "i386"

Comment on attachment 297560 [details]
change bugs.rep_platform's value from "PC" to "i386"

Code looks good Tony. Please run on bz-db1-test.devel.redhat.com 'bugs2'
database and verify that data is proper converted. Also look through some
sample bug reports on bz-web1-test.devel.redhat.com. If it looks good, then
check the script into redhat directory in CVS. Put this bug into MODIFIED state
and we will schedule it to be ran on live for Thursday.

Thanks
Dave

(In reply to comment #6)
> (From update of attachment 297560 [details] [edit])
> Code looks good Tony. Please run on bz-db1-test.devel.redhat.com 'bugs2'
> database and verify that data is proper converted. Also look through some
> sample bug reports on bz-web1-test.devel.redhat.com. If it looks good, then
> check the script into redhat directory in CVS. Put this bug into MODIFIED state
> and we will schedule it to be ran on live for Thursday.
> 
> Thanks
> Dave
> 

I have tested this script against bugs2 db on bz-db1-test.devel.redhat.com and
it looked good.

checked this script into redhat directory in CVS repository.

Tony

Tony, I cannot remember, was this ran on production during one of our thursday
updates? If yes, please close this as CURRENTRELEASE/2.18

Thanks
Dave

(In reply to comment #8)
> Tony, I cannot remember, was this ran on production during one of our thursday
> updates? If yes, please close this as CURRENTRELEASE/2.18
> 
> Thanks
> Dave

Dave,

I think we have done it on production server.

mysql> select count(bug_id) from bugs where rep_platform='arm';
+---------------+
| count(bug_id) |
+---------------+
|             0 | 
+---------------+
1 row in set (0.30 sec)

mysql> select count(bug_id) from bugs where rep_platform='pc';
+---------------+
| count(bug_id) |
+---------------+
|             0 | 
+---------------+
1 row in set (0.30 sec)

Close this bug.

Tony