Server responding with 500 when Deleting user account with 2 organizations while current_organization_id is the one that will be deleted

[mahbubsabuj]

Description

---

Steps To Reproduce

1. Create user A and Invite user B to the org
2. User B creates an account and accept the invitation
3. User B switched to his own org
4. User B tries to delete own account.

Self-hosted or Cloud?

Both

Version of solidtime: (for self-hosted)

No response

solidtime self-hosting guide: (for self-hosted)

No response

[Onatcer]

Thanks for reporting. Looks like the organizations_current_organization_id_foreign contraint is throwing there. We convert the user that is in the organization into a placeholder user and delete the organization where the user is the owner (and the only member). because MemberService:199 replicates the current user, it also replicates the current_organization_id which is set to the organization we just deleted. From what I see deleting the user when you have the other organization (the one that you are not member of) should work.

The permanent fix should set the current_organization_id for the placeholder user to the actual organization where he is now a placeholder user.

internal reference (SOLIDTIME-CY)