@dkayiwa @burke perhaps related to:
I have written an installation document for RefApp 2.12.2
Installing on Windows 10 and Windows 11 OS using Java 8
I initially used Java 16: “This release requires Java 1.8 and supports up to Java 16” statement from: Release Notes 2.12.1 - Resources - OpenMRS Wiki
line number log references below are from invoking installation from cmd console using -commandline switch.
during “initialsetup” stage of installation process installation halts with: “Line 4558: 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)]”
Reloading browser displays 3 database updates remaining to be processed in browser window, starting with samuel34 item, followed by 2 miirochristopher items.
Processing proceeds by ignoring failure at samuel34:
Line 4563: org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: org\openmrs\liquibase\updates\liquibase-update-to-latest-2.3.x.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34:
…
Line 5092: INFO - Slf4jLogger.info(42) … Marking ChangeSet: liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34 ran despite precondition failure due to onFail=‘MARK_RAN’:
…
Line 5100: INFO - Slf4jLogger.info(42) … INSERT INTO openmrs.liquibasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION
, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES (‘TRUNK-5728-2020-04-15’, ‘samuel34’, ‘liquibase-update-to-latest.xml’, NOW(), 10872, ‘8:2a90bedc8b02e4c89e1a37dc1110014b’, ‘addColumn tableName=conditions; addForeignKeyConstraint baseTableName=conditions, constraintName=conditions_encounter_id_fk, referencedTableName=encounter’, ‘Adding ‘‘encounter_id’’ column to ‘‘conditions’’ table’, ‘MARK_RAN’, NULL, NULL, ‘3.10.2’, NULL)
…
Line 5124: INFO - Slf4jLogger.info(42) … Marking ChangeSet: liquibase-update-to-latest.xml::2020-08-29-2200-TRUNK-5821::miirochristopher ran despite precondition failure due to onFail=‘MARK_RAN’:
Because of mark_ran, installation completes and the RefApp appears functional.
Using Java 16 install fails at same initial samuel34 liquibase update,
Line 4564: 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-65a0_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)]
but - unlike Java 8 - does not recover when browser is reloaded and installation cannot complete (onFail=‘MARK_RAN’ apparently has no effect). Line 4619: org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: org\openmrs\liquibase\updates\liquibase-update-to-latest-2.3.x.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::TRUNK-5728-2020-04-15::samuel34:
miirochristopher references do not get processed at all because processing is blocked by samuel34 failure .
Question: samuel34 appears to involve encounter and condition data, and miirochristopher is somehow dependent upon samuel34 updates. What demonstration RefApp functions are impacted by these dataload failures?