Bug 511343

Summary:	Changing Architectures of the RHEV-M Related Channels
Product:	[Retired] Red Hat Network	Reporter:	Jay Greguske <jgreguske>
Component:	RHN/Rel-Eng	Assignee:	Grant Gainey <ggainey>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Network Quality Assurance <rhn-qa-list>
Severity:	medium	Docs Contact:
Priority:	high
Version:	RHN Stable	CC:	acarter, dhughes, rhn-bugs
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-07-23 19:32:38 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:

Description Jay Greguske 2009-07-14 19:08:59 UTC

RHN channels related to the RHEV-M product have an incorrect architecture: they are listed as x86_64 but it should be IA-32/i386. The architecture field has been changed to correct this, however the arch is also present in the channel labels (and their corresponding families) which is inconsistent.

The channel labels that need to change are:
rhev-x86_64-m-d-2 ---> rhev-i386-m-d-2
rhev-x86_64-m-s-2 ---> rhev-i386-m-s-2

and the family labels that need to change are exactly the same:
rhev-x86_64-m-d-2 ---> rhev-i386-m-d-2
rhev-x86_64-m-s-2 ---> rhev-i386-m-s-2

These changes need to be replicated in stage and prod environments too. The beta channels should NOT be impacted.

Comment 1 Grant Gainey 2009-07-14 19:20:43 UTC

update rhn.rhnchannel c
   set c.label = 'rhev-i386-m-d-2'
 where c.label = 'rhev-x86_64-m-d-2';
 
update rhn.rhnchannel c
   set c.label = 'rhev-i386-m-s-2'
 where c.label = 'rhev-x86_64-m-s-2';
 
update rhn.rhnchannelfamily cf
   set cf.label = 'rhev-i386-m-d-2'
 where cf.label = 'rhev-x86_64-m-d-2';
 
update rhn.rhnchannelfamily cf
   set cf.label = 'rhev-i386-m-s-2'
 where cf.label = 'rhev-x86_64-m-s-2';

Comment 2 Grant Gainey 2009-07-14 19:33:38 UTC

This change can't be accomplished using the RCM tooling, because the channel/family label is the *id* those tools work with.  Therefore, it must be done with SQL run against the DB.

The above SQL is checked in here:

http://git.corp.redhat.com/?p=rhn/rhn.git;a=blob;f=schema/changes/dev/512/511343.sql;h=1b8a68619c8fa590ce6c3b1420cc08c3cb752e63;hb=HEAD

It needs to be run in STAGE and PROD

Comment 3 Denise Hughes 2009-07-23 19:32:38 UTC

This is complete and stage and prod.  Closing bug.