[MUZIMA-775] Issue with loading mUzima Core Module 1.4.3 - mUzima JIRA

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Done
Labels:
- muzima-core-1.4.2
- pih

Description

Setup an instance with a fresh database and is working pretty fine with mUzima Core Module 1.4.3. However, when loading mUzima Core Module 1.4.3 to instance that has previously loaded with mUizma Core Module, it runs into the following issue.

Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist

logs:

INFO 8/13/19 2:07 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
INFO 8/13/19 2:07 PM:liquibase: Reading from `liquibasechangelog`
INFO 8/13/19 2:07 PM:liquibase: Successfully acquired change log lock
INFO 8/13/19 2:07 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
INFO 8/13/19 2:07 PM:liquibase: Reading from `liquibasechangelog`
SEVERE 8/13/19 2:07 PM:liquibase: Change Set liquibase.xml::muzimaform-2014-10-31::SahajSoft failed.  Error: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:198)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:227)
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:847)
at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:577)
at org.openmrs.api.context.Daemon$1.run(Daemon.java:57)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'butaroprod20190530.muzimaforms_form' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 11 more
INFO 8/13/19 2:07 PM:liquibase: Successfully released change log lock
WARN - ModuleFactory.startModuleInternal(637) |2019-08-13 14:07:44,890| Error while trying to start module: muzimacore
org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Muzima Core Module
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:857)
at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:577)
at org.openmrs.api.context.Daemon$1.run(Daemon.java:57)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::muzimaform-2014-10-31::SahajSoft:
     Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist:
          Caused By: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist:
          Caused By: Table 'butaroprod20190530.muzimaforms_form' doesn't exist
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:198)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:227)
at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:847)
... 2 more
Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `muzimaforms_form` ADD CONSTRAINT `fk_muzimaforms_form_openmrs_form` FOREIGN KEY (`form`) REFERENCES `form` (`uuid`): Table 'butaroprod20190530.muzimaforms_form' doesn't exist
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
... 7 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'butaroprod20190530.muzimaforms_form' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
... 11 more

Gliffy Diagrams

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

DESC form.csv
0.6 kB
14/Aug/19 7:44 AM
DESC muzimaforms_form.csv
0.6 kB
14/Aug/19 7:43 AM
Engine INNODB status.csv
5 kB
14/Aug/19 7:13 AM
SHOW TABLE STATUS like 'form'.csv
0.3 kB
14/Aug/19 8:06 AM
SHOW TABLE STATUS like muzimaforms_form.csv
0.3 kB
14/Aug/19 8:05 AM

Activity

People

Assignee:: Simon Savai

Reporter:: Joshua Byiringiro

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 13/Aug/19 11:38 AM

Updated:: 21/Aug/19 5:08 AM

Resolved:: 19/Aug/19 4:56 AM