Liquibase checksum validation error without any changes

maven liquibase changeset
Daggeto picture Daggeto · Apr 3, 2012 · Viewed 87.4k times · Source

Maven fires liquibase validation fail even no changes was made in changeset.

My database is oracle.

Situation:

  1. In DB changelog table was record for changeset <changeSet id="1" author="me" dbms="oracle">;

  2. Then by mistake i added another changeset <changeSet id="1" author="me" dbms="hsqldb">

  3. Reruned liquibase scripts Maven fired checksum validation error.

  4. Then i changed hsqldb changeSet to <changeSet id="2" author="me" dbms="hsqldb">

  5. Maven still firing checksum validation error.

  6. Then i changed first changeSet checksum in DB manually to current checkSum and scripts runned successfully.

Everything looks nice ,but when i redeploy whole application and run liquibase scripts checksum of first changeSet is still like before 6 step.

Answer

Roy Truelove picture Roy Truelove · Apr 3, 2012

If you're confident that your scripts correctly reflect what should be in the database, run the liquibase:clearCheckSums maven goal, which will clean it all up.

Related questions

Spring boot - disable Liquibase at startup

I want to have Liquibase configured with my spring boot aplication, so I added dependencies to pom.xml and set the path to master.xml in application.properties. This works fine and Spring runs Liquibase at startup. The problem is …

Read More
How to solve liquibase checksum validation fail after liquibase upgrade

In my project I just tried upgrading liquibase from 3.2.2 to 3.4.2 (both the jars and the maven plugin). EDIT: same for upgrade to 3.3.x. As a consequence, starting the application now gives the following error: Caused by: liquibase.exception.ValidationFailedException: Validation …

Read More
Loading data from properties file to be used by Liquibase in Maven build

I can run Liquibase changelog through maven build (liquibase:update goal) without any problems. Now I'd like Liquibase to use database credentials and URL loaded from a properties file (db.properties) depending on the selected Maven profile: |-- pom.xml `…

Read More