You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by David Comerford <da...@gmail.com> on 2013/10/22 17:20:41 UTC

Downloading templates loop

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-e921b8d00638","request":"GET_STATUS","hvm":true,"description":"RHEL
Server 6.3 32
Bit","checksum":"edd93cda6935bcf04c3381446764eb26","maxDownloadSizeInBytes":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://othernas/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-e921b8d00638","downloadPct":0,"errorString":"No
route to
host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStorage/9219e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld1954968885437896633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93cda6935bcf04c3381446764eb26","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/dnld1954968885437896633tmp_
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

RE: Downloading templates loop

Posted by David Comerford <da...@gmail.com>.
Sorry, restart MS.
I was surprised it didn't just stop when it was removed from the database.
And it wasn't in the async job queue or anything either.
 On 23 Oct 2013 18:33, "Nitin Mehta" <Ni...@citrix.com> wrote:

> Great that it worked. You mean restart of the cloud agent on ssvm or MS
> restart ?
>
> Thanks,
> -Nitin
> ________________________________________
> From: David Comerford [davestyle@gmail.com]
> Sent: Wednesday, October 23, 2013 10:02 PM
> To: users@cloudstack.apache.org
> Subject: Re: Downloading templates loop
>
> I tried it on one row and CS stopped trying to download but it did require
> a restart of the service.
> Didn't need to restart SSVM.
>
> Thanks for your help :)
> Best regards,
> David Comerford
> ------------------------
> Tel: +353 87 1238295
> Email: davestyle@gmail.com
> Website: http://dave.ie
> GPG key: http://gpg.dave.ie
>
>
> On 23 October 2013 17:10, Nitin Mehta <Ni...@citrix.com> wrote:
>
> > 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" <da...@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: davestyle@gmail.com
> > >Website: http://dave.ie
> > >GPG key: http://gpg.dave.ie
> > >
> > >
> > >On 23 October 2013 12:16, David Comerford <da...@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: davestyle@gmail.com
> > >> Website: http://dave.ie
> > >> GPG key: http://gpg.dave.ie
> > >>
> > >>
> > >> On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
> > >>> >> >Website: http://dave.ie
> > >>> >> >GPG key: http://gpg.dave.ie
> > >>> >>
> > >>> >>
> > >>>
> > >>>
> > >>
> >
> >
>

RE: Downloading templates loop

Posted by Nitin Mehta <Ni...@citrix.com>.
Great that it worked. You mean restart of the cloud agent on ssvm or MS restart ?

Thanks,
-Nitin
________________________________________
From: David Comerford [davestyle@gmail.com]
Sent: Wednesday, October 23, 2013 10:02 PM
To: users@cloudstack.apache.org
Subject: Re: Downloading templates loop

I tried it on one row and CS stopped trying to download but it did require
a restart of the service.
Didn't need to restart SSVM.

Thanks for your help :)
Best regards,
David Comerford
------------------------
Tel: +353 87 1238295
Email: davestyle@gmail.com
Website: http://dave.ie
GPG key: http://gpg.dave.ie


On 23 October 2013 17:10, Nitin Mehta <Ni...@citrix.com> wrote:

> 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" <da...@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: davestyle@gmail.com
> >Website: http://dave.ie
> >GPG key: http://gpg.dave.ie
> >
> >
> >On 23 October 2013 12:16, David Comerford <da...@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: davestyle@gmail.com
> >> Website: http://dave.ie
> >> GPG key: http://gpg.dave.ie
> >>
> >>
> >> On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
> >>> >> >Website: http://dave.ie
> >>> >> >GPG key: http://gpg.dave.ie
> >>> >>
> >>> >>
> >>>
> >>>
> >>
>
>

Re: Downloading templates loop

Posted by David Comerford <da...@gmail.com>.
I tried it on one row and CS stopped trying to download but it did require
a restart of the service.
Didn't need to restart SSVM.

Thanks for your help :)
Best regards,
David Comerford
------------------------
Tel: +353 87 1238295
Email: davestyle@gmail.com
Website: http://dave.ie
GPG key: http://gpg.dave.ie


On 23 October 2013 17:10, Nitin Mehta <Ni...@citrix.com> wrote:

> 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" <da...@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: davestyle@gmail.com
> >Website: http://dave.ie
> >GPG key: http://gpg.dave.ie
> >
> >
> >On 23 October 2013 12:16, David Comerford <da...@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: davestyle@gmail.com
> >> Website: http://dave.ie
> >> GPG key: http://gpg.dave.ie
> >>
> >>
> >> On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
> >>> >> >Website: http://dave.ie
> >>> >> >GPG key: http://gpg.dave.ie
> >>> >>
> >>> >>
> >>>
> >>>
> >>
>
>

