Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1642480

Summary: rhnKickstartableTree schema upgrade fails on Oracle
Product: [Community] Spacewalk Reporter: Ales Dujicek <adujicek>
Component: ServerAssignee: Michael Mráka <mmraka>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 2.9CC: mmraka
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-schema-2.10.2-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-03-19 12:16:49 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: 1802137    

Description Ales Dujicek 2018-10-24 13:43:59 UTC
Description of problem:

# spacewalk-schema-upgrade -y
...
Schema upgrade: [spacewalk-schema-2.8.25-1.fc28] -> [spacewalk-schema-2.9.7-1.el7]
Searching for upgrade path: [spacewalk-schema-2.8.25-1] -> [spacewalk-schema-2.9.7-1]
Searching for upgrade path: [spacewalk-schema-2.8.25] -> [spacewalk-schema-2.9.7]
Searching for upgrade path: [spacewalk-schema-2.8] -> [spacewalk-schema-2.9]
The path: [spacewalk-schema-2.8] -> [spacewalk-schema-2.9]
Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/20181023-233424-to-spacewalk-schema-2.9.log].
Upgrade failed, please see log [/var/log/spacewalk/schema-upgrade/20181023-233424-to-spacewalk-schema-2.9.log].



spacewalk-schema-2.8-to-spacewalk-schema-2.9/002-rhnKickstartableTree-kernelOptions.sql.oracle

    ADD COLUMN kernel_options	    VARCHAR2(256),
        *
ERROR at line 2:
ORA-00904: : invalid identifier


Version-Release number of selected component (if applicable):
spacewalk-schema-2.9.7-1.el7.noarch

Comment 1 Michael Mráka 2020-03-09 13:22:21 UTC
Fixed in spacewalk git by
commit b4dec482edc9795a301e3c6e2dbac528e6a12d2a
    fixed failed upgrade on oracle

Comment 2 Michael Mráka 2020-03-19 12:16:49 UTC
Spacewalk 2.10 has been released.
https://github.com/spacewalkproject/spacewalk/wiki/ReleaseNotes210