Nitin, You was tight...I issued the SQL statement: delete FROM cloud.template_store_ref where store_id=14 and template_id in (select id from vm_template where type='user' and format='iso');
So deleted all references for all "user" ISOs from old NFS (store_id=14), and then I was able to delete the storage from GUI. This should be submited as a BUG, this is not normal and expected behaviour. Since all ISOs are replicated to all SS/NFS, eather enable option from GUI to delete all ISOs reference to storage to be removed, or simply do NOT take into account ISOs when checking if it is OK to delete SS/NFS... Thanks Nitin. On 18 December 2013 10:06, Andrija Panic <andrija.pa...@gmail.com> wrote: > 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 > -------------------------------------- > -- Andrija Panić -------------------------------------- http://admintweets.com --------------------------------------
