starred/vaultwarden
1
0
Fork 0
mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-04-25 17:25:57 +03:00
Code Issues 39 Projects Releases 5 Packages Wiki Activity

[GH-ISSUE #3247] Foreign key constraint violation upon deleting organization with group #1512

New issue
Closed
opened 2026-03-03 02:09:47 +03:00 by kerem · 6 comments
kerem commented 2026-03-03 02:09:47 +03:00
Owner
Copy link

Originally created by @phiekl on GitHub (Feb 15, 2023).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/3247

Subject of the issue

Unable to delete organizations containing groups (with the groups beta feature enabled).

Deployment environment

  • vaultwarden version: 1.27.0-1ba8275d (HEAD)

  • Install method: Built from source

  • Clients used: web vault

  • Reverse proxy and version: nginx (1.18.0-6.1+deb11u3)

  • MySQL/MariaDB or PostgreSQL version: postgres-13 (13.9-0+deb11u1)

  • Environment variables:

    ADMIN_TOKEN=...
DATABASE_URL=...
DISABLE_2FA_REMEMBER=false
DISABLE_ADMIN_TOKEN=true
DOMAIN=...
LOGIN_RATELIMIT_MAX_BURST=10
LOGIN_RATELIMIT_SECONDS=60
LOG_LEVEL=info
LOG_TIMESTAMP_FORMAT=''
ORG_CREATION_USERS=all
ORG_GROUPS_ENABLED=true
PASSWORD_HINTS_ALLOWED=false
REQUIRE_DEVICE_EMAIL=true
SENDS_ALLOWED=true
SIGNUPS_ALLOWED=true
SIGNUPS_DOMAINS_WHITELIST=...
SIGNUPS_VERIFY=true
SIGNUPS_VERIFY_RESEND_TIME=300
SMTP_FROM=...
SMTP_FROM_NAME=...
SMTP_HOST=...
SMTP_PASSWORD=...
SMTP_PORT=25
SMTP_SECURITY=starttls
SMTP_USERNAME=...
TRASH_AUTO_DELETE_DAYS=30
USER_ATTACHMENT_LIMIT=131072
WEBSOCKET_ENABLED=true
WEBSOCKET_PORT=127.0.0.1

Steps to reproduce

  1. Create a new organization.
  2. Create a group within the new organization.
  3. Try to remove the organization. Nothing happens.
  4. Try to remove it via admin interface, same thing.

Expected behaviour

Organization removed.

Actual behaviour

Organization not removed.

Troubleshooting data

Related log entries in systemd journal:

vaultwarden[3206]: [][request][INFO] DELETE /api/organizations/fbeabd5b-3d65-4b29-9881-37ba2a15d270
postgres[3226]: [9-1] 1676417219.784 [3226] vaultwarden@vaultwarden ERROR:  update or delete on table "organizations" violates foreign key constraint "groups_organizations_uuid_fkey" on table "groups"
postgres[3226]: [9-2] 1676417219.784 [3226] vaultwarden@vaultwarden DETAIL:  Key (uuid)=(fbeabd5b-3d65-4b29-9881-37ba2a15d270) is still referenced from table "groups".
postgres[3226]: [9-3] 1676417219.784 [3226] vaultwarden@vaultwarden STATEMENT:  DELETE  FROM "organizations" WHERE ("organizations"."uuid" = $1) 
vaultwarden[3206]: [][error][ERROR] Error saving organization.
vaultwarden[3206]: [CAUSE] DatabaseError(
vaultwarden[3206]:     ForeignKeyViolation,
vaultwarden[3206]:     "update or delete on table \"organizations\" violates foreign key constraint \"groups_organizations_uuid_fkey\" on table \"groups\"",
vaultwarden[3206]: )
vaultwarden[3206]: [][response][INFO] (delete_organization) DELETE /api/organizations/<org_id> => 400 Bad Request
Originally created by @phiekl on GitHub (Feb 15, 2023). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/3247 ### Subject of the issue Unable to delete organizations containing groups (with the groups beta feature enabled). ### Deployment environment * vaultwarden version: 1.27.0-1ba8275d (HEAD) * Install method: Built from source * Clients used: web vault * Reverse proxy and version: nginx (1.18.0-6.1+deb11u3) * MySQL/MariaDB or PostgreSQL version: postgres-13 (13.9-0+deb11u1) * Environment variables: ``` ADMIN_TOKEN=... DATABASE_URL=... DISABLE_2FA_REMEMBER=false DISABLE_ADMIN_TOKEN=true DOMAIN=... LOGIN_RATELIMIT_MAX_BURST=10 LOGIN_RATELIMIT_SECONDS=60 LOG_LEVEL=info LOG_TIMESTAMP_FORMAT='' ORG_CREATION_USERS=all ORG_GROUPS_ENABLED=true PASSWORD_HINTS_ALLOWED=false REQUIRE_DEVICE_EMAIL=true SENDS_ALLOWED=true SIGNUPS_ALLOWED=true SIGNUPS_DOMAINS_WHITELIST=... SIGNUPS_VERIFY=true SIGNUPS_VERIFY_RESEND_TIME=300 SMTP_FROM=... SMTP_FROM_NAME=... SMTP_HOST=... SMTP_PASSWORD=... SMTP_PORT=25 SMTP_SECURITY=starttls SMTP_USERNAME=... TRASH_AUTO_DELETE_DAYS=30 USER_ATTACHMENT_LIMIT=131072 WEBSOCKET_ENABLED=true WEBSOCKET_PORT=127.0.0.1 ``` ### Steps to reproduce 1. Create a new organization. 2. Create a group within the new organization. 3. Try to remove the organization. Nothing happens. 4. Try to remove it via admin interface, same thing. ### Expected behaviour Organization removed. ### Actual behaviour Organization not removed. ### Troubleshooting data Related log entries in systemd journal: ``` vaultwarden[3206]: [][request][INFO] DELETE /api/organizations/fbeabd5b-3d65-4b29-9881-37ba2a15d270 postgres[3226]: [9-1] 1676417219.784 [3226] vaultwarden@vaultwarden ERROR: update or delete on table "organizations" violates foreign key constraint "groups_organizations_uuid_fkey" on table "groups" postgres[3226]: [9-2] 1676417219.784 [3226] vaultwarden@vaultwarden DETAIL: Key (uuid)=(fbeabd5b-3d65-4b29-9881-37ba2a15d270) is still referenced from table "groups". postgres[3226]: [9-3] 1676417219.784 [3226] vaultwarden@vaultwarden STATEMENT: DELETE FROM "organizations" WHERE ("organizations"."uuid" = $1) vaultwarden[3206]: [][error][ERROR] Error saving organization. vaultwarden[3206]: [CAUSE] DatabaseError( vaultwarden[3206]: ForeignKeyViolation, vaultwarden[3206]: "update or delete on table \"organizations\" violates foreign key constraint \"groups_organizations_uuid_fkey\" on table \"groups\"", vaultwarden[3206]: ) vaultwarden[3206]: [][response][INFO] (delete_organization) DELETE /api/organizations/<org_id> => 400 Bad Request ```
kerem 2026-03-03 02:09:47 +03:00
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Feb 15, 2023):

