Advertisement
Guest User

bahmni-setup error

a guest
Sep 7th, 2016
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.63 KB | None | 0 0
  1. fatal: [localhost]: FAILED! => {"changed": true, "failed": true, "rc": 255, "std err": "+ . /etc/bahmni-installer/bahmni.conf\n++ IMPLEMENTATION_NAME=bd-uhc\n++ OPENMRS_DB_USERNAME=openmrs-user\n++ OPENMRS_DB_PASSWORD=password\n++ OPENMRS_DB _SERVER=localhost\n++ OPENELIS_DB_USERNAME=clinlims\n++ OPENELIS_DB_PASSWORD=pas sword\n++ OPENELIS_DB_SERVER=localhost\n++ OPENERP_DB_USERNAME=openerp\n++ OPENE RP_DB_PASSWORD=password\n++ OPENERP_DB_SERVER=localhost\n++ MYSQL_ROOT_USER=root \n++ MYSQL_ROOT_PASSWORD=password\n+ CHANGE_LOG_TABLE='-Dliquibase.databaseChang eLogTableName=liquibasechangelog -Dliquibase.databaseChangeLogLockTableName=liqu ibasechangeloglock -DschemaName=openmrs'\n+ LIQUIBASE_JAR=/opt/openmrs/openmrs/W EB-INF/lib/liquibase-core-2.0.5.jar\n+ DRIVER=com.mysql.jdbc.Driver\n+ CLASSPATH =/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar\n+ CHANGE_LOG_ FILE=liquibase.xml\n+ cd /var/www/bahmni_config/openmrs/migrations\n+ java -Dliq uibase.databaseChangeLogTableName=liquibasechangelog -Dliquibase.databaseChangeL ogLockTableName=liquibasechangeloglock -DschemaName=openmrs -jar /opt/openmrs/op enmrs/WEB-INF/lib/liquibase-core-2.0.5.jar --driver=com.mysql.jdbc.Driver --clas spath=/opt/openmrs/openmrs/WEB-INF/lib/mysql-connector-java-5.1.28.jar --changeL ogFile=liquibase.xml --url=jdbc:mysql://localhost:3306/openmrs --username=openmr s-user --password=password update\nINFO 9/7/16 7:40 PM:liquibase: Successfully a cquired change log lock\nINFO 9/7/16 7:40 PM:liquibase: Reading from `liquibasec hangelog`\nINFO 9/7/16 7:40 PM:liquibase: Reading from `liquibasechangelog`\nINF O 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xml::JSS-201405141259::mih ir/shruthi ran successfully in 15ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bd shr-liquibase.xml::JSS-201405141113::mihir/shruthi ran successfully in 6ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xml::JSS-201406261644::arat hy/mujir ran successfully in 6ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr -liquibase.xml::BD-201406241630::angshu ran successfully in 24ms\nINFO 9/7/16 7: 40 PM:liquibase: ChangeSet bdshr-liquibase.xml::BD-201409101706::Neha,Sumit ran successfully in 9ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xm l::BD-201411271111::tw ran successfully in 4ms\nINFO 9/7/16 7:40 PM:liquibase: C hangeSet bdshr-liquibase.xml::BD-201411271042::neha ran successfully in 23ms\nIN FO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xml::BD-201412031437::neh a ran successfully in 7ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquib ase.xml::BD-20150216-1611::neha ran successfully in 8ms\nINFO 9/7/16 7:40 PM:liq uibase: ChangeSet bdshr-liquibase.xml::BD-20150415-2100::Angshu ran successfully in 47ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xml::BD-20150 511-1031::Hemanth ran successfully in 9ms\nINFO 9/7/16 7:40 PM:liquibase: Markin g ChangeSet: bdshr-liquibase.xml::BD-20150625-1631::neha,angshu::(Checksum: 3:0e eb5c618506048e51563a00d778f0cd) ran despite precondition failure due to onFail=' MARK_RAN': \n liquibase.xml : SQL Precondition failed. Expected '0' go t '1'\n\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-liquibase.xml::BD-201512 04-20919::neha ran successfully in 11ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSe t bdshr-liquibase.xml::201603081440::Neha,Sukreet ran successfully in 47ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-observation-templates-liquibase.xml:: BD-20150107-1158::dubey, sukreet ran successfully in 33ms\nINFO 9/7/16 7:40 PM:l iquibase: ChangeSet bdshr-observation-templates-liquibase.xml::BD-20150107-1308: :dubey, sukreet ran successfully in 41ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeS et bdshr-observation-templates-liquibase.xml::BD-20150107-1429::dubey, sukreet r an successfully in 54ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-observat ion-templates-liquibase.xml::BD-20150107-1444::dubey, sukreet ran successfully i n 43ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-observation-templates-liq uibase.xml::BD-20150107-1454::dubey, sukreet ran successfully in 27ms\nINFO 9/7/ 16 7:40 PM:liquibase: ChangeSet bdshr-observation-templates-liquibase.xml::BD-20 150107-1500::dubey, sukreet ran successfully in 17ms\nINFO 9/7/16 7:40 PM:liquib ase: ChangeSet bdshr-orders-setup-liquibase.xml::BD-20160108-1204::dubey,sukreet ran successfully in 11ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders -setup-liquibase.xml::BD-20160108-1206::dubey, sukreet ran successfully in 7ms\n INFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders-setup-liquibase.xml::BD-20 150108-1214::dubey, sukreet ran successfully in 11ms\nINFO 9/7/16 7:40 PM:liquib ase: ChangeSet bdshr-orders-setup-liquibase.xml::BD-20150108-1231::dubey, sukree t ran successfully in 10ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-order s-setup-liquibase.xml::BD-20150108-1353::dubey, sukreet ran successfully in 7ms\ nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders-setup-liquibase.xml::BD-2 0150121-1657::dubey ran successfully in 5ms\nINFO 9/7/16 7:40 PM:liquibase: Mark ing ChangeSet: bdshr-orders-setup-liquibase.xml::BD-20160314-1636::neha,sukreet: :(Checksum: 3:48d613e4681605c6dd107ef59b7cc2da) ran despite precondition failure due to onFail='MARK_RAN': \n liquibase.xml : SQL Precondition failed. Expected '0' got '1'\n\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders-s etup-liquibase.xml::BD-20160314-1637::neha,sukreet ran successfully in 6ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders-setup-liquibase.xml::BD-201603 14-1638::neha,sukreet ran successfully in 12ms\nINFO 9/7/16 7:40 PM:liquibase: C hangeSet bdshr-orders-setup-liquibase.xml::BD-20160314-1653::sukreet,neha ran su ccessfully in 12ms\nINFO 9/7/16 7:40 PM:liquibase: ChangeSet bdshr-orders-setup- liquibase.xml::BD-20160314-1825::neha, sukreet ran successfully in 9ms\nSEVERE 9 /7/16 7:40 PM:liquibase: Change Set openmrs-roles-and-privileges-liquibase.xml:: BAHMNI-IMPL-OMRS-ROLES-PVG-001::tw failed. Error: Error executing SQL insert in to role_privilege (role, privilege) values ('RegistrationClerk', 'View Location Attribute Types'): Cannot add or update a child row: a foreign key constraint fa ils (`openmrs`.`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (`privilege`))\nliquibase.exception.Databas eException: Error executing SQL insert into role_privilege (role, privilege) val ues ('RegistrationClerk', 'View Location Attribute Types'): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`role_privilege`, CONSTR AINT `privilege_definitions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (` privilege`))\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\ta t liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:10 75)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n\tat liquib ase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)\n\tat liquibase .changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)\n\tat liquibase.Liqu ibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.do Migration(Main.java:825)\n\tat liquibase.integration.commandline.Main.main(Main. java:134)\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintVi olationException: Cannot add or update a child row: a foreign key constraint fai ls (`openmrs`.`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KEY ( `privilege`) REFERENCES `privilege` (`privilege`))\n\tat sun.reflect.NativeConst ructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstruct orAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)\n\tat sun.refl ect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorI mpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java:52 6)\n\tat com.mysql.jdbc.Util.handleNewInstance(Util.java:411)\n\tat com.mysql.jd bc.Util.getInstance(Util.java:386)\n\tat com.mysql.jdbc.SQLError.createSQLExcept ion(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va: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.Mysql IO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL (ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(Connectio nImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:9 49)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liq uibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExe cutor.java:92)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.ja va:55)\n\t... 9 more\nINFO 9/7/16 7:40 PM:liquibase: Successfully released chang e log lock\nLiquibase Update Failed: Error executing SQL insert into role_privil ege (role, privilege) values ('RegistrationClerk', 'View Location Attribute Type s'): Cannot add or update a child row: a foreign key constraint fails (`openmrs` .`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (`privilege`))\nSEVERE 9/7/16 7:40 PM:liquibase: Error ex ecuting SQL insert into role_privilege (role, privilege) values ('RegistrationCl erk', 'View Location Attribute Types'): Cannot add or update a child row: a fore ign key constraint fails (`openmrs`.`role_privilege`, CONSTRAINT `privilege_defi nitions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (`privilege`))\nliquib ase.exception.MigrationFailedException: Migration failed for change set openmrs- roles-and-privileges-liquibase.xml::BAHMNI-IMPL-OMRS-ROLES-PVG-001::tw:\n Re ason: liquibase.exception.DatabaseException: Error executing SQL insert into rol e_privilege (role, privilege) values ('RegistrationClerk', 'View Location Attrib ute Types'): Cannot add or update a child row: a foreign key constraint fails (` openmrs`.`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KEY (`priv ilege`) REFERENCES `privilege` (`privilege`)):\n Caused By: Error execu ting SQL insert into role_privilege (role, privilege) values ('RegistrationClerk ', 'View Location Attribute Types'): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`role_privilege`, CONSTRAINT `privilege_definit ions` FOREIGN KEY (`privilege`) REFERENCES `privilege` (`privilege`)):\n Caused By: Cannot add or update a child row: a foreign key constraint fails (` openmrs`.`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KEY (`priv ilege`) REFERENCES `privilege` (`privilege`))\n\tat liquibase.changelog.ChangeSe t.execute(ChangeSet.java:347)\n\tat liquibase.changelog.visitor.UpdateVisitor.vi sit(UpdateVisitor.java:27)\n\tat liquibase.changelog.ChangeLogIterator.run(Chang eLogIterator.java:58)\n\tat liquibase.Liquibase.update(Liquibase.java:114)\n\tat liquibase.integration.commandline.Main.doMigration(Main.java:825)\n\tat liquiba se.integration.commandline.Main.main(Main.java:134)\nCaused by: liquibase.except ion.DatabaseException: Error executing SQL insert into role_privilege (role, pri vilege) values ('RegistrationClerk', 'View Location Attribute Types'): Cannot ad d or update a child row: a foreign key constraint fails (`openmrs`.`role_privile ge`, CONSTRAINT `privilege_definitions` FOREIGN KEY (`privilege`) REFERENCES `pr ivilege` (`privilege`))\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcEx ecutor.java:62)\n\tat liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.j ava:104)\n\tat liquibase.database.AbstractDatabase.execute(AbstractDatabase.java :1091)\n\tat liquibase.database.AbstractDatabase.executeStatements(AbstractDatab ase.java:1075)\n\tat liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)\n \t... 5 more\nCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstrain tViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`role_privilege`, CONSTRAINT `privilege_definitions` FOREIGN KE Y (`privilege`) REFERENCES `privilege` (`privilege`))\n\tat sun.reflect.NativeCo nstructorAccessorImpl.newInstance0(Native Method)\n\tat sun.reflect.NativeConstr uctorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)\n\tat sun.r eflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccess orImpl.java:45)\n\tat java.lang.reflect.Constructor.newInstance(Constructor.java :526)\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.createSQLExc eption(SQLError.java:1041)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO .java:4237)\n\tat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)\n\t at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)\n\tat com.mysql.jdbc.My sqlIO.sqlQueryDirect(MysqlIO.java:2778)\n\tat com.mysql.jdbc.ConnectionImpl.exec SQL(ConnectionImpl.java:2819)\n\tat com.mysql.jdbc.ConnectionImpl.execSQL(Connec tionImpl.java:2768)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.jav a:949)\n\tat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)\n\tat liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(Jdbc Executor.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": []}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement