Liquibase: Deleting Sql File used in Changeset

Question

we are using liquibase for our DB-Deployment. We are currently doing some refactoring. There is an old changeset which is running an sql script. This has been executed in the past. Now this sql script (or the statement in it) is outdated and I would like to deleted from our VCS System. I did that and tried to deploy again, but I am getting an exception saying that the sql file is not there, although my Changeset has runAlways="false" and runOnChange="false".

Does this mean that I have to always keep the specific sql script always in my CVS although it is deprecated?

Have you removed the outdated changeset fully or just one file constituting it? In our liquibase migrations we constantly drop old changesets and that works without problems. — Mykola Gurov
– Mykola Gurov, Commented May 26, 2016 at 6:12

SteveDonie · Accepted Answer · 2016-05-24 17:28:12Z

1

According how checksum works on Liquibase, you can't delete it. Technically you run that changeset one time, and something happened on DB, then liquibase created a checksum for your file. Now if you change some part of it, liquibase will say your file is updated and you can't do that.

So in summary, your file is part of the story of your application build, even if it is no longer useful, and you can't get rid of it.

If you are not in production case, one solution could be create a dump from your current database as init.sql and start from that.

I hope this helps you.

edited May 24, 2016 at 17:28

SteveDonie

9,0463 gold badges47 silver badges43 bronze badges

answered May 24, 2016 at 10:29

cralfaro

5,9463 gold badges23 silver badges33 bronze badges

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

2 Comments

Elena Over a year ago

Thanks for the answer. I was afraid of that. I just thought, that somebody else might have an idea.

cralfaro Over a year ago

You have to think that the main task of liquibase is have an history of actions in the database and dont allow regresion or unstability, so even if now the file dont make sense, technically one day he did... :)

Collectives™ on Stack Overflow

Liquibase: Deleting Sql File used in Changeset

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related