Bug 1308521 - Purge taskomatic records during upgrade
Summary: Purge taskomatic records during upgrade
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Ales Dujicek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-02-15 12:57 UTC by Tomáš Kašpárek
Modified: 2016-04-28 11:16 UTC (History)
4 users (show)

Fixed In Version: rhn-upgrade-5.7.0.32-1-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-04-28 11:16:02 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2016:0698 0 normal SHIPPED_LIVE Red Hat Satellite rhn-upgrade-5.7 bug fix update 2016-04-28 15:15:14 UTC

Description Tomáš Kašpárek 2016-02-15 12:57:58 UTC
Description of problem:
In BZ#1305157 we've added additional functionality to Sat 5.6 added in BZ#1215671 to 5.7. However as these are added later in 5.7 lifecycle and not in plain 5.7 there are few problems during 5.6 -> 5.7 upgrade.
1. There are additional taskomatic related records in the DB but no Java classes -> taskomatic will be failing on plain 5.7 with ClassNotFound exceptions.
2. Applying erratum which fixed BZ#1215671 can cause troubles as there are no INSERT WHERE NOT EXISTS statements in https://github.com/spacewalkproject/spacewalk/blob/master/schema/spacewalk/upgrade/spacewalk-schema-2.3-to-spacewalk-schema-2.4/002-auto-errata-update-task.sql

Version-Release number of selected component (if applicable):
5.6 -> 5.7 upgrade

How reproducible:
always

Steps to Reproduce:
1. Apply fix for BZ#1305157 on 5.6
2. Upgrade to 5.7

Actual results:
Upgraded DB from 5.6 to 5.7 contains taskomatic records related to (at plain 5.7) non-existing Java classes. During upgrade process either duplicate records are created or schema-upgrade process fails with unique constraint violation (haven't tested this one).

Expected results:
There should be no evidence of taskomatic classes added by BZ#1305157 on upgraded 5.7 instance.

Comment 9 errata-xmlrpc 2016-04-28 11:16:02 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2016-0698.html


Note You need to log in before you can comment on or make changes to this bug.