Changeset executing twice when we do update from one version to another version

Saikrishna · April 3, 2023, 2:20pm

Recently we changed the liquibase library to 3.5 from 3.0
Afterwards on ward fresh instalation working fine.
while updating one version to another version already executed changeset in the databasechangelog entry again executing. and failing with unique key constraint.

Error log: SEVERE 3/4/23 6:48 PM: liquibase: stripPath: stripPath::tracking 3.0.0_to_3.1.0.sql::core: Change Set stripPath::tracking 3.0.0_to_3.1.0.sql::core failed. Error: ORA-00001: unique constraint (AIMSTAR33.PK_LIST_CONFIGS) violated
i am updating the tracking 3.4.0 to tracking 3.5.0 .
in 3.4.0 updated the liquibase libary 3.5 from 3.0.
tracking 3.0.0_to_3.1.0.sql has MD5 cheksum generated in the databasechangelog long back,
now upgrading the tracking 3.4.0 to tracking 3.5.0.
we are getting above error.

Could you please help me how to resolve this isse.

daryldoak · April 3, 2023, 5:13pm

Can you provide the entire changeset. I’m assuming this is going to be related to how the filename field is stored in the databasechangelog table.

Saikrishna · April 4, 2023, 2:50am

<?xml version="1.0" encoding="UTF-8"?>

<changeSet id="create_audit_sequence.sql" author="core">

    <sqlFile splitStatements="true" endDelimiter = "/" path = "@@path@@/imaging-schema/create_audit_sequence.sql"/>

</changeSet>

<changeSet id="create_session_package.sql" author="core">

    <sqlFile splitStatements="true" endDelimiter = "/" path = "@@path@@/imaging-schema/create_session_package.sql"/>

</changeSet>

<changeSet id="create_tables.sql" author="core">

    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_tables.sql"/>

</changeSet>

<changeSet id="create_package.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_package.sql"/>

</changeSet>

<changeSet id="create_views.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_views.sql"/>

</changeSet>

<changeSet id="create_audit_tables.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_audit_tables.sql"/>

</changeSet>

<changeSet id="create_triggers.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_triggers.sql"/>

</changeSet>

<changeSet id="create_rule_triggers.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/"  stripComments="true" path = "@@path@@/imaging-schema/create_rule_triggers.sql"/>

</changeSet>

<changeSet id="create_view_after_audit.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true"  stripComments="true" path = "@@path@@/imaging-schema/create_view_after_audit.sql"/>

</changeSet>

<changeSet id="insert_base_configs.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_base_configs.sql"/>

</changeSet>
<changeSet id="create_analysis_2.x_tables.sql" author="core" runOnChange="true">

<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_analysis_2.x_tables.sql"/>

</changeSet>

<changeSet id="afd_trigger.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/afd_trigger.sql"/>

</changeSet>

<changeSet id="ocf_create_tables.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/ocf-schema/ocf_create_tables.sql" />

</changeSet>

<changeSet id="ocf_create_audit_tables.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/ocf-schema/ocf_create_audit_tables.sql"/>

 </changeSet>

 <changeSet id="ocf_seed_data.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = ";" stripComments="true" path = "@@path@@/ocf-schema/ocf_seed_data.sql"/>

</changeSet>

<changeSet id="insert_base_configs_2.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_base_configs_2.sql"/>

</changeSet>
 <changeSet id="create_tables2.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_tables2.sql"/>

</changeSet>

<changeSet id="create_package2.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_package2.sql"/>

</changeSet>

<changeSet id="create_audit_tables2.sql" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_audit_tables2.sql"/>

</changeSet>


<changeSet id="test_transfer_visit" author="core" runOnChange="true">
	<sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/insert_test_transfer_visit.sql"/>
 	<sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/function_display_visit_sequence.sql"/>
 	<sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/modify_views_for_test_transfer.sql"/>
</changeSet>

<changeSet id="update_db_schema_2.5.sql" author="core">
	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema_2.5.sql"/>
</changeSet>

 <changeSet id="modified_search_images_view.sql" author="core" runOnChange="true">
	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/modified_search_images_view.sql"/>
</changeSet>

<changeSet id="patch.2_5" author="core" runOnChange="true">

	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_dirtysubject_sequence.sql"/>
	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/exec_dirtysubject_sequence.sql"/>
	<sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/update_rule_triggers.sql"/>

</changeSet>

<changeSet id="create_case_indexes.sql" author="core">
		<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_case_indexes.sql"/>

<changeSet id="create_case_indexes2.sql" author="core">
		<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_case_indexes2.sql"/>

    <sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_get_case_rules_function.sql"/>
    <sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_get_review_periods.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_composite_casevisit_view.sql"/>

</changeSet>

<changeSet id="update_db_schema_2.6.sql" author="core" runOnChange="true">
	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema_2.6.sql"/>
</changeSet>

<changeSet id="audit_tables_check.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/audit_tables_check.sql"/>
</changeSet>

<changeSet id="update_base_configs_visit_types.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_base_configs_visit_types.sql"/>
</changeSet>

<changeSet id="update_rpt_overdue_visits_2.7.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_rpt_overdue_visits.sql"/>
</changeSet>

<changeSet id="create_unique_visit_index.sql" author="core">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_unique_visit_index.sql"/>
</changeSet>

<changeSet id="update_db_schema_2.7.0.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema_2.7.0.sql"/>
</changeSet>

<changeSet id="update_db_schema_2.8.0.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema_2.8.0.sql"/>
</changeSet>

<changeSet id="update_db_schema.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
</changeSet>

<changeSet id="update_search_fields_lables.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_search_fields_lables.sql"/>
</changeSet>

<changeSet id="insert_base_configs_4.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_base_configs_4.sql"/>
</changeSet>

<changeSet id="create_tables3.sql" author="core" runOnChange="true">
     <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_tables3.sql"/>
</changeSet>

<changeSet id="create_audit_tables3.sql" author="core" runOnChange="true">
   <sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_audit_tables3.sql"/>
</changeSet>

<changeSet id="update_view rpt_queries.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_view_rpt_queries.sql"/>
</changeSet>

<changeSet id="update_search_communication_views.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_search_communication_views.sql"/>
</changeSet>

<changeSet id="insert_base_configs_5.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_base_configs_5.sql"/>
</changeSet>

<changeSet id="queries_indexes.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/queries_indexes.sql"/>
</changeSet>


<changeSet id="case_indexes.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/case_indexes.sql"/>
</changeSet>

<changeSet id="create_tables_query_viewed.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_tables_query_viewed.sql"/>
</changeSet>


<changeSet id="faxes_index_query_history_recid.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_index_faxes_query_history_recid.sql"/>
</changeSet>

<changeSet id="create_index_notes_query_recid.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_index_notes_query_recid.sql"/>
</changeSet>
<changeSet id="communication_queued_indexes.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/communication_queued_indexes.sql"/>
</changeSet>

<changeSet id="Create_Search_Queries_View_3.0.0.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/Create_Search_Queries_View_3.0.0.sql"/>
</changeSet>

<changeSet id="create_function_get_query_readby_users.sql" author="core">
    <sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path = "@@path@@/imaging-schema/create_function_get_query_readby_users.sql"/>
</changeSet>

<changeSet id="create_rpt_queries_3.0.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_rpt_queries_3.0.sql"/>
</changeSet>

<changeSet id="create_table_Portal_User_Site_Mapping.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_table_Portal_User_Site_Mapping.sql"/>
</changeSet>

<changeSet id="create_query_view_audit_table.sql" author="core" runOnChange="true">
    <sqlFile splitStatements="true" endDelimiter = "/" stripComments="true" path ="@@path@@/imaging-schema/create_query_view_audit_table.sql"/>
</changeSet>
<changeSet id= "tracking 3.0.0_to_3.1.0.sql"    author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_unknown_visit.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_other_modality_series.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/create_get_query_from_string_function.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/create_function_get_query_readby_users_3.1.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path="@@path@@/imaging-schema/create_rpt_queries_3.1.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
</changeSet>

<changeSet id= "tracking 3.1.0_to_3.1.3.sql"    author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/trk_ddl_indexes.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/afd_trigger2.sql"/>
     <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
</changeSet>

<changeSet id= "tracking 3.1.3_to_3.2.0.sql"    author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path = "@@path@@/imaging-schema/add_visit_columns.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter=";" path="@@path@@/imaging-schema/composite_view_01.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/insert_base_configs_6.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path = "@@path@@/imaging-schema/alter_contacts.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path = "@@path@@/imaging-schema/add_query_columns.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
	<sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/alter_seacrh_fields.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/create_search_contacts_view.sql"/>
</changeSet>

<changeSet id= "tracking 3.2.0_to_3.2.1.sql"    author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/alter_visit_columns.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter=";" path="@@path@@/imaging-schema/alter_base_configs.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/alter_contacts_2.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/add_recipient_column.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter=";" path="@@path@@/imaging-schema/alter_search_contacts_view.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter=";" path="@@path@@/imaging-schema/update_composite_visits_view.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
</changeSet>

<changeSet id= "tracking 3.2.1_to_3.3.0.sql"    author="core" runOnChange="true">
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/alter_queries.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter=";" path="@@path@@/imaging-schema/alter_rpt_queries_view.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/alter_erd.sql"/>
    <sqlFile splitStatements="true" stripComments="true" endDelimiter="/" path="@@path@@/imaging-schema/update_erd_view.sql"/>
    <sqlFile splitStatements="true" stripComments="true" path = "@@path@@/imaging-schema/update_db_schema.sql"/>
</changeSet>

Databasechangelog table

tracking 3.4.1_to_3.4.2.sql	core	stripPath	02-04-23 10:29:27.342000000 AM	61	EXECUTED	7:90486c0b3f292a52b9c782b32a5b1e4d	sqlFile	3.5.0	0411548334
tracking 3.4.0_to_3.4.1.sql	core	stripPath	02-04-23 10:29:27.330000000 AM	60	EXECUTED	7:d9c6db071a7ba233fdaf3103f1840cbc	sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.3.2.1_to_3.4.0.sql	core	stripPath	02-04-23 10:29:15.638000000 AM	59	EXECUTED	7:402662513ae6b8cb9e4cd4cf81812e9d	sqlFile; sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.3.0_to_3.3.1.sql	core	stripPath	02-04-23 10:29:15.503000000 AM	58	EXECUTED	7:a840c5066e5dc567b4e98d66358977be	sqlFile; sqlFile	3.5.0	0411548334
tracking 3.2.1_to_3.3.0.sql	core	stripPath	02-04-23 10:29:15.468000000 AM	57	EXECUTED	7:173ca84f8da899648f13b70586164817	sqlFile; sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.2.0_to_3.2.1.sql	core	stripPath	02-04-23 10:29:15.226000000 AM	56	EXECUTED	7:69d5ce405aa34b35202ab82a4c5a725f	sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.1.3_to_3.2.0.sql	core	stripPath	02-04-23 10:29:14.769000000 AM	55	EXECUTED	7:3022669d653e75bf175b2d020d20e888	sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.1.0_to_3.1.3.sql	core	stripPath	02-04-23 10:29:14.183000000 AM	54	EXECUTED	7:4e3d505b2dad13a4df464b9340cf5e2a	sqlFile; sqlFile; sqlFile	3.5.0	0411548334
tracking 3.0.0_to_3.1.0.sql	core	stripPath	02-04-23 10:29:14.120000000 AM	53	EXECUTED	7:bfb55e598a3084706912e75aae0fc978	sqlFile; sqlFile; sqlFile; sqlFile; sqlFile; sqlFile	3.5.0	0411548334

Saikrishna · April 4, 2023, 2:56am

older version liquibase entries in the database changelog.(liquibase3.0)

tracking 3.3.2.1_to_3.4.0.sql	core	stripPath	19-01-23 12:09:16.898000000 PM	59	EXECUTED	7:402662513ae6b8cb9e4cd4cf81812e9d	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.3.0_to_3.3.1.sql	core	stripPath	19-01-23 12:09:16.704000000 PM	58	EXECUTED	7:a840c5066e5dc567b4e98d66358977be	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.2.1_to_3.3.0.sql	core	stripPath	19-01-23 12:09:16.666000000 PM	57	EXECUTED	7:173ca84f8da899648f13b70586164817	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.2.0_to_3.2.1.sql	core	stripPath	19-01-23 12:09:16.455000000 PM	56	EXECUTED	7:69d5ce405aa34b35202ab82a4c5a725f	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.1.3_to_3.2.0.sql	core	stripPath	19-01-23 12:09:16.016000000 PM	55	EXECUTED	7:3022669d653e75bf175b2d020d20e888	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.1.0_to_3.1.3.sql	core	stripPath	19-01-23 12:09:15.270000000 PM	54	EXECUTED	7:4e3d505b2dad13a4df464b9340cf5e2a	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
tracking 3.0.0_to_3.1.0.sql	core	stripPath	19-01-23 12:09:15.129000000 PM	53	EXECUTED	7:bfb55e598a3084706912e75aae0fc978	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_query_view_audit_table.sql	core	stripPath	19-01-23 12:09:15.062000000 PM	52	EXECUTED	7:083f42594e8ba3ab03465cf82cee0d22	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_table_Portal_User_Site_Mapping.sql	core	stripPath	19-01-23 12:09:14.999000000 PM	51	EXECUTED	7:600187daffce140f33348308dda79c57	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_rpt_queries_3.0.sql	core	stripPath	19-01-23 12:09:14.982000000 PM	50	EXECUTED	7:ac8a40131a73ee04c73181d1724e7975	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_function_get_query_readby_users.sql	core	stripPath	19-01-23 12:09:14.961000000 PM	49	EXECUTED	7:301c42d3c1144da8b80e60874226a9de	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
Create_Search_Queries_View_3.0.0.sql	core	stripPath	19-01-23 12:09:14.946000000 PM	48	EXECUTED	7:e17f2b6490989ece99c29441c8dcf4f0	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
communication_queued_indexes.sql	core	stripPath	19-01-23 12:09:14.885000000 PM	47	EXECUTED	7:4486bce4798564da115fb1ae0c0f8a54	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_index_notes_query_recid.sql	core	stripPath	19-01-23 12:09:14.875000000 PM	46	EXECUTED	7:fcf9a45bc633d4940dacd6489f55e6d1	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
faxes_index_query_history_recid.sql	core	stripPath	19-01-23 12:09:14.846000000 PM	45	EXECUTED	7:052fc5540cceb9daad8821b2b14a7d02	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_tables_query_viewed.sql	core	stripPath	19-01-23 12:09:14.838000000 PM	44	EXECUTED	7:f15bf68841b141f9056412a9c6279b1d	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
case_indexes.sql	core	stripPath	19-01-23 12:09:14.776000000 PM	43	EXECUTED	7:d532eb7d002d05ed304230384baeeafa	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
queries_indexes.sql	core	stripPath	19-01-23 12:09:14.742000000 PM	42	EXECUTED	7:e1059d2c5595443af909b84aab640ab2	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
insert_base_configs_5.sql	core	stripPath	19-01-23 12:09:14.708000000 PM	41	EXECUTED	7:dae0dd0a8ec61913564ed6bdbc674a83	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_search_communication_views.sql	core	stripPath	19-01-23 12:09:14.700000000 PM	40	EXECUTED	7:e41697e5814663aa76c6d872de36fcb0	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_view rpt_queries.sql	core	stripPath	19-01-23 12:09:14.631000000 PM	39	EXECUTED	7:7003680bd210028831b5b5cb7805a13a	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_audit_tables3.sql	core	stripPath	19-01-23 12:09:14.613000000 PM	38	EXECUTED	7:8368185e5d49bda8c7cb583d303114d8	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_tables3.sql	core	stripPath	19-01-23 12:09:14.561000000 PM	37	EXECUTED	7:86c66590a88dba4df6114d7bfee87a49	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
insert_base_configs_4.sql	core	stripPath	19-01-23 12:09:14.486000000 PM	36	EXECUTED	7:5a7f4f71392aad7506786b2099f02a97	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_search_fields_lables.sql	core	stripPath	19-01-23 12:09:14.477000000 PM	35	EXECUTED	7:c0d488a9dc2c224ac414ebc581978802	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_db_schema.sql	core	stripPath	19-01-23 12:09:14.453000000 PM	34	EXECUTED	7:90486c0b3f292a52b9c782b32a5b1e4d	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_db_schema_2.8.0.sql	core	stripPath	19-01-23 12:09:14.448000000 PM	33	EXECUTED	7:e8cafd344254fead08b9ed1fd714a19e	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_db_schema_2.7.0.sql	core	stripPath	19-01-23 12:09:14.441000000 PM	32	EXECUTED	7:5bc33b93a50ad73225be9aa1ca5a7af7	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_unique_visit_index.sql	core	stripPath	19-01-23 12:09:14.435000000 PM	31	EXECUTED	7:1c5a0d70fe847be8510247b1b99ece3a	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_rpt_overdue_visits_2.7.sql	core	stripPath	19-01-23 12:09:14.421000000 PM	30	EXECUTED	7:2e92da5c67f79d7db85bf1d3d4abaef4	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_base_configs_visit_types.sql	core	stripPath	19-01-23 12:09:14.366000000 PM	29	EXECUTED	7:3fd3d087d0e5a8af221cea3786ad8c45	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
audit_tables_check.sql	core	stripPath	19-01-23 12:09:14.355000000 PM	28	EXECUTED	7:02e43cb39f71270783a1e2dd20d4141d	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_db_schema_2.6.sql	core	stripPath	19-01-23 12:09:14.320000000 PM	27	EXECUTED	7:4654167c8414827ee49d512c65b88fb7	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
composite_casevisit	core	stripPath	19-01-23 12:09:14.313000000 PM	26	EXECUTED	7:ca3eeca7fbe1e1c908e4e1998d675eca	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_case_indexes2.sql	core	stripPath	19-01-23 12:09:14.237000000 PM	25	EXECUTED	7:3eb8e86ad00f9fca765c2c7c9ae331b4	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_case_indexes.sql	core	stripPath	19-01-23 12:09:14.203000000 PM	24	EXECUTED	7:04ce7aec592a6b2bdf37e456a9f32ab7	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
patch.2_5	core	stripPath	19-01-23 12:09:14.156000000 PM	23	EXECUTED	7:3c8ff6dae603aa3433af4af02589c71e	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
modified_search_images_view.sql	core	stripPath	19-01-23 12:09:13.992000000 PM	22	EXECUTED	7:8152aa14185e29e5c272a9c7707917a6	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
update_db_schema_2.5.sql	core	stripPath	19-01-23 12:09:13.973000000 PM	21	EXECUTED	7:f5426f8b84e095a22aaabe1affb5294b	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
test_transfer_visit	core	stripPath	19-01-23 12:09:13.965000000 PM	20	EXECUTED	7:70723bd85c8991c26202ea4e38717f5b	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_audit_tables2.sql	core	stripPath	19-01-23 12:09:13.865000000 PM	19	EXECUTED	7:947673229b868ae6e00784be0b82e323	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_package2.sql	core	stripPath	19-01-23 12:09:13.761000000 PM	18	EXECUTED	7:2fe42e6a96b5319c75f523d0e4659150	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_tables2.sql	core	stripPath	19-01-23 12:09:13.751000000 PM	17	EXECUTED	7:cab5878344e935fe6e8cfccea6e77689	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
insert_base_configs_2.sql	core	stripPath	19-01-23 12:09:13.730000000 PM	16	EXECUTED	7:dff31c10c3798aaec361770c9f2fb68b	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
ocf_seed_data.sql	core	stripPath	19-01-23 12:09:13.724000000 PM	15	EXECUTED	7:bf77e3c95f63a4829c93c51938159595	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
ocf_create_audit_tables.sql	core	stripPath	19-01-23 12:09:13.706000000 PM	14	EXECUTED	7:43c84959a821dd0a8f03b30c777b1e86	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
ocf_create_tables.sql	core	stripPath	19-01-23 12:09:13.498000000 PM	13	EXECUTED	7:9986ea2ff0cb9e4cb9238605e66cb495	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
afd_trigger.sql	core	stripPath	19-01-23 12:09:13.256000000 PM	12	EXECUTED	7:cbceb713916f00120e8696404c289885	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_analysis_2.x_tables.sql	core	stripPath	19-01-23 12:09:13.240000000 PM	11	EXECUTED	7:e38430983bd64579f3756862cbb9f5d7	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
insert_base_configs.sql	core	stripPath	19-01-23 12:09:12.976000000 PM	10	EXECUTED	7:70353804b8507e98aa5e87c72ddf2b78	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_view_after_audit.sql	core	stripPath	19-01-23 12:09:11.782000000 PM	9	EXECUTED	7:64e51e4392ccc873e1ab2ac3648a6076	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_rule_triggers.sql	core	stripPath	19-01-23 12:09:11.764000000 PM	8	EXECUTED	7:9a3be153167a4d7c77ed67488ead8353	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_triggers.sql	core	stripPath	19-01-23 12:09:11.673000000 PM	7	EXECUTED	7:e89068206f7351029cc5f67a80f97488	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_audit_tables.sql	core	stripPath	19-01-23 12:09:11.606000000 PM	6	EXECUTED	7:2da20301f1872880444e419d7f6ae4c7	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_views.sql	core	stripPath	19-01-23 12:09:09.637000000 PM	5	EXECUTED	7:9f3fee9a41e2cd9499cfdbd0cf36767f	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_package.sql	core	stripPath	19-01-23 12:09:09.283000000 PM	4	EXECUTED	7:e450a8db44542850861edb90692966a1	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_tables.sql	core	stripPath	19-01-23 12:09:09.016000000 PM	3	EXECUTED	7:e6cc673ef3b56ca0be13156085d02229	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_session_package.sql	core	stripPath	19-01-23 12:09:07.385000000 PM	2	EXECUTED	7:6a4e392531dee772e501c3137d1f9d7b	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP
create_audit_sequence.sql	core	stripPath	19-01-23 12:09:07.318000000 PM	1	EXECUTED	7:04f166edb785c78a38a86ef25c5d71c9	The ‘sqlFile’ tag allows you to specify any sql statements and have it stored external in a file. It is useful for complex changes that are not supported through LiquiBase’s automated refactoring tags such as stored procedures. The sqlFile refact…	3.0.0-SNP

daryldoak · April 4, 2023, 2:54pm

Well, looks like the ID, author, and filename fields match, so I’m not sure why it’s running them again.

Considering liquibase is now on 4.20.0, I’m not sure you are going to get much help with issues in 3.5.

I’d suggest updating to a more current version.

Saikrishna · April 5, 2023, 1:13pm

Thank you very much darryldoak.

After updating the liquibase.jar to 4.20.0we got following error:
18:38:04.809 [main] INFO modifyWarFiletracking - Deleting existing war file deployTemp/aimstar3.5.war
[zip] Building zip: C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployTemp\aimstar3.5.war
18:38:19.338 [main] INFO installer - appMgr:TomcatAppMgr - serverName: localhost; port: 9080; appName: aimstar3.5; outputFolder: deployTemp
18:38:19.338 [main] INFO installer - Deploying Database for Tracking …
18:38:19.453 [main] ERROR installer - Exception occurred deploying the database and the exception is org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 12: unable to resolve class liquibase.database.jvm.JdbcConnection
@ line 12, column 1.
import liquibase.database.jvm.JdbcConnection;
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 8: unable to resolve class liquibase.Liquibase
@ line 8, column 1.
import liquibase.Liquibase
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 11: unable to resolve class liquibase.database.DatabaseFactory
@ line 11, column 1.
import liquibase.database.DatabaseFactory;
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 10: unable to resolve class liquibase.database.Database
@ line 10, column 1.
import liquibase.database.Database;
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 13: unable to resolve class liquibase.resource.FileSystemResourceAccessor
@ line 13, column 1.
import liquibase.resource.FileSystemResourceAccessor;
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 17: unable to resolve class liquibase.exception.LiquibaseException
@ line 17, column 1.
import liquibase.exception.LiquibaseException
^

C:\deploy\Tracking_local_deployment\v1_7_4_0\trackingDeployer\deployDBtracking.groovy: 9: unable to resolve class liquibase.exception.DatabaseException
@ line 9, column 1.
import liquibase.exception.DatabaseException
^

7 errors

18:38:19.454 [main] INFO installer - Ignoring the above exception and continuing with WAR file deployment…

package liquibase.database.jvm.JdbcConnection has been after the liquibase_4.20.0.jar
Could you please provide me the liqueibase 3.0 tp liquibase 4.20.0.jar migration guide.
Could you plese provid eme the right package for JdbcConnection class.?

Topic		Replies	Views
Guidance Needed for Liquibase Upgrade (3.5.5 to 4.30.0) – Checksum Issues with Old ChangeSets General Discussion	1	35	December 17, 2024
Error running update General Discussion	6	2656	September 16, 2021
Updating a Database General Discussion	3	345	December 3, 2009
Update in databasechangelog is not picked up in the same run General Discussion	1	937	April 18, 2022
Liquibase 2.0.5 does not seem to commit between changesets against MySQL 5.5 General Discussion	2	710	May 9, 2013

Changeset executing twice when we do update from one version to another version

Related topics