[cloudstack] branch main updated: vpc/network: set mtu of networks/vpcs/nics during 4.18 upgrade (#7124)

[da...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

dahn pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/main by this push:
     new 42f0d758c16 vpc/network: set mtu of networks/vpcs/nics during 4.18 upgrade (#7124)
42f0d758c16 is described below

commit 42f0d758c1620bbea70c1a2cffb17a77bb497d65
Author: Wei Zhou <we...@apache.org>
AuthorDate: Tue Jan 24 09:51:08 2023 +0100

    vpc/network: set mtu of networks/vpcs/nics during 4.18 upgrade (#7124)
---
 engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql b/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
index 726d36caea8..ba66a28b26d 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql
@@ -33,6 +33,10 @@ ALTER TABLE `cloud`.`networks` ADD COLUMN `private_mtu` bigint unsigned comment
 ALTER TABLE `cloud`.`vpc` ADD COLUMN `public_mtu` bigint unsigned comment "MTU for VPC VR public interface" ;
 ALTER TABLE `cloud`.`nics` ADD COLUMN `mtu` bigint unsigned comment "MTU for the VR interface" ;
 
+UPDATE `cloud`.`networks` SET public_mtu = 1500, private_mtu = 1500 WHERE removed IS NULL AND guest_type='Isolated';
+UPDATE `cloud`.`vpc` SET public_mtu = 1500 WHERE removed IS NULL;
+UPDATE `cloud`.`nics` SET mtu = 1500 WHERE vm_type='DomainRouter' AND removed IS NULL AND reserver_name IN ('PublicNetworkGuru', 'ExternalGuestNetworkGuru');
+
 DROP VIEW IF EXISTS `cloud`.`domain_router_view`;
 CREATE VIEW `cloud`.`domain_router_view` AS
     select