Version 4.18 and 4.17.2 taking long time in computing checksum

Liquibase Development
1

Environment

Liquibase Version:
4.18 and 4.17.2
Liquibase Integration & Version: <Pick one: CLI, maven, gradle, spring boot, servlet, etc.>
CLI
Liquibase Extension(s) & Version:
4.18 and 4.17.2
Database Vendor & Version:
Oracle Database 19c Enterprise Edition Release 19.3.0.0.0

Operating System Type & Version:
Oracle Enterprise Linux 7
Infrastructure Type/Provider: <AWC, GCS, Azure, VM, etc>
VM

Description

Starting Liquibase at 20:06:21 (version 4.17.2 #5255 built at 2022-11-01 18:07+0000)
[2022-11-30 20:06:23] INFO [liquibase.lockservice] Successfully acquired change log lock
[2022-11-30 20:06:39] INFO [liquibase.changelog] Creating database history table with name: TEST_APP.DBCHANGELOG
[2022-11-30 20:06:39] INFO [liquibase.changelog] Reading from TEST_APP.DBCHANGELOG
Running Changeset: changelogs/prerequisite_checks.xml::1::base
[2022-11-30 20:29:36] INFO [liquibase.changelog] ChangeSet changelogs/prerequisite_checks.xml::1::base ran successfully in 16ms

Starting Liquibase at 23:59:58 (version 4.18.0 #5864 built at 2022-12-02 18:02+0000)
[2023-01-09 23:59:59] INFO [liquibase.lockservice] Successfully acquired change log lock
[2023-01-10 00:00:18] INFO [liquibase.changelog] Creating database history table with name: TEST_APP.DBCHANGELOG
[2023-01-10 00:00:18] INFO [liquibase.changelog] Reading from TEST_APP.DBCHANGELOG
Running Changeset: changelogs/prerequisite_checks.xml::1::base
[2023-01-10 00:22:13] INFO [liquibase.changelog] ChangeSet changelogs/prerequisite_checks.xml::1::base ran successfully in 16ms

Taking approx ~ 22 mins in version 4.17.2 and version 4.18.0

Starting Liquibase at 16:24:35 (version 4.14.0 #3667 built at 2022-07-22 18:36+0000)
[2022-07-29 16:24:37] INFO [liquibase.lockservice] Successfully acquired change log lock
[2022-07-29 16:24:51] INFO [liquibase.changelog] Creating database history table with name: TEST_APP.DBCHANGELOG
[2022-07-29 16:24:51] INFO [liquibase.changelog] Reading from TEST_APP.DBCHANGELOG
Running Changeset: changelogs/prerequisite_checks.xml::1::base
[2022-07-29 16:25:04] INFO [liquibase.changelog] ChangeSet changelogs/prerequisite_checks.xml::1::safety-base ran successfully in 16ms

Taking approx ~ few secs in version 4.14.0 ( issue not seen here)

A clear and concise description of the issue being addressed.

  • Describe the actual problematic behavior.
  • Ensure private information is redacted.

Steps To Reproduce

  1. Run Liquibase version 4.14, runs fine no slowness seen
  2. Run Liquibase version 4.17.2 and version 4.18, takes long time as shown above, Issue seen in recent versions.

List the steps to reproduce the behavior.

  1. Run Liquibase version 4.14, runs fine no slowness seen
  2. Run Liquibase version 4.17.2 and version 4.18, takes long time as shown above, Issue seen in recent versions.

Actual Behavior

  1. Run Liquibase version 4.14, runs fine no slowness seen
  2. Run Liquibase version 4.17.2 and version 4.18, takes long time as shown above, Issue seen in recent versions.

Expected/Desired Behavior

  1. Run Liquibase version 4.17.2 and version 4.18, no slowness should be seen as mentioned in above steps.
    This should behave as Liquibase version 4.14.

Jars used under /lib folder in version 4.14, version 4.17.2 and version 4.18
commons-lang3.jar
liquibase-core.jar
ojdbc8.jar
opencsv.jar
README.txt
snakeyaml.jar

2

Reported under Version 4.18 and 4.17.2 taking long time in computing checksum · Issue #3655 · liquibase/liquibase · GitHub