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.

Uses

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.

Running the clearCheckSums command

To run the clearCheckSums command, you can specify the database 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 clearCheckSums command:

liquibase clearCheckSums

clearCheckSums global attributes

Attribute Definition Requirement
--username The database username Required*
--password The database password Required*
--url The JDBC database connection Required

Note: The username and password attributes are not required for connections and systems which use alternate means of authentication.

clearCheckSums example output

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.