[
https://issues.apache.org/jira/browse/CLOUDSTACK-4704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13772477#comment-13772477
]
Chandan Purushothama commented on CLOUDSTACK-4704:
--------------------------------------------------
Upgraded a 3.0.7 Setup to 4.2.0 and verified vpc_service_map table:
mysql> select * from vpc_service_map;
+----+--------+----------------+------------------+---------------------+
| id | vpc_id | service | provider | created |
+----+--------+----------------+------------------+---------------------+
| 1 | 1 | Dhcp | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 2 | 1 | Dns | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 3 | 1 | Gateway | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 4 | 1 | Lb | InternalLbVm | 2013-09-20 10:26:03 |
| 5 | 1 | Lb | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 6 | 1 | NetworkACL | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 7 | 1 | PortForwarding | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 8 | 1 | SourceNat | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 9 | 1 | StaticNat | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 10 | 1 | UserData | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 11 | 1 | Vpn | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 12 | 2 | Dhcp | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 13 | 2 | Dns | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 14 | 2 | Gateway | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 15 | 2 | Lb | InternalLbVm | 2013-09-20 10:26:03 |
| 16 | 2 | Lb | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 17 | 2 | NetworkACL | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 18 | 2 | PortForwarding | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 19 | 2 | SourceNat | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 20 | 2 | StaticNat | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 21 | 2 | UserData | VpcVirtualRouter | 2013-09-20 10:26:03 |
| 22 | 2 | Vpn | VpcVirtualRouter | 2013-09-20 10:26:03 |
+----+--------+----------------+------------------+---------------------+
22 rows in set (0.00 sec)
mysql> select * from version;
+----+----------------------+---------------------+----------+
| id | version | updated | step |
+----+----------------------+---------------------+----------+
| 1 | 3.0.7.20130731133233 | 2013-09-19 18:07:36 | Complete |
| 2 | 4.1.0 | 2013-09-20 04:56:03 | Complete |
| 3 | 4.2.0 | 2013-09-20 04:56:04 | Complete |
+----+----------------------+---------------------+----------+
3 rows in set (0.00 sec)
mysql>
> DB upgrade bug caused by the new table "vpc_service_map"
> --------------------------------------------------------
>
> Key: CLOUDSTACK-4704
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4704
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.2.0
> Reporter: Alena Prokharchyk
> Assignee: Kishan Kavala
> Priority: Critical
> Fix For: 4.2.1
>
>
> As a part of the commit 836ce6c1, new table vpc_service_map was introduced.
> Before Vpc code used to read services/providers combination from
> vpc_service_offering_map, after the commit it reads from vpc_service_map (the
> way we do for the networks).
> Bug: as a part of the DB upgrade, all existing VPCs are not updated with the
> data in vpc_service_map table. It means existing VPC will never have any
> Services/Providers to implement, and after the existing VR is gone (can
> happen during the VPC restart, or VPC VR removal), it will never gonna get a
> new VR again.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
