Advertisement
Guest User

Untitled

a guest
Feb 2nd, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.84 KB | None | 0 0
  1. ) NOT NULL, `identifier_type` INT(11) DEFAULT 0 NOT NULL, `creator` INT(11) DEFAULT 0 NOT NULL, `date_created` DATETIME NOT NULL, `changed_by` INT(11) DEFAULT NULL NULL, `date_changed` DATETIME DEFAULT null NULL, `retired` TINYINT(1) DEFAULT 0 NOT NULL, `retired_by` INT(11) DEFAULT NULL NULL, `date_retired` DATETIME DEFAULT null NULL, `retire_reason` VARCHAR(255) DEFAULT null NULL, CONSTRAINT `PK_IDGEN_IDENTIFIER_SOURCE` PRIMARY KEY (`id`), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`retired_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`identifier_type`) REFERENCES patient_identifier_type(patient_identifier_type_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`changed_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`creator`) REFERENCES users(user_id), UNIQUE (`changed_by`), UNIQUE (`creator`), UNIQUE (`identifier_type`), UNIQUE (`retired_by`), UNIQUE (`id`)): Table 'idgen_identifier_source' already exists
  2. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  3. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  4. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  5. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  6. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  7. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  8. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  9. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  10. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  11. at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1024)
  12. at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  13. at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  14. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'idgen_identifier_source' already exists
  15. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  16. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  17. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  18. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  19. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  20. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  21. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  22. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  23. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  24. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  25. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  26. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  27. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  28. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  29. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  30. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  31. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  32. ... 11 more
  33. INFO 2/2/18 1:45 PM:liquibase: Successfully released change log lock
  34. WARN - ModuleFactory.startModuleInternal(788) |2018-02-02 13:45:06,601| Error while trying to start module: idgen
  35. org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: ID Generation
  36. at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1034)
  37. at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
  38. at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
  39. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::1.0::Partners In Health:
  40. Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `idgen_identifier_source` (`id` INT(11) AUTO_INCREMENT NOT NULL, `uuid` CHAR(38) NOT NULL, `name` VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NOT NULL, `identifier_type` INT(11) DEFAULT 0 NOT NULL, `creator` INT(11) DEFAULT 0 NOT NULL, `date_created` DATETIME NOT NULL, `changed_by` INT(11) DEFAULT NULL NULL, `date_changed` DATETIME DEFAULT null NULL, `retired` TINYINT(1) DEFAULT 0 NOT NULL, `retired_by` INT(11) DEFAULT NULL NULL, `date_retired` DATETIME DEFAULT null NULL, `retire_reason` VARCHAR(255) DEFAULT null NULL, CONSTRAINT `PK_IDGEN_IDENTIFIER_SOURCE` PRIMARY KEY (`id`), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`retired_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`identifier_type`) REFERENCES patient_identifier_type(patient_identifier_type_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`changed_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`creator`) REFERENCES users(user_id), UNIQUE (`changed_by`), UNIQUE (`creator`), UNIQUE (`identifier_type`), UNIQUE (`retired_by`), UNIQUE (`id`)): Table 'idgen_identifier_source' already exists:
  41. Caused By: Error executing SQL CREATE TABLE `idgen_identifier_source` (`id` INT(11) AUTO_INCREMENT NOT NULL, `uuid` CHAR(38) NOT NULL, `name` VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NOT NULL, `identifier_type` INT(11) DEFAULT 0 NOT NULL, `creator` INT(11) DEFAULT 0 NOT NULL, `date_created` DATETIME NOT NULL, `changed_by` INT(11) DEFAULT NULL NULL, `date_changed` DATETIME DEFAULT null NULL, `retired` TINYINT(1) DEFAULT 0 NOT NULL, `retired_by` INT(11) DEFAULT NULL NULL, `date_retired` DATETIME DEFAULT null NULL, `retire_reason` VARCHAR(255) DEFAULT null NULL, CONSTRAINT `PK_IDGEN_IDENTIFIER_SOURCE` PRIMARY KEY (`id`), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`retired_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`identifier_type`) REFERENCES patient_identifier_type(patient_identifier_type_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`changed_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`creator`) REFERENCES users(user_id), UNIQUE (`changed_by`), UNIQUE (`creator`), UNIQUE (`identifier_type`), UNIQUE (`retired_by`), UNIQUE (`id`)): Table 'idgen_identifier_source' already exists:
  42. Caused By: Table 'idgen_identifier_source' already exists
  43. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  44. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  45. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  46. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  47. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  48. at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1024)
  49. ... 2 more
  50. Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE `idgen_identifier_source` (`id` INT(11) AUTO_INCREMENT NOT NULL, `uuid` CHAR(38) NOT NULL, `name` VARCHAR(255) NOT NULL, `description` VARCHAR(1000) NOT NULL, `identifier_type` INT(11) DEFAULT 0 NOT NULL, `creator` INT(11) DEFAULT 0 NOT NULL, `date_created` DATETIME NOT NULL, `changed_by` INT(11) DEFAULT NULL NULL, `date_changed` DATETIME DEFAULT null NULL, `retired` TINYINT(1) DEFAULT 0 NOT NULL, `retired_by` INT(11) DEFAULT NULL NULL, `date_retired` DATETIME DEFAULT null NULL, `retire_reason` VARCHAR(255) DEFAULT null NULL, CONSTRAINT `PK_IDGEN_IDENTIFIER_SOURCE` PRIMARY KEY (`id`), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`retired_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`identifier_type`) REFERENCES patient_identifier_type(patient_identifier_type_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`changed_by`) REFERENCES users(user_id), CONSTRAINT `idgen_identifier_source` FOREIGN KEY (`creator`) REFERENCES users(user_id), UNIQUE (`changed_by`), UNIQUE (`creator`), UNIQUE (`identifier_type`), UNIQUE (`retired_by`), UNIQUE (`id`)): Table 'idgen_identifier_source' already exists
  51. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  52. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  53. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  54. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  55. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  56. ... 7 more
  57. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'idgen_identifier_source' already exists
  58. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  59. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  60. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  61. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  62. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  63. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  64. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  65. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  66. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  67. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  68. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  69. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  70. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  71. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  72. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  73. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  74. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  75. ... 11 more
  76. INFO - LoggingAdvice.invoke(115) |2018-02-02 13:45:06,685| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
  77. INFO - LoggingAdvice.invoke(155) |2018-02-02 13:45:06,699| Exiting method saveAlert
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement