Error running migrations: QueryError(DieselMigrationName

[mcamp-ata]

I just ran into the below problem running Vaultwarden on NixOS. I have tried to drop the database and restore older snapshots but keep running into this. I was able to make an empty database and things run fine (just no data 😑 ).

Any idea what I could run to fix this? Or scripts to migrate from a saved snapshot?

Its running on a Postgres database also on my NixOS system if that helps.

Jun 04 13:32:14 webb systemd[1]: vaultwarden.service: Scheduled restart job, restart counter is at 4.
Jun 04 13:32:14 webb systemd[1]: Started vaultwarden.service.
Jun 04 13:32:14 webb vaultwarden[34534]: /--------------------------------------------------------------------\
Jun 04 13:32:14 webb vaultwarden[34534]: |                        Starting Vaultwarden                        |
Jun 04 13:32:14 webb vaultwarden[34534]: |                           Version 1.30.5                           |
Jun 04 13:32:14 webb vaultwarden[34534]: |--------------------------------------------------------------------|
Jun 04 13:32:14 webb vaultwarden[34534]: | This is an *unofficial* Bitwarden implementation, DO NOT use the   |
Jun 04 13:32:14 webb vaultwarden[34534]: | official channels to report bugs/features, regardless of client.   |
Jun 04 13:32:14 webb vaultwarden[34534]: | Send usage/configuration questions or feature requests to:         |
Jun 04 13:32:14 webb vaultwarden[34534]: |   https://github.com/dani-garcia/vaultwarden/discussions or        |
Jun 04 13:32:14 webb vaultwarden[34534]: |   https://vaultwarden.discourse.group/                             |
Jun 04 13:32:14 webb vaultwarden[34534]: | Report suspected bugs/issues in the software itself at:            |
Jun 04 13:32:14 webb vaultwarden[34534]: |   https://github.com/dani-garcia/vaultwarden/issues/new            |
Jun 04 13:32:14 webb vaultwarden[34534]: \--------------------------------------------------------------------/
Jun 04 13:32:14 webb vaultwarden[34534]: [2024-06-04 13:32:14.847][panic][ERROR] thread 'main' panicked at 'Error running migrations: QueryError(DieselMigrationName { name: "2024-01-12-210182_change_attachment_size", version: MigrationVersion("20240112210182") }, DatabaseError(Unknown, "must be owner of table attachments"))': src/db/mod.rs:487
Jun 04 13:32:14 webb vaultwarden[34534]:    0: vaultwarden::init_logging::{{closure}}
Jun 04 13:32:14 webb vaultwarden[34534]:    1: std::panicking::rust_panic_with_hook
Jun 04 13:32:14 webb vaultwarden[34534]:    2: std::panicking::begin_panic_handler::{{closure}}
Jun 04 13:32:14 webb vaultwarden[34534]:    3: std::sys_common::backtrace::__rust_end_short_backtrace
Jun 04 13:32:14 webb vaultwarden[34534]:    4: rust_begin_unwind
Jun 04 13:32:14 webb vaultwarden[34534]:    5: core::panicking::panic_fmt
Jun 04 13:32:14 webb vaultwarden[34534]:    6: core::result::unwrap_failed
Jun 04 13:32:14 webb vaultwarden[34534]:    7: vaultwarden::db::DbPool::from_config
Jun 04 13:32:14 webb vaultwarden[34534]:    8: vaultwarden::main::{{closure}}
Jun 04 13:32:14 webb vaultwarden[34534]:    9: vaultwarden::main
Jun 04 13:32:14 webb vaultwarden[34534]:   10: std::sys_common::backtrace::__rust_begin_short_backtrace
Jun 04 13:32:14 webb vaultwarden[34534]:   11: std::rt::lang_start::{{closure}}
Jun 04 13:32:14 webb vaultwarden[34534]:   12: main
Jun 04 13:32:14 webb vaultwarden[34534]:   13: __libc_start_call_main
Jun 04 13:32:14 webb vaultwarden[34534]:   14: __libc_start_main@@GLIBC_2.34
Jun 04 13:32:14 webb vaultwarden[34534]:   15: _start
Jun 04 13:32:14 webb systemd[1]: vaultwarden.service: Main process exited, code=exited, status=101/n/a
Jun 04 13:32:14 webb systemd[1]: vaultwarden.service: Failed with result 'exit-code'.
Jun 04 13:32:15 webb systemd[1]: vaultwarden.service: Scheduled restart job, restart counter is at 5.
Jun 04 13:32:15 webb systemd[1]: vaultwarden.service: Start request repeated too quickly.
Jun 04 13:32:15 webb systemd[1]: vaultwarden.service: Failed with result 'exit-code'.
Jun 04 13:32:15 webb systemd[1]: Failed to start vaultwarden.service.
~

[BlackDex]

Please check and verify your database config. According to the error the user is incorrect.

I would suggest to search for that specific error must be owner of table in combination with PostgreSQL.

This is not something we can fix.