Server crashed because hosting_site_alias table was huge

It took me hours to find this. I am running a production system on aegir 8.

for some reason, my hosting_site_alias table had hundred of thousands of entries. There were multiple entries of only three aliases.

I had to go into the database and delete the recurring entries.

DELETE FROM `hosting_site_alias` WHERE `hosting_site_alias`.`vid` = 1684 AND `hosting_site_alias`.`nid` = 1591

I am placing this here in case someone has the same issue one of these days.