How to delete last executed liquibase changeset from database

Question

I accidently ran this changeset, but I want to do some modification to this changeset. This is still in development mode, so I do not want to add another changeset to revert these changes. I am planning to delete PAYLOAD_SIZE column from the table by executing sql query directly in database. After that I want to run the changeset again by doing some modification.

From the liquibase documentation I understand that liquibase creates an entry in table DATABASECHANGELOG for successfully executed changeset. So I am planning to delete the entry corresponding to changeset "ADD_PAYLOADSIZE" from table DATABASECHANGELOG. Will it cause any inconsistency by deleting entry from DATABASECHANGELOG please suggest.

<changeSet author="*****" id="ADD_PAYLOADSIZE">
        <addColumn tableName="METER_DATA">
            <column name="PAYLOAD_SIZE" type="BIGINT" defaultValue="0"></column>
        </addColumn>
</changeSet>

Aditi · Accepted Answer · 2021-10-28 18:38:25Z

1

No, it wont cause any inconsistency as long as you make these two changes (manually delete the payload size column and remove the entry for this changeset from the DATABASECHANGELOG table)

answered Oct 28, 2021 at 18:38

Aditi

3671 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to delete last executed liquibase changeset from database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related