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

Question

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.

score 1 · Accepted Answer · answered Mar 23 '21 at 09:08

1

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.

answered Mar 23 '21 at 09:08

htshame

6,599
5
36
56

If i clear checksums. it will re run all statements again right? – DilliBabu S Mar 23 '21 at 09:59
It will not rerun the changeSets which were already executed. If some of the changeSets weren't executed, then these changeSets will be executed. – htshame Mar 23 '21 at 10:18
Thanks @htshame. You given me a clear answer. – DilliBabu S Mar 26 '21 at 09:12

score 0 · Answer 2 · answered Mar 24 '21 at 10:06

0

Posting a link to the answer on liquibase forums for other users if they encounter the same query ever in future.

answered Mar 24 '21 at 10:06

Rakhi Agrawal

827
7
14

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

2 Answers2