How to find list of all database schema changes during RH-SSO version upgradation ?
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.