NOT NULL constraint failed: new_ciphers.name #1396

Closed
opened 2025-10-09 17:13:52 +03:00 by OVERLORD · 4 comments
Owner

Originally created by @luckydonald on GitHub.

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. <!-- # ### 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 -->
Author
Owner

@luckydonald commented on GitHub:

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

@luckydonald commented on GitHub: @BlackDex That's mysql though. Isn't it using sqlite though?
Author
Owner
@BlackDex commented on GitHub: Please see: https://github.com/dani-garcia/vaultwarden/discussions/1492#discussioncomment-544064
Author
Owner

@luckydonald commented on GitHub:

How do I execute that script?

@luckydonald commented on GitHub: How do I execute that script?
Author
Owner

@BlackDex commented on GitHub:

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.

@BlackDex commented on GitHub: 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.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/vaultwarden#1396