starred/vaultwarden

Fork 0

mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-04-25 17:25:57 +03:00

[GH-ISSUE #4556] Can't delete Organization when organization_api_key is present #1920

New issue

Closed

opened 2026-03-03 02:13:23 +03:00 by kerem · 3 comments

kerem commented

2026-03-03 02:13:23 +03:00

Owner

Originally created by @Misterbabou on GitHub (May 15, 2024).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/4556

Subject of the issue

Can't delete Organization when organization_api_key is present

Deployment environment

Your environment (Generated via diagnostics page)

Vaultwarden version: v1.30.5
Web-vault version: v2024.1.2b
Install method: Docker
Clients used: web vault, and admin panel
Reverse proxy and version: /
MySQL/MariaDB or PostgreSQL version: 11.3.2-MariaDB
Other relevant details:

Steps to reproduce

Create an Organization on the web vault
Go to your new organization-> Settings -> Organization Info : ( https://<your_url>/#/organizations/<org_uuid>/settings/account )
Generate an api_key by cliking on "VIEW API KEY" (it will generate an entry in the Table : organization_api_key
(on the Web-vault) Try to Delete Organisation -> Error message (user is then disconnected and can't show organization but it's still show on admin panel

log:

vaultwarden   | [2024-05-15 12:45:44.310][request][INFO] DELETE /api/organizations/7a711a73-3cfc-45cd-a4b8-7d5dc5d944b3
vaultwarden    | [2024-05-15 12:45:44.646][error][ERROR] Error saving organization.
vaultwarden    | [CAUSE] DatabaseError(
vaultwarden    |     ForeignKeyViolation,
vaultwarden    |     "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`organization_api_key`, CONSTRAINT `organization_api_key_ibfk_1` FOREIGN KEY (`org_uuid`) REFERENCES `organizations` (`uuid`))",
vaultwarden    | )

(on the admin panel) Try to Delete Organisation ->

Error deleting organization
Error saving organization

log

vaultwarden   | [2024-05-15 12:34:40.819][request][INFO] POST /admin/organizations/0df42829-4957-41c3-8c5b-b50396ceeb81/delete
vaultwarden    | [2024-05-15 12:34:40.846][error][ERROR] Error saving organization.
vaultwarden    | [CAUSE] DatabaseError(
vaultwarden    |     ForeignKeyViolation,
vaultwarden    |     "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`organization_api_key`, CONSTRAINT `organization_api_key_ibfk_1` FOREIGN KEY (`org_uuid`) REFERENCES `organizations` (`uuid`))",
vaultwarden    | )

Expected behaviour

Organization should be deleted

Actual behaviour

All entries linked to organization are deleted as usual but the organization_api_key is not that's why it can't be deleted.

To manually resolve this issue on Mariadb :

DELETE FROM organization_api_key where organization_api_key.org_uuid="<org_uuid>"

Then Organization Delete is possible

Originally created by @Misterbabou on GitHub (May 15, 2024). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/4556 ### Subject of the issue Can't delete Organization when organization_api_key is present ### Deployment environment ### Your environment (Generated via diagnostics page) * Vaultwarden version: v1.30.5 * Web-vault version: v2024.1.2b * Install method: Docker * Clients used: web vault, and admin panel * Reverse proxy and version: / * MySQL/MariaDB or PostgreSQL version: 11.3.2-MariaDB * Other relevant details: ### Steps to reproduce - Create an Organization on the web vault - Go to your new organization-> Settings -> Organization Info : ( https://<your_url>/#/organizations/<org_uuid>/settings/account ) - Generate an api_key by cliking on "VIEW API KEY" (it will generate an entry in the Table : organization_api_key - (on the Web-vault) Try to Delete Organisation -> Error message (user is then disconnected and can't show organization but it's still show on admin panel ![image](https://github.com/dani-garcia/vaultwarden/assets/58564168/2e7608e5-5a14-418c-a642-a8b9cdb3f279) log: ``` vaultwarden | [2024-05-15 12:45:44.310][request][INFO] DELETE /api/organizations/7a711a73-3cfc-45cd-a4b8-7d5dc5d944b3 vaultwarden | [2024-05-15 12:45:44.646][error][ERROR] Error saving organization. vaultwarden | [CAUSE] DatabaseError( vaultwarden | ForeignKeyViolation, vaultwarden | "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`organization_api_key`, CONSTRAINT `organization_api_key_ibfk_1` FOREIGN KEY (`org_uuid`) REFERENCES `organizations` (`uuid`))", vaultwarden | ) ``` OR - (on the admin panel) Try to Delete Organisation -> ``` Error deleting organization Error saving organization ``` log ``` vaultwarden | [2024-05-15 12:34:40.819][request][INFO] POST /admin/organizations/0df42829-4957-41c3-8c5b-b50396ceeb81/delete vaultwarden | [2024-05-15 12:34:40.846][error][ERROR] Error saving organization. vaultwarden | [CAUSE] DatabaseError( vaultwarden | ForeignKeyViolation, vaultwarden | "Cannot delete or update a parent row: a foreign key constraint fails (`vaultwarden`.`organization_api_key`, CONSTRAINT `organization_api_key_ibfk_1` FOREIGN KEY (`org_uuid`) REFERENCES `organizations` (`uuid`))", vaultwarden | ) ``` ### Expected behaviour Organization should be deleted ### Actual behaviour All entries linked to organization are deleted as usual but the organization_api_key is not that's why it can't be deleted. To manually resolve this issue on Mariadb : ``` DELETE FROM organization_api_key where organization_api_key.org_uuid="<org_uuid>" ``` Then Organization Delete is possible

kerem

2026-03-03 02:13:23 +03:00

closed this issue
added the
bug
label

kerem commented

2026-03-03 02:13:24 +03:00

Author

Owner

@stefan0xC commented on GitHub (May 15, 2024):

Thanks. This is probably also the cause for #4540.

@stefan0xC commented on GitHub (May 15, 2024): Thanks. This is probably also the cause for #4540.

kerem commented

2026-03-03 02:13:24 +03:00

Author

Owner

@Misterbabou commented on GitHub (May 15, 2024):

Thanks for your fix ^^.

I have a question regarding events from table event on organization delete.

For now events linked to the organization are not delete on organization delete.
Will it be better to also clean events linked to this organization ?

Equivalent to :

DELETE FROM event where event.org_uuid="<org_uuid>"

@Misterbabou commented on GitHub (May 15, 2024): Thanks for your fix ^^. I have a question regarding events from table event on organization delete. For now events linked to the organization are not delete on organization delete. Will it be better to also clean events linked to this organization ? Equivalent to : ``` DELETE FROM event where event.org_uuid="<org_uuid>" ```

kerem commented

2026-03-03 02:13:24 +03:00

Author

Owner

@BlackDex commented on GitHub (May 15, 2024):

I would rather not delete events during the deletion of an organizations.
The main reason is that it could hold useful information on who deleted the organization for example, and if there were some unwanted actions done.

Logs will be delete automatically if the cleanup job is enabled.

@BlackDex commented on GitHub (May 15, 2024): I would rather not delete events during the deletion of an organizations. The main reason is that it could hold useful information on who deleted the organization for example, and if there were some unwanted actions done. Logs will be delete automatically if the cleanup job is enabled.

kerem referenced this issue

2026-03-03 09:25:15 +03:00

[PR #1922] [MERGED] Fix error with adding file attachment from org vault view #3019