Re: Downloading templates loop

Posted by Nitin Mehta <Ni...@citrix.com>.
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" <da...@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: davestyle@gmail.com
>Website: http://dave.ie
>GPG key: http://gpg.dave.ie
>
>
>On 23 October 2013 12:16, David Comerford <da...@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: davestyle@gmail.com
>> Website: http://dave.ie
>> GPG key: http://gpg.dave.ie
>>
>>
>> On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
>>> >> >Website: http://dave.ie
>>> >> >GPG key: http://gpg.dave.ie
>>> >>
>>> >>
>>>
>>>
>>


Re: Downloading templates loop

Posted by David Comerford <da...@gmail.com>.
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: davestyle@gmail.com
Website: http://dave.ie
GPG key: http://gpg.dave.ie


On 23 October 2013 12:16, David Comerford <da...@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: davestyle@gmail.com
> Website: http://dave.ie
> GPG key: http://gpg.dave.ie
>
>
> On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
>> >> >Website: http://dave.ie
>> >> >GPG key: http://gpg.dave.ie
>> >>
>> >>
>>
>>
>

Template Update properties issue.

Posted by Thomas Joseph <t....@imperial.ac.uk>.
Hi,

  After creating a template from a running VM present under a Project, as a local user, I'm unable to make changes to it's properties e.g. to parameter "OS Type".
I believe it's a permission related issue, but unable to find any settings or DB value that we need to change to rectify this problem.

Cloudstack version: 4.1.1

error:
==========
2013-11-28 11:50:59,845 DEBUG [cloud.api.ApiServlet] (http-8443-20:null) ===START===  146.169.1.7 -- GET  command=updateTemplate&response=json&sessionkey=y3BOUl31eZKpQpYTEtX%2BMjKzHbc%3D&projectid=09da065b-e744-49c4-b8fe-2edb0344d5c3&id=897ab607-6b37-4c11-bab3-da096a8048fd&zoneid=ec3bf9da-f510-49a0-b21d-fb7ecdd5ab67&name=test-prj2&displaytext=test-prj2&ostypeid=7d77166c-1fa2-11e3-809d-38acb5898e2d&passwordenabled=false&_=1385639465477

2013-11-28 11:50:59,850 INFO  [cloud.api.ApiServer] (http-8443-20:null) PermissionDenied: Domain Admin and regular users can modify only their own Public templates on uuids: []
===========

Any thoughts?

Regards,
Thomas Joseph

Re: Downloading templates loop

Posted by David Comerford <da...@gmail.com>.
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: davestyle@gmail.com
Website: http://dave.ie
GPG key: http://gpg.dave.ie


On 23 October 2013 05:41, Nitin Mehta <Ni...@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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
> >> >Website: http://dave.ie
> >> >GPG key: http://gpg.dave.ie
> >>
> >>
>
>

Re: Downloading templates loop

Posted by Nitin Mehta <Ni...@citrix.com>.
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" <da...@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 <Ni...@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" <da...@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: davestyle@gmail.com
>> >Website: http://dave.ie
>> >GPG key: http://gpg.dave.ie
>>
>>


Re: Downloading templates loop

Posted by David Comerford <da...@gmail.com>.
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 <Ni...@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" <da...@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-e921
> >b8d00638","request":"GET_STATUS","hvm":true,"description":"RHEL
> >Server 6.3 32
> >Bit","checksum":"edd93cda6935bcf04c3381446764eb26","maxDownloadSizeInBytes
> >":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://other
> >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-e921b8d00638"
> >,"downloadPct":0,"errorString":"No
> >route to
> >host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStorage/92
> >19e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld195496888543789
> >6633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93cda69
> >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: davestyle@gmail.com
> >Website: http://dave.ie
> >GPG key: http://gpg.dave.ie
>
>

Re: Downloading templates loop

Posted by Nitin Mehta <Ni...@citrix.com>.
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" <da...@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-e921
>b8d00638","request":"GET_STATUS","hvm":true,"description":"RHEL
>Server 6.3 32
>Bit","checksum":"edd93cda6935bcf04c3381446764eb26","maxDownloadSizeInBytes
>":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://other
>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-e921b8d00638"
>,"downloadPct":0,"errorString":"No
>route to
>host","downloadStatus":"NOT_DOWNLOADED","downloadPath":"/mnt/SecStorage/92
>19e7b2-1e8a-3b9c-bfba-fa05ffc80290/template/tmpl/2/233/dnld195496888543789
>6633tmp_","templateSize":0,"templatePhySicalSize":0,"checkSum":"edd93cda69
>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: davestyle@gmail.com
>Website: http://dave.ie
>GPG key: http://gpg.dave.ie