Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ) 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
- 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:189)
- at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
- at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
- at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1024)
- at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
- at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'idgen_identifier_source' already exists
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- 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 2/2/18 1:45 PM:liquibase: Successfully released change log lock
- WARN - ModuleFactory.startModuleInternal(788) |2018-02-02 13:45:06,601| Error while trying to start module: idgen
- org.openmrs.module.ModuleException: Unable to update data model using liquibase.xml. Module: ID Generation
- at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1034)
- at org.openmrs.module.ModuleFactory.startModuleInternal(ModuleFactory.java:728)
- at org.openmrs.api.context.Daemon$1.run(Daemon.java:74)
- Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::1.0::Partners In Health:
- 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:
- 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:
- Caused By: Table 'idgen_identifier_source' already exists
- 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:189)
- at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
- at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
- at org.openmrs.module.ModuleFactory.runLiquibase(ModuleFactory.java:1024)
- ... 2 more
- 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
- 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 'idgen_identifier_source' already exists
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- 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 - LoggingAdvice.invoke(115) |2018-02-02 13:45:06,685| In method AlertService.saveAlert. Arguments: Alert=Alert: #null,
- INFO - LoggingAdvice.invoke(155) |2018-02-02 13:45:06,699| Exiting method saveAlert
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement