incubator-cloudstack-dev mailing list archives

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

This bug fix is here:



-----Original Message-----
From: Alex Huang [] 
Sent: Monday, July 09, 2012 6:09 PM
Subject: RE: unique key and removed field

It's a bug.  Please file it.


> -----Original Message-----
> From: Hugo Trippaers []
> Sent: Monday, July 09, 2012 1:00 AM
> To:
> 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

View raw message