Can you clear liquibase checksums for a given file only?

liquibase
Lionel Orellana picture Lionel Orellana · May 27, 2015 · Viewed 20.6k times · Source

Running

liquibase --url=jdbc:oracle:thin:@localhost:1521/XE --    
driver=oracle.jdbc.OracleDriver --changeLogFile=db.changelog-next.xml --    
username=owner --password=xxxx --logLevel=info clearCheckSums

clears ALL checksums from the database. Is there a way to clear only the checksums for changesets in db.changelog-next.xml.

Thanks

Answer

Jens picture Jens · May 28, 2015

I don't think there is another command or a parameter to clearCheckSums that does this.

But you could do this manually. All that clearCheckSums does is nullifying the MD5SUM column of the databasechangelog table.

So something like: 

update databasechangelog set md5sum=null where filename like '%db.changelog-next.xml';

should work.

(I haven't tested this SQL. It's just an example - so before you apply this to your production database make sure this works on a development db.)

Related questions

Liquibase lock - reasons?

I get this when running a lot of liquibase-scripts against a Oracle-server. SomeComputer is me. Waiting for changelog lock.... Waiting for changelog lock.... Waiting for changelog lock.... Waiting for changelog lock.... Waiting for changelog lock.... Waiting for changelog lock.... Waiting …

Read More
List all liquibase sql types

I try to find documentation on the supported types that can be used in change log files. But cannot find it. Is there any document, site or something similar where I can find all types-specific issues. For example clob type …

Read More
Liquibase checksum validation error without any changes

Maven fires liquibase validation fail even no changes was made in changeset. My database is oracle. Situation: In DB changelog table was record for changeset <changeSet id="1" author="me" dbms="oracle">; Then by mistake i added another changeset &…

Read More