Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unconfirmed user deletion seems broken #45

Closed
jridderbusch opened this issue Mar 12, 2024 · 1 comment · Fixed by #46
Closed

Unconfirmed user deletion seems broken #45

jridderbusch opened this issue Mar 12, 2024 · 1 comment · Fixed by #46
Assignees
@jridderbusch
Labels
area/backend kind/bug Something isn't working. The software does not behave as expected or specified. status/updated MDS Authority Portal Issue was updated since last Bi-weekly
Milestone
R 22.03.

Comments

@jridderbusch
Copy link
Contributor

Description - What happened? *

Unconfirmed user deletion seems to break under certain circumstances and leaves remainders in the DB, which results in a failing "Users & Roles" download.

Expected Behavior *

Users are cleaned up correctly.

Observed Behavior *

DB deletion fails with the log output below.

Steps to Reproduce

No response

Context Information

No response

Relevant log output

2024-03-12 09:41:58,064 ERROR [io.qua.sch.com.run.StatusEmitterInvoker] (executor-thread-8358) Error occurred while executing task for trigger IntervalTrigger [id=1_de.sovity.authorityportal.web.pages.usermanagement.UnconfirmedUserDeletionService#deleteUnconfirmedUsersAndOrganizations, interval=900000]: java.util.concurrent.CompletionException: org.jooq.exception.IntegrityConstraintViolationException: SQL [delete from "organization" where "organization"."mds_id" in (?, ?, ?)]; ERROR: update or delete on table "organization" violates foreign key constraint "fk_user_organization_id" on table "user"

Screenshots

No response
@jridderbusch jridderbusch added kind/bug Something isn't working. The software does not behave as expected or specified. status/updated MDS Authority Portal Issue was updated since last Bi-weekly area/backend labels Mar 12, 2024
@jridderbusch jridderbusch added this to the Release March 15 milestone Mar 12, 2024
@jridderbusch jridderbusch self-assigned this Mar 12, 2024
@jridderbusch jridderbusch mentioned this issue Mar 12, 2024
Merged
@jridderbusch jridderbusch linked a pull request Mar 12, 2024 that will close this issue
Fix user deletion #46
Merged
@jridderbusch jridderbusch added the status/blocked An issue is blocked by another issue or task label Mar 14, 2024
@kamilczaja
Copy link
Collaborator

@jridderbusch
What is this blocked by?

@jridderbusch jridderbusch removed the status/blocked An issue is blocked by another issue or task label Mar 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jridderbusch jridderbusch

Labels
area/backend kind/bug Something isn't working. The software does not behave as expected or specified. status/updated MDS Authority Portal Issue was updated since last Bi-weekly
Projects
None yet
Milestone
R 22.03.
Development

Successfully merging a pull request may close this issue.

Fix user deletion sovity/authority-portal
2 participants
@jridderbusch @kamilczaja