[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2014-11-14 Thread Kishan Kavala (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kishan Kavala updated CLOUDSTACK-252:
-
Assignee: Jayapal Reddy  (was: Kishan Kavala)

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Jayapal Reddy
> Fix For: 4.4.0, 4.5.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_route

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2014-11-25 Thread Rajani Karuturi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajani Karuturi updated CLOUDSTACK-252:
---
Fix Version/s: (was: 4.4.0)
   4.4.3

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Jayapal Reddy
> Fix For: 4.5.0, 4.4.3
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2014-12-10 Thread Jayapal Reddy (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jayapal Reddy updated CLOUDSTACK-252:
-
Assignee: Sudhansu Sahu  (was: Jayapal Reddy)

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Sudhansu Sahu
> Fix For: 4.5.0, 4.4.3
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_route

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-03-15 Thread Rajani Karuturi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajani Karuturi updated CLOUDSTACK-252:
---
Fix Version/s: (was: 4.5.0)
   4.5.1

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Sudhansu Sahu
> Fix For: 4.4.3, 4.5.1
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-03-18 Thread Rajani Karuturi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajani Karuturi updated CLOUDSTACK-252:
---
Description: 
===
Steps to Reproduce:
===

1. On an Advanced Zone with two physical networks, create a guest network from 
a network offering with services as mentioned below

{noformat}
mysql> select * from network_offerings where id=13 \G
*** 1. row ***
   id: 13
 name: Network-SNAT-guest1
 uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
  unique_name: Network-SNAT-guest1
 display_text: Network-SNAT-guest1
  nw_rate: 500
  mc_rate: 10
 traffic_type: Guest
 tags: guest1
  system_only: 0
 specify_vlan: 0
  service_offering_id: NULL
conserve_mode: 0
  created: 2012-09-26 18:43:35
  removed: NULL
  default: 0
 availability: Optional
 dedicated_lb_service: 1
shared_source_nat_service: 0
 sort_key: 0
 redundant_router_service: 0
state: Enabled
   guest_type: Isolated
   elastic_ip_service: 0
   elastic_lb_service: 0
specify_ip_ranges: 0
1 row in set (0.00 sec)

mysql> select * from ntwk_offering_service_map where network_offering_id=13;
++-++---+-+
| id | network_offering_id | service| provider  | created   
  |
++-++---+-+
| 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
18:43:35 |
| 51 |  13 | Dns| VirtualRouter | 2012-09-26 
18:43:35 |
| 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
18:43:35 |
| 49 |  13 | Lb | VirtualRouter | 2012-09-26 
18:43:35 |
| 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
18:43:35 |
| 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
18:43:35 |
| 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
18:43:35 |
| 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
18:43:35 |
| 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
18:43:35 |
++-++---+-+
9 rows in set (0.00 sec)

mysql>
{noformat}

2, Deploy three VMs on a guest network that is created from the above mentioned 
network offering.
3. Create a Load balancing rule servicing the VMs on the guest network.
4. Stop All the VMs and UpdateNetwork to the Network offering with services as 
mentioned below. Notice that the LB Service is provided by F5 in the new 
network offering.

{noformat}
mysql> select * from network_offerings where id=18 \G
*** 1. row ***
   id: 18
 name: Network-F5-guest1
 uuid: 5c7746b8-e29f-4a74-8369-e88647081053
  unique_name: Network-F5-guest1
 display_text: Network-F5-guest1
  nw_rate: 535
  mc_rate: 10
 traffic_type: Guest
 tags: guest1
  system_only: 0
 specify_vlan: 0
  service_offering_id: NULL
conserve_mode: 0
  created: 2012-09-27 01:13:38
  removed: NULL
  default: 0
 availability: Optional
 dedicated_lb_service: 0
shared_source_nat_service: 0
 sort_key: 0
 redundant_router_service: 0
state: Enabled
   guest_type: Isolated
   elastic_ip_service: 0
   elastic_lb_service: 0
specify_ip_ranges: 0
1 row in set (0.00 sec)
{noformat}
{noformat}
mysql> select * from ntwk_offering_service_map where network_offering_id=18;
++-++---+-+
| id | network_offering_id | service| provider  | created   
  |
++-++---+-+
| 81 |  18 | Dhcp   | VirtualRouter | 2012-09-27 
01:13:38 |
| 86 |  18 | Dns| VirtualRouter | 2012-09-27 
01:13:38 |
| 83 |  18 | Firewall   | VirtualRouter | 2012-09-27 
01:13:38 |
| 85 |  18 | Lb | F5BigIp   | 2012-09-27 
01:13:38 |
| 80 |  18 | PortForwarding | VirtualRouter | 2012-09-27 
01:13:38 |
| 84 |  18 | SourceNat  | VirtualRouter | 2012-09-27 
01:13:38 |
| 82 |  18 | StaticNat  | VirtualR

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-03-18 Thread Rajani Karuturi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rajani Karuturi updated CLOUDSTACK-252:
---
Description: 
===
Steps to Reproduce:
===

1. On an Advanced Zone with two physical networks, create a guest network from 
a network offering with services as mentioned below

{noformat}
mysql> select * from network_offerings where id=13 \G
*** 1. row ***
   id: 13
 name: Network-SNAT-guest1
 uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
  unique_name: Network-SNAT-guest1
 display_text: Network-SNAT-guest1
  nw_rate: 500
  mc_rate: 10
 traffic_type: Guest
 tags: guest1
  system_only: 0
 specify_vlan: 0
  service_offering_id: NULL
conserve_mode: 0
  created: 2012-09-26 18:43:35
  removed: NULL
  default: 0
 availability: Optional
 dedicated_lb_service: 1
shared_source_nat_service: 0
 sort_key: 0
 redundant_router_service: 0
state: Enabled
   guest_type: Isolated
   elastic_ip_service: 0
   elastic_lb_service: 0
specify_ip_ranges: 0
1 row in set (0.00 sec)
{noformat}
{noformat}
mysql> select * from ntwk_offering_service_map where network_offering_id=13;
++-++---+-+
| id | network_offering_id | service| provider  | created   
  |
++-++---+-+
| 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
18:43:35 |
| 51 |  13 | Dns| VirtualRouter | 2012-09-26 
18:43:35 |
| 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
18:43:35 |
| 49 |  13 | Lb | VirtualRouter | 2012-09-26 
18:43:35 |
| 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
18:43:35 |
| 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
18:43:35 |
| 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
18:43:35 |
| 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
18:43:35 |
| 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
18:43:35 |
++-++---+-+
9 rows in set (0.00 sec)

mysql>
{noformat}

2, Deploy three VMs on a guest network that is created from the above mentioned 
network offering.
3. Create a Load balancing rule servicing the VMs on the guest network.
4. Stop All the VMs and UpdateNetwork to the Network offering with services as 
mentioned below. Notice that the LB Service is provided by F5 in the new 
network offering.

{noformat}
mysql> select * from network_offerings where id=18 \G
*** 1. row ***
   id: 18
 name: Network-F5-guest1
 uuid: 5c7746b8-e29f-4a74-8369-e88647081053
  unique_name: Network-F5-guest1
 display_text: Network-F5-guest1
  nw_rate: 535
  mc_rate: 10
 traffic_type: Guest
 tags: guest1
  system_only: 0
 specify_vlan: 0
  service_offering_id: NULL
conserve_mode: 0
  created: 2012-09-27 01:13:38
  removed: NULL
  default: 0
 availability: Optional
 dedicated_lb_service: 0
shared_source_nat_service: 0
 sort_key: 0
 redundant_router_service: 0
state: Enabled
   guest_type: Isolated
   elastic_ip_service: 0
   elastic_lb_service: 0
specify_ip_ranges: 0
1 row in set (0.00 sec)
{noformat}
{noformat}
mysql> select * from ntwk_offering_service_map where network_offering_id=18;
++-++---+-+
| id | network_offering_id | service| provider  | created   
  |
++-++---+-+
| 81 |  18 | Dhcp   | VirtualRouter | 2012-09-27 
01:13:38 |
| 86 |  18 | Dns| VirtualRouter | 2012-09-27 
01:13:38 |
| 83 |  18 | Firewall   | VirtualRouter | 2012-09-27 
01:13:38 |
| 85 |  18 | Lb | F5BigIp   | 2012-09-27 
01:13:38 |
| 80 |  18 | PortForwarding | VirtualRouter | 2012-09-27 
01:13:38 |
| 84 |  18 | SourceNat  | VirtualRouter | 2012-09-27 
01:13:38 |
| 82 |  18 | Stat

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-11-29 Thread Abhinandan Prateek (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhinandan Prateek updated CLOUDSTACK-252:
--

Assignee: (was: Abhinandan Prateek)

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.3.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> stat

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-06-04 Thread Chip Childers (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Chip Childers updated CLOUDSTACK-252:
-

Fix Version/s: (was: 4.1.0)
   4.2.0

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.2.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2014-11-04 Thread Animesh Chaturvedi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-252:
--
Assignee: Kishan Kavala

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Kishan Kavala
> Fix For: 4.4.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2014-11-04 Thread Animesh Chaturvedi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-252:
--
Fix Version/s: 4.5.0

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Kishan Kavala
> Fix For: 4.4.0, 4.5.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-09-19 Thread Abhinandan Prateek (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhinandan Prateek updated CLOUDSTACK-252:
--

Fix Version/s: (was: 4.2.0)
   4.2.1

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.2.1
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-10-09 Thread Abhinandan Prateek (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abhinandan Prateek updated CLOUDSTACK-252:
--

Fix Version/s: (was: 4.2.1)
   4.3.0

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.3.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-11-07 Thread Animesh Chaturvedi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-252:
--


BULK EDIT> These issues are open to be picked up. Help in resolution is 
appreciated.

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.3.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_r

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-11-07 Thread Animesh Chaturvedi (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Animesh Chaturvedi updated CLOUDSTACK-252:
--


BULK EDIT> These issues are open to be picked up. Help in resolution is 
appreciated.

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
> Fix For: 4.3.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_r

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2013-11-27 Thread Jayapal Reddy (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jayapal Reddy updated CLOUDSTACK-252:
-

Assignee: Abhinandan Prateek

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Abhinandan Prateek
> Fix For: 4.3.0
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
>

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-05-12 Thread Daan Hoogland (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Daan Hoogland updated CLOUDSTACK-252:
-
Fix Version/s: (was: 4.5.1)
   4.5.2

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Sudhansu Sahu
> Fix For: 4.4.3, 4.5.2
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> {noformat}
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> {noformat}
> {noformat}
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> {noformat}
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> {noformat}
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> sh

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-05-12 Thread Daan Hoogland (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Daan Hoogland updated CLOUDSTACK-252:
-
Fix Version/s: (was: 4.4.3)
   4.4.4

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Sudhansu Sahu
> Fix For: 4.4.4, 4.5.2
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> {noformat}
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> {noformat}
> {noformat}
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> {noformat}
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> {noformat}
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 0
> sh

[jira] [Updated] (CLOUDSTACK-252) UpdateNetwork Operation on a guest network that is currently using Virtual Router for Lb services to a network offering that uses "F5" for Lb services Fails due to My

2015-07-08 Thread Daan Hoogland (JIRA) 

 [ 
https://issues.apache.org/jira/browse/CLOUDSTACK-252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Daan Hoogland updated CLOUDSTACK-252:
-
Fix Version/s: (was: 4.5.2)
   (was: 4.4.4)
   Future

> UpdateNetwork Operation on a guest network that is currently using Virtual 
> Router for Lb services to a network offering that uses "F5" for Lb services 
> Fails due to MySQLIntegrityConstraintViolationException.
> ---
>
> Key: CLOUDSTACK-252
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-252
> Project: CloudStack
>  Issue Type: Bug
>  Security Level: Public(Anyone can view this level - this is the 
> default.) 
>  Components: Management Server
>Affects Versions: pre-4.0.0
>Reporter: Chandan Purushothama
>Assignee: Sudhansu Sahu
> Fix For: Future
>
> Attachments: managementserverlog_mysqldumps.zip
>
>
> ===
> Steps to Reproduce:
> ===
> 1. On an Advanced Zone with two physical networks, create a guest network 
> from a network offering with services as mentioned below
> {noformat}
> mysql> select * from network_offerings where id=13 \G
> *** 1. row ***
>id: 13
>  name: Network-SNAT-guest1
>  uuid: 277b7b7a-8aeb-46f8-94e9-e83de34912a8
>   unique_name: Network-SNAT-guest1
>  display_text: Network-SNAT-guest1
>   nw_rate: 500
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-26 18:43:35
>   removed: NULL
>   default: 0
>  availability: Optional
>  dedicated_lb_service: 1
> shared_source_nat_service: 0
>  sort_key: 0
>  redundant_router_service: 0
> state: Enabled
>guest_type: Isolated
>elastic_ip_service: 0
>elastic_lb_service: 0
> specify_ip_ranges: 0
> 1 row in set (0.00 sec)
> {noformat}
> {noformat}
> mysql> select * from ntwk_offering_service_map where network_offering_id=13;
> ++-++---+-+
> | id | network_offering_id | service| provider  | created 
> |
> ++-++---+-+
> | 48 |  13 | Dhcp   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 51 |  13 | Dns| VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 52 |  13 | Firewall   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 49 |  13 | Lb | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 50 |  13 | PortForwarding | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 53 |  13 | SourceNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 46 |  13 | StaticNat  | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 54 |  13 | UserData   | VirtualRouter | 2012-09-26 
> 18:43:35 |
> | 47 |  13 | Vpn| VirtualRouter | 2012-09-26 
> 18:43:35 |
> ++-++---+-+
> 9 rows in set (0.00 sec)
> mysql>
> {noformat}
> 2, Deploy three VMs on a guest network that is created from the above 
> mentioned network offering.
> 3. Create a Load balancing rule servicing the VMs on the guest network.
> 4. Stop All the VMs and UpdateNetwork to the Network offering with services 
> as mentioned below. Notice that the LB Service is provided by F5 in the new 
> network offering.
> {noformat}
> mysql> select * from network_offerings where id=18 \G
> *** 1. row ***
>id: 18
>  name: Network-F5-guest1
>  uuid: 5c7746b8-e29f-4a74-8369-e88647081053
>   unique_name: Network-F5-guest1
>  display_text: Network-F5-guest1
>   nw_rate: 535
>   mc_rate: 10
>  traffic_type: Guest
>  tags: guest1
>   system_only: 0
>  specify_vlan: 0
>   service_offering_id: NULL
> conserve_mode: 0
>   created: 2012-09-27 01:13:38
>   removed: NULL
>   default: 0
>  availability: Optional
>