Currently, I’m running Liquibase in Jenkins, and would like to test out deployment of new changesets. After I run my initial Liquibase update, this checks the DDL statement changesets I have in my changelogs, and creates entries into the DATABASECHANGELOG table. Whenever I add new changes to my changelogs, which are to simply ALTER 3 tables by adding a few columns, and re-deploy the views, every single changeset is entered as a duplicate into my DATABASECHANGELOG table. Duplicate ID, AUTHOR, and FILENAME.
I can also see that there are no other running queries in Snowflake either as the Liquibase service account whenever this happens.
SELECT ID, AUTHOR, FILENAME, DATEEXECUTED FROM DATABASECHANGELOG WHERE ID = ‘1_1’;
SELECT ID, AUTHOR, FILENAME, DATEEXECUTED FROM DATABASECHANGELOG WHERE ID = ‘2_1’;