Bug 1410365

Summary: Upgrade from 5.7@Oracle to 5.8@EmbPosgres - taskomatic schema diff
Product: Red Hat Satellite 5 Reporter: Ales Dujicek <adujicek>
Component: UpgradesAssignee: Tomáš Kašpárek <tkasparek>
Status: CLOSED CURRENTRELEASE QA Contact: Ales Dujicek <adujicek>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 580CC: tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: rhn-upgrade-5.8.0.10-1-sat Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-06-21 12:13:02 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: 1393921    

Description Ales Dujicek 2017-01-05 10:24:13 UTC
Description of problem:

After upgrade of Satellite with oracle database to 5.8 with embedded db
there are taskomatic related differences in database schema

Data in [rhntaskobunch] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select description, name, org_bunch from rhntaskobunch order by description, name, org_bunch
< Calls the synch probe state proc sync-probe-bunch 
< Runs satellite-sync
Parameters:
- list parameter lists channels
- channel parameter specifies channel to be synced
- without parameter runs satellite-sync without parameters sat-sync-bunch Y
< Schedule automatic errata update actions auto-errata-bunch 
< Schedules a comparison of config files on all systems compare-configs-bunch 
< Sends daily report daily-status-bunch 
< Syncs kickstart profiles that were generated using the wizard kickstartfile-sync-bunch 
< Used for syncing repos to a channel repo-sync-bunch Y
> purge orphaned uuid records uuid-cleanup-bunch 
> Runs satellite-sync
Parameters:
- list parameter lists channels
- channel parameter specifies channel to be synced
- without parameter runs satellite-sync without parameters sat-sync-bunch Y
> Schedule automatic errata update actions auto-errata-bunch 
> Schedules a comparison of config files on all systems compare-configs-bunch 
> Sends daily report daily-status-bunch 
> Syncs kickstart profiles that were generated using the wizard kickstartfile-sync-bunch 
> Used for syncing repos to a channel repo-sync-bunch Y

Data in [rhntaskoschedule] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select active_till, cron_expr, job_label, org_id from rhntaskoschedule order by active_till, cron_expr, job_label, org_id
>  0 * * * * ? errata-cache-default 
<  0 * * * * ? sync-probe-default 
>  0 0 * * * ? uuid-cleanup-default 
<  0 0/10 * * * ? errata-cache-default 

Data in [rhntaskotask] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select class, name from rhntaskotask order by class, name
< com.redhat.rhn.taskomatic.task.SynchProbeState sync-probe-state
< com.redhat.rhn.taskomatic.task.TimeSeriesCleanUp cleanup-timeseries-data
> com.redhat.rhn.taskomatic.task.UuidCleanup uuid-cleanup

Data in [view_rhntaskoschedule] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select active_till, bunch, cron_expr, job_label, org_id from view_rhntaskoschedule order by active_till, bunch, cron_expr, job_label, org_id
>  errata-cache-bunch 0 * * * * ? errata-cache-default 
<  errata-cache-bunch 0 0/10 * * * ? errata-cache-default 
<  sync-probe-bunch 0 * * * * ? sync-probe-default 
>  uuid-cleanup-bunch 0 0 * * * ? uuid-cleanup-default 

Data in [view_rhntaskotemplate] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select bunch, ordering, start_if, task from view_rhntaskotemplate order by bunch, ordering, start_if, task
> cleanup-data-bunch 0  cleanup-packagechangelog-data
< cleanup-data-bunch 0  cleanup-timeseries-data
< cleanup-data-bunch 1  cleanup-packagechangelog-data
< sync-probe-bunch 0  sync-probe-state
> uuid-cleanup-bunch 0  uuid-cleanup


Version-Release number of selected component (if applicable):
spacewalk-schema-2.5.1-27.el6sat.noarch
satellite-schema-5.8.0.17-1.el6sat.noarch
rhn-upgrade-5.8.0.7-1.el6sat.noarch


Steps to Reproduce:
1. upgrade 5.7 with oracle to 5.8 with emb database
2. compare database schema with new 5.8 schema