Bug 872348
| Summary: | Since 1.8 Release, Cannot Access Channels | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Kevin Stange <kevin> | ||||
| Component: | Server | Assignee: | Michael Mráka <mmraka> | ||||
| Status: | CLOSED NOTABUG | QA Contact: | Red Hat Satellite QA List <satqe-list> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 1.8 | ||||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2012-11-01 21:39:34 UTC | Type: | Bug | ||||
| 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: | 1484117 | ||||||
| Attachments: |
|
||||||
I tried running spacewalk-sql manually (just discovered the command) using scripts 145 - 149 and that seems to have resolved the problem. This BZ closed some time during 2.5, 2.6 or 2.7. Adding to 2.7 tracking bug. |
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