[Bug Report] Stash does not detect a failed migration on upgrade

[Conical1553]

I had an upgrade/migration fail due to disk space. The new version of stash runs with the old database, and errors like "database disk image is malformed" propagate up to the web ui. Stash could and probably should detect a failed migration and at least show a better error message, or perhaps it could prompt to re-run the migration.

Below I've attached a snippet of the installation logs.
...
INFO[2025-01-15 23:34:41] Migrating database from 67 to 68
INFO[2025-01-15 23:34:41] Backing up database into: /tank3/stash/stash-home/stash-go.sqlite.67.20250116_043430
INFO[2025-01-15 23:36:39] Optimising database
INFO[2025-01-15 23:36:52] Restoring backup database /tank3/stash/stash-home/stash-go.sqlite.67.20250116_043430 into /tank3/stash/stash-home/stash-go.sqlite
ERRO[2025-01-15 23:36:52] task failed due to error: An error occurred migrating the database to the latest schema version. The backup database file was automatically renamed to restore the database.
error performing migration: error optimising database: performing vacuum: database or disk is full

ls -al /tank3/stash/stash-home/stash-go.sqlite.67.20250116_043430

ls: cannot access '/tank3/stash/stash-home/stash-go.sqlite.67.20250116_043430': No such file or directory

When I tried to use the new version of the application, I saw database disk image is malformed errors.