Advertisement
Guest User

logs from patient flag module

a guest
Sep 26th, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 11.98 KB | None | 0 0
  1.  
  2.  
  3. SEVERE 9/26/19 3:32 PM:liquibase: Change Set liquibase.xml::patientflags-1554735240623-7::slubwama failed.  Error: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  4. liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  5.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  6.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  7.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  8.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  9.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  10.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  11.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  12.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  13.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  14.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:990)
  15.     at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  16.     at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  17. Caused by: java.sql.SQLException: Cannot add foreign key constraint
  18.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
  19.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  20.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  21.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  22.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  23.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  24.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  25.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  26.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  27.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  28.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  29.     ... 11 more
  30. WARN - ModuleFactory.startModuleInternal(788) |2019-09-26 15:32:15,857| Error while trying to start module: patientflags
  31. org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Patient Flags Module
  32.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1000)
  33.     at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  34.     at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  35. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::patientflags-1554735240623-7::slubwama:
  36.      Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint:
  37.           Caused By: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint:
  38.           Caused By: Cannot add foreign key constraint
  39.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  40.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  41.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  42.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  43.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  44.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:990)
  45.     ... 2 more
  46. Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  47.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  48.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  49.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  50.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  51.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  52.     ... 7 more
  53. Caused by: java.sql.SQLException: Cannot add foreign key constraint
  54.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
  55.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  56.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  57.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  58.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  59.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  60.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  61.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  62.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  63.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  64.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  65.     ... 11 more
  66. INFO 9/26/19 3:32 PM:liquibase: Successfully released change log lock
  67. INFO - LoggingAdvice.invoke(115) |2019-09-26 15:32:15,890| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
  68. INFO - LoggingAdvice.invoke(155) |2019-09-26 15:32:15,896| Exiting method saveAlert
  69. INFO - LoggingAdvice.invoke(115) |2019-09-26 15:32:18,894| In method AlertService.saveAlert. Arguments: Alert=Alert: #2,
  70. INFO - LoggingAdvice.invoke(155) |2019-09-26 15:32:18,901| Exiting method saveAlert
  71. INFO 9/26/19 3:32 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
  72. INFO 9/26/19 3:32 PM:liquibase: Reading from `liquibasechangelog`
  73. INFO 9/26/19 3:32 PM:liquibase: Successfully acquired change log lock
  74. INFO 9/26/19 3:32 PM:liquibase: liquibase.xml is using schema version 1.9 rather than version 2.0
  75. INFO 9/26/19 3:32 PM:liquibase: Reading from `liquibasechangelog`
  76. SEVERE 9/26/19 3:32 PM:liquibase: Change Set liquibase.xml::patientflags-1554735240623-7::slubwama failed.  Error: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  77. liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  78.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  79.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  80.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  81.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  82.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  83.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  84.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  85.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  86.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  87.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:990)
  88.     at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  89.     at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  90. Caused by: java.sql.SQLException: Cannot add foreign key constraint
  91.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
  92.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  93.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  94.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  95.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  96.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  97.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  98.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  99.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  100.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  101.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  102.     ... 11 more
  103. INFO 9/26/19 3:32 PM:liquibase: Successfully released change log lock
  104. WARN - ModuleFactory.startModuleInternal(788) |2019-09-26 15:32:35,194| Error while trying to start module: patientflags
  105. org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: Patient Flags Module
  106.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1000)
  107.     at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  108.     at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  109. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::patientflags-1554735240623-7::slubwama:
  110.      Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint:
  111.           Caused By: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint:
  112.           Caused By: Cannot add foreign key constraint
  113.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  114.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  115.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  116.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  117.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  118.     at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:990)
  119.     ... 2 more
  120. Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `patientflags_tag_role` (`tag_id` INT NOT NULL, `role` VARCHAR(50) NOT NULL, CONSTRAINT `patientflags_tag_role_ibfk_2` FOREIGN KEY (`role`) REFERENCES role(role)): Cannot add foreign key constraint
  121.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  122.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  123.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  124.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  125.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  126.     ... 7 more
  127. Caused by: java.sql.SQLException: Cannot add foreign key constraint
  128.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
  129.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  130.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  131.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  132.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  133.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  134.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  135.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  136.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  137.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  138.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  139.     ... 11 more
  140. INFO - LoggingAdvice.invoke(115) |2019-09-26 15:32:35,241| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
  141. INFO - LoggingAdvice.invoke(155) |2019-09-26 15:32:35,243| Exiting method saveAlert
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement