Andrija - Glad that you were able to get through this and thanks for raising the bug. I am taking the liberty to add the [SOLVED] tag.
Thanks, -Nitin On 18/12/13 8:18 AM, "Andrija Panic" <andrija.pa...@gmail.com> wrote: >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&respo >>>>>nse= >>>> >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 >--------------------------------------
