Created attachment 636833 [details]
Traceback

Description of problem:

I just updated last night to the latest nightly, including a schema update.  This turned out to be the 1.8 release version.

Since upgrading, I can no longer enroll systems or visit any channel details page in the web UI (via Channels > Any Channel Name).  I can visit the packages list or other tabs for a channel besides details.

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

spacewalk-schema-1.8.86-1.el6.noarch
spacewalk-base-1.8.49-1.el6.noarch
spacewalk-java-lib-1.8.178-1.el6.noarch

How reproducible:

100% on all channels.

Steps to Reproduce:
1. Click Channels
2. Click any channel name (to reach Details page)

1.   /usr/sbin/rhnreg_ks -v --serverUrl=http://<host>/XMLRPC   --activationkey=1-centos5-x86_64

Actual results:

Internal Server Error and traceback email.

Expected results:

Success

Additional info:

I believe this is related to the schema updates:

* Wed Oct 31 2012 Jan Pazdziora 1.8.86-1
- The index might not actually exist.
- Fixing syntax.
- define rhnOrgDistChannelMap view dependency
- create rhnDistChannelMap triggers in the schema

* Wed Oct 31 2012 Jan Pazdziora 1.8.85-1
- Fixing syntax.

* Tue Oct 30 2012 Tomas Lestach <tlestach> 1.8.84-1
- channel permission shall be guaranteed by the rhnOrgDistChannelMap
- update rhn_channel package to use rhnOrgDistChannelMap
- introduce rhnOrgDistChannelMap
- create rhnDistChannelMap triggers to auto fill in id
- add id and org_id to rhnDistChannelMap

I ran spacewalk-schema-upgrade with spacewalk service stopped after upgrading to this package version and no error was reported.

I'm attaching a traceback from accessing the channel details page.  Relevant line is surely:

Caused by: org.postgresql.util.PSQLException: ERROR: column distchanne0_.id does not exist