stashapp/stash

[Bug Report] Stuck at Optimising database when installing it inside sandboxie plus

saddestboy opened this issue · 1 comments

Describe the bug
Stuck at Optimising database when installing it with sandboxie plus.

To Reproduce
Steps to reproduce the behavior:

  1. Create a new sandbox in sandboxie.
  2. Run stash inside it.
  3. Set the folder and leave the other settings default.
  4. It didn't finish after a long time and from console it is clearly to see that it stuck at Optimising database.

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

INFO[2024-06-12 15:18:42] Migrating database from version 0 to 55
INFO[2024-06-12 15:18:42] Running pre-migration for schema version 32
INFO[2024-06-12 15:18:43] Running post-migration for schema version 32
INFO[2024-06-12 15:18:43] Migrating folders
INFO[2024-06-12 15:18:43] Migrating 0 files...
INFO[2024-06-12 15:18:43] Finished migrating files
INFO[2024-06-12 15:18:43] Running post-migration for schema version 34
INFO[2024-06-12 15:18:43] Migrating scenes table
INFO[2024-06-12 15:18:43] Migrating images table
INFO[2024-06-12 15:18:43] Migrating galleries table
INFO[2024-06-12 15:18:43] Migrating files table
INFO[2024-06-12 15:18:43] Migrating folders table
INFO[2024-06-12 15:18:43] Running post-migration for schema version 42
INFO[2024-06-12 15:18:43] Migrating performer aliases
INFO[2024-06-12 15:18:43] Migrating duplicate performers
INFO[2024-06-12 15:18:43] Migrating performer disambiguation
INFO[2024-06-12 15:18:43] Running post-migration for schema version 45
INFO[2024-06-12 15:18:43] Moving tags_image to blobs table
INFO[2024-06-12 15:18:43] Moving studios_image to blobs table
INFO[2024-06-12 15:18:43] Moving performers_image to blobs table
INFO[2024-06-12 15:18:43] Moving scenes_cover to blobs table
INFO[2024-06-12 15:18:43] Moving movies_images to blobs table
INFO[2024-06-12 15:18:43] Blobs storage already set, not overwriting
INFO[2024-06-12 15:18:43] Running pre-migration for schema version 48
INFO[2024-06-12 15:18:43] Running post-migration for schema version 49
INFO[2024-06-12 15:18:43] Running post-migration for schema version 52
INFO[2024-06-12 15:18:43] Running post-migration for schema version 55
INFO[2024-06-12 15:18:43] Optimising database

Stash Version: (from Settings -> About):
latest (till now)

Desktop (please complete the following information):

  • OS: Windows (with Sandboxie-plus)

In 0.26.1 there's no log indicating that the migration is complete, and there appears to be a (hard to reproduce) bug in the UI stopping it from detecting when the migration has completed, so it stays on the same page indefinitely.

I've improved the logging on develop to indicate when the migration is complete, but I haven't been able to reliably reproduce the UI issue. It is quite likely that the migration finished, and you can just reload the browser window.