Bug 721383 - Beaker displays many duplicate distro families in Excluded Families tab.
Summary: Beaker displays many duplicate distro families in Excluded Families tab.
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: web UI
Version: 0.6
Hardware: All
OS: All
unspecified
medium vote
Target Milestone: ---
Assignee: Bill Peck
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-07-14 13:12 UTC by Vadim Grinco
Modified: 2019-05-22 13:41 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-09-08 02:43:25 UTC

Attachments (Terms of Use)
screen shot (153.17 KB, image/png)
2011-07-14 13:14 UTC, Vadim Grinco 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

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.
Note You need to log in before you can comment on or make changes to this bug.