Bug 528953
Summary: | Schema upgrade needs to properly update rhnKickstartPackage table | ||
---|---|---|---|
Product: | Red Hat Satellite 5 | Reporter: | Milan Zázrivec <mzazrivec> |
Component: | Upgrades | Assignee: | Michael Mráka <mmraka> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Milan Zázrivec <mzazrivec> |
Severity: | high | Docs Contact: | |
Priority: | high | ||
Version: | 530 | CC: | cperry, jhutar, msuchy |
Target Milestone: | --- | ||
Target Release: | --- | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | spacewalk-schema-0.9.2-1 | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2010-10-28 14:56:29 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: | |||
Bug Depends On: | |||
Bug Blocks: | 608757 |
Description
Milan Zázrivec
2009-10-14 13:54:54 UTC
Problem fixed by Michael Mraka in spacewalk-schema, spacewalk.git: 35e5f0f431788d7617dec023aeb19069175e0cf5 Verified with Satellite-5.4.0-RHEL5-re20101001.1 / spacewalk-schema-1.2.21-3 Results you see and are describing are expected. The procedure you used was correct -- 5.2.0 -> 5.4.0 upgrade. The position column was added after 5.2.0 , the data in the column was not set correctly and this bug report was just about that -- fixing the data. I have updated Satellite 5.2.0 -> 5.4.0 and KS profiles software section did not kept their ordering: == Kickstart: jhutar1-Base == %packages @ Base == Kickstart: jhutar2-Base-a2ps-zsh == %packages @ Base a2ps zsh == Kickstart: jhutar3-Base-zsh-a2ps == %packages @ Base a2ps zsh == Kickstart: jhutar4-Base-acl-aide-MINUSacpid-adaptx == (see comment #4 for original order) %packages -acpid @ Base acl adaptx aide And in DB there is: SQL> Name Null? Type ----------------------------------------- -------- ---------------------------- KICKSTART_ID NOT NULL NUMBER PACKAGE_NAME_ID NOT NULL NUMBER CREATED NOT NULL DATE MODIFIED NOT NULL DATE POSITION NOT NULL NUMBER # echo "SELECT * FROM rhnKickstartPackage WHERE KICKSTART_ID = 4 ORDER BY POSITION;" | sqlplus rhnsat/rhnsat@rhnsat KICKSTART_ID PACKAGE_NAME_ID CREATED MODIFIED POSITION ------------ --------------- --------- --------- ---------- 4 2695 21-OCT-10 22-OCT-10 0 4 2462 21-OCT-10 22-OCT-10 1 4 805 21-OCT-10 22-OCT-10 2 4 1477 21-OCT-10 22-OCT-10 3 4 263 21-OCT-10 22-OCT-10 4 # echo "SELECT * FROM rhnPackageName WHERE ID = 2695 OR ID = 2462 OR ID = 805 OR ID = 1477 OR ID = 263;" | sqlplus rhnsat/rhnsat@rhnsat ID NAME ---------- ---------------------------------------------------------------- 2695 -acpid 2462 @ Base 805 acl 1477 adaptx 263 aide Please is this PASS (POSITION column seems sane) or FAIL (sorting was not kept)? Results in comment #6 mean PASS. So according to comment #7 this was re-verified => RELEASE_PENDING The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332 RHEA-2010:0803 - RHN Tools enhancement update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333 RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334 RHEA-2010:0800 - RHN Satellite Server 5.4.0 https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335 Docs are available: http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html Regards, Clifford |