I failed to login on all clients(web, Android, ios and etc). I'm running version 2.25.1 of Vaultwarden/server in docker, using postgresql14. I accidentally restarted postgresql and then can't log into my account. The log is as follows.
vaultwarden | [2022-05-24 06:48:37.570][error][ERROR] Error saving device.
vaultwarden | [CAUSE] DatabaseError(
vaultwarden | __Unknown,
vaultwarden | "there is no unique or exclusion constraint matching the ON CONFLICT specification",
vaultwarden | )
The devices table in postgresql has been emptied, but such an error still occurs. How to fix or how to migrate data to other database types like SQLite or MySQL?
Originally created by @jz8132543 on GitHub (May 24, 2022).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/2487
I failed to login on all clients(web, Android, ios and etc). I'm running version 2.25.1 of Vaultwarden/server in docker, using postgresql14. I accidentally restarted postgresql and then can't log into my account. The log is as follows.
```
vaultwarden | [2022-05-24 06:48:37.570][error][ERROR] Error saving device.
vaultwarden | [CAUSE] DatabaseError(
vaultwarden | __Unknown,
vaultwarden | "there is no unique or exclusion constraint matching the ON CONFLICT specification",
vaultwarden | )
```
The devices table in postgresql has been emptied, but such an error still occurs. How to fix or how to migrate data to other database types like SQLite or MySQL?
Could you post the generated support string please. That would be really helpful.
<!-- gh-comment-id:1135504811 -->
@BlackDex commented on GitHub (May 24, 2022):
Could you post the generated support string please. That would be really helpful.
Also, if you still see v2.25.1 as your web-vault version, you are not on the latest version.
I would make sure you are using the latest version. Since it seems to work for me just fine using Postgresql.
So, posting the Support String would be helpful.
<!-- gh-comment-id:1135537426 -->
@BlackDex commented on GitHub (May 24, 2022):
Also, if you still see v2.25.1 as your web-vault version, you are not on the latest version.
I would make sure you are using the latest version. Since it seems to work for me just fine using Postgresql.
So, posting the Support String would be helpful.
Thanks for your reply! It works after I update my docker container. It is a weird issue but I'm so glad it was solved after update.
<!-- gh-comment-id:1139346088 -->
@jz8132543 commented on GitHub (May 27, 2022):
Thanks for your reply! It works after I update my docker container. It is a weird issue but I'm so glad it was solved after update.
@Bluscream that looks more like a PostgreSQL issue that it isn't able to store data. Check the storage or logs of the database.
<!-- gh-comment-id:2024448296 -->
@BlackDex commented on GitHub (Mar 28, 2024):
@Bluscream that looks more like a PostgreSQL issue that it isn't able to store data. Check the storage or logs of the database.
<!-- gh-comment-id:2024515208 -->
@Bluscream commented on GitHub (Mar 28, 2024):
> @Bluscream that looks more like a PostgreSQL issue that it isn't able to store data. Check the storage or logs of the database.
i am using the rpi portainer install with no special database (https://github.com/pi-hosted/pi-hosted/blob/master/template/apps/vaultwarden.json)
disk space seems not critical to me:
container stats also look fine to me
Still remains a database storage issue.
I suggest to open a topic in the Q&A discussion and post your support string which you can generate via the admin diagnostics page.
<!-- gh-comment-id:2024546645 -->
@BlackDex commented on GitHub (Mar 28, 2024):
Then your issues is misplaced in this topic.
1. It was closed already for a long time.
2. You are using a totally different setup.
Still remains a database storage issue.
I suggest to open a topic in the Q&A discussion and post your support string which you can generate via the admin diagnostics page.
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Originally created by @jz8132543 on GitHub (May 24, 2022).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/2487
I failed to login on all clients(web, Android, ios and etc). I'm running version 2.25.1 of Vaultwarden/server in docker, using postgresql14. I accidentally restarted postgresql and then can't log into my account. The log is as follows.
The devices table in postgresql has been emptied, but such an error still occurs. How to fix or how to migrate data to other database types like SQLite or MySQL?
@BlackDex commented on GitHub (May 24, 2022):
Could you post the generated support string please. That would be really helpful.
@BlackDex commented on GitHub (May 24, 2022):
Also, if you still see v2.25.1 as your web-vault version, you are not on the latest version.
I would make sure you are using the latest version. Since it seems to work for me just fine using Postgresql.
So, posting the Support String would be helpful.
@jz8132543 commented on GitHub (May 27, 2022):
Thanks for your reply! It works after I update my docker container. It is a weird issue but I'm so glad it was solved after update.
@Bluscream commented on GitHub (Mar 28, 2024):
I have a similar error:
@BlackDex commented on GitHub (Mar 28, 2024):
@Bluscream that looks more like a PostgreSQL issue that it isn't able to store data. Check the storage or logs of the database.
@Bluscream commented on GitHub (Mar 28, 2024):
i am using the rpi portainer install with no special database (https://github.com/pi-hosted/pi-hosted/blob/master/template/apps/vaultwarden.json)
disk space seems not critical to me:
container stats also look fine to me
@BlackDex commented on GitHub (Mar 28, 2024):
Then your issues is misplaced in this topic.
Still remains a database storage issue.
I suggest to open a topic in the Q&A discussion and post your support string which you can generate via the admin diagnostics page.