Great that it worked. You mean restart of the cloud agent on ssvm or MS restart ?
Thanks, -Nitin ________________________________________ From: David Comerford [davest...@gmail.com] Sent: Wednesday, October 23, 2013 10:02 PM To: users@cloudstack.apache.org Subject: Re: Downloading templates loop I tried it on one row and CS stopped trying to download but it did require a restart of the service. Didn't need to restart SSVM. Thanks for your help :) Best regards, David Comerford ------------------------ Tel: +353 87 1238295 Email: davest...@gmail.com Website: http://dave.ie GPG key: http://gpg.dave.ie On 23 October 2013 17:10, Nitin Mehta <nitin.me...@citrix.com> wrote: > Yes - it should be fine. That said, I would first try and do it only for > one entry (also keeping a backup) and see what happens. > You might also need to stop/start ssvm to cancel the job (do it only if > its not cancelled) > > On 23/10/13 5:08 AM, "David Comerford" <davest...@gmail.com> wrote: > > >Or a more exciting way of phrasing that last question, is the safe to > >delete all entries from template_host_ref where download_state is > >NOT_DOWNLOADED? > > > >DELETE FROM template_host_ref WHERE download_state='NOT_DOWNLOADED'; > > > >Best regards, > >David Comerford > >------------------------ > >Tel: +353 87 1238295 > >Email: davest...@gmail.com > >Website: http://dave.ie > >GPG key: http://gpg.dave.ie > > > > > >On 23 October 2013 12:16, David Comerford <davest...@gmail.com> wrote: > > > >> Right sounds good. > >> In some cases I have a working template that has multiple entries in > >> template_host_ref. Usually there's a few failed download entries and the > >> one that succeded. Am I safe to just delete the rows that have the > >>failures > >> from this table? > >> Best regards, > >> David Comerford > >> ------------------------ > >> Tel: +353 87 1238295 > >> Email: davest...@gmail.com > >> Website: http://dave.ie > >> GPG key: http://gpg.dave.ie > >> > >> > >> On 23 October 2013 05:41, Nitin Mehta <nitin.me...@citrix.com> wrote: > >> > >>> David - I donĀ¹t think it should be a problem. The reference is the > >>>other > >>> way around. > >>> Also mark the vm_template table entry as removed. Try this for one of > >>>them > >>> and see. > >>> > >>> On 22/10/13 1:22 PM, "David Comerford" <davest...@gmail.com> wrote: > >>> > >>> >They aren't present in the UI. > >>> >Would deleting them from template_store_ref not cause a problem as > >>>they > >>> >are > >>> >referenced by template_host_ref and vm_template? > >>> > > >>> >Best regards, > >>> >David Comerford > >>> >------------------------ > >>> >Tel: +353 87 1238295 > >>> >Email: davest...@gmail.com > >>> >Website: http://dave.ie > >>> >GPG key: http://gpg.dave.ie > >>> > > >>> > > >>> >On 22 October 2013 17:42, Nitin Mehta <nitin.me...@citrix.com> wrote: > >>> > > >>> >> If there is an option available in the UI to delete them then do > >>>that. > >>> >> Else you can remove the entry from template_store_ref, I think that > >>> >>should > >>> >> do > >>> >> > >>> >> On 22/10/13 8:20 AM, "David Comerford" <davest...@gmail.com> wrote: > >>> >> > >>> >> >Hi, > >>> >> > > >>> >> >I've noticed my logs are filled with what looks like attempts to > >>> >> >re-download old failed template downloads. The jobID's from the > >>>logs > >>> >>can > >>> >> >be > >>> >> >seen in the template_host_ref table. > >>> >> >I'm wondering why the jobs haven't timed out or otherwise given up. > >>> >>And If > >>> >> >they are going on go on forever then how do I stop/remove them. > >>> >> > > >>> >> >Thanks > >>> >> > > >>> >> >=== Extract from management-server.log === > >>> >> >2013-10-21 16:46:55,202 DEBUG [agent.transport.Request] > >>> (Timer-13:null) > >>> >> >Seq > >>> >> >67-1910165348: Sending { Cmd , MgmtId: 345051854263, via: 67, Ver: > >>>v1, > >>> >> >Flags: 100011, > >>> >> > >>> > >>> > >>>>>>[{"storage.DownloadProgressCommand":{"jobId":"25d111cf-767d-40f2-9d3f > >>>>>>-e9 > >>> >>>21 > >>> >> >b8d00638","request":"GET_STATUS","hvm":true,"description":"RHEL > >>> >> >Server 6.3 32 > >>> >> > >>> > >>> > >>>>>>Bit","checksum":"edd93cda6935bcf04c3381446764eb26","maxDownloadSizeIn > >>>>>>Byt > >>> >>>es > >>> >> >":53687091200,"id":233,"resourceType":"TEMPLATE","url":" > >>> >> >http://bignas01/rhel-server-6.3-i386-dvd.iso > >>> >> ","format":"ISO","accountId":2 > >>> >> > >>> > >>> > >>>>>>,"name":"233-2-03f4e933-fc90-3056-8ccd-78b4a1b27dfb","secUrl":"nfs:// > >>>>>>oth > >>> >>>er > >>> >> >nas/export/sec2","wait":0}}] > >>> >> >} > >>> >> >2013-10-21 16:46:55,254 DEBUG [agent.transport.Request] > >>> >> >(AgentManager-Handler-2:null) Seq 67-1910165348: Processing: { > >>>Ans: , > >>> >> >MgmtId: 345051854263, via: 67, Ver: v1, Flags: 10, > >>> >> > >>> > >>> > >>>>>>[{"storage.DownloadAnswer":{"jobId":"25d111cf-767d-40f2-9d3f-e921b8d0 > >>>>>>063 > >>> >>>8" > >>> >> >,"downloadPct":0,"errorString":"No > >>> >> >route to > >>> >> > >>> > >>> > >>>>>>host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStora > >>>>>>ge/ > >>> >>>92 > >>> >> > >>> > >>> > >>>>>>19e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld1954968885 > >>>>>>437 > >>> >>>89 > >>> >> > >>> > >>> > >>>>>>6633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93 > >>>>>>cda > >>> >>>69 > >>> >> >35bcf04c3381446764eb26","result":false,"details":"No > >>> >> >route to host","wait":0}}] } > >>> >> > > >>> >> >=== Example JobID from database ==== > >>> >> >mysql> select * from template_host_ref where job_id = > >>> >> >'25d111cf-767d-40f2-9d3f-e921b8d00638' \G > >>> >> >*************************** 1. row *************************** > >>> >> >id: 385 > >>> >> >host_id: 55 > >>> >> >template_id: 233 > >>> >> >created: 2012-10-29 23:09:28 > >>> >> >last_updated: 2013-10-21 15:54:55 > >>> >> >job_id: 25d111cf-767d-40f2-9d3f-e921b8d00638 > >>> >> >download_pct: 0 > >>> >> >size: 0 > >>> >> >physical_size: 0 > >>> >> >download_state: NOT_DOWNLOADED > >>> >> >error_str: No route to host > >>> >> >local_path: > >>> >> > >>> > >>> > >>>>>>/mnt/SecStorage/9219e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/ > >>>>>>233 > >>> >>>/d > >>> >> >nld1954968885437896633tmp_ > >>> >> >install_path: NULL > >>> >> >url: http://bignas01/rhel-server-6.3-i386-dvd.iso > >>> >> >destroyed: 0 > >>> >> >is_copy: 0 > >>> >> >1 row in set (0.00 sec) > >>> >> >Cheers! > >>> >> > > >>> >> >Best regards, > >>> >> >David Comerford > >>> >> >------------------------ > >>> >> >Tel: +353 87 1238295 > >>> >> >Email: davest...@gmail.com > >>> >> >Website: http://dave.ie > >>> >> >GPG key: http://gpg.dave.ie > >>> >> > >>> >> > >>> > >>> > >> > >