Guest User

Migration error during endtb installation

a guest
Nov 14th, 2016
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.33 KB | None | 0 0
  1. TASK [implementation-config : Run openmrs liquibase migrations] ****************
  2. task path: /opt/bahmni-installer/bahmni-playbooks/roles/implementation-config/tasks/implementation-config.yml:70
  3. fatal: [localhost]: FAILED! => {"changed": true, "failed": true, "rc": 255, "stderr": "+ . /etc/bahmni-installer/bahmni.conf\n++ IMPLEMENTATION_NAME=endtb\n++ OPENMRS_DB_USERNAME=openmrs-user\n++ OPENMRS_DB_PASSWORD=password\n++ OPENMRS_DB_SERVER=localhost\n++ MYSQL_ROOT_USER=root\n++ MYSQL_ROOT_PASSWORD=password\n++ REPORTS_DB_SERVER=localhost\n++ REPORTS_DB_PASSWORD=password\n++ REPORTS_DB_USERNAME=reports-user\n+ CHANGE_LOG_TABLE='-Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs'\n+ LIQUIBASE_JAR=/opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar\n+ DRIVER=com.mysql.jdbc.Driver\n++ ls /opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CLASSPATH=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CHANGE_LOG_FILE=liquibase.xml\n+ '[' -f /var/www/bahmni_config/openmrs/migrations/liquibase.xml ']'\n+ cd /var/www/bahmni_config/openmrs/migrations\n+ java -Dliquibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liquibasechangeloglock -DschemaName=openmrs -jar /opt/openmrs/openmrs/WEB-INF/lib/liquibase-core-2.0.5.jar --driver=com.mysql.jdbc.Driver --classpath=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar --changeLogFile=liquibase.xml --url=jdbc:mysql://localhost:3306/openmrs --username=openmrs-user --password=password update\nINFO 11/14/16 12:07 PM:liquibase: Successfully acquired change log lock\nINFO 11/14/16 12:07 PM:liquibase: Reading from `liquibasechangelog`\nINFO 11/14/16 12:07 PM:liquibase: Reading from `liquibasechangelog`\nSEVERE 11/14/16 12:07 PM:liquibase: Change Set liquibase.xml::ENDTB-201605101556::Mahesh failed. Error: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\nliquibase.exception.DatabaseException: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)\n\tat java.lang.reflect.Constructor.newInstance(Unknown Source)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t... 9 more\nINFO 11/14/16 12:07 PM:liquibase: Successfully released change log lock\nLiquibase Update Failed: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\nSEVERE 11/14/16 12:07 PM:liquibase: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\nliquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::ENDTB-201605101556::Mahesh:\n Reason: liquibase.exception.DatabaseException: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`)):\n Caused By: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`)):\n Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)\n\tat liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main.java:134)\nCaused by: liquibase.exception.DatabaseException: Error executing SQL insert into concept_answer (concept_id,answer_concept,creator,date_created,sort_weight,uuid)\n values (792,1648,4,now(),6,uuid()): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\t... 5 more\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`concept_answer`, CONSTRAINT `answer` FOREIGN KEY (`answer_concept`) REFERENCES `concept` (`concept_id`))\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)\n\tat java.lang.reflect.Constructor.newInstance(Unknown Source)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jdbc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\tat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)\n\t... 9 more\n\n\nFor more information, use the --logLevel flag)\n", "stdout": "", "stdout_lines": []}
  4. to retry, use: --limit @all.retry
Add Comment
Please, Sign In to add comment