API tools faq
paste
Advertisement
Guest User

logs from patient flag module

a guest
Sep 26th, 2019
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 11.98 KB | None | 0 0
raw download clone embed print report
  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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!