[GH-ISSUE #6602] DatabaseError(Unknown, "Can't create table vaultwarden.sso_users (errno: 150 \"Foreign key constraint is incorrectly formed\")")) #2477

Closed
opened 2026-03-03 02:18:41 +03:00 by kerem · 7 comments
Owner

Originally created by @DMJoh on GitHub (Dec 28, 2025).
Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/6602

Prerequisites

Vaultwarden Support String

Your environment (Generated via diagnostics page)

  • Vaultwarden version: v1.34.3
  • Web-vault version: v2025.7.0
  • OS/Arch: linux/x86_64
  • Running within a container: true (Base: Debian)
  • Database type: MySQL
  • Database version: 12.1.2-MariaDB-ubu2404
  • Uses config.json: false
  • Uses a reverse proxy: true
  • IP Header check: false (X-Forwarded-For)
  • Internet access: true
  • Internet access via a proxy: false
  • DNS Check: true
  • TZ environment: Asia/Kolkata
  • Browser/Server Time Check: true
  • Server/NTP Time Check: true
  • Domain Configuration Check: false
  • HTTPS Check: true
  • Websocket Check: true
  • HTTP Response Checks: true

Config & Details (Generated via diagnostics page)

Show Config & Details

Config:

{
  "_duo_akey": null,
  "_enable_duo": true,
  "_enable_email_2fa": true,
  "_enable_smtp": true,
  "_enable_yubico": true,
  "_icon_service_csp": "",
  "_icon_service_url": "",
  "_ip_header_enabled": true,
  "_max_note_size": 10000,
  "_smtp_img_src": "***:",
  "admin_ratelimit_max_burst": 3,
  "admin_ratelimit_seconds": 300,
  "admin_session_lifetime": 20,
  "admin_token": "***",
  "allowed_connect_src": "",
  "allowed_iframe_ancestors": "",
  "attachments_folder": "data/attachments",
  "auth_request_purge_schedule": "30 * * * * *",
  "authenticator_disable_time_drift": false,
  "data_folder": "data",
  "database_conn_init": "",
  "database_max_conns": 10,
  "database_timeout": 30,
  "database_url": "*****://***********************************************",
  "db_connection_retries": 15,
  "disable_2fa_remember": false,
  "disable_admin_token": false,
  "disable_icon_download": false,
  "domain": "*****://*******************",
  "domain_origin": "*****://*******************",
  "domain_path": "",
  "domain_set": true,
  "duo_context_purge_schedule": "30 * * * * *",
  "duo_host": null,
  "duo_ikey": null,
  "duo_skey": null,
  "duo_use_iframe": false,
  "email_2fa_auto_fallback": false,
  "email_2fa_enforce_on_verified_invite": false,
  "email_attempts_limit": 3,
  "email_change_allowed": true,
  "email_expiration_time": 600,
  "email_token_size": 6,
  "emergency_access_allowed": true,
  "emergency_notification_reminder_schedule": "0 3 * * * *",
  "emergency_request_timeout_schedule": "0 7 * * * *",
  "enable_db_wal": true,
  "enable_websocket": true,
  "enforce_single_org_with_reset_pw_policy": false,
  "event_cleanup_schedule": "0 10 0 * * *",
  "events_days_retain": null,
  "experimental_client_feature_flags": "",
  "extended_logging": true,
  "helo_name": null,
  "hibp_api_key": null,
  "http_request_block_non_global_ips": true,
  "http_request_block_regex": null,
  "icon_blacklist_non_global_ips": true,
  "icon_blacklist_regex": null,
  "icon_cache_folder": "data/icon_cache",
  "icon_cache_negttl": 259200,
  "icon_cache_ttl": 2592000,
  "icon_download_timeout": 10,
  "icon_redirect_code": 302,
  "icon_service": "internal",
  "incomplete_2fa_schedule": "30 * * * * *",
  "incomplete_2fa_time_limit": 3,
  "increase_note_size_limit": false,
  "invitation_expiration_hours": 120,
  "invitation_org_name": "Vaultwarden",
  "invitations_allowed": true,
  "ip_header": "X-Real-IP",
  "job_poll_interval_ms": 30000,
  "log_file": null,
  "log_level": "info",
  "log_timestamp_format": "%Y-%m-%d %H:%M:%S.%3f",
  "login_ratelimit_max_burst": 10,
  "login_ratelimit_seconds": 60,
  "org_attachment_limit": null,
  "org_creation_users": "",
  "org_events_enabled": false,
  "org_groups_enabled": false,
  "password_hints_allowed": true,
  "password_iterations": 600000,
  "push_enabled": true,
  "push_identity_uri": "https://identity.bitwarden.com",
  "push_installation_id": "***",
  "push_installation_key": "***",
  "push_relay_uri": "https://push.bitwarden.com",
  "reload_templates": false,
  "require_device_email": false,
  "rsa_key_filename": "data/rsa_key",
  "send_purge_schedule": "0 5 * * * *",
  "sendmail_command": null,
  "sends_allowed": true,
  "sends_folder": "data/sends",
  "show_password_hint": false,
  "signups_allowed": false,
  "signups_domains_whitelist": "",
  "signups_verify": false,
  "signups_verify_resend_limit": 6,
  "signups_verify_resend_time": 3600,
  "smtp_accept_invalid_certs": false,
  "smtp_accept_invalid_hostnames": false,
  "smtp_auth_mechanism": null,
  "smtp_debug": false,
  "smtp_embed_images": true,
  "smtp_explicit_tls": null,
  "smtp_from": "*********************",
  "smtp_from_name": "Vaultwarden",
  "smtp_host": "********************",
  "smtp_password": "***",
  "smtp_port": 587,
  "smtp_security": "starttls",
  "smtp_ssl": null,
  "smtp_timeout": 15,
  "smtp_username": "*************************",
  "templates_folder": "data/templates",
  "tmp_folder": "data/tmp",
  "trash_auto_delete_days": null,
  "trash_purge_schedule": "0 5 0 * * *",
  "use_sendmail": false,
  "use_syslog": false,
  "user_attachment_limit": null,
  "user_send_limit": null,
  "web_vault_enabled": true,
  "web_vault_folder": "web-vault/",
  "yubico_client_id": null,
  "yubico_secret_key": null,
  "yubico_server": null
}

Vaultwarden Build Version

v1.35.0

Deployment method

Official Container Image

Custom deployment method

No response

Reverse Proxy

Caddy v2.10.2

Host/Server Operating System

Linux

Operating System Version

Debian Trixie 13.2

Clients

Web Vault

Client Version

2025.7.0

Steps To Reproduce

Install the latest version and start.
The server fails to start due to database migration error.

Expected Result

VW should be up and running.

Actual Result

After upgrading to v 1.35.0, Vaultwarden with MariaDB is throwing a migration error and is failing to start.

 DatabaseError(Unknown, "Can't create table `vaultwarden`.`sso_users` (errno: 150 \"Foreign key constraint is incorrectly formed\")"))

Logs

vaultwarden  | 2025-12-28T02:51:50.009648342Z /--------------------------------------------------------------------\
vaultwarden  | 2025-12-28T02:51:50.009673250Z |                        Starting Vaultwarden                        |
vaultwarden  | 2025-12-28T02:51:50.009680901Z |                           Version 1.35.0                           |
vaultwarden  | 2025-12-28T02:51:50.009686876Z |--------------------------------------------------------------------|
vaultwarden  | 2025-12-28T02:51:50.009692741Z | This is an *unofficial* Bitwarden implementation, DO NOT use the   |
vaultwarden  | 2025-12-28T02:51:50.009698447Z | official channels to report bugs/features, regardless of client.   |
vaultwarden  | 2025-12-28T02:51:50.009704022Z | Send usage/configuration questions or feature requests to:         |
vaultwarden  | 2025-12-28T02:51:50.009709873Z |   https://github.com/dani-garcia/vaultwarden/discussions or        |
vaultwarden  | 2025-12-28T02:51:50.009715460Z |   https://vaultwarden.discourse.group/                             |
vaultwarden  | 2025-12-28T02:51:50.009721153Z | Report suspected bugs/issues in the software itself at:            |
vaultwarden  | 2025-12-28T02:51:50.009726762Z |   https://github.com/dani-garcia/vaultwarden/issues/new            |
vaultwarden  | 2025-12-28T02:51:50.009732311Z \--------------------------------------------------------------------/
vaultwarden  | 2025-12-28T02:51:50.009737872Z 
vaultwarden  | 2025-12-28T02:51:50.069044864Z [2025-12-28 08:21:50.068][panic][ERROR] thread 'main' panicked at 'Error running migrations: QueryError(DieselMigrationName { name: "2024-03-06-170000_add_sso_users", version: MigrationVersion("20240306170000") }, DatabaseError(Unknown, "Can't create table `vaultwarden`.`sso_users` (errno: 150 \"Foreign key constraint is incorrectly formed\")"))': src/db/mod.rs:505
vaultwarden  | 2025-12-28T02:51:50.072025666Z    0: vaultwarden::init_logging::{{closure}}
vaultwarden  | 2025-12-28T02:51:50.072055497Z    1: std::panicking::panic_with_hook
vaultwarden  | 2025-12-28T02:51:50.072063701Z    2: std::panicking::panic_handler::{{closure}}
vaultwarden  | 2025-12-28T02:51:50.072070091Z    3: std::sys::backtrace::__rust_end_short_backtrace
vaultwarden  | 2025-12-28T02:51:50.072076012Z    4: __rustc::rust_begin_unwind
vaultwarden  | 2025-12-28T02:51:50.072092906Z    5: core::panicking::panic_fmt
vaultwarden  | 2025-12-28T02:51:50.072098281Z    6: core::result::unwrap_failed
vaultwarden  | 2025-12-28T02:51:50.072102948Z    7: vaultwarden::db::DbPool::from_config
vaultwarden  | 2025-12-28T02:51:50.072107442Z    8: vaultwarden::main::{{closure}}
vaultwarden  | 2025-12-28T02:51:50.072111873Z    9: vaultwarden::main
vaultwarden  | 2025-12-28T02:51:50.072116258Z   10: std::sys::backtrace::__rust_begin_short_backtrace
vaultwarden  | 2025-12-28T02:51:50.072120732Z   11: main
vaultwarden  | 2025-12-28T02:51:50.072124979Z   12: 
vaultwarden  | 2025-12-28T02:51:50.072129546Z   13: __libc_start_main
vaultwarden  | 2025-12-28T02:51:50.072133851Z   14: _start
vaultwarden  | 2025-12-28T02:51:50.072138237Z

Screenshots or Videos

No response

Additional Context

Your environment (Generated via diagnostics page)

  • Vaultwarden version: v1.34.3
  • Web-vault version: v2025.7.0
  • OS/Arch: linux/x86_64
  • Running within a container: true (Base: Debian)
  • Database type: MySQL
  • Database version: 12.1.2-MariaDB-ubu2404
  • Uses config.json: false
  • Uses a reverse proxy: true
  • IP Header check: false (X-Forwarded-For)
  • Internet access: true
  • Internet access via a proxy: false
  • DNS Check: true
  • TZ environment: Asia/Kolkata
  • Browser/Server Time Check: true
  • Server/NTP Time Check: true
  • Domain Configuration Check: false
  • HTTPS Check: true
  • Websocket Check: true
  • HTTP Response Checks: true

Config & Details (Generated via diagnostics page)

Show Config & Details

Config:

{
  "_duo_akey": null,
  "_enable_duo": true,
  "_enable_email_2fa": true,
  "_enable_smtp": true,
  "_enable_yubico": true,
  "_icon_service_csp": "",
  "_icon_service_url": "",
  "_ip_header_enabled": true,
  "_max_note_size": 10000,
  "_smtp_img_src": "***:",
  "admin_ratelimit_max_burst": 3,
  "admin_ratelimit_seconds": 300,
  "admin_session_lifetime": 20,
  "admin_token": "***",
  "allowed_connect_src": "",
  "allowed_iframe_ancestors": "",
  "attachments_folder": "data/attachments",
  "auth_request_purge_schedule": "30 * * * * *",
  "authenticator_disable_time_drift": false,
  "data_folder": "data",
  "database_conn_init": "",
  "database_max_conns": 10,
  "database_timeout": 30,
  "database_url": "*****://***********************************************",
  "db_connection_retries": 15,
  "disable_2fa_remember": false,
  "disable_admin_token": false,
  "disable_icon_download": false,
  "domain": "*****://*******************",
  "domain_origin": "*****://*******************",
  "domain_path": "",
  "domain_set": true,
  "duo_context_purge_schedule": "30 * * * * *",
  "duo_host": null,
  "duo_ikey": null,
  "duo_skey": null,
  "duo_use_iframe": false,
  "email_2fa_auto_fallback": false,
  "email_2fa_enforce_on_verified_invite": false,
  "email_attempts_limit": 3,
  "email_change_allowed": true,
  "email_expiration_time": 600,
  "email_token_size": 6,
  "emergency_access_allowed": true,
  "emergency_notification_reminder_schedule": "0 3 * * * *",
  "emergency_request_timeout_schedule": "0 7 * * * *",
  "enable_db_wal": true,
  "enable_websocket": true,
  "enforce_single_org_with_reset_pw_policy": false,
  "event_cleanup_schedule": "0 10 0 * * *",
  "events_days_retain": null,
  "experimental_client_feature_flags": "",
  "extended_logging": true,
  "helo_name": null,
  "hibp_api_key": null,
  "http_request_block_non_global_ips": true,
  "http_request_block_regex": null,
  "icon_blacklist_non_global_ips": true,
  "icon_blacklist_regex": null,
  "icon_cache_folder": "data/icon_cache",
  "icon_cache_negttl": 259200,
  "icon_cache_ttl": 2592000,
  "icon_download_timeout": 10,
  "icon_redirect_code": 302,
  "icon_service": "internal",
  "incomplete_2fa_schedule": "30 * * * * *",
  "incomplete_2fa_time_limit": 3,
  "increase_note_size_limit": false,
  "invitation_expiration_hours": 120,
  "invitation_org_name": "Vaultwarden",
  "invitations_allowed": true,
  "ip_header": "X-Real-IP",
  "job_poll_interval_ms": 30000,
  "log_file": null,
  "log_level": "info",
  "log_timestamp_format": "%Y-%m-%d %H:%M:%S.%3f",
  "login_ratelimit_max_burst": 10,
  "login_ratelimit_seconds": 60,
  "org_attachment_limit": null,
  "org_creation_users": "",
  "org_events_enabled": false,
  "org_groups_enabled": false,
  "password_hints_allowed": true,
  "password_iterations": 600000,
  "push_enabled": true,
  "push_identity_uri": "https://identity.bitwarden.com",
  "push_installation_id": "***",
  "push_installation_key": "***",
  "push_relay_uri": "https://push.bitwarden.com",
  "reload_templates": false,
  "require_device_email": false,
  "rsa_key_filename": "data/rsa_key",
  "send_purge_schedule": "0 5 * * * *",
  "sendmail_command": null,
  "sends_allowed": true,
  "sends_folder": "data/sends",
  "show_password_hint": false,
  "signups_allowed": false,
  "signups_domains_whitelist": "",
  "signups_verify": false,
  "signups_verify_resend_limit": 6,
  "signups_verify_resend_time": 3600,
  "smtp_accept_invalid_certs": false,
  "smtp_accept_invalid_hostnames": false,
  "smtp_auth_mechanism": null,
  "smtp_debug": false,
  "smtp_embed_images": true,
  "smtp_explicit_tls": null,
  "smtp_from": "*********************",
  "smtp_from_name": "Vaultwarden",
  "smtp_host": "********************",
  "smtp_password": "***",
  "smtp_port": 587,
  "smtp_security": "starttls",
  "smtp_ssl": null,
  "smtp_timeout": 15,
  "smtp_username": "*************************",
  "templates_folder": "data/templates",
  "tmp_folder": "data/tmp",
  "trash_auto_delete_days": null,
  "trash_purge_schedule": "0 5 0 * * *",
  "use_sendmail": false,
  "use_syslog": false,
  "user_attachment_limit": null,
  "user_send_limit": null,
  "web_vault_enabled": true,
  "web_vault_folder": "web-vault/",
  "yubico_client_id": null,
  "yubico_secret_key": null,
  "yubico_server": null
}

