Attachment 303334 Details for Bug 431086 – possible solutions of fixing database inconsistencies, reported by sanitcheck, commented by dkl

possible solutions of fixing database inconsistencies, reported by sanitcheck, commented by dkl

foreign_keys.orig.comment (text/plain), 38.17 KB, created by David Lawrence on 2008-04-22 16:15:37 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Lawrence

Created: 2008-04-22 16:15:37 UTC

Size: 38.17 KB

patch

obsolete

>Check: foreign_keys
>===================================================================
>Status:
>--------
>FAIL
>
>Report:
>--------
>Checking references to profiles.userid... from bugs.reporter
>Checking references to profiles.userid... from bugs.assigned_to
>Bad value 50943 found in bugs.assigned_to
>Bad value 80221 found in bugs.assigned_to
>
>XXX tfu: change bugs.assigned_to to bugzilla@redhat.com
>XXX dkl: Agreed
>XXX dkl: Some SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from bugs.qa_contact
>Bad value 0 found in bugs.qa_contact
>Bad value 8032 found in bugs.qa_contact
>Bad value 68153 found in bugs.qa_contact
>Bad value 105329 found in bugs.qa_contact
>
>XXX tfu: change bugs.qa_contact to null
>XXX dkl: Agreed
>XXX dkl: Some SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from attachments.submitter_id
>Bad value 11616 found in attachments.submitter_id
>Bad value 12963 found in attachments.submitter_id
>Bad value 17808 found in attachments.submitter_id
>Bad value 34412 found in attachments.submitter_id
>Bad value 85801 found in attachments.submitter_id
>Bad value 92468 found in attachments.submitter_id
>Bad value 160812 found in attachments.submitter_id
>
>XXX tfu: change attachments.submitter_id to bugzilla@redhat.com
>XXX dkl: SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from bugs_activity.who
>Bad value 0 found in bugs_activity.who
>Bad value 23 found in bugs_activity.who
>Bad value 289 found in bugs_activity.who
>Bad value 956 found in bugs_activity.who
>Bad value 1014 found in bugs_activity.who
>Bad value 7965 found in bugs_activity.who
>Bad value 8032 found in bugs_activity.who
>Bad value 11616 found in bugs_activity.who
>Bad value 12963 found in bugs_activity.who
>Bad value 16840 found in bugs_activity.who
>Bad value 17808 found in bugs_activity.who
>Bad value 80221 found in bugs_activity.who
>Bad value 160812 found in bugs_activity.who
>Bad value 162584 found in bugs_activity.who
>Bad value 164666 found in bugs_activity.who
>Bad value 182439 found in bugs_activity.who
>Bad value 211604 found in bugs_activity.who
>
>XXX tfu: change bugs_activity.who to bugzilla@redhat.com
>XXX dkl: Agreed
>
>Checking references to profiles.userid... from cc.who
>Bad value 23 found in cc.who
>Bad value 287 found in cc.who
>Bad value 1014 found in cc.who
>Bad value 1831 found in cc.who
>Bad value 2791 found in cc.who
>Bad value 7963 found in cc.who
>Bad value 7965 found in cc.who
>Bad value 8117 found in cc.who
>Bad value 10172 found in cc.who
>Bad value 12963 found in cc.who
>Bad value 16840 found in cc.who
>Bad value 17808 found in cc.who
>Bad value 34412 found in cc.who
>Bad value 41639 found in cc.who
>Bad value 80221 found in cc.who
>Bad value 85801 found in cc.who
>Bad value 87800 found in cc.who
>Bad value 88029 found in cc.who
>Bad value 105329 found in cc.who
>Bad value 130686 found in cc.who
>Bad value 159676 found in cc.who
>Bad value 160592 found in cc.who
>Bad value 160812 found in cc.who
>Bad value 162584 found in cc.who
>Bad value 164666 found in cc.who
>Bad value 166720 found in cc.who
>Bad value 182439 found in cc.who
>
>XXX tfu: delete record if the record's cc.who is an invalid profiles.userid
>XXX dkl: Agreed
>XXX dkl: SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from flags.setter_id
>Checking references to profiles.userid... from flags.requestee_id
>Checking references to profiles.userid... from votes.who
>Checking references to profiles.userid... from longdescs.who
>Bad value 23 found in longdescs.who
>Bad value 287 found in longdescs.who
>Bad value 289 found in longdescs.who
>Bad value 453 found in longdescs.who
>Bad value 870 found in longdescs.who
>Bad value 956 found in longdescs.who
>Bad value 1014 found in longdescs.who
>Bad value 2791 found in longdescs.who
>Bad value 2850 found in longdescs.who
>Bad value 4420 found in longdescs.who
>Bad value 7965 found in longdescs.who
>Bad value 8032 found in longdescs.who
>Bad value 10172 found in longdescs.who
>Bad value 11616 found in longdescs.who
>Bad value 12963 found in longdescs.who
>Bad value 15695 found in longdescs.who
>Bad value 16156 found in longdescs.who
>Bad value 16840 found in longdescs.who
>Bad value 17808 found in longdescs.who
>Bad value 24015 found in longdescs.who
>Bad value 24555 found in longdescs.who
>Bad value 30050 found in longdescs.who
>Bad value 33725 found in longdescs.who
>Bad value 34412 found in longdescs.who
>Bad value 41639 found in longdescs.who
>Bad value 44029 found in longdescs.who
>Bad value 49411 found in longdescs.who
>Bad value 60983 found in longdescs.who
>Bad value 80221 found in longdescs.who
>Bad value 85801 found in longdescs.who
>Bad value 87800 found in longdescs.who
>Bad value 88029 found in longdescs.who
>Bad value 92468 found in longdescs.who
>Bad value 98575 found in longdescs.who
>Bad value 101155 found in longdescs.who
>Bad value 130686 found in longdescs.who
>Bad value 160812 found in longdescs.who
>Bad value 162584 found in longdescs.who
>Bad value 164666 found in longdescs.who
>Bad value 182439 found in longdescs.who
>Bad value 211953 found in longdescs.who
>Bad value 212062 found in longdescs.who
>Bad value 212779 found in longdescs.who
>
>XXX tfu: change longdescs.who to bugzilla@redhat.com
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from logincookies.userid
>Checking references to profiles.userid... from namedqueries.userid
>Bad value 0 found in namedqueries.userid
>Bad value 23 found in namedqueries.userid
>Bad value 202 found in namedqueries.userid
>Bad value 1014 found in namedqueries.userid
>Bad value 1763 found in namedqueries.userid
>Bad value 11616 found in namedqueries.userid
>Bad value 16840 found in namedqueries.userid
>Bad value 17808 found in namedqueries.userid
>Bad value 33725 found in namedqueries.userid
>Bad value 101155 found in namedqueries.userid
>
>XXX tfu: change namedqueries.userid to bugzilla@redhat.com
>XXX dkl: Delete the namedqueries that have userids that do not match a row in profiles.
>XXX dkl: bugzilla@redhat.com will never need to run the saved queries
>XXX dkl: SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from profiles_activity.userid
>Bad value 105329 found in profiles_activity.userid
>Bad value 156511 found in profiles_activity.userid
>Bad value 160812 found in profiles_activity.userid
>Bad value 161845 found in profiles_activity.userid
>Bad value 182439 found in profiles_activity.userid
>Bad value 211658 found in profiles_activity.userid
>
>XXX tfu: delete those records with invalid profiels.userid
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from profiles_activity.who
>Checking references to profiles.userid... from quips.userid
>Checking references to profiles.userid... from series.creator
>Bad value 0 found in series.creator
>
>XXX tfu: change series.creator to bugzilla@redhat.com
>XXX dkl: Delete series that has creator of 0
>
>Checking references to profiles.userid... from watch.watcher
>Bad value 165722 found in watch.watcher
>
>XXX tfu: delete records with invalid profiles.userid as watcher
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from watch.watched
>Checking references to profiles.userid... from tokens.userid
>Checking references to profiles.userid... from components.initialowner
>Checking references to profiles.userid... from components.initialqacontact
>Bad value 68153 found in components.initialqacontact
>
>XXX tfu: change components.initialqacontact to null
>XXX dkl: Agreed.
>
>Checking references to profiles.userid... from component_cc.user_id
>Checking references to profiles.userid... from whine_events.owner_userid
>Checking references to profiles.userid... from user_group_map.user_id
>Bad value 16840 found in user_group_map.user_id
>Bad value 20998 found in user_group_map.user_id
>Bad value 25991 found in user_group_map.user_id
>Bad value 30050 found in user_group_map.user_id
>Bad value 37703 found in user_group_map.user_id
>Bad value 45879 found in user_group_map.user_id
>Bad value 46333 found in user_group_map.user_id
>Bad value 46370 found in user_group_map.user_id
>Bad value 48771 found in user_group_map.user_id
>Bad value 49303 found in user_group_map.user_id
>Bad value 49312 found in user_group_map.user_id
>Bad value 49313 found in user_group_map.user_id
>Bad value 49314 found in user_group_map.user_id
>Bad value 49315 found in user_group_map.user_id
>Bad value 51175 found in user_group_map.user_id
>Bad value 52865 found in user_group_map.user_id
>Bad value 54988 found in user_group_map.user_id
>Bad value 62727 found in user_group_map.user_id
>Bad value 67605 found in user_group_map.user_id
>Bad value 105805 found in user_group_map.user_id
>Bad value 107014 found in user_group_map.user_id
>Bad value 130686 found in user_group_map.user_id
>Bad value 147463 found in user_group_map.user_id
>Bad value 155642 found in user_group_map.user_id
>Bad value 156511 found in user_group_map.user_id
>Bad value 159676 found in user_group_map.user_id
>Bad value 161845 found in user_group_map.user_id
>
>XXX tfu: Delete these recores with invalid profiles.userid as user_id
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to profiles.userid... from whine_schedules.mailto
>Checking references to whine_events.id... from whine_queries.eventid
>Checking references to whine_events.id... from whine_schedules.eventid
>Checking references to keyworddefs.id... from keywords.keywordid
>Checking references to series.series_id... from series_data.series_id
>Checking references to products.id... from bugs.product_id
>Checking references to products.id... from components.product_id
>Checking references to products.id... from milestones.product_id
>Bad value 59 found in milestones.product_id
>
>XXX tfu: Delete records with product_id=59
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to products.id... from versions.product_id
>Bad value 59 found in versions.product_id
>
>XXX tfu: Delete records with product_id=59
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to products.id... from group_control_map.product_id
>Bad value 59 found in group_control_map.product_id
>
>XXX tfu: Delete records with product_id=59
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to products.id... from flaginclusions.product_id
>Bad value 59 found in flaginclusions.product_id
>
>XXX tfu: Delete records with product_id=59
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to products.id... from flagexclusions.product_id
>Checking references to bug_severity.value... from bugs.bug_severity
>Checking references to resolution.value... from bugs.resolution
>Bad value  found in bugs.resolution
>
>XXX tfu: change '' to default value NULL
>XXX dkl: Agreed. Please make sure that the bugs.bug_status != 'CLOSED'.
>XXX dkl: If bug_status == 'CLOSED' then change resolution to 'CURRENTRELEASE'.
>
>Checking references to series_categories.id... from category_group_map.category_id
>Checking references to series_categories.id... from series.category
>Checking references to series_categories.id... from series.subcategory
>Checking references to components.id... from bugs.component_id
>Checking references to components.id... from component_cc.component_id
>Checking references to components.id... from flagexclusions.component_id
>Checking references to components.id... from flaginclusions.component_id
>Bad value 16465 found in flaginclusions.component_id
>
>XXX tfu: delete these records with invalid component_id
>XXX dkl: Agreed.
>
>Checking references to bugs.bug_id... from bugs_activity.bug_id
>Bad value 26178 found in bugs_activity.bug_id
>Bad value 36326 found in bugs_activity.bug_id
>Bad value 43632 found in bugs_activity.bug_id
>
>XXX tfu: delete these records with invalid bug_id
>XXX dkl: Agreed
>
>Checking references to bugs.bug_id... from bug_group_map.bug_id
>Bad value 105087 found in bug_group_map.bug_id
>Bad value 105088 found in bug_group_map.bug_id
>Bad value 105089 found in bug_group_map.bug_id
>Bad value 105090 found in bug_group_map.bug_id
>Bad value 105091 found in bug_group_map.bug_id
>Bad value 105092 found in bug_group_map.bug_id
>Bad value 105093 found in bug_group_map.bug_id
>Bad value 105094 found in bug_group_map.bug_id
>Bad value 105095 found in bug_group_map.bug_id
>Bad value 105096 found in bug_group_map.bug_id
>Bad value 105097 found in bug_group_map.bug_id
>Bad value 105098 found in bug_group_map.bug_id
>Bad value 105099 found in bug_group_map.bug_id
>Bad value 105100 found in bug_group_map.bug_id
>Bad value 105101 found in bug_group_map.bug_id
>Bad value 105102 found in bug_group_map.bug_id
>Bad value 105103 found in bug_group_map.bug_id
>Bad value 105104 found in bug_group_map.bug_id
>Bad value 105105 found in bug_group_map.bug_id
>Bad value 105106 found in bug_group_map.bug_id
>Bad value 105107 found in bug_group_map.bug_id
>Bad value 105108 found in bug_group_map.bug_id
>Bad value 105109 found in bug_group_map.bug_id
>Bad value 105110 found in bug_group_map.bug_id
>Bad value 105111 found in bug_group_map.bug_id
>Bad value 105112 found in bug_group_map.bug_id
>Bad value 105113 found in bug_group_map.bug_id
>Bad value 105114 found in bug_group_map.bug_id
>Bad value 105115 found in bug_group_map.bug_id
>Bad value 105116 found in bug_group_map.bug_id
>Bad value 105117 found in bug_group_map.bug_id
>Bad value 105118 found in bug_group_map.bug_id
>Bad value 105119 found in bug_group_map.bug_id
>Bad value 105120 found in bug_group_map.bug_id
>Bad value 105121 found in bug_group_map.bug_id
>Bad value 105122 found in bug_group_map.bug_id
>Bad value 105123 found in bug_group_map.bug_id
>Bad value 105124 found in bug_group_map.bug_id
>Bad value 105125 found in bug_group_map.bug_id
>Bad value 105126 found in bug_group_map.bug_id
>Bad value 105127 found in bug_group_map.bug_id
>Bad value 105128 found in bug_group_map.bug_id
>Bad value 105129 found in bug_group_map.bug_id
>Bad value 105130 found in bug_group_map.bug_id
>Bad value 105131 found in bug_group_map.bug_id
>Bad value 105132 found in bug_group_map.bug_id
>Bad value 105133 found in bug_group_map.bug_id
>Bad value 105134 found in bug_group_map.bug_id
>Bad value 105135 found in bug_group_map.bug_id
>Bad value 105136 found in bug_group_map.bug_id
>Bad value 105137 found in bug_group_map.bug_id
>Bad value 105138 found in bug_group_map.bug_id
>Bad value 105139 found in bug_group_map.bug_id
>Bad value 105140 found in bug_group_map.bug_id
>Bad value 105141 found in bug_group_map.bug_id
>Bad value 105142 found in bug_group_map.bug_id
>Bad value 105143 found in bug_group_map.bug_id
>Bad value 105144 found in bug_group_map.bug_id
>Bad value 105145 found in bug_group_map.bug_id
>Bad value 105146 found in bug_group_map.bug_id
>Bad value 105147 found in bug_group_map.bug_id
>Bad value 105148 found in bug_group_map.bug_id
>Bad value 105149 found in bug_group_map.bug_id
>Bad value 105150 found in bug_group_map.bug_id
>Bad value 105151 found in bug_group_map.bug_id
>Bad value 105152 found in bug_group_map.bug_id
>Bad value 105153 found in bug_group_map.bug_id
>Bad value 105154 found in bug_group_map.bug_id
>Bad value 105155 found in bug_group_map.bug_id
>Bad value 105156 found in bug_group_map.bug_id
>Bad value 105157 found in bug_group_map.bug_id
>Bad value 105158 found in bug_group_map.bug_id
>Bad value 105159 found in bug_group_map.bug_id
>Bad value 105160 found in bug_group_map.bug_id
>Bad value 105161 found in bug_group_map.bug_id
>Bad value 105162 found in bug_group_map.bug_id
>Bad value 105163 found in bug_group_map.bug_id
>Bad value 105164 found in bug_group_map.bug_id
>Bad value 105165 found in bug_group_map.bug_id
>Bad value 105166 found in bug_group_map.bug_id
>Bad value 105167 found in bug_group_map.bug_id
>Bad value 105168 found in bug_group_map.bug_id
>Bad value 105169 found in bug_group_map.bug_id
>Bad value 105170 found in bug_group_map.bug_id
>Bad value 105171 found in bug_group_map.bug_id
>Bad value 105172 found in bug_group_map.bug_id
>Bad value 105173 found in bug_group_map.bug_id
>Bad value 105174 found in bug_group_map.bug_id
>Bad value 105175 found in bug_group_map.bug_id
>Bad value 105176 found in bug_group_map.bug_id
>Bad value 105177 found in bug_group_map.bug_id
>Bad value 105178 found in bug_group_map.bug_id
>Bad value 105179 found in bug_group_map.bug_id
>Bad value 105180 found in bug_group_map.bug_id
>Bad value 105181 found in bug_group_map.bug_id
>Bad value 105182 found in bug_group_map.bug_id
>Bad value 105183 found in bug_group_map.bug_id
>Bad value 105184 found in bug_group_map.bug_id
>Bad value 105185 found in bug_group_map.bug_id
>Bad value 105186 found in bug_group_map.bug_id
>Bad value 105187 found in bug_group_map.bug_id
>Bad value 105188 found in bug_group_map.bug_id
>Bad value 105189 found in bug_group_map.bug_id
>Bad value 105190 found in bug_group_map.bug_id
>Bad value 105191 found in bug_group_map.bug_id
>Bad value 105192 found in bug_group_map.bug_id
>Bad value 105193 found in bug_group_map.bug_id
>Bad value 105194 found in bug_group_map.bug_id
>Bad value 105195 found in bug_group_map.bug_id
>Bad value 105196 found in bug_group_map.bug_id
>Bad value 105197 found in bug_group_map.bug_id
>Bad value 105198 found in bug_group_map.bug_id
>Bad value 105199 found in bug_group_map.bug_id
>Bad value 105200 found in bug_group_map.bug_id
>Bad value 105201 found in bug_group_map.bug_id
>Bad value 105202 found in bug_group_map.bug_id
>Bad value 105203 found in bug_group_map.bug_id
>Bad value 105204 found in bug_group_map.bug_id
>Bad value 105205 found in bug_group_map.bug_id
>Bad value 105206 found in bug_group_map.bug_id
>Bad value 105207 found in bug_group_map.bug_id
>Bad value 105208 found in bug_group_map.bug_id
>Bad value 105209 found in bug_group_map.bug_id
>Bad value 105210 found in bug_group_map.bug_id
>Bad value 105211 found in bug_group_map.bug_id
>Bad value 105212 found in bug_group_map.bug_id
>Bad value 105213 found in bug_group_map.bug_id
>Bad value 105214 found in bug_group_map.bug_id
>Bad value 105215 found in bug_group_map.bug_id
>Bad value 105216 found in bug_group_map.bug_id
>Bad value 105217 found in bug_group_map.bug_id
>Bad value 105218 found in bug_group_map.bug_id
>Bad value 105219 found in bug_group_map.bug_id
>Bad value 105220 found in bug_group_map.bug_id
>Bad value 105221 found in bug_group_map.bug_id
>Bad value 105222 found in bug_group_map.bug_id
>Bad value 105223 found in bug_group_map.bug_id
>Bad value 105224 found in bug_group_map.bug_id
>Bad value 105225 found in bug_group_map.bug_id
>Bad value 105226 found in bug_group_map.bug_id
>Bad value 105227 found in bug_group_map.bug_id
>Bad value 105228 found in bug_group_map.bug_id
>Bad value 105229 found in bug_group_map.bug_id
>Bad value 105230 found in bug_group_map.bug_id
>Bad value 105231 found in bug_group_map.bug_id
>Bad value 105232 found in bug_group_map.bug_id
>Bad value 105233 found in bug_group_map.bug_id
>Bad value 105234 found in bug_group_map.bug_id
>Bad value 105236 found in bug_group_map.bug_id
>Bad value 105237 found in bug_group_map.bug_id
>Bad value 105238 found in bug_group_map.bug_id
>Bad value 105239 found in bug_group_map.bug_id
>Bad value 105240 found in bug_group_map.bug_id
>Bad value 105241 found in bug_group_map.bug_id
>Bad value 105242 found in bug_group_map.bug_id
>Bad value 105243 found in bug_group_map.bug_id
>Bad value 105244 found in bug_group_map.bug_id
>Bad value 105245 found in bug_group_map.bug_id
>Bad value 105246 found in bug_group_map.bug_id
>Bad value 105247 found in bug_group_map.bug_id
>Bad value 105248 found in bug_group_map.bug_id
>Bad value 105249 found in bug_group_map.bug_id
>Bad value 105250 found in bug_group_map.bug_id
>Bad value 105251 found in bug_group_map.bug_id
>Bad value 105252 found in bug_group_map.bug_id
>Bad value 105253 found in bug_group_map.bug_id
>Bad value 105254 found in bug_group_map.bug_id
>Bad value 105255 found in bug_group_map.bug_id
>Bad value 105256 found in bug_group_map.bug_id
>Bad value 105257 found in bug_group_map.bug_id
>Bad value 105258 found in bug_group_map.bug_id
>Bad value 105259 found in bug_group_map.bug_id
>Bad value 105260 found in bug_group_map.bug_id
>Bad value 105261 found in bug_group_map.bug_id
>Bad value 105262 found in bug_group_map.bug_id
>Bad value 105263 found in bug_group_map.bug_id
>Bad value 105264 found in bug_group_map.bug_id
>Bad value 105265 found in bug_group_map.bug_id
>Bad value 105266 found in bug_group_map.bug_id
>Bad value 105267 found in bug_group_map.bug_id
>Bad value 105268 found in bug_group_map.bug_id
>Bad value 105269 found in bug_group_map.bug_id
>Bad value 105270 found in bug_group_map.bug_id
>Bad value 105271 found in bug_group_map.bug_id
>Bad value 105272 found in bug_group_map.bug_id
>Bad value 105273 found in bug_group_map.bug_id
>Bad value 105274 found in bug_group_map.bug_id
>Bad value 105275 found in bug_group_map.bug_id
>Bad value 105276 found in bug_group_map.bug_id
>Bad value 105277 found in bug_group_map.bug_id
>Bad value 105278 found in bug_group_map.bug_id
>Bad value 105279 found in bug_group_map.bug_id
>Bad value 105280 found in bug_group_map.bug_id
>Bad value 105281 found in bug_group_map.bug_id
>Bad value 105282 found in bug_group_map.bug_id
>Bad value 105283 found in bug_group_map.bug_id
>Bad value 105284 found in bug_group_map.bug_id
>Bad value 105285 found in bug_group_map.bug_id
>Bad value 105286 found in bug_group_map.bug_id
>Bad value 105287 found in bug_group_map.bug_id
>Bad value 105288 found in bug_group_map.bug_id
>Bad value 105289 found in bug_group_map.bug_id
>Bad value 105290 found in bug_group_map.bug_id
>Bad value 105291 found in bug_group_map.bug_id
>Bad value 105292 found in bug_group_map.bug_id
>Bad value 105293 found in bug_group_map.bug_id
>Bad value 105294 found in bug_group_map.bug_id
>Bad value 105295 found in bug_group_map.bug_id
>Bad value 105296 found in bug_group_map.bug_id
>Bad value 105297 found in bug_group_map.bug_id
>Bad value 105298 found in bug_group_map.bug_id
>Bad value 105299 found in bug_group_map.bug_id
>Bad value 105300 found in bug_group_map.bug_id
>Bad value 105301 found in bug_group_map.bug_id
>Bad value 105302 found in bug_group_map.bug_id
>Bad value 105303 found in bug_group_map.bug_id
>Bad value 105304 found in bug_group_map.bug_id
>Bad value 105305 found in bug_group_map.bug_id
>Bad value 105306 found in bug_group_map.bug_id
>Bad value 105307 found in bug_group_map.bug_id
>Bad value 105308 found in bug_group_map.bug_id
>Bad value 105309 found in bug_group_map.bug_id
>Bad value 105310 found in bug_group_map.bug_id
>Bad value 105311 found in bug_group_map.bug_id
>Bad value 105312 found in bug_group_map.bug_id
>Bad value 105313 found in bug_group_map.bug_id
>Bad value 105314 found in bug_group_map.bug_id
>Bad value 105315 found in bug_group_map.bug_id
>Bad value 105316 found in bug_group_map.bug_id
>Bad value 105317 found in bug_group_map.bug_id
>Bad value 105318 found in bug_group_map.bug_id
>Bad value 105319 found in bug_group_map.bug_id
>Bad value 105320 found in bug_group_map.bug_id
>Bad value 105321 found in bug_group_map.bug_id
>Bad value 105322 found in bug_group_map.bug_id
>Bad value 105323 found in bug_group_map.bug_id
>Bad value 105324 found in bug_group_map.bug_id
>Bad value 105325 found in bug_group_map.bug_id
>
>XXX tfu: delete these records with invalid bugs.bug_id
>XXX dkl: Agreed.
>
>Checking references to bugs.bug_id... from bz_it_map.bz_id
>Checking references to bugs.bug_id... from attachments.bug_id
>Checking references to bugs.bug_id... from cc.bug_id
>Checking references to bugs.bug_id... from ext_bz_bug_map.bug_id
>Checking references to bugs.bug_id... from flags.bug_id
>Checking references to bugs.bug_id... from longdescs.bug_id
>Bad value 26178 found in longdescs.bug_id
>Bad value 36326 found in longdescs.bug_id
>Bad value 43632 found in longdescs.bug_id
>Bad value 105049 found in longdescs.bug_id
>Bad value 105052 found in longdescs.bug_id
>Bad value 105053 found in longdescs.bug_id
>Bad value 105054 found in longdescs.bug_id
>Bad value 105055 found in longdescs.bug_id
>Bad value 105056 found in longdescs.bug_id
>Bad value 105057 found in longdescs.bug_id
>Bad value 105058 found in longdescs.bug_id
>Bad value 105059 found in longdescs.bug_id
>Bad value 105060 found in longdescs.bug_id
>Bad value 105061 found in longdescs.bug_id
>Bad value 105062 found in longdescs.bug_id
>Bad value 105063 found in longdescs.bug_id
>Bad value 105064 found in longdescs.bug_id
>Bad value 105065 found in longdescs.bug_id
>Bad value 105066 found in longdescs.bug_id
>Bad value 105067 found in longdescs.bug_id
>Bad value 105068 found in longdescs.bug_id
>Bad value 105069 found in longdescs.bug_id
>Bad value 105070 found in longdescs.bug_id
>Bad value 105071 found in longdescs.bug_id
>Bad value 105072 found in longdescs.bug_id
>Bad value 105073 found in longdescs.bug_id
>Bad value 105074 found in longdescs.bug_id
>Bad value 105075 found in longdescs.bug_id
>Bad value 105076 found in longdescs.bug_id
>Bad value 105077 found in longdescs.bug_id
>Bad value 105078 found in longdescs.bug_id
>Bad value 105079 found in longdescs.bug_id
>Bad value 105080 found in longdescs.bug_id
>Bad value 105081 found in longdescs.bug_id
>Bad value 105082 found in longdescs.bug_id
>Bad value 105083 found in longdescs.bug_id
>Bad value 105084 found in longdescs.bug_id
>Bad value 105085 found in longdescs.bug_id
>Bad value 105086 found in longdescs.bug_id
>Bad value 105087 found in longdescs.bug_id
>Bad value 105088 found in longdescs.bug_id
>Bad value 105089 found in longdescs.bug_id
>Bad value 105090 found in longdescs.bug_id
>Bad value 105091 found in longdescs.bug_id
>Bad value 105092 found in longdescs.bug_id
>Bad value 105093 found in longdescs.bug_id
>Bad value 105094 found in longdescs.bug_id
>Bad value 105095 found in longdescs.bug_id
>Bad value 105096 found in longdescs.bug_id
>Bad value 105097 found in longdescs.bug_id
>Bad value 105098 found in longdescs.bug_id
>Bad value 105099 found in longdescs.bug_id
>Bad value 105100 found in longdescs.bug_id
>Bad value 105101 found in longdescs.bug_id
>Bad value 105102 found in longdescs.bug_id
>Bad value 105103 found in longdescs.bug_id
>Bad value 105104 found in longdescs.bug_id
>Bad value 105105 found in longdescs.bug_id
>Bad value 105106 found in longdescs.bug_id
>Bad value 105107 found in longdescs.bug_id
>Bad value 105108 found in longdescs.bug_id
>Bad value 105109 found in longdescs.bug_id
>Bad value 105110 found in longdescs.bug_id
>Bad value 105111 found in longdescs.bug_id
>Bad value 105112 found in longdescs.bug_id
>Bad value 105113 found in longdescs.bug_id
>Bad value 105114 found in longdescs.bug_id
>Bad value 105115 found in longdescs.bug_id
>Bad value 105116 found in longdescs.bug_id
>Bad value 105117 found in longdescs.bug_id
>Bad value 105118 found in longdescs.bug_id
>Bad value 105119 found in longdescs.bug_id
>Bad value 105120 found in longdescs.bug_id
>Bad value 105121 found in longdescs.bug_id
>Bad value 105122 found in longdescs.bug_id
>Bad value 105123 found in longdescs.bug_id
>Bad value 105124 found in longdescs.bug_id
>Bad value 105125 found in longdescs.bug_id
>Bad value 105126 found in longdescs.bug_id
>Bad value 105127 found in longdescs.bug_id
>Bad value 105128 found in longdescs.bug_id
>Bad value 105129 found in longdescs.bug_id
>Bad value 105130 found in longdescs.bug_id
>Bad value 105131 found in longdescs.bug_id
>Bad value 105132 found in longdescs.bug_id
>Bad value 105133 found in longdescs.bug_id
>Bad value 105134 found in longdescs.bug_id
>Bad value 105135 found in longdescs.bug_id
>Bad value 105136 found in longdescs.bug_id
>Bad value 105137 found in longdescs.bug_id
>Bad value 105138 found in longdescs.bug_id
>Bad value 105139 found in longdescs.bug_id
>Bad value 105140 found in longdescs.bug_id
>Bad value 105141 found in longdescs.bug_id
>Bad value 105142 found in longdescs.bug_id
>Bad value 105143 found in longdescs.bug_id
>Bad value 105144 found in longdescs.bug_id
>Bad value 105145 found in longdescs.bug_id
>Bad value 105146 found in longdescs.bug_id
>Bad value 105147 found in longdescs.bug_id
>Bad value 105148 found in longdescs.bug_id
>Bad value 105149 found in longdescs.bug_id
>Bad value 105150 found in longdescs.bug_id
>Bad value 105151 found in longdescs.bug_id
>Bad value 105152 found in longdescs.bug_id
>Bad value 105153 found in longdescs.bug_id
>Bad value 105154 found in longdescs.bug_id
>Bad value 105155 found in longdescs.bug_id
>Bad value 105156 found in longdescs.bug_id
>Bad value 105157 found in longdescs.bug_id
>Bad value 105158 found in longdescs.bug_id
>Bad value 105159 found in longdescs.bug_id
>Bad value 105160 found in longdescs.bug_id
>Bad value 105161 found in longdescs.bug_id
>Bad value 105162 found in longdescs.bug_id
>Bad value 105163 found in longdescs.bug_id
>Bad value 105164 found in longdescs.bug_id
>Bad value 105165 found in longdescs.bug_id
>Bad value 105166 found in longdescs.bug_id
>Bad value 105167 found in longdescs.bug_id
>Bad value 105168 found in longdescs.bug_id
>Bad value 105169 found in longdescs.bug_id
>Bad value 105170 found in longdescs.bug_id
>Bad value 105171 found in longdescs.bug_id
>Bad value 105172 found in longdescs.bug_id
>Bad value 105173 found in longdescs.bug_id
>Bad value 105174 found in longdescs.bug_id
>Bad value 105175 found in longdescs.bug_id
>Bad value 105176 found in longdescs.bug_id
>Bad value 105177 found in longdescs.bug_id
>Bad value 105178 found in longdescs.bug_id
>Bad value 105179 found in longdescs.bug_id
>Bad value 105180 found in longdescs.bug_id
>Bad value 105181 found in longdescs.bug_id
>Bad value 105182 found in longdescs.bug_id
>Bad value 105183 found in longdescs.bug_id
>Bad value 105184 found in longdescs.bug_id
>Bad value 105185 found in longdescs.bug_id
>Bad value 105186 found in longdescs.bug_id
>Bad value 105187 found in longdescs.bug_id
>Bad value 105188 found in longdescs.bug_id
>Bad value 105189 found in longdescs.bug_id
>Bad value 105190 found in longdescs.bug_id
>Bad value 105191 found in longdescs.bug_id
>Bad value 105192 found in longdescs.bug_id
>Bad value 105193 found in longdescs.bug_id
>Bad value 105194 found in longdescs.bug_id
>Bad value 105195 found in longdescs.bug_id
>Bad value 105196 found in longdescs.bug_id
>Bad value 105197 found in longdescs.bug_id
>Bad value 105198 found in longdescs.bug_id
>Bad value 105199 found in longdescs.bug_id
>Bad value 105200 found in longdescs.bug_id
>Bad value 105201 found in longdescs.bug_id
>Bad value 105202 found in longdescs.bug_id
>Bad value 105203 found in longdescs.bug_id
>Bad value 105204 found in longdescs.bug_id
>Bad value 105205 found in longdescs.bug_id
>Bad value 105206 found in longdescs.bug_id
>Bad value 105207 found in longdescs.bug_id
>Bad value 105208 found in longdescs.bug_id
>Bad value 105209 found in longdescs.bug_id
>Bad value 105210 found in longdescs.bug_id
>Bad value 105211 found in longdescs.bug_id
>Bad value 105212 found in longdescs.bug_id
>Bad value 105213 found in longdescs.bug_id
>Bad value 105214 found in longdescs.bug_id
>Bad value 105215 found in longdescs.bug_id
>Bad value 105216 found in longdescs.bug_id
>Bad value 105217 found in longdescs.bug_id
>Bad value 105218 found in longdescs.bug_id
>Bad value 105219 found in longdescs.bug_id
>Bad value 105220 found in longdescs.bug_id
>Bad value 105221 found in longdescs.bug_id
>Bad value 105222 found in longdescs.bug_id
>Bad value 105223 found in longdescs.bug_id
>Bad value 105224 found in longdescs.bug_id
>Bad value 105225 found in longdescs.bug_id
>Bad value 105226 found in longdescs.bug_id
>Bad value 105227 found in longdescs.bug_id
>Bad value 105228 found in longdescs.bug_id
>Bad value 105229 found in longdescs.bug_id
>Bad value 105230 found in longdescs.bug_id
>Bad value 105231 found in longdescs.bug_id
>Bad value 105232 found in longdescs.bug_id
>Bad value 105233 found in longdescs.bug_id
>Bad value 105234 found in longdescs.bug_id
>Bad value 105236 found in longdescs.bug_id
>Bad value 105237 found in longdescs.bug_id
>Bad value 105238 found in longdescs.bug_id
>Bad value 105239 found in longdescs.bug_id
>Bad value 105240 found in longdescs.bug_id
>Bad value 105241 found in longdescs.bug_id
>Bad value 105242 found in longdescs.bug_id
>Bad value 105243 found in longdescs.bug_id
>Bad value 105244 found in longdescs.bug_id
>Bad value 105245 found in longdescs.bug_id
>Bad value 105246 found in longdescs.bug_id
>Bad value 105247 found in longdescs.bug_id
>Bad value 105248 found in longdescs.bug_id
>Bad value 105249 found in longdescs.bug_id
>Bad value 105250 found in longdescs.bug_id
>Bad value 105251 found in longdescs.bug_id
>Bad value 105252 found in longdescs.bug_id
>Bad value 105253 found in longdescs.bug_id
>Bad value 105254 found in longdescs.bug_id
>Bad value 105255 found in longdescs.bug_id
>Bad value 105256 found in longdescs.bug_id
>Bad value 105257 found in longdescs.bug_id
>Bad value 105258 found in longdescs.bug_id
>Bad value 105259 found in longdescs.bug_id
>Bad value 105260 found in longdescs.bug_id
>Bad value 105261 found in longdescs.bug_id
>Bad value 105262 found in longdescs.bug_id
>Bad value 105263 found in longdescs.bug_id
>Bad value 105264 found in longdescs.bug_id
>Bad value 105265 found in longdescs.bug_id
>Bad value 105266 found in longdescs.bug_id
>Bad value 105267 found in longdescs.bug_id
>Bad value 105268 found in longdescs.bug_id
>Bad value 105269 found in longdescs.bug_id
>Bad value 105270 found in longdescs.bug_id
>Bad value 105271 found in longdescs.bug_id
>Bad value 105272 found in longdescs.bug_id
>Bad value 105273 found in longdescs.bug_id
>Bad value 105274 found in longdescs.bug_id
>Bad value 105275 found in longdescs.bug_id
>Bad value 105276 found in longdescs.bug_id
>Bad value 105277 found in longdescs.bug_id
>Bad value 105278 found in longdescs.bug_id
>Bad value 105279 found in longdescs.bug_id
>Bad value 105280 found in longdescs.bug_id
>Bad value 105281 found in longdescs.bug_id
>Bad value 105282 found in longdescs.bug_id
>Bad value 105283 found in longdescs.bug_id
>Bad value 105284 found in longdescs.bug_id
>Bad value 105285 found in longdescs.bug_id
>Bad value 105286 found in longdescs.bug_id
>Bad value 105287 found in longdescs.bug_id
>Bad value 105288 found in longdescs.bug_id
>Bad value 105289 found in longdescs.bug_id
>Bad value 105290 found in longdescs.bug_id
>Bad value 105291 found in longdescs.bug_id
>Bad value 105292 found in longdescs.bug_id
>Bad value 105293 found in longdescs.bug_id
>Bad value 105294 found in longdescs.bug_id
>Bad value 105295 found in longdescs.bug_id
>Bad value 105296 found in longdescs.bug_id
>Bad value 105297 found in longdescs.bug_id
>Bad value 105298 found in longdescs.bug_id
>Bad value 105299 found in longdescs.bug_id
>Bad value 105300 found in longdescs.bug_id
>Bad value 105301 found in longdescs.bug_id
>Bad value 105302 found in longdescs.bug_id
>Bad value 105303 found in longdescs.bug_id
>Bad value 105304 found in longdescs.bug_id
>Bad value 105305 found in longdescs.bug_id
>Bad value 105306 found in longdescs.bug_id
>Bad value 105307 found in longdescs.bug_id
>Bad value 105308 found in longdescs.bug_id
>Bad value 105309 found in longdescs.bug_id
>Bad value 105310 found in longdescs.bug_id
>Bad value 105311 found in longdescs.bug_id
>Bad value 105312 found in longdescs.bug_id
>Bad value 105313 found in longdescs.bug_id
>Bad value 105314 found in longdescs.bug_id
>Bad value 105315 found in longdescs.bug_id
>Bad value 105316 found in longdescs.bug_id
>Bad value 105317 found in longdescs.bug_id
>Bad value 105318 found in longdescs.bug_id
>Bad value 105319 found in longdescs.bug_id
>Bad value 105320 found in longdescs.bug_id
>Bad value 105321 found in longdescs.bug_id
>Bad value 105322 found in longdescs.bug_id
>Bad value 105323 found in longdescs.bug_id
>Bad value 105324 found in longdescs.bug_id
>Bad value 105325 found in longdescs.bug_id
>Bad value 136839 found in longdescs.bug_id
>
>XXX tfu: delete these records with invalid bugs.bug_id
>XXX dkl: Agreed
>
>Checking references to bugs.bug_id... from dependencies.blocked
>Checking references to bugs.bug_id... from dependencies.dependson
>Checking references to bugs.bug_id... from votes.bug_id
>Checking references to bugs.bug_id... from keywords.bug_id
>Checking references to bugs.bug_id... from duplicates.dupe_of
>Checking references to bugs.bug_id... from duplicates.dupe
>Checking references to priority.value... from bugs.priority
>Checking references to external_bugzilla.id... from ext_bz_bug_map.ext_bz_id
>Checking references to rep_platform.value... from bugs.rep_platform
>Bad value PC found in bugs.rep_platform
>
>XXX tfu: change bugs.rep_platform's value to i386
>XXX dkl: Agreed.
>
>Checking references to attachments.attach_id... from flags.attach_id
>Checking references to attachments.attach_id... from bugs_activity.attach_id
>Bad value 93000 found in bugs_activity.attach_id
>Bad value 94077 found in bugs_activity.attach_id
>Bad value 96520 found in bugs_activity.attach_id
>Bad value 96899 found in bugs_activity.attach_id
>Bad value 123296 found in bugs_activity.attach_id
>Bad value 154253 found in bugs_activity.attach_id
>
>XXX tfu: delete these records with invalid bugs_activity.attach_id value
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to flagtypes.id... from flags.type_id
>Checking references to flagtypes.id... from flagexclusions.type_id
>Checking references to flagtypes.id... from flaginclusions.type_id
>Checking references to op_sys.value... from bugs.op_sys
>Checking references to groups.id... from bug_group_map.group_id
>Checking references to groups.id... from category_group_map.group_id
>Checking references to groups.id... from flagtypes.grant_group_id
>Checking references to groups.id... from flagtypes.request_group_id
>Checking references to groups.id... from flagtypes.view_group_id
>Checking references to groups.id... from group_group_map.grantor_id
>Checking references to groups.id... from group_group_map.member_id
>Checking references to groups.id... from group_control_map.group_id
>Checking references to groups.id... from user_group_map.group_id
>Bad value 115 found in user_group_map.group_id
>
>XXX tfu: delete these records with invalid user_group_map.group_id value.
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to groups.id... from whine_schedules.mailto
>Checking references to fielddefs.fieldid... from bugs_activity.fieldid
>Bad value 15 found in bugs_activity.fieldid
>
>XXX tfu: After checking some records at random, it looks like the "15" present the "assigned_to" field.  So change 15 to 41 (assigned_to)
>XXX dkl: Agreed. SQL in redhat/db_fixup.sql
>
>Checking references to fielddefs.fieldid... from profiles_activity.fieldid
>Checking references to bug_status.value... from bugs.bug_status
>Checking references to components.product_id / components.id... from bugs.product_id / bugs.component_id
>Checking references to milestones.product_id / milestones.value... from bugs.product_id / bugs.target_milestone
>Checking references to milestones.product_id / milestones.value... from products.id / products.defaultmilestone
>Checking references to versions.product_id / versions.value... from bugs.product_id / bugs.version
>Bad values 17, 1.0 found in bugs.product_id / bugs.version
>
>XXX tfu: change it to 17, 6.0.  product_id 17 is product "Red Hat Linux" and "6.0" is the first version of it.
>XXX dkl: Agreed. Make sure to add entries into bugs_activity for the change.
>
>Bad values 39,  found in bugs.product_id / bugs.version
>
>XXX tfu: change to 39, 'None'.  product_id 39 is "Feature Tracker" and it includes a valid version "None".
>XXX dkl: Agreed. Make sure to add entries into bugs_activity for the change.
>

Actions: View

Attachments on bug 431086: 302838 | 303334 | 303599 | 304295 | 305333 | 305640 | 313167 | 324678