Uploaded image for project: 'Reference Application'
  1. Reference Application
  2. RA-1987

incomplete deployment of RefApp 2.12.2 due to database precondition failures

    XMLWordPrintable

Details

    • Bug
    • Status: Ready for Work
    • Should
    • Resolution: Unresolved
    • None
    • None
    • Demo
    • Low

    Description

      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':

       

      Gliffy Diagrams

        Attachments

          Activity

            People

              Unassigned Unassigned
              dwilliscroft Doug Williscroft
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: