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’;
| ID | AUTHOR | FILENAME | DATEEXECUTED |
|---|---|---|---|
| 1_1 | M11X | ./…/com/idrc/tst/CMS_AGG_GEO_SPTL_TST/CMS_AGG_GEO_SPTL_TST-changelog.sql | 2023-04-19 14:12:35.249000 |
| 1_1 | M11X | ./…/com/idrc/tst/CMS_AGG_GEO_SPTL_TST/CMS_AGG_GEO_SPTL_TST-changelog.sql | 2023-04-19 17:04:41.158000 |
SELECT ID, AUTHOR, FILENAME, DATEEXECUTED FROM DATABASECHANGELOG WHERE ID = ‘2_1’;
| ID | AUTHOR | FILENAME | DATEEXECUTED |
|---|---|---|---|
| 2_1 | M11X | ./…/com/idrc/tst/CMS_DIM_ACO_TST/CMS_DIM_ACO_TST-changelog.sql | 2023-04-19 14:12:51.219000 |
| 2_1 | M11X | ./…/com/idrc/tst/CMS_DIM_ACO_TST/CMS_DIM_ACO_TST-changelog.sql | 2023-04-19 17:04:56.658000 |