Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-dev@incubator.apache.org
Content-Type: multipart/alternative;
 boundary="===============8167333358096242155=="
MIME-Version: 1.0
Subject: Re: Review Request: CLOUDSTACK-1429: single account is unable to use
 same
 vnet across multiple physical networks
From: "venkata swamy babu  budumuru" <venkataswamybabu.budumuru@citrix.com>
To: "Chip Childers" <chip.childers@sungard.com>,
 "Marcus Sorensen" <shadowsor@gmail.com>
Cc: "cloudstack" <cloudstack-dev@incubator.apache.org>,
 "Kishan Kavala" <Kishan.Kavala@citrix.com>,
 "venkata swamy babu  budumuru" <venkataswamybabu.budumuru@citrix.com>,
 "Prasanna Santhanam" <Prasanna.Santhanam@citrix.com>
Date: Tue, 05 Mar 2013 13:31:27 -0000
Message-ID: <20130305133127.27098.83270@reviews.apache.org>
Auto-Submitted: auto-generated
Sender: "venkata swamy babu  budumuru" <noreply@reviews.apache.org>
References: <20130227135347.17206.94561@reviews.apache.org>
In-Reply-To: <20130227135347.17206.94561@reviews.apache.org>
Reply-To: "venkata swamy babu budumuru" <venkataswamybabu.budumuru@citrix.com>

--===============8167333358096242155==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/9651/
-----------------------------------------------------------

(Updated March 5, 2013, 1:31 p.m.)


Review request for cloudstack, Chip Childers and Marcus Sorensen.


Changes
-------

Chip,

Can you please add this code to 4.1?

Thanks,
SWAMY


Description
-------

to repro =


(1) Have an advanced zone with physical networks say Phynet1: 900-905 Phyne=
t2: 905-909
(2) create a Network in physical network1 (id : 200) and deploy a vm (for e=
x:- network created is using vlan 905 )
(3) create another network in physical network2 (id : 201) and deploy a vm =


Observations :

(i) It tried to pick up vlan 905 from physical network 2 (id : 201) and it =
failed with the following error.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolatio=
nException: Duplicate entry '905-1-3' for key 'i_op_dc_vnet_alloc__vnet__da=
ta_center_id__account_id'

Attached patch fixes the issue.


This addresses bug CLOUDSTACK-1429.


Diffs
-----

  setup/db/db/schema-40to410.sql 59b2a7d =


Diff: https://reviews.apache.org/r/9651/diff/


Testing
-------

Retried the scenario with the dropped index and it works successfully.


Thanks,

venkata swamy babu  budumuru


--===============8167333358096242155==--