I have reverted to 1.34.3 for now and is working as expected.

Originally created by @DMJoh on GitHub (Dec 28, 2025). Original GitHub issue: https://github.com/dani-garcia/vaultwarden/issues/6602 ### Prerequisites - [x] I have searched the existing **Closed _AND_ Open** [Issues](https://github.com/dani-garcia/vaultwarden/issues?q=is%3Aissue%20) **_AND_** [Discussions](https://github.com/dani-garcia/vaultwarden/discussions?discussions_q=) - [x] I have searched and read the [documentation](https://github.com/dani-garcia/vaultwarden/wiki/) ### Vaultwarden Support String ### Your environment (Generated via diagnostics page) * Vaultwarden version: v1.34.3 * Web-vault version: v2025.7.0 * OS/Arch: linux/x86_64 * Running within a container: true (Base: Debian) * Database type: MySQL * Database version: 12.1.2-MariaDB-ubu2404 * Uses config.json: false * Uses a reverse proxy: true * IP Header check: false (X-Forwarded-For) * Internet access: true * Internet access via a proxy: false * DNS Check: true * TZ environment: Asia/Kolkata * Browser/Server Time Check: true * Server/NTP Time Check: true * Domain Configuration Check: false * HTTPS Check: true * Websocket Check: true * HTTP Response Checks: true ### Config & Details (Generated via diagnostics page) <details><summary>Show Config & Details</summary> **Config:** ```json { "_duo_akey": null, "_enable_duo": true, "_enable_email_2fa": true, "_enable_smtp": true, "_enable_yubico": true, "_icon_service_csp": "", "_icon_service_url": "", "_ip_header_enabled": true, "_max_note_size": 10000, "_smtp_img_src": "***:", "admin_ratelimit_max_burst": 3, "admin_ratelimit_seconds": 300, "admin_session_lifetime": 20, "admin_token": "***", "allowed_connect_src": "", "allowed_iframe_ancestors": "", "attachments_folder": "data/attachments", "auth_request_purge_schedule": "30 * * * * *", "authenticator_disable_time_drift": false, "data_folder": "data", "database_conn_init": "", "database_max_conns": 10, "database_timeout": 30, "database_url": "*****://***********************************************", "db_connection_retries": 15, "disable_2fa_remember": false, "disable_admin_token": false, "disable_icon_download": false, "domain": "*****://*******************", "domain_origin": "*****://*******************", "domain_path": "", "domain_set": true, "duo_context_purge_schedule": "30 * * * * *", "duo_host": null, "duo_ikey": null, "duo_skey": null, "duo_use_iframe": false, "email_2fa_auto_fallback": false, "email_2fa_enforce_on_verified_invite": false, "email_attempts_limit": 3, "email_change_allowed": true, "email_expiration_time": 600, "email_token_size": 6, "emergency_access_allowed": true, "emergency_notification_reminder_schedule": "0 3 * * * *", "emergency_request_timeout_schedule": "0 7 * * * *", "enable_db_wal": true, "enable_websocket": true, "enforce_single_org_with_reset_pw_policy": false, "event_cleanup_schedule": "0 10 0 * * *", "events_days_retain": null, "experimental_client_feature_flags": "", "extended_logging": true, "helo_name": null, "hibp_api_key": null, "http_request_block_non_global_ips": true, "http_request_block_regex": null, "icon_blacklist_non_global_ips": true, "icon_blacklist_regex": null, "icon_cache_folder": "data/icon_cache", "icon_cache_negttl": 259200, "icon_cache_ttl": 2592000, "icon_download_timeout": 10, "icon_redirect_code": 302, "icon_service": "internal", "incomplete_2fa_schedule": "30 * * * * *", "incomplete_2fa_time_limit": 3, "increase_note_size_limit": false, "invitation_expiration_hours": 120, "invitation_org_name": "Vaultwarden", "invitations_allowed": true, "ip_header": "X-Real-IP", "job_poll_interval_ms": 30000, "log_file": null, "log_level": "info", "log_timestamp_format": "%Y-%m-%d %H:%M:%S.%3f", "login_ratelimit_max_burst": 10, "login_ratelimit_seconds": 60, "org_attachment_limit": null, "org_creation_users": "", "org_events_enabled": false, "org_groups_enabled": false, "password_hints_allowed": true, "password_iterations": 600000, "push_enabled": true, "push_identity_uri": "https://identity.bitwarden.com", "push_installation_id": "***", "push_installation_key": "***", "push_relay_uri": "https://push.bitwarden.com", "reload_templates": false, "require_device_email": false, "rsa_key_filename": "data/rsa_key", "send_purge_schedule": "0 5 * * * *", "sendmail_command": null, "sends_allowed": true, "sends_folder": "data/sends", "show_password_hint": false, "signups_allowed": false, "signups_domains_whitelist": "", "signups_verify": false, "signups_verify_resend_limit": 6, "signups_verify_resend_time": 3600, "smtp_accept_invalid_certs": false, "smtp_accept_invalid_hostnames": false, "smtp_auth_mechanism": null, "smtp_debug": false, "smtp_embed_images": true, "smtp_explicit_tls": null, "smtp_from": "*********************", "smtp_from_name": "Vaultwarden", "smtp_host": "********************", "smtp_password": "***", "smtp_port": 587, "smtp_security": "starttls", "smtp_ssl": null, "smtp_timeout": 15, "smtp_username": "*************************", "templates_folder": "data/templates", "tmp_folder": "data/tmp", "trash_auto_delete_days": null, "trash_purge_schedule": "0 5 0 * * *", "use_sendmail": false, "use_syslog": false, "user_attachment_limit": null, "user_send_limit": null, "web_vault_enabled": true, "web_vault_folder": "web-vault/", "yubico_client_id": null, "yubico_secret_key": null, "yubico_server": null } ``` </details> ### Vaultwarden Build Version v1.35.0 ### Deployment method Official Container Image ### Custom deployment method _No response_ ### Reverse Proxy Caddy v2.10.2 ### Host/Server Operating System Linux ### Operating System Version Debian Trixie 13.2 ### Clients Web Vault ### Client Version 2025.7.0 ### Steps To Reproduce Install the latest version and start. The server fails to start due to database migration error. ### Expected Result VW should be up and running. ### Actual Result After upgrading to v 1.35.0, Vaultwarden with MariaDB is throwing a migration error and is failing to start. ``` DatabaseError(Unknown, "Can't create table `vaultwarden`.`sso_users` (errno: 150 \"Foreign key constraint is incorrectly formed\")")) ``` ### Logs ```text vaultwarden | 2025-12-28T02:51:50.009648342Z /--------------------------------------------------------------------\ vaultwarden | 2025-12-28T02:51:50.009673250Z | Starting Vaultwarden | vaultwarden | 2025-12-28T02:51:50.009680901Z | Version 1.35.0 | vaultwarden | 2025-12-28T02:51:50.009686876Z |--------------------------------------------------------------------| vaultwarden | 2025-12-28T02:51:50.009692741Z | This is an *unofficial* Bitwarden implementation, DO NOT use the | vaultwarden | 2025-12-28T02:51:50.009698447Z | official channels to report bugs/features, regardless of client. | vaultwarden | 2025-12-28T02:51:50.009704022Z | Send usage/configuration questions or feature requests to: | vaultwarden | 2025-12-28T02:51:50.009709873Z | https://github.com/dani-garcia/vaultwarden/discussions or | vaultwarden | 2025-12-28T02:51:50.009715460Z | https://vaultwarden.discourse.group/ | vaultwarden | 2025-12-28T02:51:50.009721153Z | Report suspected bugs/issues in the software itself at: | vaultwarden | 2025-12-28T02:51:50.009726762Z | https://github.com/dani-garcia/vaultwarden/issues/new | vaultwarden | 2025-12-28T02:51:50.009732311Z \--------------------------------------------------------------------/ vaultwarden | 2025-12-28T02:51:50.009737872Z vaultwarden | 2025-12-28T02:51:50.069044864Z [2025-12-28 08:21:50.068][panic][ERROR] thread 'main' panicked at 'Error running migrations: QueryError(DieselMigrationName { name: "2024-03-06-170000_add_sso_users", version: MigrationVersion("20240306170000") }, DatabaseError(Unknown, "Can't create table `vaultwarden`.`sso_users` (errno: 150 \"Foreign key constraint is incorrectly formed\")"))': src/db/mod.rs:505 vaultwarden | 2025-12-28T02:51:50.072025666Z 0: vaultwarden::init_logging::{{closure}} vaultwarden | 2025-12-28T02:51:50.072055497Z 1: std::panicking::panic_with_hook vaultwarden | 2025-12-28T02:51:50.072063701Z 2: std::panicking::panic_handler::{{closure}} vaultwarden | 2025-12-28T02:51:50.072070091Z 3: std::sys::backtrace::__rust_end_short_backtrace vaultwarden | 2025-12-28T02:51:50.072076012Z 4: __rustc::rust_begin_unwind vaultwarden | 2025-12-28T02:51:50.072092906Z 5: core::panicking::panic_fmt vaultwarden | 2025-12-28T02:51:50.072098281Z 6: core::result::unwrap_failed vaultwarden | 2025-12-28T02:51:50.072102948Z 7: vaultwarden::db::DbPool::from_config vaultwarden | 2025-12-28T02:51:50.072107442Z 8: vaultwarden::main::{{closure}} vaultwarden | 2025-12-28T02:51:50.072111873Z 9: vaultwarden::main vaultwarden | 2025-12-28T02:51:50.072116258Z 10: std::sys::backtrace::__rust_begin_short_backtrace vaultwarden | 2025-12-28T02:51:50.072120732Z 11: main vaultwarden | 2025-12-28T02:51:50.072124979Z 12: vaultwarden | 2025-12-28T02:51:50.072129546Z 13: __libc_start_main vaultwarden | 2025-12-28T02:51:50.072133851Z 14: _start vaultwarden | 2025-12-28T02:51:50.072138237Z ``` ### Screenshots or Videos _No response_ ### Additional Context ### Your environment (Generated via diagnostics page) * Vaultwarden version: v1.34.3 * Web-vault version: v2025.7.0 * OS/Arch: linux/x86_64 * Running within a container: true (Base: Debian) * Database type: MySQL * Database version: 12.1.2-MariaDB-ubu2404 * Uses config.json: false * Uses a reverse proxy: true * IP Header check: false (X-Forwarded-For) * Internet access: true * Internet access via a proxy: false * DNS Check: true * TZ environment: Asia/Kolkata * Browser/Server Time Check: true * Server/NTP Time Check: true * Domain Configuration Check: false * HTTPS Check: true * Websocket Check: true * HTTP Response Checks: true ### Config & Details (Generated via diagnostics page) <details><summary>Show Config & Details</summary> **Config:** ```json { "_duo_akey": null, "_enable_duo": true, "_enable_email_2fa": true, "_enable_smtp": true, "_enable_yubico": true, "_icon_service_csp": "", "_icon_service_url": "", "_ip_header_enabled": true, "_max_note_size": 10000, "_smtp_img_src": "***:", "admin_ratelimit_max_burst": 3, "admin_ratelimit_seconds": 300, "admin_session_lifetime": 20, "admin_token": "***", "allowed_connect_src": "", "allowed_iframe_ancestors": "", "attachments_folder": "data/attachments", "auth_request_purge_schedule": "30 * * * * *", "authenticator_disable_time_drift": false, "data_folder": "data", "database_conn_init": "", "database_max_conns": 10, "database_timeout": 30, "database_url": "*****://***********************************************", "db_connection_retries": 15, "disable_2fa_remember": false, "disable_admin_token": false, "disable_icon_download": false, "domain": "*****://*******************", "domain_origin": "*****://*******************", "domain_path": "", "domain_set": true, "duo_context_purge_schedule": "30 * * * * *", "duo_host": null, "duo_ikey": null, "duo_skey": null, "duo_use_iframe": false, "email_2fa_auto_fallback": false, "email_2fa_enforce_on_verified_invite": false, "email_attempts_limit": 3, "email_change_allowed": true, "email_expiration_time": 600, "email_token_size": 6, "emergency_access_allowed": true, "emergency_notification_reminder_schedule": "0 3 * * * *", "emergency_request_timeout_schedule": "0 7 * * * *", "enable_db_wal": true, "enable_websocket": true, "enforce_single_org_with_reset_pw_policy": false, "event_cleanup_schedule": "0 10 0 * * *", "events_days_retain": null, "experimental_client_feature_flags": "", "extended_logging": true, "helo_name": null, "hibp_api_key": null, "http_request_block_non_global_ips": true, "http_request_block_regex": null, "icon_blacklist_non_global_ips": true, "icon_blacklist_regex": null, "icon_cache_folder": "data/icon_cache", "icon_cache_negttl": 259200, "icon_cache_ttl": 2592000, "icon_download_timeout": 10, "icon_redirect_code": 302, "icon_service": "internal", "incomplete_2fa_schedule": "30 * * * * *", "incomplete_2fa_time_limit": 3, "increase_note_size_limit": false, "invitation_expiration_hours": 120, "invitation_org_name": "Vaultwarden", "invitations_allowed": true, "ip_header": "X-Real-IP", "job_poll_interval_ms": 30000, "log_file": null, "log_level": "info", "log_timestamp_format": "%Y-%m-%d %H:%M:%S.%3f", "login_ratelimit_max_burst": 10, "login_ratelimit_seconds": 60, "org_attachment_limit": null, "org_creation_users": "", "org_events_enabled": false, "org_groups_enabled": false, "password_hints_allowed": true, "password_iterations": 600000, "push_enabled": true, "push_identity_uri": "https://identity.bitwarden.com", "push_installation_id": "***", "push_installation_key": "***", "push_relay_uri": "https://push.bitwarden.com", "reload_templates": false, "require_device_email": false, "rsa_key_filename": "data/rsa_key", "send_purge_schedule": "0 5 * * * *", "sendmail_command": null, "sends_allowed": true, "sends_folder": "data/sends", "show_password_hint": false, "signups_allowed": false, "signups_domains_whitelist": "", "signups_verify": false, "signups_verify_resend_limit": 6, "signups_verify_resend_time": 3600, "smtp_accept_invalid_certs": false, "smtp_accept_invalid_hostnames": false, "smtp_auth_mechanism": null, "smtp_debug": false, "smtp_embed_images": true, "smtp_explicit_tls": null, "smtp_from": "*********************", "smtp_from_name": "Vaultwarden", "smtp_host": "********************", "smtp_password": "***", "smtp_port": 587, "smtp_security": "starttls", "smtp_ssl": null, "smtp_timeout": 15, "smtp_username": "*************************", "templates_folder": "data/templates", "tmp_folder": "data/tmp", "trash_auto_delete_days": null, "trash_purge_schedule": "0 5 0 * * *", "use_sendmail": false, "use_syslog": false, "user_attachment_limit": null, "user_send_limit": null, "web_vault_enabled": true, "web_vault_folder": "web-vault/", "yubico_client_id": null, "yubico_secret_key": null, "yubico_server": null } ``` </details> I have reverted to 1.34.3 for now and is working as expected.
kerem 2026-03-03 02:18:41 +03:00
  • closed this issue
  • added the
    bug
    label
