[Spacewalk-list] [SOLVED] Current packages in 1.6-nightly repo breaks Spacewalk

[Miroslav Suchý]

On 10/18/2011 03:03 PM, Scott Worthington wrote:
> Miroslav Suchy,
> 
> Thank you for that tip to add that new constraint to a system using 1.6-nightly.
> 
> Where is the code for the "alter table rhnservernetwork add constraint
> vn_rhnservernetwork_ip6addr" located?
> 
> I thought it would be in a file in the subdirectory of
> /etc/sysconfig/rhn/schema-upgrade/ for users upgrading from Spacewalk
> 1.5 to 1.6, but it is not.
> 
> So I searched for the constraint portion of the alter table you
> mentioned above in other places...
> 
> grep -R -i "check (ip6addr::text" /usr/share/spacewalk/*
> grep -R -i "check (ip6addr::text" /usr/share/perl5/*
> grep -R -i "check (ip6addr::text" /usr/lib/python2.6/site-packages/spacewalk/*
> grep -R -i "check (ip6addr::text" /usr/share/rhn/*
> 
> ...but found no reference to it.
> 
> Would you mind letting me know where that change gets applied in the
> upgrade/setup/fresh-install code?

In fresh-install it is located in postgres/end.sql and is dynamically
created by create_varnull_constriants() function.

But I forget that this is not called during upgrades. I will add it to
upgrade script as well.

-- 
Miroslav Suchy
Red Hat Satellite Engineering