Uploaded image for project: 'Chart Search Module'
  1. Chart Search Module
  2. CSM-98

Error starting Chart Search module (MariaDB)

    XMLWordPrintable

    Details

      Description

      I installed all 2.2 modules on OpenMRS running as WAR connected to MariaDB and all of them started ok except Chart Search. Here' s the exception:

      WARN - ModuleFactory.startModuleInternal(792) |2015-05-19 21:49:38,596| Error while trying to start module: chartsearch
      org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Chart Search Module
      at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1038)
      at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:730)
      at org.openmrs.api.context.Daemon$1.run(Daemon.java:68)
      Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::4::Eli:
      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE chartsearch_synonyms ADD CONSTRAINT fk_synonymgroups_synonyms_cascade FOREIGN KEY (group_id) REFERENCES chartsearch_synonym_groups (group_id) ON UPDATE CASCADE ON DELETE CASCADE: Can't create table 'openmrs.#sql-f48_64' (errno: 121):

      It looks like the cause is that there are 2 foreign keys for the same column. And they are contradictory (one has update cascade and the other restrict).

        Gliffy Diagrams

          Attachments

            Activity

              People

              Assignee:
              k.joseph Kaweesi Joseph
              Reporter:
              lluismf Lluis Martinez
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: