250663 - sanity check reports some insanity :-)

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, defect)

Description

[Asa Dotzler [:asa]]

Bugzilla Sanity Check
	  	
OK, now running sanity checks.

Checking for invalid enumeration values

Bug(s) found with invalid op_sys value: 6553, 16125, 18914, 19125, 19248, 19449,
21160, 21596, 24160, 24273, 24320, 24326, 24387, 24994, 25042, 25175, 25179,
25192, 25197, 25200, 25344, 25366, 25385, 25445, 25484, 25515, 25526, 25582,
25614, 25711, 25718, 25720, 25722, 25723, 25724, 25744, 25745, 25746, 25748,
25754, 25780, 25792, 25793, 25794, 25795, 25796, 25812, 25814, 25896, 26114,
26141, 26144, 26150, 26318, 26332, 26335, 26338, 26589, 26619, 26632, 26748,
26869, 26902, 26913, 26914, 26946, 26997, 27108, 27139, 27157, 27247, 27257,
27276, 27310, 27328, 27426, 27427, 27677, 27773, 27778, 27836, 27901, 27904,
27910, 27935, 28067, 28148, 28466, 28689, 28739, 28889, 28996, 29022, 29044,
29174, 29206, 29257, 29266, 29290, 29349, 29569, 29657, 29665, 29717, 29729,
29774, 29830, 29835, 29874, 29889, 29908, 29920, 30023, 30038, 30045, 30049,
30055, 30060, 30061, 30072, 30074, 30083, 30084, 30086, 30089, 30194, 30199,
30200, 30251, 30300, 30343, 30412, 30445, 30704, 30719, 30729, 30912, 30948,
30962, 31054, 31071, 31103, 31104, 31131, 31202, 31267, 31271, 31272, 31274,
31340, 31395, 31400, 31408, 31851, 32430, 32434, 32529, 32592, 32622, 32682,
32764, 32769, 32783, 32798, 32883, 32896, 32916, 33010, 33011, 33138, 33202,
33205, 33258, 33261, 33268, 33411, 33435, 33501, 33531, 33547, 33587, 33598,
33656, 33659, 33674, 33780, 33791, 33792, 33814, 33816, 33994, 33997, 34001,
34002, 34005, 34112, 34115, 34138, 34157, 34195, 34275, 34410, 34474, 34497,
34513, 34541, 34631, 34744, 34770, 34875, 34937, 34948, 35018, 35023, 35119,
35201, 35202, 35316, 35383, 35394, 35396, 35406, 35410, 35474, 35501, 35520,
35565, 35659, 35901, 35940, 36027, 36033, 36037, 36038, 36042, 36046, 36089,
36134, 36251, 36259, 36443, 36470, 36475, 36496, 36500, 36556, 36561, 36568,
36569, 36571, 36588, 36618, 36631, 36718, 36726, 36758, 36766, 36784, 36931,
36959, 36983, 37018, 37325, 37327, 37329, 37572, 37580, 37655, 37696, 37722,
37735, 37740, 37769, 37785, 37802, 37804, 37807, 37813, 37818, 37841, 37848,
37851, 37852, 37857, 37859, 37860, 37957, 37970, 37971, 38053, 38065, 38086,
38182, 38245, 38499, 38510, 38555, 38581, 38676, 38689, 38717, 38734, 38948,
38962, 38989, 39347, 39352, 39357, 39440, 39448, 39450, 39461, 39462, 39485,
39503, 39518, 39676, 39677, 39678, 39707, 39708, 39758, 39797, 39867, 39906,
39959, 40042, 40174, 40180, 40219, 40325, 40378, 40482, 40511, 40540, 40647,
40648, 40706, 40766, 40783, 40786, 41004, 41006, 41010, 41015, 41016, 41031,
41036, 41048, 41056, 41091, 41131, 41203, 41204, 41213, 41320, 41325, 41352,
41361, 41451, 41573, 41607, 41732, 41733, 41741, 41812, 41823, 41855, 41870,
41928, 41990, 42070, 42104, 42145, 42147, 42163, 42213, 42269, 42289, 42298,
42299, 42408, 42539, 42540, 42552, 42569, 42575, 42578, 42603, 42666, 42681,
42700, 42702, 42708, 42711, 42719, 42747, 42794, 42818, 42823, 42882, 42883,
42896, 42980, 43060, 43061, 43069, 43199, 43227, 43235, 43240, 43334, 43392,
43401, 43419, 43422, 43423, 43482, 43548, 43565, 43572, 43585, 43621, 43632,
43843, 43867, 43932, 43944, 43945, 43948, 43949, 43967, 43972, 44030, 44031,
44035, 44151, 44241, 44285, 44339, 44390, 44404, 44417, 44585, 44619, 44717,
44810, 44840, 45039, 45150, 45151, 45166, 45183, 45217, 45238, 45243, 45264,
45309, 45310, 45321, 45379, 45394, 45447, 45504, 45506, 45509, 45515, 45516,
45598, 45599, 45653, 45660, 45718, 45725, 45825, 45853, 45889, 45898, 45900,
46008, 46096, 46192, 46282, 46457, 46531, 46652, 46663, 46720, 46747, 46787,
46909, 46933, 47076, 47077, 47084, 47085, 47086, 47099, 47206, 47216, 47240,
47269, 47349, 47364, 47382, 47473, 47474, 47500, 47672, 47714, 47818, 47819,
47820, 47912, 47918, 47920, 47928, 47950, 48034, 48141, 48153, 48166, 48194,
48228, 48302, 48316, 48324, 48365, 48381, 48387, 48477, 48489, 48493, 48605,
48614, 48662, 48689, 48690, 48736, 48866, 48882, 48941, 48950, 49007, 49008,
49137, 49227, 49346, 49356, 49370, 49380, 49385, 49515, 49578, 49705, 49828,
49850, 49852, 49907, 49975, 50016, 50024, 50057, 50060, 50097, 50234, 50301,
50315, 50389, 50560, 50569, 50635, 50669, 50689, 50706, 50707, 50725, 50773,
50779, 50827, 50830, 50852, 50981, 51009, 51029, 51069, 51180, 51373, 51414,
51450, 51488, 51499, 51532, 51534, 51535, 51540, 51572, 51617, 51641, 51642,
51649, 51685, 51708, 51709, 51716, 51780, 51783, 51787, 51789, 51805, 51943,
51976, 51978, 52079, 52143, 52163, 52201, 52274, 52281, 52305, 52355, 52447,
52546, 52553, 52569, 52570, 52750, 52753, 52811, 52829, 52831, 52895, 52950,
53010, 53018, 53089, 53093, 53095, 53101, 53105, 53107, 53109, 53120, 53121,
53174, 53183, 53193, 53202, 53264, 53351, 53385, 53407, 53412, 53541, 53553,
53643, 53739, 53766, 53812, 53834, 53844, 53848, 53852, 53892, 53898, 53914,
53987, 54021, 54069, 54102, 54179, 54182, 54400, 54440, 54445, 54572, 54968,
55087, 55102, 55125, 55127, 55134, 55183, 55287, 55432, 55529, 55852, 55881,
55885, 55901, 55911, 55994, 56047, 56209 (as buglist)

Checking references to keyworddefs.id

... from keywords.keywordid

Checking references to fielddefs.fieldid

... from bugs_activity.fieldid

Checking references to attachments.attach_id

... from flags.attach_id

... from bugs_activity.attach_id

Checking references to flagtypes.id

... from flags.type_id

Checking references to bugs.bug_id

... from bugs_activity.bug_id

... from bug_group_map.bug_id

... from attachments.bug_id

... from cc.bug_id

... from longdescs.bug_id

... from dependencies.blocked

... from dependencies.dependson

... from votes.bug_id

... from keywords.bug_id

... from duplicates.dupe_of

... from duplicates.dupe

Checking references to groups.id

... from bug_group_map.group_id

... from group_group_map.grantor_id

... from group_group_map.member_id

... from group_control_map.group_id

... from user_group_map.group_id

Checking references to profiles.userid

... from bugs.reporter

... from bugs.assigned_to

... from bugs.qa_contact

... from attachments.submitter_id

... from bugs_activity.who

... from cc.who

... from votes.who

... from longdescs.who

... from logincookies.userid

... from namedqueries.userid

... from watch.watcher

... from watch.watched

... from tokens.userid

... from components.initialowner

... from user_group_map.user_id

... from components.initialqacontact

Checking references to products.id

... from bugs.product_id

... from components.product_id

... from milestones.product_id

... from versions.product_id

... from group_control_map.product_id

... from flaginclusions.product_id

... from flagexclusions.product_id

Checking references to components.product_id / components.id

... from bugs.product_id / bugs.component_id

Checking references to versions.product_id / versions.value

