Sorry, restart MS. I was surprised it didn't just stop when it was removed from the database. And it wasn't in the async job queue or anything either. On 23 Oct 2013 18:33, "Nitin Mehta" <nitin.me...@citrix.com> wrote:
> 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 > > >>> >> > > >>> >> > > >>> > > >>> > > >> > > > > >
