[BugFix:
fix upgrade if loadbalancer have flat network
@@ -146,22 +146,6 @@ ALTER TABLE `zstack`.`VpcFirewallRuleSetVO` DROP COLUMN `vpcFirewallUuid`;
ALTER TABLE `zstack`.`VpcFirewallRuleVO` DROP COLUMN `vpcFirewallUuid`;
ALTER TABLE `zstack`.`VpcFirewallRuleVO` DROP COLUMN `ruleSetName`;
-DROP PROCEDURE IF EXISTS checkFlatLoadBalancerExist;
-DELIMITER $$
-CREATE PROCEDURE checkFlatLoadBalancerExist()
-BEGIN
- if((select count(*) from LoadBalancerListenerVmNicRefVO ref, VmNicVO nic
- where ref.vmNicUuid=nic.uuid
- and nic.l3NetworkUuid not in (SELECT uuid FROM L3NetworkEO l3
- LEFT JOIN NetworkServiceL3NetworkRefVO ref on l3.uuid = ref.l3NetworkUuid WHERE ref.networkServiceType='SNAT')) > 0) THEN
- SIGNAL SQLSTATE "45000"
- SET MESSAGE_TEXT = "VirtualRouter are not supported this version";
- END IF;
-END$$
-DELIMITER ;
-CALL checkFlatLoadBalancerExist();
-DROP PROCEDURE IF EXISTS checkFlatLoadBalancerExist;
-
DROP PROCEDURE IF EXISTS checkVirtualhostsExist;
DELIMITER $$
CREATE PROCEDURE checkVirtualhostsExist()