Please check: https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-%28MySQL%29-Backend#foreign-key-errors-collation-and-charset and see if that solves the issue.

<!-- gh-comment-id:1431609207 --> @BlackDex commented on GitHub (Feb 15, 2023): Please check: https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-%28MySQL%29-Backend#foreign-key-errors-collation-and-charset and see if that solves the issue.
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@phiekl commented on GitHub (Feb 15, 2023):

I'm using postgresql though, and as far as I can see collate and ctype is set to en_US.utf8.

<!-- gh-comment-id:1431809743 --> @phiekl commented on GitHub (Feb 15, 2023): I'm using postgresql though, and as far as I can see collate and ctype is set to en_US.utf8.
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Feb 15, 2023):

Ah, sorry overlooked that. Ill see if i can reproduce that.

<!-- gh-comment-id:1431822383 --> @BlackDex commented on GitHub (Feb 15, 2023): Ah, sorry overlooked that. Ill see if i can reproduce that.
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@Misterbabou commented on GitHub (Feb 16, 2023):

Hello,

I have exactly the same issue using MariaDB : 10.10.2

Impossible te delete organization with groups ( if I remove all group manually before deleting organization it works as expected)

Error message:

vaultwarden    | [2023-02-16 10:03:44.408][error][ERROR] Error saving organization.
vaultwarden    | [CAUSE] DatabaseError(
vaultwarden    |     ForeignKeyViolation,
vaultwarden    |     "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`groups`, CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`organizations_uuid`) REFERENCES `organizations` (`uuid`))",
vaultwarden    | )
<!-- gh-comment-id:1432821990 --> @Misterbabou commented on GitHub (Feb 16, 2023): Hello, I have exactly the same issue using MariaDB : 10.10.2 Impossible te delete organization with groups ( if I remove all group manually before deleting organization it works as expected) Error message: ``` vaultwarden | [2023-02-16 10:03:44.408][error][ERROR] Error saving organization. vaultwarden | [CAUSE] DatabaseError( vaultwarden | ForeignKeyViolation, vaultwarden | "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`groups`, CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`organizations_uuid`) REFERENCES `organizations` (`uuid`))", vaultwarden | ) ```
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Feb 16, 2023):

