incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugo Trippaers <HTrippa...@schubergphilis.com>
Subject RE: unique key and removed field
Date Mon, 09 Jul 2012 18:45:46 GMT
Thanks Alex,

This bug fix is here: https://reviews.apache.org/r/5839/

Cheers,

Hugo

-----Original Message-----
From: Alex Huang [mailto:Alex.Huang@citrix.com] 
Sent: Monday, July 09, 2012 6:09 PM
To: cloudstack-dev@incubator.apache.org
Subject: RE: unique key and removed field

It's a bug.  Please file it.

--Alex

> -----Original Message-----
> From: Hugo Trippaers [mailto:HTrippaers@schubergphilis.com]
> Sent: Monday, July 09, 2012 1:00 AM
> To: cloudstack-dev@incubator.apache.org
> Subject: unique key and removed field
> 
> Hey guys,
> 
> While running some test scripts I noticed that the table 
> 'physical_network_service_providers' has a unique key on the 
> combination of physical_network_id and provider_name, this is 
> potentially a problem when we also use the removed field to indicate a device is removed.
> 
> In my case I added a new device, deleted it and immediately added a 
> new device using the same provider. This resulted in a database 
> exception because of a unique key violation. I think this is a bug, we 
> should either immediately remove the device or remove the unique 
> constraint and take care of this in the code using the removed field.
> 
> Any opinions on this?
> 
> Cheers,
> 
> Hugo

Mime
View raw message