... from bugs.product_id / bugs.version

Checking references to milestones.product_id / milestones.value

... from bugs.product_id / bugs.target_milestone

... from products.id / products.defaultmilestone

Checking profile logins

Checking cached vote counts

Bad vote cache for bug 149836

Bad vote cache for bug 202978

Bad vote cache for bug 175848

Bad vote cache for bug 210215

Bad vote cache for bug 86230

Click here to rebuild the vote cache

Checking keywords table

Checking cached keywords

11 bug(s) found with incorrect keyword cache: 228542, 228545, 236115, 240643,
241157, 245903, 246236, 246264, 246329, 248172, 250180 (as buglist)

OK, now fixing keyword cache.

Keyword cache fixed.

Checking resolution/duplicates

Bug(s) found on duplicates table that are not marked duplicate: 56426, 76936,
155877, 156146, 168779, 170166, 183035 (as buglist)

Bug(s) found marked resolved duplicate and not on duplicates table: 5977, 8400,
12727, 12771, 14189, 17048, 20010, 21962, 21964, 39658, 51511, 51986, 61338,
62260, 64734, 65134, 67237, 67261, 68773, 69180, 72022, 72309, 72771, 73024,
73630, 73691, 73975, 74004, 74074, 74097, 74312, 74481, 74509, 74540, 74555,
74556, 74558, 74559, 74560, 74561, 74566, 74572, 74575, 74576, 74577, 74578,
74582, 74583, 74584, 74585, 74586, 74592, 74593, 74604, 74605, 74609, 74610,
74612, 74613, 74614, 74624, 74625, 74626, 74693, 74836, 74892, 74926, 75135,
75285, 75466, 75852, 76780, 76829, 76845, 76877, 77004, 78867, 79435, 80728,
80947, 81213, 81338, 81438, 81515, 82373, 82656, 85000, 85121, 85260, 85395,
85436, 86114, 87197, 87985, 88085, 89429, 91162, 91315, 92472, 92919, 93658,
93696, 96309, 96397, 96880, 97713, 99983, 101137, 101903, 102162, 103994,
106588, 107338, 107406, 107439, 111990, 112581, 113730, 113824, 113835, 119039,
120100, 120471, 121064, 121562, 121811, 122337, 123627, 125285, 125353, 125585,
125741, 126253, 127379, 127635, 129001, 129464, 129465, 130047, 130084, 130169,
130175, 131294, 132539, 132859, 132988, 135287, 136816, 139725, 139875, 140330,
140711, 140896, 141697, 143509, 144893, 145438, 147621, 148965, 150220, 150586,
153881, 155501, 157690, 159537, 164607, 165126, 169900, 175079, 181101, 194695,
204167, 207409, 208910, 212074, 214728, 228746, 236364, 244070, 249906, 249929,
250011, 250024, 250025 (as buglist)

Checking statuses/resolutions

Checking statuses/everconfirmed

Bugs with confirmed status but don't have everconfirmed set: 111970, 132594,
172378, 175095, 175236, 192458, 194357, 208061, 208063, 208064, 208065, 208066,
208067, 208068, 208069, 223159, 236227, 242909, 243385 (as buglist)

Checking votes/everconfirmed

Bugs that have enough votes to be confirmed but haven't been: 38544, 42669,
48579, 60309, 74241, 76124, 76589, 107582, 110580, 122093, 127390, 135910,
137185, 139084, 139818, 141514, 142722, 143916, 150345, 152605, 153346, 166100,
177498, 183754, 185291, 189819, 191267, 191435, 192131, 192751, 193131, 193140,
194169, 195632, 196816, 197182, 197351, 197785, 197976, 198418, 199055, 200121,
200293, 201720, 203281, 205011, 208524, 209666, 216694, 221889, 222780, 223879,
227484, 227881, 228582, 233213, 233525, 233851, 233985, 235331, 236073, 239014,
240142, 241812, 245862, 246027, 246229, 249649 (as buglist)

Checking dates in groups.last_changed

Checking dates in profiles.refreshed_when

Checking for bad values in group_control_map

Checking for bugs with groups violating their product's group controls

Checking for unsent mail

Bugs that have changes but no mail sent for at least half an hour: 234788,
247983 (as buglist)

Send these mails.

Sanity check completed.

Comment 1

[Dave Miller [:justdave]]

Most of this was fixed several months ago, and the little bit that wasn't I cleaned up earlier tonight.