Template settings are lost when its deleted in one zone

[kiranchavala]

problem

Template details are lost when the template is deleted from one zone

versions

Cloudstack version 4.19,4.20

The steps to reproduce the bug

1. Have a Cloudstack environment with 2 zones

2. Register a template in Zone 1 and a setting to the template for example UEFI=secure

mysql> select * from vm_template_details where template_id=208;
+----+-------------+------+--------+---------+
| id | template_id | name | value  | display |
+----+-------------+------+--------+---------+
|  4 |         208 | UEFI | SECURE |       1 |
+----+-------------+------+--------+---------+
1 row in set (0.00 sec)

3. Copy the template to Zone 2.

4. Delete the template in zone2

5. Check the Template setting in zone 1

mysql> select * from vm_template_details where template_id=208;
Empty set (0.00 sec)

What to do about it?

Actual Behaviour

Currently cloudstack deletes the template settings if its deleted in one zone

Expected Behaviour

Cloudstack should not delete the template settings if its deleted in one zone