We have a changeset applied to production via liquibase 3.0.4. Using newer versions of liquibase we can’t apply later changeset because the check sum is different for different liquibase versions. It is specific to this changeset - others are fine.
Changeset
- TYPE_ID=‘INFLATION_VOLS’
Debug logging - liquibase 3.0.4
- DEBUG 06/12/13 13:29:liquibase: Computed checksum for update:[
- columns=[
- [
- name=“CAT_2”
- value=“Impact of Volatilities”
- ]
- ]
tableName=“PNL_ATTRIB_TYPE” - whereClause=“TYPE_ID=‘INFLATION_VOLS’”
- ] as febf5cd7dc52e773fa62bff547ac5203
- DEBUG 06/12/13 13:29:liquibase: Computed checksum for 7:febf5cd7dc52e773fa62bff547ac5203: as 083928d50177aec8a6a073355be9b15b
Debug logging - liquibase 3.0.7
- DEBUG 06/12/13 13:29:liquibase: Computed checksum for update:[
- columns=[
- [
- name=“CAT_2”
- value=“Impact of Volatilities”
- ]
- ]
- tableName=“PNL_ATTRIB_TYPE”
- where=“TYPE_ID=‘INFLATION_VOLS’”
- ] as b0dda9b1838ffb6348307fd9dfd18d78
- DEBUG 06/12/13 13:29:liquibase: Computed checksum for 7:b0dda9b1838ffb6348307fd9dfd18d78: as a45c6787b90dee195944be8f0cc651ff
- Liquibase updateSql Failed: Validation Failed:
- 1 change sets check sum
- upgrades/changelog.f-3.9.1.xml::Correct INFLATION_VOLS Typo::Barney is now: 7:a45c6787b90dee195944be8f0cc651ff
The changeset’s ‘where’ has changed from ‘whereClause’ to ‘where’ in liquibase 3.0.5.
I understand there is no guarantee that check sums won’t change between liquibase versions, from other posts in this forum. How about if liquibase highlights version differences (from DATABASECHANGELOG.LIQUIBASE) in this situation - i.e. the error message should state that the changeset was applied with a different version of liquibase, and could now be failing because of liquibase version differences, not because the changeset itself has changed.