CloudStack SSVM 启动不了，可执行如下查询sql来确定

?

?SSVM?启动不了，可执行如下查询sql来确定

get?zone?template
select?a.*?from?vm_template?a,?host?h?where?h.type?=?'Routing'?and?h.data_center_id?=?1?and?a.type?=?'System'?and?a.hypervisor_type??=?h.hypervisor_type?limit?1;???#templateid?is?1

get?zone?secondary?storage
select?*?from?host?where?type?=?'SecondaryStorage'?and?data_center_id?=?1;??#?host?id?is?3

get?zone?template?and?host?ref??????
select?*?from?template_host_ref?where?host_id?=?3?and?template_id?=?1?and?download_state?=?'DOWNLOADED';?#?host?id?and?template?id??is?query?by?before.

get?host?primary?storage?pool
SELECT?p.data_center_id,??count(ph.host_id)?count??FROM?storage_pool?p,?storage_pool_host_ref?ph?WHERE?p.id?=?ph.pool_id?AND??p.data_center_id?=?1?GROUP?by?p.data_center_id;
count?need?bigger?than?0;
这个是ssvm不启动的时候原因查找，这个是查询问题的，查询出问题，解决相应问题，CS会自动启动SSVM的