mod-pubsub failing to migrate from v2.5.0 to v2.5.1 for Lotus hotfix #1

Description

When trying to upgrade mod-pubsub to v2.5.1 - fails with Internal Server error

2022-06-21 15:27:24.526,15:27:24 [] [] [] [] WARN ? Activation of module 'mod-pubsub-2.5.1' for tenant 'tenantid' failed: Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.526, 5 change sets check sum 2022-06-21 15:27:24.526, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.526, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.526, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.526, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.526, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.527,"140.234.254.225, 10.23.44.194 - 10.23.46.84 - - [21/Jun/2022:15:27:24 +0000] ""POST /_/proxy/tenants/tenantid/install?async=false&ignoreErrors=false HTTP/1.1"" 500 1381 rt=1.062 uct=""0.000"" uht=""1.060"" urt=""1.060"" ""Apache-HttpClient/4.5.13 (Java/11.0.14.1)"" ""supertenant"" ""-"" ""-""" 2022-06-21 15:27:24.527,15:27:24 [] [] [] [] WARN ? job failed 2022-06-21 15:27:24.527,io.vertx.core.impl.NoStackTraceThrowable: Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.527, 5 change sets check sum 2022-06-21 15:27:24.527, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.527, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.527, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.527, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.527, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.527,15:27:24 [] [] [] [] WARN ? Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.527, 5 change sets check sum 2022-06-21 15:27:24.527, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.527, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.527, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.527, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.527, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.527,io.vertx.core.impl.NoStackTraceThrowable: Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.527, 5 change sets check sum 2022-06-21 15:27:24.527, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.527, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.527, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.527, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.527, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.527,15:27:24 [] [] [] [] INFO ? 972899/proxy RES 500 1060561us okapi Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.527, 5 change sets check sum 2022-06-21 15:27:24.527, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.527, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.527, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.527, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.527, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.527,15:27:24 [] [] [] [] ERROR ? HTTP response code=500 msg=Tenant operation failed for module mod-pubsub-2.5.1: liquibase.exception.ValidationFailedException: Validation Failed: 2022-06-21 15:27:24.527, 5 change sets check sum 2022-06-21 15:27:24.527, 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:6c6833be2718646fc0755242ddebe156 but is now: 8:22e89c357e72dd3d2dd90103f6dbe6b1 2022-06-21 15:27:24.527, 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:695adf23ac2c12a8110b381c027a9f34 but is now: 8:5be51c99bc6b3df6fc5323d0257cbf76 2022-06-21 15:27:24.527, 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:3932094d0fe3b9483527ef2973abe31c but is now: 8:be3f746d17912c946b7224e2307402fc 2022-06-21 15:27:24.527, 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:b806427376139fa5efbad3048f69c4a2 but is now: 8:75ed3d3c5b6f5f403b2bdb2a7f9a8bf0 2022-06-21 15:27:24.527, 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:5e6b1fd4af0cf7cc2207931d1d4eed02 but is now: 8:0623f749c49fcab1d65a2a9e73061f84 2022-06-21 15:27:24.529,"140.234.254.225 - 10.23.47.191 - - [21/Jun/2022:15:27:24 +0000] ""POST /_/proxy/tenants/tenantid/install?async=false&ignoreErrors=false HTTP/1.1"" 500 90 rt=1.065 uct=""0.004"" uht=""1.068"" urt=""1.068"" ""Apache-HttpClient/4.5.13 (Java/11.0.14.1)"" ""supertenant"" ""-"" ""-"""

The problem is very similar to:
https://folio-org.atlassian.net/browse/MODKBEKBJ-656

The same workaround worked: "The suggested solution is to replace failed check sums in database with new ones..."

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Michelle Suranofsky June 23, 2022 at 12:27 PM

- that is correct. I will send you the log.

Mykyta Varenyk June 23, 2022 at 9:09 AM

Hi . Do I understand correctly that you've substituted the real tenant ID with 'tenantid'? If yes, in order for us to fix the bug we need to write a migration script that should include the real tenant ID

Ann-Marie Breaux June 22, 2022 at 10:47 AM

Hi There was no dev team on this, so I assigned to Vega, per the matrix. Please adjust if that's not correct. Thank you!

Done

Details

Assignee

Reporter

Priority

Story Points

Development Team

Vega

Release

Morning Glory (R2 2022) Bug Fix

RCA Group

TBD

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created June 21, 2022 at 8:59 PM
Updated June 23, 2022 at 1:00 PM
Resolved June 23, 2022 at 1:00 PM
TestRail: Cases
TestRail: Runs

Flag notifications