Bug 721383

Summary: Beaker displays many duplicate distro families in Excluded Families tab.
Product: [Retired] Beaker Reporter: Vadim Grinco <vgrinco>
Component: web UIAssignee: Bill Peck <bpeck>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: 0.6CC: bpeck, dcallagh, mcsontos, rmancy, stl
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-09-08 02:43:25 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
screen shot none

Description Vadim Grinco 2011-07-14 13:12:58 UTC 
Description of problem:
Beaker displays many duplicate distro families in Excluded Families tab.

Version-Release number of selected component (if applicable):
0.6.15

How reproducible:
Always

Steps to Reproduce:
1. Open any system you have access to
2. Open the Excluded Families tab
3. Check out how many duplicates are there.

A screen shot is attached.
Comment 1 Vadim Grinco 2011-07-14 13:14:08 UTC 
Created attachment 512891 [details]
screen shot
Comment 2 Bill Peck 2011-07-14 15:30:00 UTC 
We're missing a unique constraint on osversion table:

--- a/Server/bkr/server/model.py
+++ b/Server/bkr/server/model.py
@@ -430,6 +430,7 @@
            nullable=False, primary_key=True),
     Column('osmajor_id', Integer, ForeignKey('osmajor.id')),
     Column('osminor',Unicode(255)),
+    UniqueConstraint('osmajor_id', 'osminor', name='uix_1'),
     mysql_engine='InnoDB',
 )
 


That's the easy part.  I'm now looking at how we craft the sql to fix the current duplicates.
Comment 5 Dan Callaghan 2011-09-08 02:43:25 UTC 
Beaker 0.7.1 has been released.