Bug 1245771

Summary: [RFE] Method by which to check for schema version discrepancies for debugging purposes.
Product: Red Hat Satellite Reporter: Corey Welton <cwelton>
Component: UpgradesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED WONTFIX QA Contact: Katello QA List <katello-qa-list>
Severity: high Docs Contact:
Priority: high    
Version: 6.1.0CC: bkearney, cdonnell, ktordeur, sthirugn
Target Milestone: UnspecifiedKeywords: FutureFeature, Triaged, UserExperience
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-03-22 19:49:31 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: 1115190    

Description Corey Welton 2015-07-22 17:35:05 UTC 
Description of problem:

We should have some method, executed ($how?) that

* Checks the appropriate schema version per Satellite packages installed
* Checks to see what schema version is currently running on an existing satellite.

If a mismatch is encountered, a warning is thrown that reads something like

WARNING: Schema Mismatch! Satellite package indicate schema xxx.yyz should be used, you are using schema xxx.yyy.  Please follow appropriate upgrade steps from documentation"

$how - I am not sure.  Is it something you'd want to run periodically?  Almost certainly something that might be useful in foreman-debug, and perhaps `katello-service status` as well...
Comment 1 Corey Welton 2015-07-22 17:37:11 UTC 
Rationale:

Doing something like

`katello-service stop && yum -y update && katello-service start` w/o running `katello-installer --upgrade` may put the system in a state of confusion.  We should be able to determine  (and perhaps check from time to time) whether everything is just so.
Comment 2 Bryan Kearney 2015-07-23 15:23:32 UTC 
Satellite 5 has a batch job which loooks for out of date schemas. Perhaps we look at this type of model.
Comment 5 Bryan Kearney 2016-07-08 20:22:54 UTC 
Per 6.3 planning, moving out non acked bugs to the backlog
Comment 9 sthirugn@redhat.com 2018-03-22 14:04:54 UTC 
this issue also has related bugs like https://bugzilla.redhat.com/show_bug.cgi?id=1459358
Comment 10 Bryan Kearney 2018-03-22 19:49:31 UTC 
Per meeting with rjerrido We are going to focus on fixing https://bugzilla.redhat.com/show_bug.cgi?id=1459358 which is the root cause, not on this.