incomplete deployment of RefApp 2.12.2 due to database precondition failures

Related openMRS talk item:

https://talk.openmrs.org/t/openmrs-reference-application-2-12-2-error-when-installing-liquibase-updates-samuel34-and-miirochristopher-fail/36155/9

 

Errors when installing standalone reference application 2.12.2 

when installing with demo data the installation process hangs during initialsetup phase during Samuel34 liquibase update, apparently due to:

ERROR - Slf4jLogger.severe(22) ... Change Set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34 failed. Error: Can't create table 'openmrs.#sql-5bb4_6b' (errno: 121) [Failed SQL: (1005) ALTER TABLE openmrs.conditions ADD CONSTRAINT conditions_encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES openmrs.encounter (encounter_id)][Failed SQL: (1005) ALTER TABLE openmrs.conditions ADD CONSTRAINT conditions_encounter_id_fk FOREIGN KEY (encounter_id) REFERENCES openmrs.encounter (encounter_id)]

 

SPECULATION: This may be due to earlier database installation failures: 

INFO - Slf4jLogger. Marking ChangeSet: liquibase

•  -update-to-latest.xml::201609171146-2.1::vshanka
• -update-to-latest.xml::201610242135-3::vshankar
• -update-to-latest.xml::201609171146-5.1::vshankar
• -update-to-latest.xml::201610042145-1.1::vshankar
• -update-to-latest.xml::TRUNK-4755::Rahul,Swathi
• -update-to-latest.xml::20151218-1729::Rahul,Swathi
• update-to-latest.xml::20181402TRUNK-5339::esirkings
• -update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34
• update-to-latest.xml::2020-08-29-2200TRUNK-5821::miirochristopher
• update-to-latest.xml::2020-08-30-100TRUNK-5821::miirochristopher
• .xml::openconceptlab-v1-5::rkorytkowski
• .xml::openconceptlab-v1-7::rkorytkowski
• .xml::openconceptlab-v1-03.11.2016-16.10::adamgrzybkowski
• .xml::openconceptlab-v1-03.11.2016-16.11::adamgrzybkowski
• .xml::10000000-2019-appointment-status::yony258
• .xml::43889130-55c2-49e9-b72b-a9eae9a31da7::Partners In Health
• {{}}.xml::a7a39c84-cb48-427e-9141-ee851c283132::Partners In Health
• .xml::a92f91c0-162b-42d9-a33b-c1412dc2948d::Partners In Health
• .xml::b50c8351-3c6c-40eb-be40-bbdaed78c5a0::Partners In Health
• .xml::9b1eb03d-bd27-428b-8359-5877797b0fb8::Partners In Health
• .xml::82b51fe1-e6ad-423c-80a0-d2a48a3efe6c::Partners In Health
• .xml::4b4ee08c-262f-48f0-a37e-2372614e1a58::Partners In Health
• .xml::17a1d838-bf40-45d0-9e2b-6d177ff7ad62::Partners In Health
• .xml::e931b3c1-94b6-4169-90f4-1c6bf49d4883::Partners In Health
• .xml::3e32c214-9f9a-4424-8590-43ca68396aa6::Partners In Health
• .xml::1df31052-65ce-4b81-8a9c-86c58c87c042::Partners In Health
• .xml::aea80abc-8e1b-44f2-9574-c64741750cec::Jeremy Keiper
• .xml::f3244825-c3d1-4789-99bd-03a014ae56a4::Jeremy Keiper
• .xml::d5bc38a3-35e3-4a16-b1b2-df6f4c32ec7a::Partners In Health
• .xml::02fb6cc1-d45c-4985-8117-0d313975fd81::Partners In Health
• .xml::e8258234-2133-4270-9370-301c908f1e2b::Partners In Health

 

all: ran despite precondition failure due to onFail='MARK_RAN':

 

During troubleshooting investigation:

Attempting deploy with data option: Starter Implementation (java ui deploy) / empty (commandline deploy)

does not block, but tomcat logs show similar "ran despite precondition failure" :

 

Search "ran despite " (32 hits in 1 file of 1 searched) new 1 (32 hits) 

INFO - Slf4jLogger.info(42) |2022-03-21T13:29:28,660| Marking ChangeSet: liquibase.xml::

 

• {{openconceptlab-v1-5::rkorytkowski }}
• {{openconceptlab-v1-7::rkorytkowski }}
• {{openconceptlab-v1-03.11.2016-16.10::adamgrzybkowski }}
• {{openconceptlab-v1-03.11.2016-16.11::adamgrzybkowski }}
• {{metadatamapping-2016-02-07-1310-b-non-mysql::kosmik }}
• {{reporting_report_processor_2::mseaton }}
• {{reporting_id_set_cleanup::mseaton }}
• {{drop_report_definition_uuid_constraint::mgoodrich }}
• {{drop_report_definition_uuid_index::mgoodrich }}
• {{drop_creator_for_reporting_report_design::mgoodrich }}
• {{drop_changed_by_for_reporting_report_design::mgoodrich }}
• {{drop_retired_by_for_reporting_report_design::mgoodrich }}
• {{drop_report_design_id_for_reporting_report_design_resource::mgoodrich }}
• {{drop_creator_for_reporting_report_design_resource::mgoodrich }}
• {{drop_changed_by_for_reporting_report_design_resource::mgoodrich }}
• {{drop_retired_by_for_reporting_report_design_resource::mgoodrich }}
• {{drop_requested_by_for_reporting_report_request::mgoodrich }}
• {{drop_creator_for_reporting_report_processor::mgoodrich }}
• {{drop_changed_by_for_reporting_report_processor::mgoodrich }}
• {{drop_retired_by_reporting_report_processor::mgoodrich }}
• {{add_report_definition_uuid_index::mgoodrich }}
• {{add_creator_for_reporting_report_design::mgoodrich }}
• {{add_changed_by_for_reporting_report_design::mgoodrich }}
• {{add_retired_by_for_reporting_report_design::mgoodrich }}
• {{add_report_design_id_for_reporting_report_design_resource::mgoodrich }}
• {{add_creator_for_reporting_report_design_resource::mgoodrich }}
• {{add_changed_by_for_reporting_report_design_resource::mgoodrich }}
• {{add_retired_by_for_reporting_report_design_resource::mgoodrich }}
• {{add_requested_by_for_reporting_report_request::mgoodrich }}
• {{add_creator_for_reporting_report_processor::mgoodrich }}
• {{add_changed_by_for_reporting_report_processor::mgoodrich }}
• add_retired_by_for_reporting_report_processor::mgoodrich

{{}}

{{}}

ran despite precondition failure due to onFail='MARK_RAN':