Page MenuHomePhabricator
Paste P320

sanitize bugzilla db
ActivePublic

Authored by Dzahn on Feb 21 2015, 12:50 AM.
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

Event Timeline

Dzahn edited the content of this paste. (Show Details)Feb 21 2015, 12:50 AM
Dzahn changed the title of this paste from untitled to sanitize bugzilla db.
Dzahn updated the paste's language from autodetect to autodetect.
Dzahn edited the content of this paste. (Show Details)Feb 21 2015, 12:52 AM