Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
First Last Prev Next    This bug is not in your last search results.
Bug 1417313 - Schema missing warnings in logs
Schema missing warnings in logs
Status: CLOSED ERRATA
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Providers (Show other bugs)
5.7.0
Unspecified Unspecified
high Severity high
: GA
: 5.9.0
Assigned To: Nick Carboni
luke couzens
black
:
Depends On:
Blocks:
  Show dependency tree / graph
 
Reported: 2017-01-27 18:09 EST by myoder
Modified: 2018-03-01 08:09 EST (History)
9 users (show)

See Also:
Fixed In Version: 5.9.0.1
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2018-03-01 08:09:24 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: Bug
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2018:0380 normal SHIPPED_LIVE Moderate: Red Hat CloudForms security, bug fix, and enhancement update 2018-03-01 13:37:12 EST

  None (edit)
Description myoder 2017-01-27 18:09:13 EST 
Description of problem:

After the upgrade to CloudForms 4.2, there is a hotfix to install cfme-5.7.0.17-2.el7cf.x86_64.rpm, to fix failed refresh for the OCP 3.3 provider.  Once the hotfix is applied, these WARN messages are showing up in the logs:

[----] W, [2017-01-19T23:15:24.136788 #41978:369138]  WARN -- : MIQ(MiqServer.check_migrations_up_to_date) database schema is from a newer version of the product and may be incompatible.  Schema version is [20160922235000].  Missing files: [20160106214719, 20160425161345]
[----] W, [2017-01-19T23:15:24.136884 #41978:369138]  WARN -- : MIQ(MiqServer.check_migrations_up_to_date) appliance should be updated to match database version

Version-Release number of selected component (if applicable):
CFME 5.7.0.17

How reproducible:
always

Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:
Comment 12 Nick Carboni 2017-02-20 10:04:15 EST 
The issue here is that migrations that have been run previously are no longer present on the filesystem. This would be an issue if we ever wanted to migrate "down", but we don't ever do that in production.

The warning can be "fixed" by removing the version rows for the two migrations from the schema_migrations table.

What do you think Jason? Is that a thing we should do (write a new migration to edit schema_migrations) or should we be deleting the contents of the migrations rather than the entire files?
Comment 17 CFME Bot 2017-06-13 14:01:44 EDT 
New commit detected on ManageIQ/manageiq/master:
https://github.com/ManageIQ/manageiq/commit/4a44664a08f67f5127ad4d04581f17d0c48a03a8

commit 4a44664a08f67f5127ad4d04581f17d0c48a03a8
Author:     Nick Carboni <ncarboni@redhat.com>
AuthorDate: Wed Apr 19 11:51:51 2017 -0400
Commit:     Nick Carboni <ncarboni@redhat.com>
CommitDate: Wed Apr 19 11:51:51 2017 -0400

    Remove the rows from schema_migrations for deleted migration files
    
    These migrations were removed in #11197 and #9696 and are now
    causing a warning in the logs if the schema_migrations row is present,
    but the files are not.
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1417313

 db/migrate/20170419154137_remove_deleted_migration_timestamps.rb | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 db/migrate/20170419154137_remove_deleted_migration_timestamps.rb
Comment 19 luke couzens 2017-10-24 04:02:50 EDT 
Verified in 5.9.0.3
Comment 22 errata-xmlrpc 2018-03-01 08:09:24 EST 
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://access.redhat.com/errata/RHSA-2018:0380
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.