Page MenuHomePhabricator
Paste P320

sanitize bugzilla db
ActivePublic

Authored by Dzahn on Feb 21 2015, 12:50 AM.
Tags
None
Referenced Files
F44591: sanitize_bugzilla_db
Feb 21 2015, 12:52 AM
F44587: sanitize_bugzilla_db
Feb 21 2015, 12:50 AM
Subscribers
None
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 changed the title of this paste from untitled to sanitize bugzilla db.
Dzahn updated the paste's language from autodetect to autodetect.