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 >--------------------------------------
