Hi Nitin, yes that is true, ISOs does exist, which can be seen from the result of the query you sent.(lot of ISOs that are "user" type, and those 3 templates I already sent that are system/builtin type)
But how am I supposed to delete them ? Manualy from DB - I don't see any other way... ? Thanks On 17 December 2013 23:23, Nitin Mehta <nitin.me...@citrix.com> wrote: > Andrija - I think the issue is that the ISOs are still existing for that > store. What is the result of the query below ? > > > mysql> SELECT unique_name,name,uuid,type FROM cloud.vm_template where id in > (SELECT template_id FROM cloud.template_store_ref where store_id=14) > > > On 17/12/13 12:55 PM, "Andrija Panic" <andrija.pa...@gmail.com> wrote: > > >Hi, > > > >I have just stumbled upon the bug that is (seems to be) described here: > >https://issues.apache.org/jira/browse/CLOUDSTACK-2590 > >Cant delete secodnary storage NFS, with message: Cannot delete image store > >with active templates backup! > > > >I'm using the 4.2 RPMs from CS repo. > > > >What I have done: > > > >SCP over all templates (except the system ones, that are replicated) from > >S1 to S2 NFS storage, > >I have not deleted any ISOs, that are replicated accross all NFS > >storages... > > > >Than I have updated table "template_store_ref" accordingly (not > >template_host_ref, because now in 4.2 template_store_ref is used instead > >of > >template_host_ref. as I was told on mailing list), for each template > >separately to point to new host CS, that is I changed the store_id field > >with new value. Deplyoument of new VMs from those templates are fine, all > >verified. > > > >So when I issue the sql: > >mysql> SELECT unique_name,name,uuid,type FROM cloud.vm_template where id > >in > >(SELECT template_id FROM cloud.template_store_ref where store_id=14) and > >format='QCOW2'; > >+--------------------------------------------+---------------------------- > >-----+--------------------------------------+---------+ > >| unique_name | name > > | uuid | type | > >+--------------------------------------------+---------------------------- > >-----+--------------------------------------+---------+ > >| routing-3 | SystemVM Template (KVM) > > | ea523de2-f588-42b1-81f0-0c0cfbb80841 | SYSTEM | > >| centos55-x86_64 | CentOS 5.5(64-bit) no GUI > >(KVM) | a2a206e9-031d-46ff-b8dd-ce6b4d4fba62 | BUILTIN | > >| 258-2-4d49b0c9-0e41-3ea6-98d7-2483a5581807 | systemvm-kvm-4.2 > > | c6b7f09b-2c0c-41a5-97ef-aa70fb86c92a | SYSTEM | > >+--------------------------------------------+---------------------------- > >-----+--------------------------------------+---------+ > >3 rows in set (0.00 sec) > > > > > >As you can see, there are only 3 templates that are of type system and > >builtin, no "user" templates on this old NFS storage... > > > >Still I'm unable to delete the NFS secondary storage, with the message: > >2013-12-17 21:46:43,696 DEBUG [cloud.api.ApiServlet] > >(catalina-exec-25:null) ===START=== 91.185.114.xxx -- GET > > > >command=deleteImageStore&id=c2c6ba11-eb85-45fc-9536-c1d6fa171572&response= > >json&sessionkey=hUArls%2BzzxZSBN6ibVqXnzPCngs%3D&_=1387313204777 > >2013-12-17 21:46:43,710 INFO [cloud.api.ApiServer] > >(catalina-exec-25:null) > >Cannot delete image store with active templates backup! > > > >THis is all that I have in management log... > > > > > >Is there any chance that the DELETE operation reads from the old > >template_host_ref table instead of the new one that is used now, > >template_store_ref...? > >Should I also update the template_host_ref along with the > >template_store_ref... ? > > > >Any help would be really appriciated... > >Andrija > > > > > > > >-- > > > > > > > >Andrija Panić > >-------------------------------------- > > http://admintweets.com > >-------------------------------------- > > -- Andrija Panić -------------------------------------- http://admintweets.com --------------------------------------
