Foreign key constraint violation upon deleting organization with group #1744

New Issue

MrUnknownDE · 2026-04-06T02:19:42+02:00

MrUnknownDE commented

2026-04-06 02:19:42 +02:00

Originally created by @phiekl on 2/15/2023

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

Create a new organization.
Create a group within the new organization.
Try to remove the organization. Nothing happens.
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 2/15/2023* ### 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 ```

MrUnknownDE closed this issue

2026-04-06 02:19:42 +02:00

Sign in to join this conversation.

No Label bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug good first issue good first issue good first issue good first issue good first issue

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#1744