Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cloudstack.apache.org
Received-SPF: pass (nike.apache.org: domain of Nitin.Mehta@citrix.com
 designates 66.165.176.63 as permitted sender)
From: Nitin Mehta <Nitin.Mehta@citrix.com>
To: "users@cloudstack.apache.org" <users@cloudstack.apache.org>
Subject: Re: Downloading templates loop
Thread-Topic: Downloading templates loop
Thread-Index: AQHOzzpbOoC+kLEH7kaG/MD2ayIRGJn/6TYAgAC7MgCAABX5AA==
Date: Wed, 23 Oct 2013 04:41:34 +0000
Message-ID: <CE8CA132.2CBFF%nitin.mehta@citrix.com>
In-Reply-To: 
 <CACb7MQUZ6gN_L4374dj4xjVA_f1+W2Kg=3S6zc_JbcGoeZ681A@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.2.0.120402
Content-Type: text/plain; charset="iso-8859-1"
Content-ID: <ADF58E889E34C546A010D95E7B12C4C9@citrix.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

David - I don=B9t 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.=20

On 22/10/13 1:22 PM, "David Comerford" <davestyle@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: davestyle@gmail.com
>Website: http://dave.ie
>GPG key: http://gpg.dave.ie
>
>
>On 22 October 2013 17:42, Nitin Mehta <Nitin.Mehta@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" <davestyle@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
>> >
>> >=3D=3D=3D Extract from management-server.log =3D=3D=3D
>> >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,
>>=20
>>>[{"storage.DownloadProgressCommand":{"jobId":"25d111cf-767d-40f2-9d3f-e9
>>>21
>> >b8d00638","request":"GET_STATUS","hvm":true,"description":"RHEL
>> >Server 6.3 32
>>=20
>>>Bit","checksum":"edd93cda6935bcf04c3381446764eb26","maxDownloadSizeInByt
>>>es
>> >":53687091200,"id":233,"resourceType":"TEMPLATE","url":"
>> >http://bignas01/rhel-server-6.3-i386-dvd.iso
>> ","format":"ISO","accountId":2
>>=20
>>>,"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,
>>=20
>>>[{"storage.DownloadAnswer":{"jobId":"25d111cf-767d-40f2-9d3f-e921b8d0063
>>>8"
>> >,"downloadPct":0,"errorString":"No
>> >route to
>>=20
>>>host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStorage/
>>>92
>>=20
>>>19e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld1954968885437
>>>89
>>=20
>>>6633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93cda
>>>69
>> >35bcf04c3381446764eb26","result":false,"details":"No
>> >route to host","wait":0}}] }
>> >
>> >=3D=3D=3D Example JobID from database =3D=3D=3D=3D
>> >mysql> select * from template_host_ref where job_id =3D
>> >'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:
>>=20
>>>/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: davestyle@gmail.com
>> >Website: http://dave.ie
>> >GPG key: http://gpg.dave.ie
>>
>>