Looks like groups are not deleted during the organization delete function, that is what is causing the issue.
Thanks for reporting.

<!-- gh-comment-id:1432835053 --> @BlackDex commented on GitHub (Feb 16, 2023): Looks like groups are **not** deleted during the organization delete function, that is what is causing the issue. Thanks for reporting.
kerem commented 2026-03-03 02:09:49 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Feb 16, 2023):

PR Created which fixes this issue.

<!-- gh-comment-id:1433372335 --> @BlackDex commented on GitHub (Feb 16, 2023): PR Created which fixes this issue.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
revert-7033-patch-1
cached-config-operations
test_dylint
1.35.7
1.35.6
1.35.5
1.35.4
1.35.3
1.35.2
1.35.1
1.35.0
1.34.3
1.34.2
1.34.1
1.34.0
1.33.2
1.33.1
1.33.0
1.32.7
1.32.6
1.32.5
1.32.4
1.32.3
1.32.2
1.32.1
1.32.0
1.31.0
1.30.5
1.30.4
1.30.3
1.30.2
1.30.1
1.30.0
1.29.2
1.29.1
1.29.0
1.28.1
1.28.0
1.27.0
1.26.0
1.25.2
1.25.1
1.25.0
1.24.0
1.23.1
1.23.0
1.22.2
1.22.1
1.22.0
1.21.0
1.20.0
1.19.0
1.18.0
1.17.0
1.16.3
1.16.2
1.16.1
1.16.0
1.15.1
1.15.0
1.14.2
1.14.1
1.14
1.13.1
1.13.0
1.12.0
1.11.0
1.10.0
1.9.1
1.9.0
1.8.0
1.7.0
1.6.1
1.6.0
1.5.0
1.4.0
1.3.0
1.2.0
1.1.0
1.0.0
0.13.0
0.12.0
0.11.0
0.10.0
0.9.0
Labels
Clear labels   
SSO

   
Third party

   
better for forum

   
bug

   
bug

   
documentation

   
duplicate

   
enhancement

   
future Vault

   
future Vault

   
future Vault

   
good first issue

   
help wanted

   
low priority

   
notes

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
troubleshooting

   
wontfix
No labels
SSO
Third party
better for forum
bug
bug
documentation
duplicate
enhancement
future Vault
future Vault
future Vault
good first issue
help wanted
low priority
notes
pull-request
question
troubleshooting
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/vaultwarden#1512
No description provided.