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.

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

[management] Error while deleting a user #7613

Closed
phiz71 opened this issue May 2, 2022 · 1 comment
Closed

[management] Error while deleting a user #7613

phiz71 opened this issue May 2, 2022 · 1 comment
Assignees
@phiz71
Labels
project: APIM type: bug
Projects
API Management
Milestone
APIM - 3.10.15

Comments

@phiz71
Copy link
Member

phiz71 commented May 2, 2022

💥 Describe the bug

On a JDBC database, I have an error when deleting user.

11:17:30.957 [gravitee-listener-57] ERROR i.g.r.j.m.JdbcAbstractCrudRepository - Failed to update users item:
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; ERROR: null value in column "organization_id" violates not-null constraint

It only occurs when this option is enabled:

user:
  anonymize-on-delete:
    enabled: true

🌄 To Reproduce

Steps to reproduce the behaviour:

  1. Enable the user.anonymize-on-delete.enabled option in gravitee.yml file
  2. Start Gravitee
  3. Create a user
  4. Try to delete the user

🌈 Expected behaviour

The user should be logically deleted, with anonymized data.

Current behaviour

Error while "updating" the user

⚠️ Potential impacts

What are the impacted versions?
3.10.x and upper
@phiz71 phiz71 added this to the APIM - 3.10.x milestone May 2, 2022
@phiz71 phiz71 self-assigned this May 2, 2022
phiz71 added a commit to gravitee-io/gravitee-api-management that referenced this issue May 2, 2022
@phiz71
fix: copy the original organizationId when anonymizing a user while d…
d9f1d27 
…eleting it

* and set `false` as the default value in gravitee.yml file to be consistent with the code

gravitee-io/issues#7613
@phiz71 phiz71 mentioned this issue May 2, 2022
Merged
gaetanmaisse pushed a commit to gravitee-io/gravitee-api-management that referenced this issue May 2, 2022
@phiz71 @gaetanmaisse
fix: copy the original organizationId when anonymizing a user while d…
289d85c 
…eleting it

* and set `false` as the default value in gravitee.yml file to be consistent with the code

gravitee-io/issues#7613
@RubenMMSantos
Copy link

Behaviour reproduced on envir 3-10-x-jdbc with no errors displayed after creating/deleting a user.
Database was checked together with dev to confirm data for deleted users was anonymised after deletion.

@phiz71 phiz71 modified the milestones: APIM - 3.10.x, APIM - 3.10.15 May 24, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@phiz71 phiz71

Labels
project: APIM type: bug
Projects
API Management
Awaiting triage
Milestone
APIM - 3.10.15
Development

No branches or pull requests
5 participants
@mouligno @gaetanmaisse @phiz71 @RubenMMSantos @ppgravitee