Bug 1410365 - Upgrade from 5.7@Oracle to 5.8@EmbPosgres - taskomatic schema diff
Summary: Upgrade from 5.7@Oracle to 5.8@EmbPosgres - taskomatic schema diff
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 580
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Ales Dujicek
URL:
Whiteboard:
Depends On:
Blocks: sat580-upgrades
TreeView+ depends on / blocked
 
Reported: 2017-01-05 10:24 UTC by Ales Dujicek
Modified: 2017-06-21 12:13 UTC (History)
1 user (show)

Fixed In Version: rhn-upgrade-5.8.0.10-1-sat
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-06-21 12:13:02 UTC
Target Upstream Version:


Attachments (Terms of Use)

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


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