INFO 3/21/18 12:18 PM: liquibase: assemblyChangelog.xml: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201412051517_diagnosis_attribute2.xml::md_attr_value_data_4::rsadikov: Continuing past: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201412051517_diagnosis_attribute2.xml::md_attr_value_data_4::rsadikov despite precondition failure due to onFail='CONTINUE':
          assemblyChangelog.xml : Change Set 'db/changelog/201412051517_diagnosis_attribute2.xml::md_attr_pos_data_2::rsadikov' has not been run

SEVERE 3/21/18 12:18 PM: liquibase: assemblyChangelog.xml: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201510061353_create_mc_case_diet.xml::201510222124_v2::atitov: Change Set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201510061353_create_mc_case_diet.xml::201510222124_v2::atitov failed.  Error: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]
liquibase.exception.DatabaseException: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
	at liquibase.Liquibase.update(Liquibase.java:210)
	at liquibase.Liquibase.update(Liquibase.java:190)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
	at liquibase.integration.commandline.Main.run(Main.java:180)
	at liquibase.integration.commandline.Main.main(Main.java:99)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
	... 12 more
INFO 3/21/18 12:18 PM: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201510061353_create_mc_case_diet.xml::201510222124_v2::atitov: Successfully released change log lock
Unexpected error running Liquibase: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]

SEVERE 3/21/18 12:18 PM: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201510061353_create_mc_case_diet.xml::201510222124_v2::atitov: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]
liquibase.exception.MigrationFailedException: Migration failed for change set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201510061353_create_mc_case_diet.xml::201510222124_v2::atitov:
     Reason: liquibase.exception.DatabaseException: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
	at liquibase.Liquibase.update(Liquibase.java:210)
	at liquibase.Liquibase.update(Liquibase.java:190)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1096)
	at liquibase.integration.commandline.Main.run(Main.java:180)
	at liquibase.integration.commandline.Main.main(Main.java:99)
Caused by: liquibase.exception.DatabaseException: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case". [Failed SQL: ALTER TABLE public.mc_case_diet ADD CONSTRAINT mc_case_id_fk FOREIGN KEY (case_id) REFERENCES public.mc_case (id)]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
	... 7 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "mc_case_diet" violates foreign key constraint "mc_case_id_fk"
  Detail: Key (case_id)=(59620) is not present in table "mc_case".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
	... 12 more