Submited bug: https://issues.apache.org/jira/browse/CLOUDSTACK-5543
On 18 December 2013 16:54, Andrija Panic <andrija.pa...@gmail.com> wrote: > 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 > -------------------------------------- > -- Andrija Panić -------------------------------------- http://admintweets.com --------------------------------------