liquibasechecksumchangelogliquibase-sql

How to recalculate checksums without re-running the statements in liquibase?

We were upgrade our liquibase from 1.9.0.0 to 3.6.3. When running migration MD5SUM for 3.6.3 was updated but it was trying to re-run the previously executed changesets which were executed with liquibase 1.9.0.0. How do i run only updating checksum with without re-running the statements.

Thanks.

Solution

  • Liquibase has Command Line Interface. And the CLI has clearCheckSums command.

    clearCheckSums clears all checksums and nullifies the MD5SUM column of the DATABASECHANGELOG table so they will be re-computed on the next database update.

    changesets that have been deployed will have their checksums re-computed, and pending changesets will be deployed.