Uploaded image for project: 'liquibase-util'
  1. liquibase-util
  2. LIQUTIL-25

Liquibase Tenant operation Validation Failed: 5 change sets check sum

    XMLWordPrintable

Details

    • EPAM-Veg Sprint 145
    • 3
    • Folijet Support
    • Nolana (R3 2022)
    • Implementation coding issue

    Description

      Upgrading mod-pubsub fails with this error in a multi-tenant environment:

      Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed:
           5 change sets check sum
                liquibase/tenant/scripts/v-0.0.1/2019-09-06--15-00-create-audit_message-table.xml::2019-09-06--15-00-create-message_state-type::KaterynaSenchenko was: 8:fd0d822c7d8aba9ebb82717a6dcdc080 but is now: 8:0677f5b7f9c5d8c8417286d9256d5702
                liquibase/tenant/scripts/v-0.0.1/2019-09-06--15-00-create-audit_message-table.xml::2019-09-06--15-00-create-audit_message-table::KaterynaSenchenko was: 8:668b7c6a54e50398c827aeb2a3ce2668 but is now: 8:23275735d59fcce794dc0014766bf9ec
                liquibase/tenant/scripts/v-0.0.1/2019-11-08--15-00-change-audit_message-table.xml::2019-11-08--15-00-add-rejected-message_state::KaterynaSenchenko was: 8:9a0377e6e9a932d18421939736ab59ce but is now: 8:4b3d5e142bfa4e8675911c05639fa630
                liquibase/tenant/scripts/v-0.0.1/2019-11-08--15-00-change-audit_message-table.xml::2019-11-08--15-00-update-audit_message-table::KaterynaSenchenko was: 8:cb80ed99ac6688a68aa692489350458f but is now: 8:eb01c205f94be6e775d70f215f61bbdc
                liquibase/tenant/scripts/v-0.0.1/2020-06-20--15-00-update-audit-message-payload-data.xml::2020-06-20--13-00-update-audit-message-payload-data::KaterynaSenchenko was: 8:190718a406903987d6985a9c5ae9e203 but is now: 8:60eea3ce275d7f32dc840547ee8b1ded
      

      Workaround: Manually run

      set search_path to minerva4_mod_pubsub ;
      update databasechangelog set md5sum='8:0677f5b7f9c5d8c8417286d9256d5702' where md5sum='8:fd0d822c7d8aba9ebb82717a6dcdc080';
      update databasechangelog set md5sum='8:23275735d59fcce794dc0014766bf9ec' where md5sum='8:668b7c6a54e50398c827aeb2a3ce2668';
      update databasechangelog set md5sum='8:4b3d5e142bfa4e8675911c05639fa630' where md5sum='8:9a0377e6e9a932d18421939736ab59ce';
      update databasechangelog set md5sum='8:eb01c205f94be6e775d70f215f61bbdc' where md5sum='8:cb80ed99ac6688a68aa692489350458f';
      update databasechangelog set md5sum='8:60eea3ce275d7f32dc840547ee8b1ded' where md5sum='8:190718a406903987d6985a9c5ae9e203';
      

      It seems that mod-pubsub used a wrong tenant when calculating the md5sum. This only happens in a multi-tenant environment.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                ruslan_lavrov Ruslan Lavrov
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases