[
https://issues.apache.org/jira/browse/FINERACT-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18101928#comment-18101928
]
Harsha Vardhan Doddi commented on FINERACT-2594:
------------------------------------------------
Investigated this. The fix already exists — commit {{59f7ec75cd}}
(FINERACT-2595) reorders the deletes in changeset 0231 to remove
{{m_role_permission}} rows before {{{}m_permission{}}}, which resolves this
exact FK violation. Verified by wiping my local DB volume and re-running the
migration on current {{develop}} — it now completes without error. Looks like
this ticket can be closed as a duplicate of FINERACT-2595.
> ERROR: Updating or deleting on "m_permission" violates foreign key
> -------------------------------------------------------------------
>
> Key: FINERACT-2594
> URL: https://issues.apache.org/jira/browse/FINERACT-2594
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Blanca Mendoza
> Priority: Major
> Labels: beginner, beginner-friendly
>
>
> fineract-server-1 | ... 6 common frames omitted
> fineract-server-1 | Caused by: liquibase.exception.LiquibaseException:
> liquibase.exception.MigrationFailedException: Migration failed for changeset
> db/changelog/tenant/parts/0231_remove_clientcharge_inactivate_permissions.xml::1::ashharahmadkhan:
> fineract-server-1 | Reason: liquibase.exception.DatabaseException:
> ERROR: update o delete en «m_permission» viola la llave foránea
> «fk8dedb048103b544b» en la tabla «m_role_permission»
> fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde
> la tabla «m_role_permission». [Failed SQL: (0) DELETE FROM
> public.m_permission WHERE code='INACTIVATE_CLIENTCHARGE']
> fineract-server-1 | at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:155)
> fineract-server-1 | at
> liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:114)
> fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
> fineract-server-1 | at
> liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:112)
> fineract-server-1 | at
> liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:100)
> fineract-server-1 | at
> liquibase.command.CommandScope.lambda$execute$6(CommandScope.java:263)
> fineract-server-1 | ... 24 common frames omitted
> fineract-server-1 | Caused by: liquibase.exception.MigrationFailedException:
> Migration failed for changeset
> db/changelog/tenant/parts/0231_remove_clientcharge_inactivate_permissions.xml::1::ashharahmadkhan:
> fineract-server-1 | Reason: liquibase.exception.DatabaseException:
> ERROR: update o delete en «m_permission» viola la llave foránea
> «fk8dedb048103b544b» en la tabla «m_role_permission»
> fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde
> la tabla «m_role_permission». [Failed SQL: (0) DELETE FROM
> public.m_permission WHERE code='INACTIVATE_CLIENTCHARGE']
> fineract-server-1 | at
> liquibase.changelog.ChangeSet.execute(ChangeSet.java:873)
> fineract-server-1 | at
> liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:127)
> fineract-server-1 | at
> liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:71)
> fineract-server-1 | at
> liquibase.changelog.ChangeLogIterator.lambda$run$0(ChangeLogIterator.java:133)
> fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
> fineract-server-1 | at
> liquibase.changelog.ChangeLogIterator.lambda$run$1(ChangeLogIterator.java:122)
> fineract-server-1 | at liquibase.Scope.lambda$child$0(Scope.java:216)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:225)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:215)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:194)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:282)
> fineract-server-1 | at liquibase.Scope.child(Scope.java:286)
> fineract-server-1 | at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:91)
> fineract-server-1 | ... 32 common frames omitted
> fineract-server-1 | Caused by: liquibase.exception.DatabaseException: ERROR:
> update o delete en «m_permission» viola la llave foránea «fk8dedb048103b544b»
> en la tabla «m_role_permission»
> fineract-server-1 | Detail: La llave (id)=(672) todavía es referida desde
> la tabla «m_role_permission». [Failed SQL: (0) DELETE FROM
> public.m_permission WHERE code='INACTIVATE_CLIENTCHARGE']
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
