This SQL (and the other sql like it) seemed like it was hanging, though maybe not.  Changed

FROM

update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null
commit;

TO

update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null
and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ;
commit;
update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null
and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ;
commit;
update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null
and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ;
commit;
...etc...


  • No labels