Web devices have longer device UUID that does not fit to MySQL/PostgreSQL devices.uuid field #3166

New Issue

MrUnknownDE · 2026-04-06T04:36:37+02:00

MrUnknownDE commented

2026-04-06 04:36:37 +02:00

Originally created by @flamechair on 12/22/2019

Subject of the issue

Using sqlite the column devices.uuid is of length 40, but the column created in the mysql migration is only 36 characters long

Your environment

Bitwarden_rs version: Version 1.13.0-25454697

Install method: docker
Other relevant information: manually modifying the columns devices.uuid and devices.user_uuid to be char(40) solve this issue

Steps to reproduce

create sqlite db
migrate to mysql via the wiki instructions
import sqlite dump into mysql database
error

Expected behaviour

migration goes smoothly

Actual behaviour

ERROR 1406 (22001) at line 14: Data too long for column 'uuid' at row 1

Relevant logs

web-aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee is 40 characters long, but the column in the mysql table is created as char(36)

*Originally created by @flamechair on 12/22/2019* ### Subject of the issue Using sqlite the column `devices.uuid` is of length 40, but the column created in the mysql migration is only 36 characters long ### Your environment  * Bitwarden_rs version: Version 1.13.0-25454697  * Install method: docker * Other relevant information: manually modifying the columns `devices.uuid` and `devices.user_uuid` to be `char(40)` solve this issue ### Steps to reproduce 1. create sqlite db 2. migrate to mysql via the wiki instructions 3. import sqlite dump into mysql database 4. error ### Expected behaviour migration goes smoothly ### Actual behaviour `ERROR 1406 (22001) at line 14: Data too long for column 'uuid' at row 1` ### Relevant logs `web-aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee` is 40 characters long, but the column in the mysql table is created as `char(36)`

MrUnknownDE closed this issue

2026-04-06 04:36:37 +02:00

Sign in to join this conversation.

No Label bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug bug

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#3166

Web devices have longer device UUID that does not fit to MySQL/PostgreSQL devices.uuid field #3166