Bug 109152

Summary: redundant tables in database
Product: Red Hat Satellite 5 Reporter: Kim Dykeman <kdykeman>
Component: OtherAssignee: Peter Jones <pjones>
Status: CLOSED CURRENTRELEASE QA Contact: Fanny Augustin <fmoquete>
Severity: medium Docs Contact:
Priority: medium    
Version: unspecified   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: rhn340sat Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2005-09-14 16:20:03 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 120995    

Description Kim Dykeman 2003-11-05 01:42:39 UTC 
check_suite_probe and check_suite_member_probes contain redundant
data.  This appears to be an artifact of the probe_schema refactor.

Apparently check_suite_probe was originally not a subclass of probe.
When check_suites was created as a subclass of probe and its data was
populated, check_suite_probe should have gone away.

Both classes are being used by the dynamo code (check_suite_probe more
heavily than check_suite_member_probe).
Comment 1 Karen Jacqmin-Adams 2004-05-18 16:29:54 UTC 
#  How was this issue addressed?
Dropped table check_suite_member_probe and replaced references to it 
with check_suite_probe.

# What level of users are affected? 
Only the non-existent monitoring UI is impacted.

# Where specifically can the change be seen?
Database schema only

# If the change cannot be verified visually, how should it be tested?
1) sqlplus command: "desc check_suite_member_probe" should not be able
to find the table after the monitoring schema is deployed
2) monitoring schema should deploy check_suite_member_probe cleanly
Comment 2 Karen Jacqmin-Adams 2004-05-28 14:48:59 UTC 
Transfering to Peter to mark as ON_DEV when he pushes the monitoring
schema to webdev.
Comment 3 Peter Jones 2004-05-31 21:58:01 UTC 
on dev
Comment 4 Nick Hansen 2004-06-09 17:12:57 UTC 
actually, #2 should read:
 2) monitoring schema should deploy check_suite_probe cleanly 

That being the case, this bug passes qa.
Comment 5 Matt Jamison 2004-06-21 14:05:12 UTC 
is there a test plan for this?
Comment 6 Matt Jamison 2004-06-22 15:56:00 UTC 
ok, I obviously didn't read this thread carefully.

I now see the test plan thanks to the observant eyes of gdk.
Comment 7 Fanny Augustin 2004-06-24 15:17:35 UTC 
Looks good in DB.