Page MenuHomePhabricator
Files F44587

sanitize_bugzilla_db
No One
Actions

Authored By
Dzahn
Feb 21 2015, 12:50 AM
Size
24 KB
Referenced Files
None
Subscribers
None

sanitize_bugzilla_db
View Options

root@zirconium:/srv/org/wikimedia/bzsane# ./sanitizeme317.pl --dry-run --trace
DBI::db=HASH(0x2f20c60) trace level set to 0x0/1 (DBI @ 0x0/0) in DBI 1.616-ithread (pid 28941)
** dry run : no changes to the database will be made **
T <- FETCH('private_bz_transaction_count')= ( undef ) [1 items] at DB.pm line 1184
T <- begin_work= ( 1 ) [1 items] at DB.pm line 1194
T <- do('SET TRANSACTION ISOLATION LEVEL REPEATABLE READ')= ( '0E0' ) [1 items] at DB.pm line 1200
T <- STORE('private_bz_transaction_count', 1)= ( 1 ) [1 items] at DB.pm line 1204
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
T <- selectall_arrayref('SELECT id,name,classification_id,description,isactive,defaultmilestone,allows_unconfirmed,votesperuser,maxvotesperbug,votestoconfirm FROM products ORDER BY name', HASH(0x30867c8))= ( [ HASH(0x308ee30) HASH(0x308ef50) HASH(0x308f070) HASH(0x308f190) HASH(0x308f2b0) HASH(0x308f3d0) HASH(0x308f4f0) HASH(0x308f610) HASH(0x308f730) HASH(0x308f850) HASH(0x308f970) HASH(0x308fa90) HASH(0x308fbb0) HASH(0x308fcd0) HASH(0x3093638) HASH(0x3093758) HASH(0x3093878) HASH(0x3093998) HASH(0x3093ab8) HASH(0x3093bd8) HASH(0x3093cf8) HASH(0x3093e18) HASH(0x3093f38) HASH(0x3094058) HASH(0x3094178) HASH(0x3094298) HASH(0x30943b8) HASH(0x30944d8) HASH(0x30979a0) HASH(0x3097ac0) HASH(0x3097be0) HASH(0x3097d00) HASH(0x3097e20) ] ) [1 items] at Object.pm line 269
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectall_arrayref('SELECT DISTINCT bug_id FROM bug_group_map')= ( [ ] ) [1 items] at sanitizeme317.pl line 134
T <- DESTROY(DBI::st=HASH(0x308ed88))= ( undef ) [1 items] at sanitizeme317.pl line 139
Deleting 0 bugs in security groups...
Done
T <- selectcol_arrayref('SELECT comment_id FROM longdescs WHERE isprivate!=0')= ( [ ] ) [1 items] at sanitizeme317.pl line 154
Deleting 'insidergroup' comments and attachments...
T <- do('DELETE FROM longdescs WHERE isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 169
T <- do('DELETE attach_data FROM attachments JOIN attach_data ON attachments.attach_id = attach_data.id WHERE attachments.isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 170
T <- do('DELETE FROM attachments WHERE isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 171
T <- do('UPDATE bugs_fulltext SET comments = comments_noprivate')= ( 73451 ) [1 items] at sanitizeme317.pl line 172
Deleting security groups...
T <- do('DELETE user_group_map FROM groups JOIN user_group_map ON groups.id = user_group_map.group_id WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 178
T <- do('DELETE group_group_map FROM groups JOIN group_group_map ON (groups.id = group_group_map.member_id OR groups.id = group_group_map.grantor_id) WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 179
T <- do('DELETE group_control_map FROM groups JOIN group_control_map ON groups.id = group_control_map.group_id WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 180
T <- do('UPDATE flagtypes LEFT JOIN groups ON flagtypes.grant_group_id = groups.id SET grant_group_id = NULL WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 181
T <- do('UPDATE flagtypes LEFT JOIN groups ON flagtypes.request_group_id = groups.id SET request_group_id = NULL WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 182
T <- do('DELETE FROM groups WHERE isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 186
Deleting sensitive user account data...
T <- do('UPDATE profiles SET cryptpassword = 'deleted'')= ( 20014 ) [1 items] at sanitizeme317.pl line 193
T <- do('DELETE FROM profiles_activity')= ( '0E0' ) [1 items] at sanitizeme317.pl line 194
T <- do('DELETE FROM profile_search')= ( '0E0' ) [1 items] at sanitizeme317.pl line 195
T <- do('DELETE FROM namedqueries')= ( '0E0' ) [1 items] at sanitizeme317.pl line 196
T <- do('DELETE FROM tokens')= ( '0E0' ) [1 items] at sanitizeme317.pl line 197
T <- do('DELETE FROM logincookies')= ( '0E0' ) [1 items] at sanitizeme317.pl line 198
T <- do('DELETE FROM login_failure')= ( '0E0' ) [1 items] at sanitizeme317.pl line 199
T <- do('DELETE FROM audit_log')= ( '0E0' ) [1 items] at sanitizeme317.pl line 200
T <- do('DELETE FROM ts_error')= ( '0E0' ) [1 items] at sanitizeme317.pl line 202
T <- do('DELETE FROM ts_exitstatus')= ( '0E0' ) [1 items] at sanitizeme317.pl line 203
T <- do('DELETE FROM ts_funcmap')= ( '0E0' ) [1 items] at sanitizeme317.pl line 204
T <- do('DELETE FROM ts_job')= ( '0E0' ) [1 items] at sanitizeme317.pl line 205
T <- do('DELETE FROM ts_note')= ( '0E0' ) [1 items] at sanitizeme317.pl line 206
Removing attachment data to preserve disk space...
T <- do('UPDATE attach_data SET thedata = ''')= ( 16959 ) [1 items] at sanitizeme317.pl line 212
Turning off email delivery...
T <- do('UPDATE profiles SET disable_mail = 1')= ( 20014 ) [1 items] at sanitizeme317.pl line 218
T <- do('UPDATE flagtypes SET cc_list = NULL')= ( 2 ) [1 items] at sanitizeme317.pl line 222
All done!
T <> FETCH('private_bz_transaction_count')= ( 1 ) [1 items] ('private_bz_transaction_count' from cache) at DB.pm line 1184
T <- rollback= ( 1 ) [1 items] at DB.pm line 1229
T <- STORE('private_bz_transaction_count', 0)= ( 1 ) [1 items] at DB.pm line 1230
T <> FETCH('private_bz_transaction_count')= ( 0 ) [1 items] ('private_bz_transaction_count' from cache) at DB.pm line 1184
T <- disconnect= ( 1 ) [1 items] at Bugzilla.pm line 679
!T <- DESTROY(DBI::db=HASH(0x2f20b70))= ( undef ) [1 items] during global destruction
root@zirconium:/srv/org/wikimedia/bzsane# ./sanitizeme317.pl --execute --trace
DBI::db=HASH(0x25f3c60) trace level set to 0x0/1 (DBI @ 0x0/0) in DBI 1.616-ithread (pid 28998)
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
!! ERROR: 2000 CLEARED by call to fetch method
T <- selectall_arrayref('SELECT id,name,classification_id,description,isactive,defaultmilestone,allows_unconfirmed,votesperuser,maxvotesperbug,votestoconfirm FROM products ORDER BY name', HASH(0x2757ba0))= ( [ HASH(0x2758470) HASH(0x275f2d8) HASH(0x275f3f8) HASH(0x275f518) HASH(0x275f638) HASH(0x275f758) HASH(0x275f878) HASH(0x275f998) HASH(0x275fab8) HASH(0x275fbd8) HASH(0x275fcf8) HASH(0x275fe18) HASH(0x275ff38) HASH(0x2760058) HASH(0x2760178) HASH(0x2763fa0) HASH(0x27640c0) HASH(0x27641e0) HASH(0x2764300) HASH(0x2764420) HASH(0x2764540) HASH(0x2764660) HASH(0x2764780) HASH(0x27648a0) HASH(0x27649c0) HASH(0x2764ae0) HASH(0x2764c00) HASH(0x2764d20) HASH(0x2764e40) HASH(0x27682f8) HASH(0x2768418) HASH(0x2768538) HASH(0x2768658) ] ) [1 items] at Object.pm line 269
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectcol_arrayref('SELECT group_id FROM group_control_map WHERE product_id = ? AND (membercontrol = 3)', undef, ...)= ( [ ] ) [1 items] at sanitizeme317.pl line 124
T <- selectall_arrayref('SELECT DISTINCT bug_id FROM bug_group_map')= ( [ ] ) [1 items] at sanitizeme317.pl line 134
T <- DESTROY(DBI::st=HASH(0x27583c8))= ( undef ) [1 items] at sanitizeme317.pl line 139
Deleting 0 bugs in security groups...
Done
T <- selectcol_arrayref('SELECT comment_id FROM longdescs WHERE isprivate!=0')= ( [ ] ) [1 items] at sanitizeme317.pl line 154
Deleting 'insidergroup' comments and attachments...
T <- do('DELETE FROM longdescs WHERE isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 169
T <- do('DELETE attach_data FROM attachments JOIN attach_data ON attachments.attach_id = attach_data.id WHERE attachments.isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 170
T <- do('DELETE FROM attachments WHERE isprivate = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 171
T <- do('UPDATE bugs_fulltext SET comments = comments_noprivate')= ( 73451 ) [1 items] at sanitizeme317.pl line 172
Deleting security groups...
T <- do('DELETE user_group_map FROM groups JOIN user_group_map ON groups.id = user_group_map.group_id WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 178
T <- do('DELETE group_group_map FROM groups JOIN group_group_map ON (groups.id = group_group_map.member_id OR groups.id = group_group_map.grantor_id) WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 179
T <- do('DELETE group_control_map FROM groups JOIN group_control_map ON groups.id = group_control_map.group_id WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 180
T <- do('UPDATE flagtypes LEFT JOIN groups ON flagtypes.grant_group_id = groups.id SET grant_group_id = NULL WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 181
T <- do('UPDATE flagtypes LEFT JOIN groups ON flagtypes.request_group_id = groups.id SET request_group_id = NULL WHERE groups.isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 182
T <- do('DELETE FROM groups WHERE isbuggroup = 1')= ( '0E0' ) [1 items] at sanitizeme317.pl line 186
Deleting sensitive user account data...
T <- do('UPDATE profiles SET cryptpassword = 'deleted'')= ( 20014 ) [1 items] at sanitizeme317.pl line 193
T <- do('DELETE FROM profiles_activity')= ( '0E0' ) [1 items] at sanitizeme317.pl line 194
T <- do('DELETE FROM profile_search')= ( '0E0' ) [1 items] at sanitizeme317.pl line 195
T <- do('DELETE FROM namedqueries')= ( '0E0' ) [1 items] at sanitizeme317.pl line 196
T <- do('DELETE FROM tokens')= ( '0E0' ) [1 items] at sanitizeme317.pl line 197
T <- do('DELETE FROM logincookies')= ( '0E0' ) [1 items] at sanitizeme317.pl line 198
T <- do('DELETE FROM login_failure')= ( '0E0' ) [1 items] at sanitizeme317.pl line 199
T <- do('DELETE FROM audit_log')= ( '0E0' ) [1 items] at sanitizeme317.pl line 200
T <- do('DELETE FROM ts_error')= ( '0E0' ) [1 items] at sanitizeme317.pl line 202
T <- do('DELETE FROM ts_exitstatus')= ( '0E0' ) [1 items] at sanitizeme317.pl line 203
T <- do('DELETE FROM ts_funcmap')= ( '0E0' ) [1 items] at sanitizeme317.pl line 204
T <- do('DELETE FROM ts_job')= ( '0E0' ) [1 items] at sanitizeme317.pl line 205
T <- do('DELETE FROM ts_note')= ( '0E0' ) [1 items] at sanitizeme317.pl line 206
Removing attachment data to preserve disk space...
T <- do('UPDATE attach_data SET thedata = ''')= ( 16959 ) [1 items] at sanitizeme317.pl line 212
Turning off email delivery...
T <- do('UPDATE profiles SET disable_mail = 1')= ( 20014 ) [1 items] at sanitizeme317.pl line 218
T <- do('UPDATE flagtypes SET cc_list = NULL')= ( 2 ) [1 items] at sanitizeme317.pl line 222
All done!
T <- FETCH('private_bz_transaction_count')= ( undef ) [1 items] at DB.pm line 1184
T <- disconnect= ( 1 ) [1 items] at Bugzilla.pm line 679
!T <- DESTROY(DBI::db=HASH(0x25f3b70))= ( undef ) [1 items] during global destruction

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
42564
Default Alt Text
sanitize_bugzilla_db (24 KB)

Event Timeline

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL