SEVERE 12/15/17 5:03 PM: liquibase: assemblyChangelog.xml: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201706061043_alter_table_mc_vmp_method.xml::constraint.add__public.mc_vmp_method.treatment_kind_id::ruslan.nizamov: Change Set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201706061043_alter_table_mc_vmp_method.xml::constraint.add__public.mc_vmp_method.treatment_kind_id::ruslan.nizamov failed.  Error: ERROR: insert or update on table "mc_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(id)]
liquibase.exception.DatabaseException: ERROR: insert or update on table "mc_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(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_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
	... 12 more
INFO 12/15/17 5:03 PM: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201706061043_alter_table_mc_vmp_method.xml::constraint.add__public.mc_vmp_method.treatment_kind_id::ruslan.nizamov: Successfully released change log lock
Unexpected error running Liquibase: ERROR: insert or update on table "mc_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(id)]

SEVERE 12/15/17 5:03 PM: liquibase: /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201706061043_alter_table_mc_vmp_method.xml::constraint.add__public.mc_vmp_method.treatment_kind_id::ruslan.nizamov: ERROR: insert or update on table "mc_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(id)]
liquibase.exception.MigrationFailedException: Migration failed for change set /opt/R1/share/n2o-liquibase/liquibase/db/changelog/201706061043_alter_table_mc_vmp_method.xml::constraint.add__public.mc_vmp_method.treatment_kind_id::ruslan.nizamov:
     Reason: liquibase.exception.DatabaseException: ERROR: insert or update on table "mc_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(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_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind". [Failed SQL: ALTER TABLE public.mc_vmp_method ADD CONSTRAINT mc_vmp_method_treatment_kind_id_fk
            FOREIGN KEY (treatment_kind_id) REFERENCES public.mc_treatment_kind(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_vmp_method" violates foreign key constraint "mc_vmp_method_treatment_kind_id_fk"
  Detail: Key (treatment_kind_id)=(19) is not present in table "mc_treatment_kind".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
	... 12 more