Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 454459 - clean up NEEDINFO_* from bugzilla for 3.2 migration
Summary: clean up NEEDINFO_* from bugzilla for 3.2 migration
Alias: None
Product: Bugzilla
Classification: Community
Component: Bugzilla General
Version: 3.2
Hardware: All
OS: Linux
medium vote
Target Milestone: ---
Assignee: Noura El hawary
QA Contact:
Depends On:
Blocks: RHBZ30UpgradeTracker
TreeView+ depends on / blocked
Reported: 2008-07-08 16:36 UTC by Noura El hawary
Modified: 2013-06-24 04:10 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2008-07-22 20:11:15 UTC

Attachments (Terms of Use)
v1 added code to clean up NEEDINFO_REPORTER status (deleted)
2008-07-09 13:05 UTC, Noura El hawary
dkl: review+
Details | Diff
patch for the rest of NEEDINFO_* cleanup (deleted)
2008-07-10 05:03 UTC, Noura El hawary
dkl: review+
Details | Diff

Description Noura El hawary 2008-07-08 16:36:26 UTC
few bugs have NEEDINFO_REPORTER status in them as reported by tony, this all
needs to be cleaned out as part of the NEEDINFO status clean up for the 3.2
bugzilla migration.

Comment 1 Noura El hawary 2008-07-09 13:05:19 UTC
Created attachment 311372 [details]
v1 added code to clean up NEEDINFO_REPORTER status

attached is a patch to the needinfo cleanup script which does clean up of the
NEEDINFO_REPORTER status and also now it has code to write the output to a log
file so we can keep track and record of the clean up process and keep Meethune
happy lol.

please review when you can.


Comment 2 Noura El hawary 2008-07-09 13:07:34 UTC
just a note when i checked the partner database it had about 35 bugs with
NEEDINFO_REPORTER, but currently the live production database has only one bug
with that status, i just fixed the script just in case at the time of the
migration there are more bugs again with that status.


Comment 3 David Lawrence 2008-07-09 16:06:55 UTC
Comment on attachment 311372 [details]
v1 added code to clean up NEEDINFO_REPORTER status

Looks good Noura. 

One little nitpick though:
Change MYFILE to LOGFILE or LOG to be more descriptive.

Once that is changed, feel free to checkin and then send email for bhowmick to
run on partner-bugzilla.


Comment 4 Noura El hawary 2008-07-09 21:48:16 UTC
Thanks for the review Dave, changed to LOGFILE, and sent request to run the
script on partner-bugzilla.


Comment 5 Noura El hawary 2008-07-10 02:14:53 UTC
looking the the result i got from meethune from running the clean up script on
partner-bugzilla , 2 things went wrong:

1- the needinfo?($SOMONE) string was appending the reporters from each bug to
the other because i forgot to rest the string to its original value inside each

2- new thing came out which is what if the prev status to a bug with NEEDINFO
was NEEDINFO_REPORTER or the other way around prev status with NEEDINFO_REPORTER
was NEEDINFO this will still change back to the NEEDINFO or NEEDINFO_REPORTER
and we haven't done anything.

a patch is attached which has the fix for the above 2 cases also i run the
script with that patch on bz-db1-test and the output is attached


Comment 6 Noura El hawary 2008-07-10 05:03:29 UTC
Created attachment 311443 [details]
patch for the rest of NEEDINFO_* cleanup

This is the patch that includes fix for the above points, basically i found out
that there are some other previous statuses that are not valid and should not
be set instead of the NEEDINFO status for example, INVISTIGATE, NEEDINFO_PM
so i put condition for the previous status that it has to be in:

removed IN (select value from bug_status where isactive=1 and is_open=1 and
value != 'NEEDINFO')

please see attached patch.


Comment 7 David Lawrence 2008-07-10 05:13:30 UTC
Comment on attachment 311443 [details]
patch for the rest of NEEDINFO_* cleanup

Looks good Noura.

Comment 8 Noura El hawary 2008-07-10 12:53:00 UTC
Thanks for the review Dave, now committed.

Comment 9 David Lawrence 2008-07-22 20:11:15 UTC
The changes have been pushed to and/or have been
recorded in the Bugzilla migration pages on the Bugzilla 3 upgrade Wiki.


Note You need to log in before you can comment on or make changes to this bug.