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