Migrations cause Postgres warnings because SET CONSTRAINTS can only be used in transaction blocks #1424

New Issue

MrUnknownDE · 2026-04-06T01:53:06+02:00

MrUnknownDE commented

2026-04-06 01:53:06 +02:00

Originally created by @spantaleev on 9/28/2023

Each time Vaultwarden starts, it runs its migrations and those trigger a Postgres warning (logged in the Postgres logs):

WARNING: SET CONSTRAINTS can only be used in transaction blocks

Deployment environment

vaultwarden version: 1.29.2

Install method: Docker image
Clients used: irrelevant
Reverse proxy and version: irrelevant
MySQL/MariaDB or PostgreSQL version: PostgreSQL v16
Other relevant details:

I've found this code to be related: bc26bfa589/src/db/mod.rs (L493)

It doesn't seem like Vaultwarden is affected negatively by this, but it's probably something that should be looked into anyway.

Steps to reproduce

Restart Vaultwarden. On startup, it will run its migrations code and trigger this warning (found in the Postgres logs).

*Originally created by @spantaleev on 9/28/2023* Each time Vaultwarden starts, it runs its migrations and those trigger a Postgres warning (logged in the Postgres logs): > WARNING: SET CONSTRAINTS can only be used in transaction blocks ### Deployment environment     * vaultwarden version: 1.29.2  * Install method: Docker image * Clients used: irrelevant * Reverse proxy and version: irrelevant * MySQL/MariaDB or PostgreSQL version: PostgreSQL v16 * Other relevant details: I've found this code to be related: https://github.com/dani-garcia/vaultwarden/blob/bc26bfa589c007da9b9be37e1172060f38a948b9/src/db/mod.rs#L493 It doesn't seem like Vaultwarden is affected negatively by this, but it's probably something that should be looked into anyway. ### Steps to reproduce Restart Vaultwarden. On startup, it will run its migrations code and trigger this warning (found in the Postgres logs).

MrUnknownDE closed this issue

2026-04-06 01:53:06 +02:00

MrUnknownDE referenced this issue

2026-04-06 02:10:57 +02:00

WebSockets via Rocket's Upgrade connection #1666

Sign in to join this conversation.

No Label enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement enhancement low priority low priority low priority low priority low priority low priority low priority low priority low priority low priority low priority low priority low priority

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#1424