# Error deleting user **URL:** \ **Category:** Help\ **Created:** [July 31, 2023, 9:38pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831 "2023-07-31T21:38:43Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [July 31, 2023, 9:38pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/1 "2023-07-31T21:38:43Z")
Hi there, I recently wanted to delete an account who forgot her password. Normally this is straight forward through the admin page. But now after typing the email for confirmation it shows “error deleting user”. I can create a new different user and delete it without problem. Only that specific user is somewhat stuck. There is nothing special about that user. Already restarted the docker container. Still “error deleting user”. Any other way to delete a user? Thanks for your help. ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [July 31, 2023, 9:50pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/2 "2023-07-31T21:50:51Z")
What is the specific error? ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [July 31, 2023, 10:13pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/3 "2023-07-31T22:13:46Z")
Quite unspecific. It says “Error deleting user” “Error deleting user” ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [August 1, 2023, 4:33am UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/4 "2023-08-01T04:33:38Z")
Any logs from Vaultwarden? Our something else with a bit more information? ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [August 1, 2023, 9:59am UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/5 "2023-08-01T09:59:23Z")
Ah, thanks for the hint. Should be the first move to look into the log. This is always logged upon trying to delete that specific user: [2023-07-31 23:04:33.949][request][INFO] GET /admin/users/overview [2023-07-31 23:04:33.952][response][INFO] (users\_overview) GET /admin/users/overview =\> 200 OK [2023-07-31 23:04:58.949][request][INFO] POST /admin/users/b3883308-1cb5-4854-841a-cbefe993d4f5/delete [2023-07-31 23:04:58.950][error][ERROR] Error deleting user. [CAUSE] DatabaseError( ForeignKeyViolation, “FOREIGN KEY constraint failed”, ) [2023-07-31 23:04:58.950][response][INFO] (delete\_user) POST /admin/users//delete =\> 400 Bad Request ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [August 2, 2023, 4:43pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/6 "2023-08-02T16:43:25Z")
Looks like the user was partially deleted somehow. Verify that you are using the latest version. And also check this [Using the MariaDB (MySQL) Backend · dani-garcia/vaultwarden Wiki · GitHub](https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-%28MySQL%29-Backend#foreign-key-errors-collation-and-charset) If there are any issues with the collation or charset that could cause issues. ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [August 2, 2023, 9:18pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/7 "2023-08-02T21:18:00Z")
Yes, I am using the latest Version 1.29.1. Also I am using SQLite. Do the mentioned collation/charset issues also apply to SQLite databases? And do you think the user can be deleted manually off the db? Or do you suggest switching to a mysql db? Could be a little overkill for our small installation. What I remember is that the user was a member of a organisation when I tried to delete him. Instead the user was only kicked out of that organisation… and got stuck. Maybe that helps. ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [August 2, 2023, 9:35pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/8 "2023-08-02T21:35:54Z")
Then i suggest to check and verify the integrity of the sqlite file. - [Pragma statements supported by SQLite](https://www.sqlite.org/pragma.html#pragma_foreign_key_check) - [Pragma statements supported by SQLite](https://www.sqlite.org/pragma.html#pragma_integrity_check) - [Pragma statements supported by SQLite](https://www.sqlite.org/pragma.html#pragma_optimize) Always create a backup before executing commands like this ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [August 23, 2023, 1:10pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/9 "2023-08-23T13:10:58Z")
This is what came out: sqlite\> PRAGMA foreign\_key\_check; sqlite\> PRAGMA integrity\_check; row 41 missing from index sqlite\_autoindex\_devices\_1 row 42 missing from index sqlite\_autoindex\_devices\_1 row 43 missing from index sqlite\_autoindex\_devices\_1 row 44 missing from index sqlite\_autoindex\_devices\_1 row 45 missing from index sqlite\_autoindex\_devices\_1 wrong # of entries in index sqlite\_autoindex\_devices\_1 And additionally I tried: sqlite3 db.sqlite3 .dump | sqlite3 db.sqlite3.fix Error: near line 1531: UNIQUE constraint failed: devices.uuid, devices.user\_uuid Also tried exporting to sql and reimporting but gave me an error similar to the dump while reimporting. Any suggestion on how to fix this? ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [September 15, 2023, 7:22pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/10 "2023-09-15T19:22:28Z")
Help is still very appreciated… ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 18, 2023, 3:41pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/11 "2023-11-18T15:41:19Z")
And now another user cannot be deleted. Message: Error deleting user Error removing devices for user Interestingly the entries of that user seem to be deleted (5 before deletion attempt, 0 after). Only the user still exists… Thanks for any help. ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 18, 2023, 3:48pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/12 "2023-11-18T15:48:53Z")
Corresponding log entries: vaultwarden | [2023-11-18 16:32:32.572][response][INFO] (disable\_user) POST /admin/users//disable =\> 400 Bad Request vaultwarden | [2023-11-18 16:33:02.552][request][INFO] GET /admin/users/overview vaultwarden | [2023-11-18 16:33:02.560][response][INFO] (users\_overview) GET /admin/users/overview =\> 200 OK vaultwarden | [2023-11-18 16:33:24.194][request][INFO] POST /admin/users/a13899a0-16bb-415a-88d4-xxxxx0b492db/delete vaultwarden | [2023-11-18 16:33:24.199][error][ERROR] Error removing devices for user. vaultwarden | [CAUSE] DatabaseError( vaultwarden | Unknown, vaultwarden | “database disk image is malformed”, vaultwarden | ) vaultwarden | [2023-11-18 16:33:24.199][response][INFO] (delete\_user) POST /admin/users//delete =\> 400 Bad Request vaultwarden | [2023-11-18 16:33:40.206][request][INFO] GET /admin/users/overview vaultwarden | [2023-11-18 16:33:40.211][response][INFO] (users\_overview) GET /admin/users/overview =\> 200 OK vaultwarden | [2023-11-18 16:33:52.793][request][INFO] GET /admin/users/overview vaultwarden | [2023-11-18 16:33:52.798][response][INFO] (users\_overview) GET /admin/users/overview =\> 200 OK vaultwarden | [2023-11-18 16:37:32.939][request][INFO] POST /admin/users/b3883308-1cb5-4854-841a-xxxxx993d4f5/delete vaultwarden | [2023-11-18 16:37:32.943][error][ERROR] Error deleting user. vaultwarden | [CAUSE] DatabaseError( vaultwarden | ForeignKeyViolation, vaultwarden | “FOREIGN KEY constraint failed”, vaultwarden | ) ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 18, 2023, 3:51pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/13 "2023-11-18T15:51:52Z")
This looks for me like a serious ongoing database problem… right?! So all I can do is export all the entries of all users manually and import them to a new vaultwarden instance. Right?! ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [November 18, 2023, 8:45pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/14 "2023-11-18T20:45:27Z")
I would suggest to read [Using the MariaDB (MySQL) Backend · dani-garcia/vaultwarden Wiki · GitHub](https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-%28MySQL%29-Backend#foreign-key-errors-collation-and-charset) ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 18, 2023, 11:11pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/15 "2023-11-18T23:11:45Z")
Thanks for that link. That is what you already suggested in August … Sorry, but what are you actually trying to say? You think that switching from sqlite to mysql/mariadb could solve these issues? ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [November 19, 2023, 8:43am UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/16 "2023-11-19T08:43:06Z")
Sorry was a bit late and didn’t saw correctly you were using sqlite. You could try to vacume/dumb the database and see if you can use that. ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 19, 2023, 4:18pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/17 "2023-11-19T16:18:59Z")
I dumped the sqlite db as shown in the Wiki with no errors. When trying to import the dump file into an empty mariadb database (docker-compose as in the Wiki) it gives me this error ERROR 1062 (23000) at line 1354: Duplicate entry ‘7f59903c-4f09-44c2-8f81-d7634ca23e62-00e76681-7f66-40a7-a565-…’ for key ‘PRIMARY’ Can duplicate entries be the reason for my actual problems with deleting users? Sorry, I am not so much into databases. How can I find and delete this duplicate entry? Possibly already while/before dumping the sqlite db…?! ---
**Author:** ![BlackDex](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/blackdex/32/8_2.png) [@BlackDex](https://vaultwarden.discourse.group/u/BlackDex)\ **Post date:** [November 19, 2023, 4:32pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/18 "2023-11-19T16:32:14Z")
I actually ment to dump as a backup and use that backup instead of the possible broken/corrupted database ---
**Author:** ![iljur](https://avatars.discourse-cdn.com/v4/letter/i/838e76/32.png) [@iljur](https://vaultwarden.discourse.group/u/iljur)\ **Post date:** [November 19, 2023, 5:52pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/19 "2023-11-19T17:52:20Z")
Yes, there is an automated dump of the sqlite db every night for backup which is than backed up. But I missed the moment the db got corrupted because it is/was still possible to add/delete entries. Only user management is corrupted so far. So I could have restored a backup when the corruption first appeared but nit knowing which and how many entries I would loose… So I decided to go on with the corrupted db. Already tried dumping and restoring the than latest version of the sqlite db. See my former posts… ---
**Author:** ![ShadowPulse](https://yyz2.discourse-cdn.com/free1/user_avatar/vaultwarden.discourse.group/shadowpulse/32/1237_2.png) [@ShadowPulse](https://vaultwarden.discourse.group/u/ShadowPulse)\ **Post date:** [December 1, 2023, 1:37pm UTC](https://vaultwarden.discourse.group/t/error-deleting-user/2831/20 "2023-12-01T13:37:41Z")
Thanks for the link. We just faced a similar issue with partial user deleting, and your link was pretty helpful.