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","maxDownloadSizeInByt >>>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-e921b8d0063 >>>8" >> >,"downloadPct":0,"errorString":"No >> >route to >> >>>host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStorage/ >>>92 >> >>>19e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld1954968885437 >>>89 >> >>>6633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93cda >>>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 >> >>
