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