LiquiBase ValidationFailedException. Checksum changed for no reason

I have some change files and when I try to create sql files for them I get: ValidationFailedException .

Caused by: liquibase.exception.ValidationFailedException: Validation Failed:
     13 change sets check sum
          db-changelogs/test1.xml::test-1::rw is now: 7:d41d8cd98f00b204e9800998ecf8427e

      

The problem is I haven't made any changes to these files. My colleagues are working on the same git branch and work great for them.

I checked textCoding and some other stuff but it still doesn't work. I am running it with an ant script.

My database is changelog (new-db-changelog.xml) :

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

    <include file="db-changelogs/testl.xml"/>

</databaseChangeLog>

      

Change History (test1.xml) :

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

        <changeSet id="test-1" author="rem" >
            <ext:sqlWrapper context="common-schema">
                <![CDATA[
    CREATE TABLE common.test(
      id bigint NOT NULL,
      "name" character varying,
      CONSTRAINT test_lb_pkey PRIMARY KEY (id)
    );
                ]]>
            </ext:sqlWrapper>
        </changeSet>

    </databaseChangeLog>

      

+4


source to share


2 answers


We just discovered that 3.1.1 seems to have an effect on spaces when calculating checksums. We have some pure SQL changes that I had to reformat from spaces to tabs with and the checksums were changed.



Could this be possible?

0


source


Add Attribute runOnChange="true"



<changeSet id="test-1" author="rem" runOnChange="true">

      

0


source







All Articles