Author
Owner

@BlackDex commented on GitHub (Dec 28, 2025):

This is already resolved in testing/main.

<!-- gh-comment-id:3694429397 --> @BlackDex commented on GitHub (Dec 28, 2025): This is already resolved in testing/main.
Author
Owner

@stefan0xC commented on GitHub (Dec 28, 2025):

@DMJoh If I recall correctly some users had problems like that before when upgrading. Can you make sure that the collation and charset of your database and tables are correctly set?

@BlackDex Are you sure? The only difference between the latest release (1.35.0) and main is an update of the Cargo.lock file (github.com/dani-garcia/vaultwarden@eb2a56aea1).

<!-- gh-comment-id:3694436267 --> @stefan0xC commented on GitHub (Dec 28, 2025): @DMJoh If I recall correctly some users had problems like that before when upgrading. Can you [make sure that the collation and charset of your database and tables](https://github.com/dani-garcia/vaultwarden/wiki/Using-the-MariaDB-%28MySQL%29-Backend#foreign-key-errors-collation-and-charset) are correctly set? @BlackDex Are you sure? The only [difference between the latest release (1.35.0) and `main`](https://github.com/dani-garcia/vaultwarden/compare/1.35.0...main) is an update of the `Cargo.lock` file (https://github.com/dani-garcia/vaultwarden/commit/eb2a56aea101f8e747228ebe497a5576ab44662b).
Author
Owner

@BlackDex commented on GitHub (Dec 28, 2025):

@stefan0xC, @DMJoh is using 1.34.3, and it should be solved in 1.35.0 actually.

<!-- gh-comment-id:3694450564 --> @BlackDex commented on GitHub (Dec 28, 2025): @stefan0xC, @DMJoh is using 1.34.3, and it should be solved in 1.35.0 actually.
Author
Owner

@stefan0xC commented on GitHub (Dec 28, 2025):

If you check the logs @DMJoh was using 1.35.0. (1.34.3 does not have that migration yet.)

<!-- gh-comment-id:3694451720 --> @stefan0xC commented on GitHub (Dec 28, 2025): If you check the logs @DMJoh was using `1.35.0`. (`1.34.3` does not have that migration yet.)
Author
Owner

@DMJoh commented on GitHub (Dec 28, 2025):

@stefan0xC @BlackDex With 1.35.0, Vaultwarden was not starting. So I reverted back to 1.34.3 to get the diagnostics.

Collation and charset from my VW db

MariaDB [vaultwarden]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden";
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4                    | utf8mb4_general_ci     |
+----------------------------+------------------------+
1 row in set (0.000 sec)
MariaDB [vaultwarden]> SELECT CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = "vaultwarden" AND CHARACTER_SET_NAME IS NOT NULL;
+--------------------+--------------------+
| CHARACTER_SET_NAME | COLLATION_NAME     |
+--------------------+--------------------+
| utf8mb4            | utf8mb4_unicode_ci |
| utf8mb4            | utf8mb4_unicode_ci |
| utf8mb4            | utf8mb4_unicode_ci |
| utf8mb4            | utf8mb4_unicode_ci |
| utf8mb4            | utf8mb4_unicode_ci |
...
MariaDB [vaultwarden]> SHOW CREATE DATABASE `vaultwarden`;
+-------------+----------------------------------------------------------------------------------------------------+
| Database    | Create Database                                                                                    |
+-------------+----------------------------------------------------------------------------------------------------+
| vaultwarden | CREATE DATABASE `vaultwarden` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ |
+-------------+----------------------------------------------------------------------------------------------------+
<!-- gh-comment-id:3694453862 --> @DMJoh commented on GitHub (Dec 28, 2025): @stefan0xC @BlackDex With 1.35.0, Vaultwarden was not starting. So I reverted back to 1.34.3 to get the diagnostics. Collation and charset from my VW db ```bash MariaDB [vaultwarden]> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = "vaultwarden"; +----------------------------+------------------------+ | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +----------------------------+------------------------+ | utf8mb4 | utf8mb4_general_ci | +----------------------------+------------------------+ 1 row in set (0.000 sec) ``` ```bash MariaDB [vaultwarden]> SELECT CHARACTER_SET_NAME, COLLATION_NAME FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = "vaultwarden" AND CHARACTER_SET_NAME IS NOT NULL; +--------------------+--------------------+ | CHARACTER_SET_NAME | COLLATION_NAME | +--------------------+--------------------+ | utf8mb4 | utf8mb4_unicode_ci | | utf8mb4 | utf8mb4_unicode_ci | | utf8mb4 | utf8mb4_unicode_ci | | utf8mb4 | utf8mb4_unicode_ci | | utf8mb4 | utf8mb4_unicode_ci | ... ``` ```bash MariaDB [vaultwarden]> SHOW CREATE DATABASE `vaultwarden`; +-------------+----------------------------------------------------------------------------------------------------+ | Database | Create Database | +-------------+----------------------------------------------------------------------------------------------------+ | vaultwarden | CREATE DATABASE `vaultwarden` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ | +-------------+----------------------------------------------------------------------------------------------------+ ```
Author
Owner

@stefan0xC commented on GitHub (Dec 28, 2025):

@DMJoh Not sure if that is the cause of the issue but I see a default collation of utf8mb4_general_ci but a collation of utf8mb4_unicode_ci for the tables, so you might want to change the default collation to the latter?

ALTER DATABASE `vaultwarden` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
<!-- gh-comment-id:3694457890 --> @stefan0xC commented on GitHub (Dec 28, 2025): @DMJoh Not sure if that is the cause of the issue but I see a default collation of `utf8mb4_general_ci` but a collation of `utf8mb4_unicode_ci` for the tables, so you might want to change the default collation to the latter? ```SQL ALTER DATABASE `vaultwarden` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ```
Author
Owner

@DMJoh commented on GitHub (Dec 28, 2025):

@stefan0xC Very well, that did the trick. Now I can see vaultwarden up and healthy.

Thank you so much for the quick responses.

<!-- gh-comment-id:3694461910 --> @DMJoh commented on GitHub (Dec 28, 2025): @stefan0xC Very well, that did the trick. Now I can see vaultwarden up and healthy. Thank you so much for the quick responses.
Sign in to join this conversation.
No milestone
No project
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#2477
No description provided.