Cannot delete user from admin panel - foreign key constraint

[FluffyDiscord]

Prerequisites

• I have searched the existing Closed AND Open Issues AND Discussions
• I have searched and read the documentation

Vaultwarden Support String

2026-03-31 09:10:43.787][error][ERROR] Error deleting user.
[CAUSE] DatabaseError(
ForeignKeyViolation,
"FOREIGN KEY constraint failed",
)

Vaultwarden Build Version

1.35.4

Deployment method

Official Container Image

Custom deployment method

No response

Reverse Proxy

nginx/1.26.3

Host/Server Operating System

Linux

Operating System Version

Debian 13 Trixie

Clients

Web Vault

Client Version

No response

Steps To Reproduce

1. Go to '/admin/users/overview'
2. Click on 'Delete User'
3. See js dialog error
4. See error in log

Expected Result

Work

Actual Result

Not work :D

Logs

[2026-03-31 09:10:43.787][error][ERROR] Error deleting user.
[CAUSE] DatabaseError(
    ForeignKeyViolation,
    "FOREIGN KEY constraint failed",
)

Screenshots or Videos

No response

Additional Context

No response

[BlackDex]

This mostly indicates that either something is wrong with the database, or you manually modified the database your self trying to delete a user or related records or other cleanups.

[BlackDex]

If you are be able to set the following as LOG_LEVEL debug,vaultwarden::db::query_logger=debug and restart Vaultwarden.
That should provide very detailed logs of the queries which are done, and might provide some more details for us where it fails.

Since it is very verbose and also contains possible privacy related contents, i would suggest to not upload it here, but either send it by mail, or via a Private Message via Matrix.

Contact me via Matrix https://matrix.to/#/#vaultwarden:matrix.org @blackdex:matrix.org, this is preferred.

Or via email, send an

[FluffyDiscord]

I was ready to send you the log, but after I restarted vaultwarden docker compose to load the new log level, suddenly I could remove that user.

[BlackDex]

That is strange.

What kind of storage are you using? Is it a shared filesystem like Samba or NFS?
If so, then SQLite might have issues.

[FluffyDiscord]

Its on VPS provided by Hetzner. We have dedicated cpu cores, but the drive is probably being shared with other VPSes (we just have a chunk of it). I have no clue if they are network mounted, or at least I dont see any indicator of that in os/system. Do you suggest to use postgres instead then?

[BlackDex]

If the OS sees it as a normal disk, and it's not a shared storage which doesn't properly support file locking, then it should be fine.
It is weird though. The only thing i can think of is that some parts of the sqlite file were not fully written/synced for some reason and that caused the issue.

If it happens again, let us known.