Do you have contents of template_view and vm_templates? Thanks -min
On 8/30/13 9:25 AM, "Soheil Eizadi" <seiz...@infoblox.com> wrote: >It was in the original email, here it is by itself: > >mysql> select * from template_store_ref; >+----+----------+-------------+---------------------+--------------------- >+--------+--------------+------------+------------+---------------+------- >---------+-----------+------------+--------------------------------------- >---------------------+---------------------------------------------------- >------------------------------------+-------+-----------+---------+------- >-------+---------+---------+ >| id | store_id | template_id | created | last_updated >| job_id | download_pct | size | store_role | physical_size | >download_state | error_str | local_path | install_path > | url > | state | destroyed | is_copy | >update_count | ref_cnt | updated | >+----+----------+-------------+---------------------+--------------------- >+--------+--------------+------------+------------+---------------+------- >---------+-----------+------------+--------------------------------------- >---------------------+---------------------------------------------------- >------------------------------------+-------+-----------+---------+------- >-------+---------+---------+ >| 5 | 1 | 1 | 2013-08-28 23:10:50 | 2013-08-29 21:01:19 >| NULL | 100 | 2101252608 | Image | 2101252608 | >DOWNLOADED | NULL | NULL | >template/tmpl/1/1/170c3425-6078-479e-8843-3f8fdc02aaf3.vhd | >http://download.cloud.com/templates/4.2/systemvmtemplate-2013-06-12-master >-xen.vhd.bz2 | Ready | 0 | 0 | 0 | 0 | >NULL | >| 6 | 1 | 5 | 2013-08-29 18:16:53 | 2013-08-29 21:01:19 >| NULL | 100 | 52428800 | Image | 50430464 | >DOWNLOADED | NULL | NULL | >template/tmpl/1/5/0911ae22-350f-38f5-ad3e-423e7e5d6539.vhd | >http://people.apache.org/~bhaisaab/vms/ttylinux_pv.vhd > | Ready | 0 | 0 | 0 | 0 | >NULL | >+----+----------+-------------+---------------------+--------------------- >+--------+--------------+------------+------------+---------------+------- >---------+-----------+------------+--------------------------------------- >---------------------+---------------------------------------------------- >------------------------------------+-------+-----------+---------+------- >-------+---------+---------+ >2 rows in set (0.00 sec) >________________________________________ >From: Chiradeep Vittal [chiradeep.vit...@citrix.com] >Sent: Friday, August 30, 2013 9:22 AM >To: dev@cloudstack.apache.org >Subject: Re: Template Problem > >Just the contents of template_store_ref > >On 8/30/13 9:17 AM, "Soheil Eizadi" <seiz...@infoblox.com> wrote: > >>Chiradeep, >>What do you want me to lookup, before I clean up my system? >>-Soheil >>________________________________________ >>From: Wei ZHOU [ustcweiz...@gmail.com] >>Sent: Thursday, August 29, 2013 3:16 PM >>To: dev@cloudstack.apache.org >>Subject: Re: Template Problem >> >>Chiradeep, Thanks. >>I cannot give more information as the environment has been cleaned. >>Maybe Soheil can. I think it is the same issue. >> >> >>2013/8/29 Chiradeep Vittal <chiradeep.vit...@citrix.com> >> >>> It should be template_store_ref >>> >>> On 8/29/13 2:34 PM, "Wei ZHOU" <ustcweiz...@gmail.com> wrote: >>> >>> >It is the same issue to what I described in comment of >>>CLOUDSTACK-4459: >>> > >>> > >>> >Wei >>> >>>>Zhou<https://issues.apache.org/jira/secure/ViewProfile.jspa?name=weizho >>>>u >>> >a >>> >dded >>> >a comment - 29/Aug/13 >>> >22:24 >>> > >>> >Edison, after I redeploy the environment (clean db, restore devcloud >>>to >>> >original, reploydb), the system is up. >>> >Th systemvms (ssvm and cpvm) are running and the state are up, but I >>>can >>> >not see tinylinux in template list. the template_host_ref table is >>>empty. >>> > >>> >Wei >>> >>>>Zhou<https://issues.apache.org/jira/secure/ViewProfile.jspa?name=weizho >>>>u >>> >a >>> >dded >>> >a comment - 29/Aug/13 >>> >23:10 >>> > >>> >It works well on 4.2-forward branch. >>> > >>> > >>> > >>> >2013/8/29 Soheil Eizadi <seiz...@infoblox.com> >>> > >>> >> I migrated my development environment to the top of trunk which >>>points >>> >>to >>> >> 4.3 now. I created a new CloudStack runtime environment running >>> >>XenServer >>> >> 6.2, for my Secondary Store I replicated another NFS Server that has >>> >>images >>> >> for preRC CloudStack version 4.2 SystemVM and TinyLinux on it. >>> >> >>> >> I have the CS running and it creates the SSVM and it is healthy, but >>>I >>> >> don't see any Templates in the UI, from the database I would expect >>>to >>> >>see >>> >> the "tiny Linux" and "SystemVM Template" in the Templates view. >>> >> >>> >> I have restarted the management server and the problem is >>>persistent. >>> >> >>> >> What is the next steps to debug this further? >>> >> -Soheil >>> >> >>> >> >>> >> Here is some logs below: >>> >> >>> >> From SSVM: >>> >> /usr/local/cloud/systemvm/ssvm-check.sh >>> >> ================================================ >>> >> First DNS server is 10.48.15.25 >>> >> PING 10.48.15.25 (10.48.15.25): 56 data bytes >>> >> 64 bytes from 10.48.15.25: icmp_seq=0 ttl=64 time=1.038 ms >>> >> 64 bytes from 10.48.15.25: icmp_seq=1 ttl=64 time=0.359 ms >>> >> --- 10.48.15.25 ping statistics --- >>> >> 2 packets transmitted, 2 packets received, 0% packet loss >>> >> round-trip min/avg/max/stddev = 0.359/0.699/1.038/0.340 ms >>> >> Good: Can ping DNS server >>> >> ================================================ >>> >> Good: DNS resolves download.cloud.com >>> >> ================================================ >>> >> NFS is currently mounted >>> >> Mount point is /mnt/SecStorage/3667905e-f9c2-388e-a8c6-112cb96a98a9 >>> >> Good: Can write to mount point >>> >> ================================================ >>> >> Management server is 10.48.15.10. Checking connectivity. >>> >> Good: Can connect to management server port 8250 >>> >> ================================================ >>> >> Good: Java process is running >>> >> ================================================ >>> >> Tests Complete. Look for ERROR or WARNING above. >>> >> >>> >> From MS log: >>> >> WARN [c.c.c.ClusterManagerImpl] (Cluster-Notification-1:null) >>>Notifying >>> >> management server join event took 21 ms >>> >> INFO [c.c.n.s.SecurityGroupListener] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Received a host startup >>> >>notification >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync found routing-1 >>> >>already >>> >> in the image store >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >>routing-3 >>> >> on image store 1, may request download based on available hypervisor >>> >>types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >> centos55-x86_64 on image store 1, may request download based on >>> >>available >>> >> hypervisor types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync found tiny Linux >>> >> already in the image store >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >> centos53-x64 on image store 1, may request download based on >>>available >>> >> hypervisor types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >>routing-8 >>> >> on image store 1, may request download based on available hypervisor >>> >>types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >>routing-9 >>> >> on image store 1, may request download based on available hypervisor >>> >>types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Template Sync did not find >>> >>routing-10 >>> >> on image store 1, may request download based on available hypervisor >>> >>types >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >>routing-10 >>> >> since current data center does not have hypervisor LXC >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >>routing-9 >>> >> since current data center does not have hypervisor Hyperv >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >>routing-8 >>> >> since current data center does not have hypervisor VMware >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >>routing-3 >>> >> since current data center does not have hypervisor KVM >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >> centos53-x64 since current data center does not have hypervisor >>>VMware >>> >> INFO [o.a.c.s.i.TemplateServiceImpl] >>> >> (AgentConnectTaskPool-2:ctx-b401ef43) Skip downloading template >>> >> centos55-x86_64 since current data center does not have hypervisor >>>KVM >>> >> INFO [c.c.c.AgentHookBase] (AgentConnectTaskPool-1:ctx-81d176bd) >>> >> Successfully sent out command to start HTTP handling in console >>>proxy >>> >>agent >>> >> INFO [c.c.a.m.AgentManagerImpl] (ClusteredAgentManager Timer:null) >>> >>Could >>> >> not to find a Discoverer to load the resource: 2 for hypervisor >>>type: >>> >>null >>> >> INFO [c.c.a.m.DirectAgentAttache] (AgentTaskPool-2:ctx-0f928c9f) >>> >> StartupAnswer received 2 Interval = 60 >>> >> INFO [c.c.n.s.SecurityGroupListener] (AgentTaskPool-2:ctx-0f928c9f) >>> >> Received a host startup notification >>> >> INFO [c.c.h.x.r.CitrixResourceBase] (AgentTaskPool-1:ctx-36b7c165) >>> >> Private Network is cloud-public for host 10.48.15.20 >>> >> INFO [c.c.h.x.r.CitrixResourceBase] (AgentTaskPool-1:ctx-36b7c165) >>> >>Guest >>> >> Network is cloud-public for host 10.48.15.20 >>> >> INFO [c.c.h.x.r.CitrixResourceBase] (AgentTaskPool-1:ctx-36b7c165) >>> >>Public >>> >> Network is cloud-public for host 10.48.15.20 >>> >> >>> >> Database: >>> >> >>> >> mysql> select * from template_host_ref; >>> >> Empty set (0.00 sec) >>> >> >>> >> mysql> select * from template_store_ref; >>> >> >>> >> >>> >>>>>+----+----------+-------------+---------------------+----------------- >>>>>- >>>>>-- >>> >>>>>-+--------+--------------+------------+------------+---------------+-- >>>>>- >>>>>-- >>> >>>>>-----------+-----------+------------+--------------------------------- >>>>>- >>>>>-- >>> >>>>>------------------------+--------------------------------------------- >>>>>- >>>>>-- >>> >>>>>----------------------------------------+-------+-----------+--------- >>>>>+ >>>>>-- >>> >>------------+---------+---------+ >>> >> | id | store_id | template_id | created | last_updated >>> >> | job_id | download_pct | size | store_role | physical_size | >>> >> download_state | error_str | local_path | install_path >>> >> | url >>> >> | state | destroyed | is_copy >>>| >>> >> update_count | ref_cnt | updated | >>> >> >>> >> >>> >>>>>+----+----------+-------------+---------------------+----------------- >>>>>- >>>>>-- >>> >>>>>-+--------+--------------+------------+------------+---------------+-- >>>>>- >>>>>-- >>> >>>>>-----------+-----------+------------+--------------------------------- >>>>>- >>>>>-- >>> >>>>>------------------------+--------------------------------------------- >>>>>- >>>>>-- >>> >>>>>----------------------------------------+-------+-----------+--------- >>>>>+ >>>>>-- >>> >>------------+---------+---------+ >>> >> | 5 | 1 | 1 | 2013-08-28 23:10:50 | 2013-08-29 >>> >>21:01:19 >>> >> | NULL | 100 | 2101252608 | Image | 2101252608 | >>> >> DOWNLOADED | NULL | NULL | >>> >> template/tmpl/1/1/170c3425-6078-479e-8843-3f8fdc02aaf3.vhd | >>> >> >>> >> >>> >>>http://download.cloud.com/templates/4.2/systemvmtemplate-2013-06-12-mast >>>e >>> >>r-xen.vhd.bz2| Ready | 0 | 0 | 0 | 0 | >>> >>NULL | >>> >> | 6 | 1 | 5 | 2013-08-29 18:16:53 | 2013-08-29 >>> >>21:01:19 >>> >> | NULL | 100 | 52428800 | Image | 50430464 | >>> >> DOWNLOADED | NULL | NULL | >>> >> template/tmpl/1/5/0911ae22-350f-38f5-ad3e-423e7e5d6539.vhd | >>> >> http://people.apache.org/~bhaisaab/vms/ttylinux_pv.vhd >>> >> | Ready | 0 | 0 | 0 | 0 >>>| >>> >>NULL >>> >> | >>> >> >>> >> >>> >>>>>+----+----------+-------------+---------------------+----------------- >>>>>- >>>>>-- >>> >>>>>-+--------+--------------+------------+------------+---------------+-- >>>>>- >>>>>-- >>> >>>>>-----------+-----------+------------+--------------------------------- >>>>>- >>>>>-- >>> >>>>>------------------------+--------------------------------------------- >>>>>- >>>>>-- >>> >>>>>----------------------------------------+-------+-----------+--------- >>>>>+ >>>>>-- >>> >>------------+---------+---------+ >>> >> 2 rows in set (0.00 sec) >>> >> >>> >> >>> >> >>> >>> >