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","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 > >> > >> > >
