ForeignKeyViolation error when deleting a user

[TheWiresharkGuy]

Hello,

I'm using your latest docker image ghcr.io/timshel/vaultwarden:1.30.5-2 with a postgres:16 database

When I try to delete a user through the web admin interface, I get the following error :

[2024-03-13 10:51:45.208][request][INFO] POST /admin/users/a1458cfc-b646-41bd-aeaf-1ed5c5a07713/delete
[2024-03-13 10:51:45.225][error][ERROR] Error deleting user.
[CAUSE] DatabaseError(
    ForeignKeyViolation,
    "update or delete on table \"users\" violates foreign key constraint \"sso_users_user_uuid_fkey\" on table \"sso_users\"",
)

If I manually delete the user in the newly added table sso_users with a pgsql command, I can then delete the user in the admin interface

[Timshel]

O crap, forgot to add the CASCADE :(.
Thx for the report :).

[Timshel]

Fix should be in 1.30.5-3 and ready in ~1h.

[Timshel]

Hey did it fix the issue ? :)