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.
clearCheckSums is typically used when there is a
[MD5Sum Check Failed] error message and there is a need to clear the checksums from the DATABASECHANGELOG table.
To run the
clearCheckSums command, you can specify the driver, classpath, and URL in your
liquibase.properties file. For more information, see Creating and configuring a liquibase.properties file. You can also specify these properties in your command line.
Then run the
liquibase –-changeLogFile=mainchangelog.xml clearCheckSums
Note: Enter the name of the changelog you want to use in place of
mainchangelog.xml. You can also add the
changeLogFile to your
clearCheckSums global attributes
||The root changelog||Required|
||The database username||Required|
||The database password||Required|
||The JDBC database connection||Required|
When successful, the
clearCheckSums command produces the following output:
Liquibase Pro 3.9.0 by Datical licensed to Liquibase Pro Customer until Tue Sep 22 19:00:00 CDT 2020 Liquibase command 'clearCheckSums' was executed successfully.