starred/vaultwarden
1
0
Fork 0
mirror of https://github.com/dani-garcia/vaultwarden.git synced 2026-04-26 01:35:54 +03:00
Code Issues 39 Projects Releases 5 Packages Wiki Activity

[GH-ISSUE #1645] NOT NULL constraint failed: new_ciphers.name #1021

New issue
Closed
opened 2026-03-03 02:05:36 +03:00 by kerem · 4 comments
kerem commented 2026-03-03 02:05:36 +03:00
Owner
Copy link

Originally created by @luckydonald on GitHub (Apr 30, 2021).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1645

bitwarden                  | /--------------------------------------------------------------------\
bitwarden                  | |                        Starting Vaultwarden                        |
bitwarden                  | |                           Version 1.21.0                           |
bitwarden                  | |--------------------------------------------------------------------|
bitwarden                  | | This is an *unofficial* Bitwarden implementation, DO NOT use the   |
bitwarden                  | | official channels to report bugs/features, regardless of client.   |
bitwarden                  | | Send usage/configuration questions or feature requests to:         |
bitwarden                  | |   https://bitwardenrs.discourse.group/                             |
bitwarden                  | | Report suspected bugs/issues in the software itself at:            |
bitwarden                  | |   https://github.com/dani-garcia/vaultwarden/issues/new            |
bitwarden                  | \--------------------------------------------------------------------/
bitwarden                  | 
bitwarden                  | [INFO] No .env file found.
bitwarden                  | 
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:04:55.699][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:04:56.720][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:04:57.735][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:04:58.757][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:04:59.776][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:00.791][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:01.807][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:02.824][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:03.842][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:04.859][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:05.882][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:06.907][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:07.922][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:08.936][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )
bitwarden                  | Running migration 20200802025025
bitwarden                  | Executing migration script 20200802025025/up.sql
bitwarden                  | [2021-04-30 13:05:09.949][vaultwarden][ERROR] Error creating database pool: DieselMigError.
bitwarden                  | [CAUSE] QueryError(
bitwarden                  |     DatabaseError(
bitwarden                  |         __Unknown,
bitwarden                  |         "NOT NULL constraint failed: new_ciphers.name",
bitwarden                  |     ),
bitwarden                  | )

Subject of the issue

Update from
image: bitwardenrs/server:1.16.1-alpine
to
image: vaultwarden/server:1.21.1-alpine

Deployment environment

  • vaultwarden version:
    image: bitwardenrs/server:1.16.1-alpine
    to
    image: vaultwarden/server:1.21.1-alpine

  • Install method:
    docker

  • Clients used:
    web, desktop (win + Mac), iOS

  • Reverse proxy and version:
    nginx

  • MySQL/MariaDB or PostgreSQL version:
    sqlite.

  • Other relevant details:

Steps to reproduce

Update.

Expected behaviour

Works.

Actual behaviour

Doesn't work.

Troubleshooting data

