I need to clean up some old PDC data in prod for @cverna's work on the fedora-packages indexer.
I just ran these commands on the staging PDC db and cverna confirmed that the indexer works as expected against stg now.
I'm filing this ticket as a reminder to do this in prod after freeze is out, rather than do a FBR now.
begin transaction; delete from component_releasecomponentrelationship where from_component_id in ( select rc.id from component_releasecomponent rc where rc.global_component_id not in ( select distinct gc.global_component_id from componentbranch_componentbranch gc)); delete from component_releasecomponentrelationship where to_component_id in ( select rc.id from component_releasecomponent rc where rc.global_component_id not in ( select distinct gc.global_component_id from componentbranch_componentbranch gc)); delete from component_releasecomponent where global_component_id not in ( select distinct b.global_component_id from componentbranch_componentbranch b); delete from component_globalcomponent where id not in ( select distinct b.global_component_id from componentbranch_componentbranch b); commit;
Metadata Update from @kevin: - Issue tagged with: unfreeze
Should be done now.
pdc=# select count(*) from component_globalcomponent; count ------- 24841 (1 row)
Metadata Update from @ralph: - Issue status updated to: Closed (was: Open)
Login to comment on this ticket.