| // Licensed to the Apache Software Foundation (ASF) under one |
| // or more contributor license agreements. See the NOTICE file |
| // distributed with this work for additional information |
| // regarding copyright ownership. The ASF licenses this file |
| // to you under the Apache License, Version 2.0 (the |
| // "License"); you may not use this file except in compliance |
| // with the License. You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, |
| // software distributed under the License is distributed on an |
| // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| // KIND, either express or implied. See the License for the |
| // specific language governing permissions and limitations |
| // under the License. |
| package com.cloud.host.dao; |
| |
| import java.sql.PreparedStatement; |
| import java.sql.ResultSet; |
| import java.sql.SQLException; |
| import java.util.ArrayList; |
| import java.util.Date; |
| import java.util.HashMap; |
| import java.util.HashSet; |
| import java.util.List; |
| import java.util.Map; |
| import java.util.Objects; |
| import java.util.Set; |
| import java.util.TimeZone; |
| import java.util.stream.Collectors; |
| |
| import javax.annotation.PostConstruct; |
| import javax.inject.Inject; |
| import javax.persistence.TableGenerator; |
| |
| import org.apache.cloudstack.utils.jsinterpreter.TagAsRuleHelper; |
| import org.apache.commons.collections.CollectionUtils; |
| import org.apache.log4j.Logger; |
| |
| import com.cloud.agent.api.VgpuTypesInfo; |
| import com.cloud.cluster.agentlb.HostTransferMapVO; |
| import com.cloud.cluster.agentlb.dao.HostTransferMapDao; |
| import com.cloud.configuration.ManagementServiceConfiguration; |
| import com.cloud.dc.ClusterVO; |
| import com.cloud.dc.dao.ClusterDao; |
| import com.cloud.gpu.dao.HostGpuGroupsDao; |
| import com.cloud.gpu.dao.VGPUTypesDao; |
| import com.cloud.host.Host; |
| import com.cloud.host.DetailVO; |
| import com.cloud.host.Host.Type; |
| import com.cloud.host.HostTagVO; |
| import com.cloud.host.HostVO; |
| import com.cloud.host.Status; |
| import com.cloud.host.Status.Event; |
| import com.cloud.hypervisor.Hypervisor; |
| import com.cloud.hypervisor.Hypervisor.HypervisorType; |
| import com.cloud.info.RunningHostCountInfo; |
| import com.cloud.org.Grouping; |
| import com.cloud.org.Managed; |
| import com.cloud.resource.ResourceState; |
| import com.cloud.utils.DateUtil; |
| import com.cloud.utils.db.Attribute; |
| import com.cloud.utils.db.DB; |
| import com.cloud.utils.db.Filter; |
| import com.cloud.utils.db.GenericDaoBase; |
| import com.cloud.utils.db.GenericSearchBuilder; |
| import com.cloud.utils.db.JoinBuilder; |
| import com.cloud.utils.db.JoinBuilder.JoinType; |
| import com.cloud.utils.db.SearchBuilder; |
| import com.cloud.utils.db.SearchCriteria; |
| import com.cloud.utils.db.SearchCriteria.Func; |
| import com.cloud.utils.db.SearchCriteria.Op; |
| import com.cloud.utils.db.TransactionLegacy; |
| import com.cloud.utils.db.UpdateBuilder; |
| import com.cloud.utils.exception.CloudRuntimeException; |
| import java.util.Arrays; |
| |
| @DB |
| @TableGenerator(name = "host_req_sq", table = "op_host", pkColumnName = "id", valueColumnName = "sequence", allocationSize = 1) |
| public class HostDaoImpl extends GenericDaoBase<HostVO, Long> implements HostDao { //FIXME: , ExternalIdDao { |
| private static final Logger s_logger = Logger.getLogger(HostDaoImpl.class); |
| private static final Logger status_logger = Logger.getLogger(Status.class); |
| private static final Logger state_logger = Logger.getLogger(ResourceState.class); |
| |
| private static final String LIST_HOST_IDS_BY_COMPUTETAGS = "SELECT filtered.host_id, COUNT(filtered.tag) AS tag_count " |
| + "FROM (SELECT host_id, tag, is_tag_a_rule FROM host_tags GROUP BY host_id,tag) AS filtered " |
| + "WHERE tag IN(%s) AND is_tag_a_rule = 0 " |
| + "GROUP BY host_id " |
| + "HAVING tag_count = %s "; |
| private static final String SEPARATOR = ","; |
| private static final String LIST_CLUSTERID_FOR_HOST_TAG = "select distinct cluster_id from host join ( %s ) AS selected_hosts ON host.id = selected_hosts.host_id"; |
| private static final String GET_HOSTS_OF_ACTIVE_VMS = "select h.id " + |
| "from vm_instance vm " + |
| "join host h on (vm.host_id=h.id) " + |
| "where vm.service_offering_id= ? and vm.state not in (\"Destroyed\", \"Expunging\", \"Error\") group by h.id"; |
| private static final String GET_ORDERED_HW_VERSIONS_IN_DC = "select hypervisor_version from host " + |
| "where type = 'Routing' and status = 'Up' and hypervisor_type = ? and data_center_id = ? " + |
| "group by hypervisor_version " + |
| "order by hypervisor_version asc"; |
| |
| protected SearchBuilder<HostVO> TypePodDcStatusSearch; |
| |
| protected SearchBuilder<HostVO> IdStatusSearch; |
| protected SearchBuilder<HostVO> TypeDcSearch; |
| protected SearchBuilder<HostVO> TypeDcStatusSearch; |
| protected SearchBuilder<HostVO> TypeClusterStatusSearch; |
| protected SearchBuilder<HostVO> MsStatusSearch; |
| protected SearchBuilder<HostVO> DcPrivateIpAddressSearch; |
| protected SearchBuilder<HostVO> DcStorageIpAddressSearch; |
| protected SearchBuilder<HostVO> PublicIpAddressSearch; |
| protected SearchBuilder<HostVO> UnremovedIpAddressSearch; |
| |
| protected SearchBuilder<HostVO> GuidSearch; |
| protected SearchBuilder<HostVO> DcSearch; |
| protected SearchBuilder<HostVO> PodSearch; |
| protected SearchBuilder<HostVO> ClusterSearch; |
| protected SearchBuilder<HostVO> TypeSearch; |
| protected SearchBuilder<HostVO> StatusSearch; |
| protected SearchBuilder<HostVO> ResourceStateSearch; |
| protected SearchBuilder<HostVO> NameLikeSearch; |
| protected SearchBuilder<HostVO> NameSearch; |
| protected SearchBuilder<HostVO> hostHypervisorTypeAndVersionSearch; |
| protected SearchBuilder<HostVO> SequenceSearch; |
| protected SearchBuilder<HostVO> DirectlyConnectedSearch; |
| protected SearchBuilder<HostVO> UnmanagedDirectConnectSearch; |
| protected SearchBuilder<HostVO> UnmanagedApplianceSearch; |
| protected SearchBuilder<HostVO> MaintenanceCountSearch; |
| protected SearchBuilder<HostVO> HostTypeCountSearch; |
| protected SearchBuilder<HostVO> ResponsibleMsCountSearch; |
| protected SearchBuilder<HostVO> HostTypeZoneCountSearch; |
| protected SearchBuilder<HostVO> ClusterStatusSearch; |
| protected SearchBuilder<HostVO> TypeNameZoneSearch; |
| protected SearchBuilder<HostVO> AvailHypevisorInZone; |
| protected SearchBuilder<HostVO> ClusterHypervisorSearch; |
| |
| protected SearchBuilder<HostVO> DirectConnectSearch; |
| protected SearchBuilder<HostVO> ManagedDirectConnectSearch; |
| protected SearchBuilder<HostVO> ManagedRoutingServersSearch; |
| protected SearchBuilder<HostVO> SecondaryStorageVMSearch; |
| |
| protected GenericSearchBuilder<HostVO, Long> HostIdSearch; |
| protected GenericSearchBuilder<HostVO, Long> HostsInStatusSearch; |
| protected GenericSearchBuilder<HostVO, Long> CountRoutingByDc; |
| protected SearchBuilder<HostTransferMapVO> HostTransferSearch; |
| protected SearchBuilder<ClusterVO> ClusterManagedSearch; |
| protected SearchBuilder<HostVO> RoutingSearch; |
| |
| protected SearchBuilder<HostVO> HostsForReconnectSearch; |
| protected GenericSearchBuilder<HostVO, Long> ClustersOwnedByMSSearch; |
| protected GenericSearchBuilder<HostVO, Long> ClustersForHostsNotOwnedByAnyMSSearch; |
| protected GenericSearchBuilder<ClusterVO, Long> AllClustersSearch; |
| protected SearchBuilder<HostVO> HostsInClusterSearch; |
| |
| protected SearchBuilder<HostVO> searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag; |
| |
| protected SearchBuilder<HostTagVO> searchBuilderFindByRuleTag; |
| |
| protected Attribute _statusAttr; |
| protected Attribute _resourceStateAttr; |
| protected Attribute _msIdAttr; |
| protected Attribute _pingTimeAttr; |
| |
| @Inject |
| protected HostDetailsDao _detailsDao; |
| @Inject |
| protected HostGpuGroupsDao _hostGpuGroupsDao; |
| @Inject |
| protected VGPUTypesDao _vgpuTypesDao; |
| @Inject |
| protected HostTagsDao _hostTagsDao; |
| @Inject |
| protected HostTransferMapDao _hostTransferDao; |
| @Inject |
| protected ClusterDao _clusterDao; |
| @Inject |
| ManagementServiceConfiguration mgmtServiceConf; |
| |
| public HostDaoImpl() { |
| super(); |
| } |
| |
| @PostConstruct |
| public void init() { |
| |
| MaintenanceCountSearch = createSearchBuilder(); |
| MaintenanceCountSearch.and("cluster", MaintenanceCountSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| MaintenanceCountSearch.and("resourceState", MaintenanceCountSearch.entity().getResourceState(), SearchCriteria.Op.IN); |
| MaintenanceCountSearch.done(); |
| |
| HostTypeCountSearch = createSearchBuilder(); |
| HostTypeCountSearch.and("type", HostTypeCountSearch.entity().getType(), SearchCriteria.Op.EQ); |
| HostTypeCountSearch.done(); |
| |
| ResponsibleMsCountSearch = createSearchBuilder(); |
| ResponsibleMsCountSearch.and("managementServerId", ResponsibleMsCountSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| ResponsibleMsCountSearch.done(); |
| |
| HostTypeZoneCountSearch = createSearchBuilder(); |
| HostTypeZoneCountSearch.and("type", HostTypeZoneCountSearch.entity().getType(), SearchCriteria.Op.EQ); |
| HostTypeZoneCountSearch.and("dc", HostTypeZoneCountSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| HostTypeZoneCountSearch.and("removed", HostTypeZoneCountSearch.entity().getRemoved(), SearchCriteria.Op.NULL); |
| HostTypeZoneCountSearch.done(); |
| |
| TypePodDcStatusSearch = createSearchBuilder(); |
| HostVO entity = TypePodDcStatusSearch.entity(); |
| TypePodDcStatusSearch.and("type", entity.getType(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.and("pod", entity.getPodId(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.and("dc", entity.getDataCenterId(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.and("cluster", entity.getClusterId(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.and("status", entity.getStatus(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.and("resourceState", entity.getResourceState(), SearchCriteria.Op.EQ); |
| TypePodDcStatusSearch.done(); |
| |
| MsStatusSearch = createSearchBuilder(); |
| MsStatusSearch.and("ms", MsStatusSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| MsStatusSearch.and("type", MsStatusSearch.entity().getType(), SearchCriteria.Op.EQ); |
| MsStatusSearch.and("resourceState", MsStatusSearch.entity().getResourceState(), SearchCriteria.Op.NIN); |
| MsStatusSearch.done(); |
| |
| TypeDcSearch = createSearchBuilder(); |
| TypeDcSearch.and("type", TypeDcSearch.entity().getType(), SearchCriteria.Op.EQ); |
| TypeDcSearch.and("dc", TypeDcSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| TypeDcSearch.done(); |
| |
| SecondaryStorageVMSearch = createSearchBuilder(); |
| SecondaryStorageVMSearch.and("type", SecondaryStorageVMSearch.entity().getType(), SearchCriteria.Op.EQ); |
| SecondaryStorageVMSearch.and("dc", SecondaryStorageVMSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| SecondaryStorageVMSearch.and("status", SecondaryStorageVMSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| SecondaryStorageVMSearch.done(); |
| |
| TypeDcStatusSearch = createSearchBuilder(); |
| TypeDcStatusSearch.and("type", TypeDcStatusSearch.entity().getType(), SearchCriteria.Op.EQ); |
| TypeDcStatusSearch.and("dc", TypeDcStatusSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| TypeDcStatusSearch.and("status", TypeDcStatusSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| TypeDcStatusSearch.and("resourceState", TypeDcStatusSearch.entity().getResourceState(), SearchCriteria.Op.EQ); |
| TypeDcStatusSearch.done(); |
| |
| TypeClusterStatusSearch = createSearchBuilder(); |
| TypeClusterStatusSearch.and("type", TypeClusterStatusSearch.entity().getType(), SearchCriteria.Op.EQ); |
| TypeClusterStatusSearch.and("cluster", TypeClusterStatusSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| TypeClusterStatusSearch.and("status", TypeClusterStatusSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| TypeClusterStatusSearch.and("resourceState", TypeClusterStatusSearch.entity().getResourceState(), SearchCriteria.Op.EQ); |
| TypeClusterStatusSearch.done(); |
| |
| IdStatusSearch = createSearchBuilder(); |
| IdStatusSearch.and("id", IdStatusSearch.entity().getId(), SearchCriteria.Op.EQ); |
| IdStatusSearch.and("states", IdStatusSearch.entity().getStatus(), SearchCriteria.Op.IN); |
| IdStatusSearch.done(); |
| |
| DcPrivateIpAddressSearch = createSearchBuilder(); |
| DcPrivateIpAddressSearch.and("privateIpAddress", DcPrivateIpAddressSearch.entity().getPrivateIpAddress(), SearchCriteria.Op.EQ); |
| DcPrivateIpAddressSearch.and("dc", DcPrivateIpAddressSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| DcPrivateIpAddressSearch.done(); |
| |
| DcStorageIpAddressSearch = createSearchBuilder(); |
| DcStorageIpAddressSearch.and("storageIpAddress", DcStorageIpAddressSearch.entity().getStorageIpAddress(), SearchCriteria.Op.EQ); |
| DcStorageIpAddressSearch.and("dc", DcStorageIpAddressSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| DcStorageIpAddressSearch.done(); |
| |
| PublicIpAddressSearch = createSearchBuilder(); |
| PublicIpAddressSearch.and("publicIpAddress", PublicIpAddressSearch.entity().getPublicIpAddress(), SearchCriteria.Op.EQ); |
| PublicIpAddressSearch.done(); |
| |
| UnremovedIpAddressSearch = createSearchBuilder(); |
| UnremovedIpAddressSearch.and("removed", UnremovedIpAddressSearch.entity().getRemoved(), Op.NULL); // We don't want any removed hosts |
| UnremovedIpAddressSearch.and().op("publicIpAddress", UnremovedIpAddressSearch.entity().getPublicIpAddress(), SearchCriteria.Op.EQ); |
| UnremovedIpAddressSearch.or("privateIpAddress", UnremovedIpAddressSearch.entity().getPrivateIpAddress(), SearchCriteria.Op.EQ); |
| UnremovedIpAddressSearch.cp(); |
| UnremovedIpAddressSearch.done(); |
| |
| GuidSearch = createSearchBuilder(); |
| GuidSearch.and("guid", GuidSearch.entity().getGuid(), SearchCriteria.Op.EQ); |
| GuidSearch.done(); |
| |
| DcSearch = createSearchBuilder(); |
| DcSearch.and("dc", DcSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| DcSearch.and("hypervisorType", DcSearch.entity().getHypervisorType(), Op.EQ); |
| DcSearch.and("type", DcSearch.entity().getType(), Op.EQ); |
| DcSearch.and("status", DcSearch.entity().getStatus(), Op.EQ); |
| DcSearch.and("resourceState", DcSearch.entity().getResourceState(), Op.EQ); |
| DcSearch.done(); |
| |
| ClusterStatusSearch = createSearchBuilder(); |
| ClusterStatusSearch.and("cluster", ClusterStatusSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| ClusterStatusSearch.and("status", ClusterStatusSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| ClusterStatusSearch.done(); |
| |
| TypeNameZoneSearch = createSearchBuilder(); |
| TypeNameZoneSearch.and("name", TypeNameZoneSearch.entity().getName(), SearchCriteria.Op.EQ); |
| TypeNameZoneSearch.and("type", TypeNameZoneSearch.entity().getType(), SearchCriteria.Op.EQ); |
| TypeNameZoneSearch.and("zoneId", TypeNameZoneSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| TypeNameZoneSearch.done(); |
| |
| PodSearch = createSearchBuilder(); |
| PodSearch.and("podId", PodSearch.entity().getPodId(), SearchCriteria.Op.EQ); |
| PodSearch.done(); |
| |
| ClusterSearch = createSearchBuilder(); |
| ClusterSearch.and("clusterId", ClusterSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| ClusterSearch.done(); |
| |
| TypeSearch = createSearchBuilder(); |
| TypeSearch.and("type", TypeSearch.entity().getType(), SearchCriteria.Op.EQ); |
| TypeSearch.done(); |
| |
| StatusSearch = createSearchBuilder(); |
| StatusSearch.and("status", StatusSearch.entity().getStatus(), SearchCriteria.Op.IN); |
| StatusSearch.done(); |
| |
| ResourceStateSearch = createSearchBuilder(); |
| ResourceStateSearch.and("resourceState", ResourceStateSearch.entity().getResourceState(), SearchCriteria.Op.IN); |
| ResourceStateSearch.done(); |
| |
| NameLikeSearch = createSearchBuilder(); |
| NameLikeSearch.and("name", NameLikeSearch.entity().getName(), SearchCriteria.Op.LIKE); |
| NameLikeSearch.done(); |
| |
| NameSearch = createSearchBuilder(); |
| NameSearch.and("name", NameSearch.entity().getName(), SearchCriteria.Op.EQ); |
| NameSearch.done(); |
| |
| hostHypervisorTypeAndVersionSearch = createSearchBuilder(); |
| hostHypervisorTypeAndVersionSearch.and("hypervisorType", hostHypervisorTypeAndVersionSearch.entity().getHypervisorType(), SearchCriteria.Op.EQ); |
| hostHypervisorTypeAndVersionSearch.and("hypervisorVersion", hostHypervisorTypeAndVersionSearch.entity().getHypervisorVersion(), SearchCriteria.Op.EQ); |
| hostHypervisorTypeAndVersionSearch.and("type", hostHypervisorTypeAndVersionSearch.entity().getType(), SearchCriteria.Op.EQ); |
| hostHypervisorTypeAndVersionSearch.and("status", hostHypervisorTypeAndVersionSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| hostHypervisorTypeAndVersionSearch.done(); |
| |
| SequenceSearch = createSearchBuilder(); |
| SequenceSearch.and("id", SequenceSearch.entity().getId(), SearchCriteria.Op.EQ); |
| // SequenceSearch.addRetrieve("sequence", SequenceSearch.entity().getSequence()); |
| SequenceSearch.done(); |
| |
| DirectlyConnectedSearch = createSearchBuilder(); |
| DirectlyConnectedSearch.and("resource", DirectlyConnectedSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| DirectlyConnectedSearch.and("ms", DirectlyConnectedSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| DirectlyConnectedSearch.and("statuses", DirectlyConnectedSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| DirectlyConnectedSearch.and("resourceState", DirectlyConnectedSearch.entity().getResourceState(), SearchCriteria.Op.NOTIN); |
| DirectlyConnectedSearch.done(); |
| |
| ClusterHypervisorSearch = createSearchBuilder(); |
| ClusterHypervisorSearch.and("clusterId", ClusterHypervisorSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| ClusterHypervisorSearch.and("hypervisor", ClusterHypervisorSearch.entity().getHypervisorType(), SearchCriteria.Op.EQ); |
| ClusterHypervisorSearch.and("type", ClusterHypervisorSearch.entity().getType(), SearchCriteria.Op.EQ); |
| ClusterHypervisorSearch.and("status", ClusterHypervisorSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| ClusterHypervisorSearch.done(); |
| |
| UnmanagedDirectConnectSearch = createSearchBuilder(); |
| UnmanagedDirectConnectSearch.and("resource", UnmanagedDirectConnectSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| UnmanagedDirectConnectSearch.and("server", UnmanagedDirectConnectSearch.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| UnmanagedDirectConnectSearch.and("lastPinged", UnmanagedDirectConnectSearch.entity().getLastPinged(), SearchCriteria.Op.LTEQ); |
| UnmanagedDirectConnectSearch.and("resourceStates", UnmanagedDirectConnectSearch.entity().getResourceState(), SearchCriteria.Op.NIN); |
| UnmanagedDirectConnectSearch.and("clusterIn", UnmanagedDirectConnectSearch.entity().getClusterId(), SearchCriteria.Op.IN); |
| try { |
| HostTransferSearch = _hostTransferDao.createSearchBuilder(); |
| } catch (Throwable e) { |
| s_logger.debug("error", e); |
| } |
| HostTransferSearch.and("id", HostTransferSearch.entity().getId(), SearchCriteria.Op.NULL); |
| UnmanagedDirectConnectSearch.join("hostTransferSearch", HostTransferSearch, HostTransferSearch.entity().getId(), UnmanagedDirectConnectSearch.entity().getId(), |
| JoinType.LEFTOUTER); |
| ClusterManagedSearch = _clusterDao.createSearchBuilder(); |
| ClusterManagedSearch.and("managed", ClusterManagedSearch.entity().getManagedState(), SearchCriteria.Op.EQ); |
| UnmanagedDirectConnectSearch.join("ClusterManagedSearch", ClusterManagedSearch, ClusterManagedSearch.entity().getId(), UnmanagedDirectConnectSearch.entity().getClusterId(), |
| JoinType.INNER); |
| UnmanagedDirectConnectSearch.done(); |
| |
| DirectConnectSearch = createSearchBuilder(); |
| DirectConnectSearch.and("resource", DirectConnectSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| DirectConnectSearch.and("id", DirectConnectSearch.entity().getId(), SearchCriteria.Op.EQ); |
| DirectConnectSearch.and().op("nullserver", DirectConnectSearch.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| DirectConnectSearch.or("server", DirectConnectSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| DirectConnectSearch.cp(); |
| DirectConnectSearch.done(); |
| |
| UnmanagedApplianceSearch = createSearchBuilder(); |
| UnmanagedApplianceSearch.and("resource", UnmanagedApplianceSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| UnmanagedApplianceSearch.and("server", UnmanagedApplianceSearch.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| UnmanagedApplianceSearch.and("types", UnmanagedApplianceSearch.entity().getType(), SearchCriteria.Op.IN); |
| UnmanagedApplianceSearch.and("lastPinged", UnmanagedApplianceSearch.entity().getLastPinged(), SearchCriteria.Op.LTEQ); |
| UnmanagedApplianceSearch.done(); |
| |
| AvailHypevisorInZone = createSearchBuilder(); |
| AvailHypevisorInZone.and("zoneId", AvailHypevisorInZone.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| AvailHypevisorInZone.and("hostId", AvailHypevisorInZone.entity().getId(), SearchCriteria.Op.NEQ); |
| AvailHypevisorInZone.and("type", AvailHypevisorInZone.entity().getType(), SearchCriteria.Op.EQ); |
| AvailHypevisorInZone.groupBy(AvailHypevisorInZone.entity().getHypervisorType()); |
| AvailHypevisorInZone.done(); |
| |
| HostsInStatusSearch = createSearchBuilder(Long.class); |
| HostsInStatusSearch.selectFields(HostsInStatusSearch.entity().getId()); |
| HostsInStatusSearch.and("dc", HostsInStatusSearch.entity().getDataCenterId(), Op.EQ); |
| HostsInStatusSearch.and("pod", HostsInStatusSearch.entity().getPodId(), Op.EQ); |
| HostsInStatusSearch.and("cluster", HostsInStatusSearch.entity().getClusterId(), Op.EQ); |
| HostsInStatusSearch.and("type", HostsInStatusSearch.entity().getType(), Op.EQ); |
| HostsInStatusSearch.and("statuses", HostsInStatusSearch.entity().getStatus(), Op.IN); |
| HostsInStatusSearch.done(); |
| |
| CountRoutingByDc = createSearchBuilder(Long.class); |
| CountRoutingByDc.select(null, Func.COUNT, null); |
| CountRoutingByDc.and("dc", CountRoutingByDc.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| CountRoutingByDc.and("type", CountRoutingByDc.entity().getType(), SearchCriteria.Op.EQ); |
| CountRoutingByDc.and("status", CountRoutingByDc.entity().getStatus(), SearchCriteria.Op.EQ); |
| CountRoutingByDc.done(); |
| |
| ManagedDirectConnectSearch = createSearchBuilder(); |
| ManagedDirectConnectSearch.and("resource", ManagedDirectConnectSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| ManagedDirectConnectSearch.and("server", ManagedDirectConnectSearch.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| ManagedDirectConnectSearch.done(); |
| |
| ManagedRoutingServersSearch = createSearchBuilder(); |
| ManagedRoutingServersSearch.and("server", ManagedRoutingServersSearch.entity().getManagementServerId(), SearchCriteria.Op.NNULL); |
| ManagedRoutingServersSearch.and("type", ManagedRoutingServersSearch.entity().getType(), SearchCriteria.Op.EQ); |
| ManagedRoutingServersSearch.done(); |
| |
| RoutingSearch = createSearchBuilder(); |
| RoutingSearch.and("type", RoutingSearch.entity().getType(), SearchCriteria.Op.EQ); |
| RoutingSearch.done(); |
| |
| HostsForReconnectSearch = createSearchBuilder(); |
| HostsForReconnectSearch.and("resource", HostsForReconnectSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| HostsForReconnectSearch.and("server", HostsForReconnectSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| HostsForReconnectSearch.and("lastPinged", HostsForReconnectSearch.entity().getLastPinged(), SearchCriteria.Op.LTEQ); |
| HostsForReconnectSearch.and("resourceStates", HostsForReconnectSearch.entity().getResourceState(), SearchCriteria.Op.NIN); |
| HostsForReconnectSearch.and("cluster", HostsForReconnectSearch.entity().getClusterId(), SearchCriteria.Op.NNULL); |
| HostsForReconnectSearch.and("status", HostsForReconnectSearch.entity().getStatus(), SearchCriteria.Op.IN); |
| HostsForReconnectSearch.done(); |
| |
| ClustersOwnedByMSSearch = createSearchBuilder(Long.class); |
| ClustersOwnedByMSSearch.select(null, Func.DISTINCT, ClustersOwnedByMSSearch.entity().getClusterId()); |
| ClustersOwnedByMSSearch.and("resource", ClustersOwnedByMSSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| ClustersOwnedByMSSearch.and("cluster", ClustersOwnedByMSSearch.entity().getClusterId(), SearchCriteria.Op.NNULL); |
| ClustersOwnedByMSSearch.and("server", ClustersOwnedByMSSearch.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| ClustersOwnedByMSSearch.done(); |
| |
| ClustersForHostsNotOwnedByAnyMSSearch = createSearchBuilder(Long.class); |
| ClustersForHostsNotOwnedByAnyMSSearch.select(null, Func.DISTINCT, ClustersForHostsNotOwnedByAnyMSSearch.entity().getClusterId()); |
| ClustersForHostsNotOwnedByAnyMSSearch.and("resource", ClustersForHostsNotOwnedByAnyMSSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| ClustersForHostsNotOwnedByAnyMSSearch.and("cluster", ClustersForHostsNotOwnedByAnyMSSearch.entity().getClusterId(), SearchCriteria.Op.NNULL); |
| ClustersForHostsNotOwnedByAnyMSSearch.and("server", ClustersForHostsNotOwnedByAnyMSSearch.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| |
| ClusterManagedSearch = _clusterDao.createSearchBuilder(); |
| ClusterManagedSearch.and("managed", ClusterManagedSearch.entity().getManagedState(), SearchCriteria.Op.EQ); |
| ClustersForHostsNotOwnedByAnyMSSearch.join("ClusterManagedSearch", ClusterManagedSearch, ClusterManagedSearch.entity().getId(), |
| ClustersForHostsNotOwnedByAnyMSSearch.entity().getClusterId(), JoinType.INNER); |
| |
| ClustersForHostsNotOwnedByAnyMSSearch.done(); |
| |
| AllClustersSearch = _clusterDao.createSearchBuilder(Long.class); |
| AllClustersSearch.select(null, Func.NATIVE, AllClustersSearch.entity().getId()); |
| AllClustersSearch.and("managed", AllClustersSearch.entity().getManagedState(), SearchCriteria.Op.EQ); |
| AllClustersSearch.done(); |
| |
| HostsInClusterSearch = createSearchBuilder(); |
| HostsInClusterSearch.and("resource", HostsInClusterSearch.entity().getResource(), SearchCriteria.Op.NNULL); |
| HostsInClusterSearch.and("cluster", HostsInClusterSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| HostsInClusterSearch.and("server", HostsInClusterSearch.entity().getManagementServerId(), SearchCriteria.Op.NNULL); |
| HostsInClusterSearch.done(); |
| |
| HostIdSearch = createSearchBuilder(Long.class); |
| HostIdSearch.selectFields(HostIdSearch.entity().getId()); |
| HostIdSearch.and("dataCenterId", HostIdSearch.entity().getDataCenterId(), Op.EQ); |
| HostIdSearch.done(); |
| |
| searchBuilderFindByRuleTag = _hostTagsDao.createSearchBuilder(); |
| searchBuilderFindByRuleTag.and("is_tag_a_rule", searchBuilderFindByRuleTag.entity().getIsTagARule(), Op.EQ); |
| searchBuilderFindByRuleTag.or("tagDoesNotExist", searchBuilderFindByRuleTag.entity().getIsTagARule(), Op.NULL); |
| |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag = createSearchBuilder(); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.and("id", searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getId(), Op.EQ); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.and("type", searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getType(), Op.EQ); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.and("cluster_id", searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getClusterId(), Op.EQ); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.and("pod_id", searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getPodId(), Op.EQ); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.and("data_center_id", searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getDataCenterId(), Op.EQ); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.join("id", searchBuilderFindByRuleTag, searchBuilderFindByRuleTag.entity().getHostId(), |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.entity().getId(), JoinType.LEFTOUTER); |
| |
| searchBuilderFindByRuleTag.done(); |
| searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.done(); |
| |
| _statusAttr = _allAttributes.get("status"); |
| _msIdAttr = _allAttributes.get("managementServerId"); |
| _pingTimeAttr = _allAttributes.get("lastPinged"); |
| _resourceStateAttr = _allAttributes.get("resourceState"); |
| |
| assert (_statusAttr != null && _msIdAttr != null && _pingTimeAttr != null) : "Couldn't find one of these attributes"; |
| } |
| |
| @Override |
| public long countBy(long clusterId, ResourceState... states) { |
| SearchCriteria<HostVO> sc = MaintenanceCountSearch.create(); |
| |
| sc.setParameters("resourceState", (Object[])states); |
| sc.setParameters("cluster", clusterId); |
| |
| List<HostVO> hosts = listBy(sc); |
| return hosts.size(); |
| } |
| |
| @Override |
| public Integer countAllByType(final Host.Type type) { |
| SearchCriteria<HostVO> sc = HostTypeCountSearch.create(); |
| sc.setParameters("type", type); |
| return getCount(sc); |
| } |
| |
| @Override |
| public Integer countAllByTypeInZone(long zoneId, Type type) { |
| SearchCriteria<HostVO> sc = HostTypeCountSearch.create(); |
| sc.setParameters("type", type); |
| sc.setParameters("dc", zoneId); |
| return getCount(sc); |
| } |
| |
| @Override |
| public List<HostVO> listByDataCenterId(long id) { |
| return listByDataCenterIdAndState(id, ResourceState.Enabled); |
| } |
| |
| @Override |
| public List<HostVO> listByDataCenterIdAndState(long id, ResourceState state) { |
| SearchCriteria<HostVO> sc = scHostsFromZoneUpRouting(id); |
| sc.setParameters("resourceState", state); |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> listDisabledByDataCenterId(long id) { |
| return listByDataCenterIdAndState(id, ResourceState.Disabled); |
| } |
| |
| private SearchCriteria<HostVO> scHostsFromZoneUpRouting(long id) { |
| SearchCriteria<HostVO> sc = DcSearch.create(); |
| sc.setParameters("dc", id); |
| sc.setParameters("status", Status.Up); |
| sc.setParameters("type", Host.Type.Routing); |
| return sc; |
| } |
| |
| @Override |
| public List<HostVO> listByDataCenterIdAndHypervisorType(long zoneId, Hypervisor.HypervisorType hypervisorType) { |
| SearchBuilder<ClusterVO> clusterSearch = _clusterDao.createSearchBuilder(); |
| |
| clusterSearch.and("allocationState", clusterSearch.entity().getAllocationState(), SearchCriteria.Op.EQ); |
| clusterSearch.and("hypervisorType", clusterSearch.entity().getHypervisorType(), SearchCriteria.Op.EQ); |
| |
| SearchBuilder<HostVO> hostSearch = createSearchBuilder(); |
| |
| hostSearch.and("dc", hostSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("type", hostSearch.entity().getType(), Op.EQ); |
| hostSearch.and("status", hostSearch.entity().getStatus(), Op.EQ); |
| hostSearch.and("resourceState", hostSearch.entity().getResourceState(), Op.EQ); |
| |
| hostSearch.join("clusterSearch", clusterSearch, hostSearch.entity().getClusterId(), clusterSearch.entity().getId(), JoinBuilder.JoinType.INNER); |
| |
| hostSearch.done(); |
| |
| SearchCriteria<HostVO> sc = hostSearch.create(); |
| |
| sc.setParameters("dc", zoneId); |
| sc.setParameters("type", Host.Type.Routing); |
| sc.setParameters("status", Status.Up); |
| sc.setParameters("resourceState", ResourceState.Enabled); |
| |
| sc.setJoinParameters("clusterSearch", "allocationState", Grouping.AllocationState.Enabled); |
| sc.setJoinParameters("clusterSearch", "hypervisorType", hypervisorType.toString()); |
| |
| return listBy(sc); |
| } |
| |
| @Override |
| public HostVO findByGuid(String guid) { |
| SearchCriteria<HostVO> sc = GuidSearch.create("guid", guid); |
| return findOneBy(sc); |
| } |
| |
| /* |
| * Find hosts which is in Disconnected, Down, Alert and ping timeout and server is not null, set server to null |
| */ |
| private void resetHosts(long managementServerId, long lastPingSecondsAfter) { |
| SearchCriteria<HostVO> sc = HostsForReconnectSearch.create(); |
| sc.setParameters("server", managementServerId); |
| sc.setParameters("lastPinged", lastPingSecondsAfter); |
| sc.setParameters("status", Status.Disconnected, Status.Down, Status.Alert); |
| |
| StringBuilder sb = new StringBuilder(); |
| List<HostVO> hosts = lockRows(sc, null, true); // exclusive lock |
| for (HostVO host : hosts) { |
| host.setManagementServerId(null); |
| update(host.getId(), host); |
| sb.append(host.getId()); |
| sb.append(" "); |
| } |
| |
| if (s_logger.isTraceEnabled()) { |
| s_logger.trace("Following hosts got reset: " + sb.toString()); |
| } |
| } |
| |
| /* |
| * Returns a list of cluster owned by @managementServerId |
| */ |
| private List<Long> findClustersOwnedByManagementServer(long managementServerId) { |
| SearchCriteria<Long> sc = ClustersOwnedByMSSearch.create(); |
| sc.setParameters("server", managementServerId); |
| |
| List<Long> clusters = customSearch(sc, null); |
| return clusters; |
| } |
| |
| /* |
| * Returns clusters based on the list of hosts not owned by any MS |
| */ |
| private List<Long> findClustersForHostsNotOwnedByAnyManagementServer() { |
| SearchCriteria<Long> sc = ClustersForHostsNotOwnedByAnyMSSearch.create(); |
| sc.setJoinParameters("ClusterManagedSearch", "managed", Managed.ManagedState.Managed); |
| |
| List<Long> clusters = customSearch(sc, null); |
| return clusters; |
| } |
| |
| /** |
| * This determines if hosts belonging to cluster(@clusterId) are up for grabs |
| * |
| * This is used for handling following cases: |
| * 1. First host added in cluster |
| * 2. During MS restart all hosts in a cluster are without any MS |
| */ |
| private boolean canOwnCluster(long clusterId) { |
| SearchCriteria<HostVO> sc = HostsInClusterSearch.create(); |
| sc.setParameters("cluster", clusterId); |
| |
| List<HostVO> hosts = search(sc, null); |
| boolean ownCluster = (hosts == null || hosts.size() == 0); |
| |
| return ownCluster; |
| } |
| |
| @Override |
| @DB |
| public List<HostVO> findAndUpdateDirectAgentToLoad(long lastPingSecondsAfter, Long limit, long managementServerId) { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Resetting hosts suitable for reconnect"); |
| } |
| // reset hosts that are suitable candidates for reconnect |
| resetHosts(managementServerId, lastPingSecondsAfter); |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Completed resetting hosts suitable for reconnect"); |
| } |
| |
| List<HostVO> assignedHosts = new ArrayList<HostVO>(); |
| |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Acquiring hosts for clusters already owned by this management server"); |
| } |
| List<Long> clusters = findClustersOwnedByManagementServer(managementServerId); |
| txn.start(); |
| if (clusters.size() > 0) { |
| // handle clusters already owned by @managementServerId |
| SearchCriteria<HostVO> sc = UnmanagedDirectConnectSearch.create(); |
| sc.setParameters("lastPinged", lastPingSecondsAfter); |
| sc.setJoinParameters("ClusterManagedSearch", "managed", Managed.ManagedState.Managed); |
| sc.setParameters("clusterIn", clusters.toArray()); |
| List<HostVO> unmanagedHosts = lockRows(sc, new Filter(HostVO.class, "clusterId", true, 0L, limit), true); // host belongs to clusters owned by @managementServerId |
| StringBuilder sb = new StringBuilder(); |
| for (HostVO host : unmanagedHosts) { |
| host.setManagementServerId(managementServerId); |
| update(host.getId(), host); |
| assignedHosts.add(host); |
| sb.append(host.getId()); |
| sb.append(" "); |
| } |
| if (s_logger.isTraceEnabled()) { |
| s_logger.trace("Following hosts got acquired for clusters already owned: " + sb.toString()); |
| } |
| } |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Completed acquiring hosts for clusters already owned by this management server"); |
| } |
| |
| if (assignedHosts.size() < limit) { |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Acquiring hosts for clusters not owned by any management server"); |
| } |
| // for remaining hosts not owned by any MS check if they can be owned (by owning full cluster) |
| clusters = findClustersForHostsNotOwnedByAnyManagementServer(); |
| List<Long> updatedClusters = clusters; |
| if (clusters.size() > limit) { |
| updatedClusters = clusters.subList(0, limit.intValue()); |
| } |
| if (updatedClusters.size() > 0) { |
| SearchCriteria<HostVO> sc = UnmanagedDirectConnectSearch.create(); |
| sc.setParameters("lastPinged", lastPingSecondsAfter); |
| sc.setJoinParameters("ClusterManagedSearch", "managed", Managed.ManagedState.Managed); |
| sc.setParameters("clusterIn", updatedClusters.toArray()); |
| List<HostVO> unmanagedHosts = lockRows(sc, null, true); |
| |
| // group hosts based on cluster |
| Map<Long, List<HostVO>> hostMap = new HashMap<Long, List<HostVO>>(); |
| for (HostVO host : unmanagedHosts) { |
| if (hostMap.get(host.getClusterId()) == null) { |
| hostMap.put(host.getClusterId(), new ArrayList<HostVO>()); |
| } |
| hostMap.get(host.getClusterId()).add(host); |
| } |
| |
| StringBuilder sb = new StringBuilder(); |
| for (Long clusterId : hostMap.keySet()) { |
| if (canOwnCluster(clusterId)) { // cluster is not owned by any other MS, so @managementServerId can own it |
| List<HostVO> hostList = hostMap.get(clusterId); |
| for (HostVO host : hostList) { |
| host.setManagementServerId(managementServerId); |
| update(host.getId(), host); |
| assignedHosts.add(host); |
| sb.append(host.getId()); |
| sb.append(" "); |
| } |
| } |
| if (assignedHosts.size() > limit) { |
| break; |
| } |
| } |
| if (s_logger.isTraceEnabled()) { |
| s_logger.trace("Following hosts got acquired from newly owned clusters: " + sb.toString()); |
| } |
| } |
| if (s_logger.isDebugEnabled()) { |
| s_logger.debug("Completed acquiring hosts for clusters not owned by any management server"); |
| } |
| } |
| txn.commit(); |
| |
| return assignedHosts; |
| } |
| |
| @Override |
| @DB |
| public List<HostVO> findAndUpdateApplianceToLoad(long lastPingSecondsAfter, long managementServerId) { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| |
| txn.start(); |
| SearchCriteria<HostVO> sc = UnmanagedApplianceSearch.create(); |
| sc.setParameters("lastPinged", lastPingSecondsAfter); |
| sc.setParameters("types", Type.ExternalDhcp, Type.ExternalFirewall, Type.ExternalLoadBalancer, Type.BaremetalDhcp, Type.BaremetalPxe, Type.TrafficMonitor, |
| Type.L2Networking, Type.NetScalerControlCenter); |
| List<HostVO> hosts = lockRows(sc, null, true); |
| |
| for (HostVO host : hosts) { |
| host.setManagementServerId(managementServerId); |
| update(host.getId(), host); |
| } |
| |
| txn.commit(); |
| |
| return hosts; |
| } |
| |
| @Override |
| public void markHostsAsDisconnected(long msId, long lastPing) { |
| SearchCriteria<HostVO> sc = MsStatusSearch.create(); |
| sc.setParameters("ms", msId); |
| |
| HostVO host = createForUpdate(); |
| host.setLastPinged(lastPing); |
| host.setDisconnectedOn(new Date()); |
| UpdateBuilder ub = getUpdateBuilder(host); |
| ub.set(host, "status", Status.Disconnected); |
| |
| update(ub, sc, null); |
| |
| sc = MsStatusSearch.create(); |
| sc.setParameters("ms", msId); |
| |
| host = createForUpdate(); |
| host.setManagementServerId(null); |
| host.setLastPinged(lastPing); |
| host.setDisconnectedOn(new Date()); |
| ub = getUpdateBuilder(host); |
| update(ub, sc, null); |
| } |
| |
| @Override |
| public List<HostVO> listByHostTag(Host.Type type, Long clusterId, Long podId, long dcId, String hostTag) { |
| SearchBuilder<HostVO> hostSearch = createSearchBuilder(); |
| HostVO entity = hostSearch.entity(); |
| hostSearch.and("type", entity.getType(), SearchCriteria.Op.EQ); |
| hostSearch.and("pod", entity.getPodId(), SearchCriteria.Op.EQ); |
| hostSearch.and("dc", entity.getDataCenterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("cluster", entity.getClusterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("status", entity.getStatus(), SearchCriteria.Op.EQ); |
| hostSearch.and("resourceState", entity.getResourceState(), SearchCriteria.Op.EQ); |
| |
| SearchCriteria<HostVO> sc = hostSearch.create(); |
| sc.setParameters("type", type.toString()); |
| if (podId != null) { |
| sc.setParameters("pod", podId); |
| } |
| if (clusterId != null) { |
| sc.setParameters("cluster", clusterId); |
| } |
| sc.setParameters("dc", dcId); |
| sc.setParameters("status", Status.Up.toString()); |
| sc.setParameters("resourceState", ResourceState.Enabled.toString()); |
| |
| List<HostVO> tmpHosts = listBy(sc); |
| List<HostVO> correctHostsByHostTags = new ArrayList(); |
| List<Long> hostIdsByComputeOffTags = findHostByComputeOfferings(hostTag); |
| |
| tmpHosts.forEach((host) -> { if(hostIdsByComputeOffTags.contains(host.getId())) correctHostsByHostTags.add(host);}); |
| |
| return correctHostsByHostTags; |
| } |
| |
| @Override |
| public List<HostVO> listAllUpAndEnabledNonHAHosts(Type type, Long clusterId, Long podId, long dcId, String haTag) { |
| SearchBuilder<HostTagVO> hostTagSearch = _hostTagsDao.createSearchBuilder(); |
| hostTagSearch.and(); |
| hostTagSearch.op("isTagARule", hostTagSearch.entity().getIsTagARule(), Op.EQ); |
| hostTagSearch.or("tagDoesNotExist", hostTagSearch.entity().getIsTagARule(), Op.NULL); |
| hostTagSearch.cp(); |
| if (haTag != null && !haTag.isEmpty()) { |
| hostTagSearch.and().op("tag", hostTagSearch.entity().getTag(), SearchCriteria.Op.NEQ); |
| hostTagSearch.or("tagNull", hostTagSearch.entity().getTag(), SearchCriteria.Op.NULL); |
| hostTagSearch.cp(); |
| } |
| |
| SearchBuilder<HostVO> hostSearch = createSearchBuilder(); |
| |
| hostSearch.and("type", hostSearch.entity().getType(), SearchCriteria.Op.EQ); |
| hostSearch.and("clusterId", hostSearch.entity().getClusterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("podId", hostSearch.entity().getPodId(), SearchCriteria.Op.EQ); |
| hostSearch.and("zoneId", hostSearch.entity().getDataCenterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("status", hostSearch.entity().getStatus(), SearchCriteria.Op.EQ); |
| hostSearch.and("resourceState", hostSearch.entity().getResourceState(), SearchCriteria.Op.EQ); |
| |
| |
| hostSearch.join("hostTagSearch", hostTagSearch, hostSearch.entity().getId(), hostTagSearch.entity().getHostId(), JoinBuilder.JoinType.LEFTOUTER); |
| |
| |
| SearchCriteria<HostVO> sc = hostSearch.create(); |
| |
| sc.setJoinParameters("hostTagSearch", "isTagARule", false); |
| |
| if (haTag != null && !haTag.isEmpty()) { |
| sc.setJoinParameters("hostTagSearch", "tag", haTag); |
| } |
| |
| if (type != null) { |
| sc.setParameters("type", type); |
| } |
| |
| if (clusterId != null) { |
| sc.setParameters("clusterId", clusterId); |
| } |
| |
| if (podId != null) { |
| sc.setParameters("podId", podId); |
| } |
| |
| sc.setParameters("zoneId", dcId); |
| sc.setParameters("status", Status.Up); |
| sc.setParameters("resourceState", ResourceState.Enabled); |
| |
| return listBy(sc); |
| } |
| |
| @Override |
| public void loadDetails(HostVO host) { |
| Map<String, String> details = _detailsDao.findDetails(host.getId()); |
| host.setDetails(details); |
| } |
| |
| @Override |
| public void loadHostTags(HostVO host) { |
| List<HostTagVO> hostTagVOList = _hostTagsDao.getHostTags(host.getId()); |
| if (CollectionUtils.isNotEmpty(hostTagVOList)) { |
| List<String> hostTagList = hostTagVOList.parallelStream().map(HostTagVO::getTag).collect(Collectors.toList()); |
| host.setHostTags(hostTagList, hostTagVOList.get(0).getIsTagARule()); |
| } else { |
| host.setHostTags(null, null); |
| } |
| } |
| |
| @DB |
| @Override |
| public List<HostVO> findLostHosts(long timeout) { |
| List<HostVO> result = new ArrayList<HostVO>(); |
| String sql = "select h.id from host h left join cluster c on h.cluster_id=c.id where h.mgmt_server_id is not null and h.last_ping < ? and h.status in ('Up', 'Updating', 'Disconnected', 'Connecting') and h.type not in ('ExternalFirewall', 'ExternalLoadBalancer', 'TrafficMonitor', 'SecondaryStorage', 'LocalSecondaryStorage', 'L2Networking') and (h.cluster_id is null or c.managed_state = 'Managed') ;"; |
| try (TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| PreparedStatement pstmt = txn.prepareStatement(sql);) { |
| pstmt.setLong(1, timeout); |
| try (ResultSet rs = pstmt.executeQuery();) { |
| while (rs.next()) { |
| long id = rs.getLong(1); //ID column |
| result.add(findById(id)); |
| } |
| } |
| } catch (SQLException e) { |
| s_logger.warn("Exception: ", e); |
| } |
| return result; |
| } |
| |
| @Override |
| public void saveDetails(HostVO host) { |
| Map<String, String> details = host.getDetails(); |
| if (details == null) { |
| return; |
| } |
| _detailsDao.persist(host.getId(), details); |
| } |
| |
| protected void saveHostTags(HostVO host) { |
| List<String> hostTags = host.getHostTags(); |
| if (CollectionUtils.isEmpty(hostTags)) { |
| return; |
| } |
| _hostTagsDao.persist(host.getId(), hostTags, host.getIsTagARule()); |
| } |
| |
| protected void saveGpuRecords(HostVO host) { |
| HashMap<String, HashMap<String, VgpuTypesInfo>> groupDetails = host.getGpuGroupDetails(); |
| if (groupDetails != null) { |
| // Create/Update GPU group entries |
| _hostGpuGroupsDao.persist(host.getId(), new ArrayList<String>(groupDetails.keySet())); |
| // Create/Update VGPU types entries |
| _vgpuTypesDao.persist(host.getId(), groupDetails); |
| } |
| } |
| |
| @Override |
| @DB |
| public HostVO persist(HostVO host) { |
| final String InsertSequenceSql = "INSERT INTO op_host(id) VALUES(?)"; |
| |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| txn.start(); |
| |
| HostVO dbHost = super.persist(host); |
| |
| try { |
| PreparedStatement pstmt = txn.prepareAutoCloseStatement(InsertSequenceSql); |
| pstmt.setLong(1, dbHost.getId()); |
| pstmt.executeUpdate(); |
| } catch (SQLException e) { |
| throw new CloudRuntimeException("Unable to persist the sequence number for this host"); |
| } |
| |
| saveDetails(host); |
| loadDetails(dbHost); |
| saveHostTags(host); |
| loadHostTags(dbHost); |
| saveGpuRecords(host); |
| |
| txn.commit(); |
| |
| return dbHost; |
| } |
| |
| @Override |
| @DB |
| public boolean update(Long hostId, HostVO host) { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| txn.start(); |
| |
| boolean persisted = super.update(hostId, host); |
| if (!persisted) { |
| return persisted; |
| } |
| |
| saveDetails(host); |
| saveHostTags(host); |
| saveGpuRecords(host); |
| |
| txn.commit(); |
| |
| return persisted; |
| } |
| |
| @Override |
| @DB |
| public List<RunningHostCountInfo> getRunningHostCounts(Date cutTime) { |
| String sql = "select * from (" + "select h.data_center_id, h.type, count(*) as count from host as h INNER JOIN mshost as m ON h.mgmt_server_id=m.msid " |
| + "where h.status='Up' and h.type='SecondaryStorage' and m.last_update > ? " + "group by h.data_center_id, h.type " + "UNION ALL " |
| + "select h.data_center_id, h.type, count(*) as count from host as h INNER JOIN mshost as m ON h.mgmt_server_id=m.msid " |
| + "where h.status='Up' and h.type='Routing' and m.last_update > ? " + "group by h.data_center_id, h.type) as t " + "ORDER by t.data_center_id, t.type"; |
| |
| ArrayList<RunningHostCountInfo> l = new ArrayList<RunningHostCountInfo>(); |
| |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| ; |
| PreparedStatement pstmt = null; |
| try { |
| pstmt = txn.prepareAutoCloseStatement(sql); |
| String gmtCutTime = DateUtil.getDateDisplayString(TimeZone.getTimeZone("GMT"), cutTime); |
| pstmt.setString(1, gmtCutTime); |
| pstmt.setString(2, gmtCutTime); |
| |
| ResultSet rs = pstmt.executeQuery(); |
| while (rs.next()) { |
| RunningHostCountInfo info = new RunningHostCountInfo(); |
| info.setDcId(rs.getLong(1)); |
| info.setHostType(rs.getString(2)); |
| info.setCount(rs.getInt(3)); |
| |
| l.add(info); |
| } |
| } catch (SQLException e) { |
| s_logger.debug("SQLException caught", e); |
| } |
| return l; |
| } |
| |
| @Override |
| public long getNextSequence(long hostId) { |
| if (s_logger.isTraceEnabled()) { |
| s_logger.trace("getNextSequence(), hostId: " + hostId); |
| } |
| |
| TableGenerator tg = _tgs.get("host_req_sq"); |
| assert tg != null : "how can this be wrong!"; |
| |
| return s_seqFetcher.getNextSequence(Long.class, tg, hostId); |
| } |
| |
| @Override |
| public boolean updateState(Status oldStatus, Event event, Status newStatus, Host vo, Object data) { |
| // lock target row from beginning to avoid lock-promotion caused deadlock |
| HostVO host = lockRow(vo.getId(), true); |
| if (host == null) { |
| if (event == Event.Remove && newStatus == Status.Removed) { |
| host = findByIdIncludingRemoved(vo.getId()); |
| } |
| } |
| |
| if (host == null) { |
| return false; |
| } |
| long oldPingTime = host.getLastPinged(); |
| |
| SearchBuilder<HostVO> sb = createSearchBuilder(); |
| sb.and("status", sb.entity().getStatus(), SearchCriteria.Op.EQ); |
| sb.and("id", sb.entity().getId(), SearchCriteria.Op.EQ); |
| sb.and("update", sb.entity().getUpdated(), SearchCriteria.Op.EQ); |
| if (newStatus.checkManagementServer()) { |
| sb.and("ping", sb.entity().getLastPinged(), SearchCriteria.Op.EQ); |
| sb.and().op("nullmsid", sb.entity().getManagementServerId(), SearchCriteria.Op.NULL); |
| sb.or("msid", sb.entity().getManagementServerId(), SearchCriteria.Op.EQ); |
| sb.cp(); |
| } |
| sb.done(); |
| |
| SearchCriteria<HostVO> sc = sb.create(); |
| |
| sc.setParameters("status", oldStatus); |
| sc.setParameters("id", host.getId()); |
| sc.setParameters("update", host.getUpdated()); |
| long oldUpdateCount = host.getUpdated(); |
| if (newStatus.checkManagementServer()) { |
| sc.setParameters("ping", oldPingTime); |
| sc.setParameters("msid", host.getManagementServerId()); |
| } |
| |
| long newUpdateCount = host.incrUpdated(); |
| UpdateBuilder ub = getUpdateBuilder(host); |
| ub.set(host, _statusAttr, newStatus); |
| if (newStatus.updateManagementServer()) { |
| if (newStatus.lostConnection()) { |
| ub.set(host, _msIdAttr, null); |
| } else { |
| ub.set(host, _msIdAttr, host.getManagementServerId()); |
| } |
| if (event.equals(Event.Ping) || event.equals(Event.AgentConnected)) { |
| ub.set(host, _pingTimeAttr, System.currentTimeMillis() >> 10); |
| } |
| } |
| if (event.equals(Event.ManagementServerDown)) { |
| ub.set(host, _pingTimeAttr, ((System.currentTimeMillis() >> 10) - mgmtServiceConf.getTimeout())); |
| } |
| int result = update(ub, sc, null); |
| assert result <= 1 : "How can this update " + result + " rows? "; |
| |
| if (result == 0) { |
| HostVO ho = findById(host.getId()); |
| assert ho != null : "How how how? : " + host.getId(); |
| |
| if (status_logger.isDebugEnabled()) { |
| |
| StringBuilder str = new StringBuilder("Unable to update host for event:").append(event.toString()); |
| str.append(". Name=").append(host.getName()); |
| str.append("; New=[status=").append(newStatus.toString()).append(":msid=").append(newStatus.lostConnection() ? "null" : host.getManagementServerId()) |
| .append(":lastpinged=").append(host.getLastPinged()).append("]"); |
| str.append("; Old=[status=").append(oldStatus.toString()).append(":msid=").append(host.getManagementServerId()).append(":lastpinged=").append(oldPingTime) |
| .append("]"); |
| str.append("; DB=[status=").append(vo.getStatus().toString()).append(":msid=").append(vo.getManagementServerId()).append(":lastpinged=").append(vo.getLastPinged()) |
| .append(":old update count=").append(oldUpdateCount).append("]"); |
| status_logger.debug(str.toString()); |
| } else { |
| StringBuilder msg = new StringBuilder("Agent status update: ["); |
| msg.append("id = " + host.getId()); |
| msg.append("; name = " + host.getName()); |
| msg.append("; old status = " + oldStatus); |
| msg.append("; event = " + event); |
| msg.append("; new status = " + newStatus); |
| msg.append("; old update count = " + oldUpdateCount); |
| msg.append("; new update count = " + newUpdateCount + "]"); |
| status_logger.debug(msg.toString()); |
| } |
| |
| if (ho.getState() == newStatus) { |
| status_logger.debug("Host " + ho.getName() + " state has already been updated to " + newStatus); |
| return true; |
| } |
| } |
| |
| return result > 0; |
| } |
| |
| @Override |
| public boolean updateResourceState(ResourceState oldState, ResourceState.Event event, ResourceState newState, Host vo) { |
| HostVO host = (HostVO)vo; |
| SearchBuilder<HostVO> sb = createSearchBuilder(); |
| sb.and("resource_state", sb.entity().getResourceState(), SearchCriteria.Op.EQ); |
| sb.and("id", sb.entity().getId(), SearchCriteria.Op.EQ); |
| sb.done(); |
| |
| SearchCriteria<HostVO> sc = sb.create(); |
| |
| sc.setParameters("resource_state", oldState); |
| sc.setParameters("id", host.getId()); |
| |
| UpdateBuilder ub = getUpdateBuilder(host); |
| ub.set(host, _resourceStateAttr, newState); |
| int result = update(ub, sc, null); |
| assert result <= 1 : "How can this update " + result + " rows? "; |
| |
| if (state_logger.isDebugEnabled() && result == 0) { |
| HostVO ho = findById(host.getId()); |
| assert ho != null : "How how how? : " + host.getId(); |
| |
| StringBuilder str = new StringBuilder("Unable to update resource state: ["); |
| str.append("m = " + host.getId()); |
| str.append("; name = " + host.getName()); |
| str.append("; old state = " + oldState); |
| str.append("; event = " + event); |
| str.append("; new state = " + newState + "]"); |
| state_logger.debug(str.toString()); |
| } else { |
| StringBuilder msg = new StringBuilder("Resource state update: ["); |
| msg.append("id = " + host.getId()); |
| msg.append("; name = " + host.getName()); |
| msg.append("; old state = " + oldState); |
| msg.append("; event = " + event); |
| msg.append("; new state = " + newState + "]"); |
| state_logger.debug(msg.toString()); |
| } |
| |
| return result > 0; |
| } |
| |
| @Override |
| public HostVO findByTypeNameAndZoneId(long zoneId, String name, Host.Type type) { |
| SearchCriteria<HostVO> sc = TypeNameZoneSearch.create(); |
| sc.setParameters("type", type); |
| sc.setParameters("name", name); |
| sc.setParameters("zoneId", zoneId); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> findByDataCenterId(Long zoneId) { |
| SearchCriteria<HostVO> sc = DcSearch.create(); |
| sc.setParameters("dc", zoneId); |
| sc.setParameters("type", Type.Routing); |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> findByPodId(Long podId) { |
| SearchCriteria<HostVO> sc = PodSearch.create(); |
| sc.setParameters("podId", podId); |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> findByClusterId(Long clusterId) { |
| SearchCriteria<HostVO> sc = ClusterSearch.create(); |
| sc.setParameters("clusterId", clusterId); |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> findByClusterIdAndEncryptionSupport(Long clusterId) { |
| SearchBuilder<DetailVO> hostCapabilitySearch = _detailsDao.createSearchBuilder(); |
| DetailVO tagEntity = hostCapabilitySearch.entity(); |
| hostCapabilitySearch.and("capability", tagEntity.getName(), SearchCriteria.Op.EQ); |
| hostCapabilitySearch.and("value", tagEntity.getValue(), SearchCriteria.Op.EQ); |
| |
| SearchBuilder<HostVO> hostSearch = createSearchBuilder(); |
| HostVO entity = hostSearch.entity(); |
| hostSearch.and("cluster", entity.getClusterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("status", entity.getStatus(), SearchCriteria.Op.EQ); |
| hostSearch.join("hostCapabilitySearch", hostCapabilitySearch, entity.getId(), tagEntity.getHostId(), JoinBuilder.JoinType.INNER); |
| |
| SearchCriteria<HostVO> sc = hostSearch.create(); |
| sc.setJoinParameters("hostCapabilitySearch", "value", Boolean.toString(true)); |
| sc.setJoinParameters("hostCapabilitySearch", "capability", Host.HOST_VOLUME_ENCRYPTION); |
| |
| if (clusterId != null) { |
| sc.setParameters("cluster", clusterId); |
| } |
| sc.setParameters("status", Status.Up.toString()); |
| sc.setParameters("resourceState", ResourceState.Enabled.toString()); |
| |
| return listBy(sc); |
| } |
| |
| @Override |
| public HostVO findByPublicIp(String publicIp) { |
| SearchCriteria<HostVO> sc = PublicIpAddressSearch.create(); |
| sc.setParameters("publicIpAddress", publicIp); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public HostVO findByIp(final String ipAddress) { |
| SearchCriteria<HostVO> sc = UnremovedIpAddressSearch.create(); |
| sc.setParameters("publicIpAddress", ipAddress); |
| sc.setParameters("privateIpAddress", ipAddress); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> findHypervisorHostInCluster(long clusterId) { |
| SearchCriteria<HostVO> sc = TypeClusterStatusSearch.create(); |
| sc.setParameters("type", Host.Type.Routing); |
| sc.setParameters("cluster", clusterId); |
| sc.setParameters("status", Status.Up); |
| sc.setParameters("resourceState", ResourceState.Enabled); |
| |
| return listBy(sc); |
| } |
| |
| @Override |
| public HostVO findOldestExistentHypervisorHostInCluster(long clusterId) { |
| SearchCriteria<HostVO> sc = TypeClusterStatusSearch.create(); |
| sc.setParameters("type", Host.Type.Routing); |
| sc.setParameters("cluster", clusterId); |
| sc.setParameters("status", Status.Up); |
| sc.setParameters("resourceState", ResourceState.Enabled); |
| Filter orderByFilter = new Filter(HostVO.class, "created", true, null, null); |
| |
| List<HostVO> hosts = search(sc, orderByFilter, null, false); |
| if (hosts != null && hosts.size() > 0) { |
| return hosts.get(0); |
| } |
| |
| return null; |
| } |
| |
| @Override |
| public List<Long> listAllHosts(long zoneId) { |
| SearchCriteria<Long> sc = HostIdSearch.create(); |
| sc.addAnd("dataCenterId", SearchCriteria.Op.EQ, zoneId); |
| return customSearch(sc, null); |
| } |
| |
| @Override |
| public List<HostVO> listAllHostsByZoneAndHypervisorType(long zoneId, HypervisorType hypervisorType) { |
| SearchCriteria<HostVO> sc = DcSearch.create(); |
| sc.setParameters("dc", zoneId); |
| if (hypervisorType != null) { |
| sc.setParameters("hypervisorType", hypervisorType.toString()); |
| } |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> listAllHostsThatHaveNoRuleTag(Type type, Long clusterId, Long podId, Long dcId) { |
| SearchCriteria<HostVO> sc = searchBuilderFindByIdTypeClusterIdPodIdDcIdAndWithoutRuleTag.create(); |
| if (type != null) { |
| sc.setParameters("type", type); |
| } |
| if (clusterId != null) { |
| sc.setParameters("cluster_id", clusterId); |
| } |
| if (podId != null) { |
| sc.setParameters("pod_id", podId); |
| } |
| if (dcId != null) { |
| sc.setParameters("data_center_id", dcId); |
| } |
| sc.setJoinParameters("id", "is_tag_a_rule", false); |
| |
| return search(sc, null); |
| } |
| |
| @Override |
| public List<Long> listClustersByHostTag(String computeOfferingTags) { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| String sql = this.LIST_CLUSTERID_FOR_HOST_TAG; |
| PreparedStatement pstmt = null; |
| List<Long> result = new ArrayList(); |
| List<String> tags = Arrays.asList(computeOfferingTags.split(this.SEPARATOR)); |
| String subselect = getHostIdsByComputeTags(tags); |
| sql = String.format(sql, subselect); |
| |
| try { |
| pstmt = txn.prepareStatement(sql); |
| |
| for(int i = 0; i < tags.size(); i++){ |
| pstmt.setString(i+1, tags.get(i)); |
| } |
| |
| ResultSet rs = pstmt.executeQuery(); |
| while (rs.next()) { |
| result.add(rs.getLong(1)); |
| } |
| pstmt.close(); |
| return result; |
| } catch (SQLException e) { |
| throw new CloudRuntimeException("DB Exception on: " + sql, e); |
| } |
| } |
| |
| private List<Long> findHostByComputeOfferings(String computeOfferingTags){ |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| PreparedStatement pstmt = null; |
| List<Long> result = new ArrayList(); |
| List<String> tags = Arrays.asList(computeOfferingTags.split(this.SEPARATOR)); |
| String select = getHostIdsByComputeTags(tags); |
| try { |
| pstmt = txn.prepareStatement(select); |
| |
| for(int i = 0; i < tags.size(); i++){ |
| pstmt.setString(i+1, tags.get(i)); |
| } |
| |
| ResultSet rs = pstmt.executeQuery(); |
| while (rs.next()) { |
| result.add(rs.getLong(1)); |
| } |
| pstmt.close(); |
| return result; |
| } catch (SQLException e) { |
| throw new CloudRuntimeException("DB Exception on: " + select, e); |
| } |
| } |
| |
| public List<HostVO> findHostsWithTagRuleThatMatchComputeOferringTags(String computeOfferingTags) { |
| List<HostTagVO> hostTagVOList = _hostTagsDao.findHostRuleTags(); |
| List<HostVO> result = new ArrayList<>(); |
| for (HostTagVO rule: hostTagVOList) { |
| if (TagAsRuleHelper.interpretTagAsRule(rule.getTag(), computeOfferingTags, HostTagsDao.hostTagRuleExecutionTimeout.value())) { |
| result.add(findById(rule.getHostId())); |
| } |
| } |
| |
| return result; |
| } |
| |
| public List<Long> findClustersThatMatchHostTagRule(String computeOfferingTags) { |
| Set<Long> result = new HashSet<>(); |
| List<HostVO> hosts = findHostsWithTagRuleThatMatchComputeOferringTags(computeOfferingTags); |
| for (HostVO host: hosts) { |
| result.add(host.getClusterId()); |
| } |
| return new ArrayList<>(result); |
| } |
| |
| private String getHostIdsByComputeTags(List<String> offeringTags){ |
| List<String> questionMarks = new ArrayList(); |
| offeringTags.forEach((tag) -> { questionMarks.add("?"); }); |
| return String.format(this.LIST_HOST_IDS_BY_COMPUTETAGS, String.join(",", questionMarks),questionMarks.size()); |
| } |
| |
| @Override |
| public List<HostVO> listHostsWithActiveVMs(long offeringId) { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| PreparedStatement pstmt = null; |
| List<HostVO> result = new ArrayList<>(); |
| StringBuilder sql = new StringBuilder(GET_HOSTS_OF_ACTIVE_VMS); |
| try { |
| pstmt = txn.prepareAutoCloseStatement(sql.toString()); |
| pstmt.setLong(1, offeringId); |
| ResultSet rs = pstmt.executeQuery(); |
| while (rs.next()) { |
| result.add(toEntityBean(rs, false)); |
| } |
| return result; |
| } catch (SQLException e) { |
| throw new CloudRuntimeException("DB Exception on: " + sql, e); |
| } catch (Throwable e) { |
| throw new CloudRuntimeException("Caught: " + sql, e); |
| } |
| } |
| |
| @Override |
| public int countByMs(long msid) { |
| SearchCriteria<HostVO> sc = ResponsibleMsCountSearch.create(); |
| sc.setParameters("managementServerId", msid); |
| return getCount(sc); |
| } |
| |
| @Override |
| public List<String> listOrderedHostsHypervisorVersionsInDatacenter(long datacenterId, HypervisorType hypervisorType) { |
| PreparedStatement pstmt = null; |
| List<String> result = new ArrayList<>(); |
| try { |
| TransactionLegacy txn = TransactionLegacy.currentTxn(); |
| pstmt = txn.prepareAutoCloseStatement(GET_ORDERED_HW_VERSIONS_IN_DC); |
| pstmt.setString(1, Objects.toString(hypervisorType)); |
| pstmt.setLong(2, datacenterId); |
| ResultSet resultSet = pstmt.executeQuery(); |
| while (resultSet.next()) { |
| result.add(resultSet.getString(1)); |
| } |
| } catch (SQLException e) { |
| s_logger.error("Error trying to obtain hypervisor version on datacenter", e); |
| } |
| return result; |
| } |
| |
| @Override |
| public List<HostVO> listAllHostsByType(Host.Type type) { |
| SearchCriteria<HostVO> sc = TypeSearch.create(); |
| sc.setParameters("type", type); |
| sc.setParameters("resourceState", ResourceState.Enabled); |
| |
| return listBy(sc); |
| } |
| |
| @Override |
| public List<HostVO> listByType(Host.Type type) { |
| SearchCriteria<HostVO> sc = TypeSearch.create(); |
| sc.setParameters("type", type); |
| return listBy(sc); |
| } |
| |
| String sqlFindHostInZoneToExecuteCommand = "Select id from host " |
| + " where type = 'Routing' and hypervisor_type = ? and data_center_id = ? and status = 'Up' " |
| + " and resource_state = '%s' " |
| + " ORDER by rand() limit 1"; |
| |
| @Override |
| public HostVO findHostInZoneToExecuteCommand(long zoneId, HypervisorType hypervisorType) { |
| try (TransactionLegacy tx = TransactionLegacy.currentTxn()) { |
| String sql = createSqlFindHostToExecuteCommand(false); |
| ResultSet rs = executeSqlGetResultsetForMethodFindHostInZoneToExecuteCommand(hypervisorType, zoneId, tx, sql); |
| if (rs.next()) { |
| return findById(rs.getLong("id")); |
| } |
| sql = createSqlFindHostToExecuteCommand(true); |
| rs = executeSqlGetResultsetForMethodFindHostInZoneToExecuteCommand(hypervisorType, zoneId, tx, sql); |
| if (!rs.next()) { |
| throw new CloudRuntimeException(String.format("Could not find a host in zone [zoneId=%d] to operate on. ", zoneId)); |
| } |
| return findById(rs.getLong("id")); |
| } catch (SQLException e) { |
| throw new CloudRuntimeException(e); |
| } |
| } |
| |
| @Override |
| public List<HostVO> listAllHostsUpByZoneAndHypervisor(long zoneId, HypervisorType hypervisorType) { |
| return listByDataCenterIdAndHypervisorType(zoneId, hypervisorType) |
| .stream() |
| .filter(x -> x.getStatus().equals(Status.Up) && |
| x.getType() == Host.Type.Routing) |
| .collect(Collectors.toList()); |
| } |
| |
| @Override |
| public List<HostVO> listByHostCapability(Type type, Long clusterId, Long podId, long dcId, String hostCapabilty) { |
| SearchBuilder<DetailVO> hostCapabilitySearch = _detailsDao.createSearchBuilder(); |
| DetailVO tagEntity = hostCapabilitySearch.entity(); |
| hostCapabilitySearch.and("capability", tagEntity.getName(), SearchCriteria.Op.EQ); |
| hostCapabilitySearch.and("value", tagEntity.getValue(), SearchCriteria.Op.EQ); |
| |
| SearchBuilder<HostVO> hostSearch = createSearchBuilder(); |
| HostVO entity = hostSearch.entity(); |
| hostSearch.and("type", entity.getType(), SearchCriteria.Op.EQ); |
| hostSearch.and("pod", entity.getPodId(), SearchCriteria.Op.EQ); |
| hostSearch.and("dc", entity.getDataCenterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("cluster", entity.getClusterId(), SearchCriteria.Op.EQ); |
| hostSearch.and("status", entity.getStatus(), SearchCriteria.Op.EQ); |
| hostSearch.and("resourceState", entity.getResourceState(), SearchCriteria.Op.EQ); |
| hostSearch.join("hostCapabilitySearch", hostCapabilitySearch, entity.getId(), tagEntity.getHostId(), JoinBuilder.JoinType.INNER); |
| |
| SearchCriteria<HostVO> sc = hostSearch.create(); |
| sc.setJoinParameters("hostCapabilitySearch", "value", Boolean.toString(true)); |
| sc.setJoinParameters("hostCapabilitySearch", "capability", hostCapabilty); |
| sc.setParameters("type", type.toString()); |
| if (podId != null) { |
| sc.setParameters("pod", podId); |
| } |
| if (clusterId != null) { |
| sc.setParameters("cluster", clusterId); |
| } |
| sc.setParameters("dc", dcId); |
| sc.setParameters("status", Status.Up.toString()); |
| sc.setParameters("resourceState", ResourceState.Enabled.toString()); |
| |
| return listBy(sc); |
| } |
| |
| public List<HostVO> listByClusterAndHypervisorType(long clusterId, HypervisorType hypervisorType) { |
| SearchCriteria<HostVO> sc = ClusterHypervisorSearch.create(); |
| sc.setParameters("clusterId", clusterId); |
| sc.setParameters("hypervisor", hypervisorType); |
| sc.setParameters("type", Type.Routing); |
| sc.setParameters("status", Status.Up); |
| return listBy(sc); |
| } |
| |
| @Override |
| public HostVO findByName(String name) { |
| SearchCriteria<HostVO> sc = NameSearch.create(); |
| sc.setParameters("name", name); |
| return findOneBy(sc); |
| } |
| |
| @Override |
| public HostVO findHostByHypervisorTypeAndVersion(HypervisorType hypervisorType, String hypervisorVersion) { |
| SearchCriteria<HostVO> sc = hostHypervisorTypeAndVersionSearch.create(); |
| sc.setParameters("hypervisorType", hypervisorType); |
| sc.setParameters("hypervisorVersion", hypervisorVersion); |
| sc.setParameters("type", Host.Type.Routing); |
| sc.setParameters("status", Status.Up); |
| return findOneBy(sc); |
| } |
| |
| private ResultSet executeSqlGetResultsetForMethodFindHostInZoneToExecuteCommand(HypervisorType hypervisorType, long zoneId, TransactionLegacy tx, String sql) throws SQLException { |
| PreparedStatement pstmt = tx.prepareAutoCloseStatement(sql); |
| pstmt.setString(1, Objects.toString(hypervisorType)); |
| pstmt.setLong(2, zoneId); |
| return pstmt.executeQuery(); |
| } |
| |
| private String createSqlFindHostToExecuteCommand(boolean useDisabledHosts) { |
| String hostResourceStatus = "Enabled"; |
| if (useDisabledHosts) { |
| hostResourceStatus = "Disabled"; |
| } |
| return String.format(sqlFindHostInZoneToExecuteCommand, hostResourceStatus); |
| } |
| } |
