Bug 809078

Summary:	Duplicate ProductPoolAttributes are created.
Product:	[Community] Candlepin	Reporter:	William Poteat <wpoteat>
Component:	candlepin	Assignee:	candlepin-bugs
Status:	CLOSED CURRENTRELEASE	QA Contact:	Katello QA List <katello-qa-list>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	0.5	CC:	aedwards, jesusr, wpoteat
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:	796421	Environment:
Last Closed:	2013-10-16 18:54:17 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:	796421
Bug Blocks:

Description William Poteat 2012-04-02 12:36:42 UTC

The hosted Candlepin in IT is showing the creation of duplicate ProductPoolAttributes in the database. This led to an inability to delete pools that was handled by a previous bug fix. The deletion of a pool will remove the duplicate attributes, but the condition should not arise to begin with.

There may need to be unique constraints applied to the ProductPoolAttribute table to stop this from happening. It will cause problems in the short term because the hosted DB will need to be cleaned first.

Determining the best way forward, accounting for short- and long-term pain will be the key.