When using the SQL provisioner plugin (4.0.2 & develop)  Resync Reference Data populates the sp_co_groups table with all 5 records. Then I click 'Reprovision All' and the table gets wiped, and only a single record is re-added.

The remaining sync is trying to write records to sp_co_group_members  without the corresponding group record existing in sp_co_groups , generating a violates foreign key constraint "sp_co_group_members_co_group_id_fkey error. I checked and of the 5 groups we have, only CO:members:active  gets a record in sp_co_groups .  Then it proceeds to try to bring in members for the other groups generating errors. This also causes the sync to take a long time as it's constantly handling errors.