# How to skip/ignore specific blocks of changesets?

**URL:** <https://forum.liquibase.org/t/how-to-skip-ignore-specific-blocks-of-changesets/7384>\
**Category:** General Discussion\
**Created:** [October 5, 2022, 1:57pm UTC](https://forum.liquibase.org/t/how-to-skip-ignore-specific-blocks-of-changesets/7384 "2022-10-05T13:57:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![davebrown1975](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/davebrown1975/32/857_2.png) [@davebrown1975](https://forum.liquibase.org/u/davebrown1975)\
**Post date:** [October 5, 2022, 1:57pm UTC](https://forum.liquibase.org/t/how-to-skip-ignore-specific-blocks-of-changesets/7384/1 "2022-10-05T13:57:57Z")

</div>

Hi,

As part of an application upgrade that has taken the app from Hibernate 3 to Hibernate 5 and Liquibase 2 to Liquibase 4.8 we’re suddenly facing thousands of newly detected changesets.

90% of these changesets are ‘dropDefaultValue’ which although shouldn’t be there, shouldn’t cause any issues if they do run.

But there other 10% look like they would potentially cause problems.

Due to the size of the detected changes, it takes a long time to gather this changelog, we’re using groovy and the resulting groovy file is too big to run with updateSql without first splitting it into separate files manually due to the maximum size of a groovy method.

What I really would like is to somehow inform liquibase that this new changeset should not be processed but ensure it doesn’t regenerate the same changesets the next time we look for changes.

What I’ve tried was to generate the SQL from the changesets, and went through commenting each statement leaving it to only add the changelog table entries. Unfortunately this isn’t enough as the next time I checked for changes, it produced exactly the same changesets.

The upgraded application is working perfectly with the database in it’s current state so I really don’t want it to detect any changes, but clearly it is, and I’m at a loss how I can continue to use Liquibase for future changes without it wanting to make all these modifications.

Any advise on this matter would be much appreciated. Thanks.

---

<div class="post-metadata">

**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\
**Post date:** [October 5, 2022, 8:58pm UTC](https://forum.liquibase.org/t/how-to-skip-ignore-specific-blocks-of-changesets/7384/2 "2022-10-05T20:58:32Z")

</div>

Maybe the changelog-sync command would help.

> **[changelog-sync | Liquibase Docs](https://docs.liquibase.com/commands/maintenance/changelog-sync.html)**
>
> Reference information and use cases for the changelog-sync Maven goal. The changelog-sync Maven goal marks all undeployed changes in your changelog as executed in your database.

---

<div class="post-metadata">

**Author:** ![davebrown1975](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/davebrown1975/32/857_2.png) [@davebrown1975](https://forum.liquibase.org/u/davebrown1975)\
**Post date:** [October 6, 2022, 1:31pm UTC](https://forum.liquibase.org/t/how-to-skip-ignore-specific-blocks-of-changesets/7384/3 "2022-10-06T13:31:06Z")

</div>

Hi, thanks for the suggestion. In practice when I tried it, and then ran status, status then claimed everything was up to date. So that looked promising.

When I ran diff, however, it generates the changesets again. Even though the changelog says it’s done and executed everything.
