Deletion of site does not cleanup cms_name

[geneguvo]

Whenever a site is removed from sitedb, its CMS alias name does not get deleted from the cms_name table.

If we then try adding the site with the same cms_name, it will fail to register that alias for the site. In the end, you have a site without a CMS alias name.

So far, whenever someone removes a site, I have to do the following surgery cleanup:

select * from cms_name where id not in (select cms_name_id from site_cms_name_map);

    ID NAME
---------- ----------------------------------------------------------------------------------------------------
     3 T1_DE_FZK
       801 T2_CH_CAF
       113 T2_PT_LIP_Lisbon
       142 T3_DE_Karlsruhe
      1341 T3_IT_Padova
       923 TX_UN_Fake

6 rows selected.

delete from cms_name where id not in (select cms_name_id from site_cms_name_map);

The bug is very easy to reproduce: just add a new site under the dev instance, remove it, then try adding again.