Unable to confirm email addresses on new install #751

New Issue

Closed

opened 2026-02-04 22:26:03 +03:00 by OVERLORD · 5 comments

OVERLORD commented 2026-02-04 22:26:03 +03:00

Owner

Copy Link

Originally created by @ChrisWiegman on GitHub (Jul 22, 2020).

Subject of the issue

On a new setup, I am unable to configure any email addresses. The log displays the following:

bitwarden_1    | [CAUSE] DatabaseError(
bitwarden_1    |     ForeignKeyViolation,
bitwarden_1    |     "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden`.`devices`, CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`))",
bitwarden_1    | )

Your environment

• Bitwarden_rs version: 1.16.0

• Install method: Docker
• Clients used:
• Reverse proxy and version: Traefik 2.2
• Version of mysql/postgresql: MariaDB 10.5.4
• Other relevant information:

Steps to reproduce

1. Bring up Bitwarden
2. Register a new user
3. Click email verification link
4. See "Verify your email address" still visible in account

Expected behaviour

Clicking the verification link should verify the email address

Actual behaviour

Email address is not verified

Relevant logs

bitwarden_1    | [2020-07-21 22:50:18][bitwarden_rs::api::core::accounts][ERROR] Error saving email verification: Error saving user.
bitwarden_1    | [CAUSE] DatabaseError(
bitwarden_1    |     ForeignKeyViolation,
bitwarden_1    |     "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden`.`devices`, CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`))",
bitwarden_1    | )
bitwarden_1    | [2020-07-21 22:50:18][response][INFO] POST /api/accounts/verify-email-token (post_verify_email_token) => 200 OK```

Originally created by @ChrisWiegman on GitHub (Jul 22, 2020). <!-- Please fill out the following template to make solving your problem easier and faster for us. This is only a guideline. If you think that parts are unneccessary for your issue, feel free to remove them. Remember to hide/obfuscate personal and confidential information, such as names, global IP/DNS adresses and especially passwords, if neccessary. --> ### Subject of the issue On a new setup, I am unable to configure any email addresses. The log displays the following: ```bitwarden_1 | [2020-07-21 22:41:52][bitwarden_rs::api::core::accounts][ERROR] Error saving email verification: Error saving user. bitwarden_1 | [CAUSE] DatabaseError( bitwarden_1 | ForeignKeyViolation, bitwarden_1 | "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden`.`devices`, CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`))", bitwarden_1 | ) ``` ### Your environment <!-- The version number, obtained from the logs or the admin page --> * Bitwarden_rs version: 1.16.0 <!-- How the server was installed: Docker image / package / built from source --> * Install method: Docker * Clients used: <!-- if applicable --> * Reverse proxy and version: Traefik 2.2 * Version of mysql/postgresql: MariaDB 10.5.4 * Other relevant information: ### Steps to reproduce 1. Bring up Bitwarden 2. Register a new user 3. Click email verification link 4. See "Verify your email address" still visible in account ### Expected behaviour Clicking the verification link should verify the email address ### Actual behaviour Email address is not verified ### Relevant logs <!-- Share some logfiles, screenshots or output of relevant programs with us. --> ```bitwarden_1 | [2020-07-21 22:50:18][request][INFO] POST /api/accounts/verify-email-token bitwarden_1 | [2020-07-21 22:50:18][bitwarden_rs::api::core::accounts][ERROR] Error saving email verification: Error saving user. bitwarden_1 | [CAUSE] DatabaseError( bitwarden_1 | ForeignKeyViolation, bitwarden_1 | "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden`.`devices`, CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`user_uuid`) REFERENCES `users` (`uuid`))", bitwarden_1 | ) bitwarden_1 | [2020-07-21 22:50:18][response][INFO] POST /api/accounts/verify-email-token (post_verify_email_token) => 200 OK```

OVERLORD closed this issue 2026-02-04 22:26:04 +03:00

OVERLORD commented 2026-02-04 22:26:10 +03:00

Author

Owner

Copy Link

@skywiley commented on GitHub (Aug 8, 2020):

I am running into this same issue using almost exactly the same setup.

I switched from MariaDB 10.5.4 to MySQL 5.7 (mysql:5.7 docker image) and everything worked as intended. Although personally would like to stick with MariaDB.

If I had to guess, maybe related to #1081?

@skywiley commented on GitHub (Aug 8, 2020): I am running into this same issue using almost exactly the same setup. I switched from MariaDB 10.5.4 to MySQL 5.7 (mysql:5.7 docker image) and everything worked as intended. Although personally would like to stick with MariaDB. If I had to guess, maybe related to #1081?

OVERLORD commented 2026-02-04 22:26:13 +03:00

Author

Owner

Copy Link

@jobec commented on GitHub (Aug 9, 2020):

I had the same issue.
You can stick with MariaDB, just set the database image to mariadb:10.3
It seems that's the version compatible with MySQL 5.7.

@jobec commented on GitHub (Aug 9, 2020): I had the same issue. You can stick with MariaDB, just set the database image to `mariadb:10.3` It seems that's the version compatible with MySQL 5.7.

OVERLORD commented 2026-02-04 22:26:16 +03:00

Author

Owner

Copy Link

@ChrisWiegman commented on GitHub (Aug 11, 2020):

I'm afraid downgrading to an older version of the DB is not a solution in this instance. Hopefully it can be fixed with current versions of MariaDB

@ChrisWiegman commented on GitHub (Aug 11, 2020): I'm afraid downgrading to an older version of the DB is not a solution in this instance. Hopefully it can be fixed with current versions of MariaDB

OVERLORD commented 2026-02-04 22:26:19 +03:00

Author

Owner

Copy Link

@smerschjohann commented on GitHub (Aug 26, 2020):

The current workaround for me is to disable the constraint checks.

@smerschjohann commented on GitHub (Aug 26, 2020): The current workaround for me is to disable the constraint checks.

OVERLORD commented 2026-02-04 22:26:21 +03:00

Author

Owner

Copy Link

@peterneutron commented on GitHub (Sep 20, 2020):

Same issue when adding an attachment,

Sep 20 20:26:08 s01 bitwarden_rs[166828]: [CAUSE] DatabaseError(
Sep 20 20:26:08 s01 bitwarden_rs[166828]:     ForeignKeyViolation,
Sep 20 20:26:08 s01 bitwarden_rs[166828]:     "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden_rs`.`attachments`, CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciph>
Sep 20 20:26:08 s01 bitwarden_rs[166828]: )
Sep 20 20:26:08 s01 bitwarden_rs[166828]: [2020-09-20 20:26:08.470][response][INFO] PUT /api/ciphers/<uuid> (put_cipher) => 400 Bad Request```

@peterneutron commented on GitHub (Sep 20, 2020): Same issue when adding an attachment, ```Sep 20 20:26:08 s01 bitwarden_rs[166828]: [2020-09-20 20:26:08.469][error][ERROR] Error saving cipher. Sep 20 20:26:08 s01 bitwarden_rs[166828]: [CAUSE] DatabaseError( Sep 20 20:26:08 s01 bitwarden_rs[166828]: ForeignKeyViolation, Sep 20 20:26:08 s01 bitwarden_rs[166828]: "Cannot delete or update a parent row: a foreign key constraint fails (`bitwarden_rs`.`attachments`, CONSTRAINT `attachments_ibfk_1` FOREIGN KEY (`cipher_uuid`) REFERENCES `ciph> Sep 20 20:26:08 s01 bitwarden_rs[166828]: ) Sep 20 20:26:08 s01 bitwarden_rs[166828]: [2020-09-20 20:26:08.470][response][INFO] PUT /api/ciphers/<uuid> (put_cipher) => 400 Bad Request```

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

main

cached-config-operations

test_dylint

1.35.2

1.35.1

1.35.0

1.34.3

1.34.2

1.34.1

1.34.0

1.33.2

1.33.1

1.33.0

1.32.7

1.32.6

1.32.5

1.32.4

1.32.3

1.32.2

1.32.1

1.32.0

1.31.0

1.30.5

1.30.4

1.30.3

1.30.2

1.30.1

1.30.0

1.29.2

1.29.1

1.29.0

1.28.1

1.28.0

1.27.0

1.26.0

1.25.2

1.25.1

1.25.0

1.24.0

1.23.1

1.23.0

1.22.2

1.22.1

1.22.0

1.21.0

1.20.0

1.19.0

1.18.0

1.17.0

1.16.3

1.16.2

1.16.1

1.16.0

1.15.1

1.15.0

1.14.2

1.14.1

1.14

1.13.1

1.13.0

1.12.0

1.11.0

1.10.0

1.9.1

1.9.0

1.8.0

1.7.0

1.6.1

1.6.0

1.5.0

1.4.0

1.3.0

1.2.0

1.1.0

1.0.0

0.13.0

0.12.0

0.11.0

0.10.0

0.9.0

Labels

Clear labels

SSO

Third party

better for forum

bug

bug

documentation

duplicate

enhancement

future Vault

future Vault

future Vault

good first issue

help wanted

low priority

notes

pull-request

Mirrored from GitHub Pull Request

question

troubleshooting

wontfix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

OVERLORD

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/vaultwarden#751