How to find list of all database schema changes during RH-SSO version upgradation ?

Solution Verified - Updated -

Issue

  • In our RH-SSO environment certain foreign key constraints got dropped and we are facing issue in migrating RH-SSO from 7.4 to 7.6. Where can we find list of all foreign key constraints that is expected to be present in RH-SSO 7.4 ?
ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 88) Error has occurred while updating the database: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset META-INF/jpa-changelog-11.0.0.xml::map-remove-ri::keycloak:
     Reason: liquibase.exception.DatabaseException: ERROR: constraint "fk_traf444kk6qrkms7n56aiwq5y" of relation "realm" does not exist [Failed SQL: (0) ALTER TABLE public.REALM DROP CONSTRAINT FK_TRAF444KK6QRKMS7N56AIWQ5Y]
  • We need to review the current RH-SSO database schema before we upgrade. Where can we find list of all database schema changes in RH-SSO database ?

Environment

  • Red Hat Single Sign-On
    • 7.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content