Originally created by @luckydonald on GitHub (Apr 30, 2021). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/1645 <!-- # ### NOTE: Please update to the latest version of vaultwarden before reporting an issue! This saves you and us a lot of time and troubleshooting. See: * https://github.com/dani-garcia/vaultwarden/issues/1180 * https://github.com/dani-garcia/vaultwarden/wiki/Updating-the-vaultwarden-image # ### --> <!-- 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 unnecessary for your issue, feel free to remove them. Remember to hide/redact personal or confidential information, such as passwords, IP addresses, and DNS names as appropriate. --> ``` bitwarden | /--------------------------------------------------------------------\ bitwarden | | Starting Vaultwarden | bitwarden | | Version 1.21.0 | bitwarden | |--------------------------------------------------------------------| bitwarden | | This is an *unofficial* Bitwarden implementation, DO NOT use the | bitwarden | | official channels to report bugs/features, regardless of client. | bitwarden | | Send usage/configuration questions or feature requests to: | bitwarden | | https://bitwardenrs.discourse.group/ | bitwarden | | Report suspected bugs/issues in the software itself at: | bitwarden | | https://github.com/dani-garcia/vaultwarden/issues/new | bitwarden | \--------------------------------------------------------------------/ bitwarden | bitwarden | [INFO] No .env file found. bitwarden | bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:04:55.699][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:04:56.720][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:04:57.735][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:04:58.757][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:04:59.776][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:00.791][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:01.807][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:02.824][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:03.842][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:04.859][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:05.882][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:06.907][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:07.922][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:08.936][vaultwarden::util][WARN] Can't connect to database, retrying: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) bitwarden | Running migration 20200802025025 bitwarden | Executing migration script 20200802025025/up.sql bitwarden | [2021-04-30 13:05:09.949][vaultwarden][ERROR] Error creating database pool: DieselMigError. bitwarden | [CAUSE] QueryError( bitwarden | DatabaseError( bitwarden | __Unknown, bitwarden | "NOT NULL constraint failed: new_ciphers.name", bitwarden | ), bitwarden | ) ``` ### Subject of the issue <!-- Describe your issue here. --> Update from `image: bitwardenrs/server:1.16.1-alpine` to `image: vaultwarden/server:1.21.1-alpine` ### Deployment environment <!-- ========================================================================================= Preferably, use the `Generate Support String` button on the admin page's Diagnostics tab. That will auto-generate most of the info requested in this section. ========================================================================================= --> <!-- The version number, obtained from the logs (at startup) or the admin diagnostics page --> <!-- This is NOT the version number shown on the web vault, which is versioned separately from vaultwarden --> <!-- Remember to check if your issue exists on the latest version first! --> * vaultwarden version: `image: bitwardenrs/server:1.16.1-alpine` to `image: vaultwarden/server:1.21.1-alpine` <!-- How the server was installed: Docker image, OS package, built from source, etc. --> * Install method: docker * Clients used: <!-- web vault, desktop, Android, iOS, etc. (if applicable) --> web, desktop (win + Mac), iOS * Reverse proxy and version: <!-- if applicable --> nginx * MySQL/MariaDB or PostgreSQL version: <!-- if applicable --> sqlite. * Other relevant details: ### Steps to reproduce <!-- Tell us how to reproduce this issue. What parameters did you set (differently from the defaults) and how did you start vaultwarden? --> Update. ### Expected behaviour <!-- Tell us what you expected to happen --> Works. ### Actual behaviour <!-- Tell us what actually happened --> Doesn't work. ### Troubleshooting data <!-- Share any log files, screenshots, or other relevant troubleshooting data -->
kerem closed this issue 2026-03-03 02:05:36 +03:00
kerem commented 2026-03-03 02:05:37 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Apr 30, 2021):

Please see: https://github.com/dani-garcia/vaultwarden/discussions/1492#discussioncomment-544064

<!-- gh-comment-id:830087168 --> @BlackDex commented on GitHub (Apr 30, 2021): Please see: https://github.com/dani-garcia/vaultwarden/discussions/1492#discussioncomment-544064
kerem commented 2026-03-03 02:05:37 +03:00
Author
Owner
Copy link

@luckydonald commented on GitHub (Apr 30, 2021):

@BlackDex That's mysql though.
Isn't it using sqlite though?

<!-- gh-comment-id:830091636 --> @luckydonald commented on GitHub (Apr 30, 2021): @BlackDex That's mysql though. Isn't it using sqlite though?
kerem commented 2026-03-03 02:05:37 +03:00
Author
Owner
Copy link

@luckydonald commented on GitHub (Apr 30, 2021):

How do I execute that script?

<!-- gh-comment-id:830095395 --> @luckydonald commented on GitHub (Apr 30, 2021): How do I execute that script?
kerem commented 2026-03-03 02:05:37 +03:00
Author
Owner
Copy link

@BlackDex commented on GitHub (Apr 30, 2021):

Those are SQL Queries, so you should connect to your database via a MYSQL client.
And adjust the variable values where needed like database name.

<!-- gh-comment-id:830098666 --> @BlackDex commented on GitHub (Apr 30, 2021): Those are SQL Queries, so you should connect to your database via a MYSQL client. And adjust the variable values where needed like database name.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
revert-7033-patch-1
cached-config-operations
test_dylint
1.35.8
1.35.7
1.35.6
1.35.5
1.35.4
1.35.3
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 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
question
troubleshooting
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/vaultwarden#1021
No description provided.