sqlite3.OperationalError: database is locked

[allinaivideo]

When I accelerate launch the webui on Azure ml compute instance, I get the following error message:
sqlite3.OperationalError: database is locked

checked the sqlite3 database, and I see the ' main' database
no locks when I check with PRAGMA schema.locks;

reproduce:
create an Azure ML compute instance with gpu
Gitclone the repo and install it
launch the ui with:
accelerate launch --mixed_precision=bf16 --num_cpu_threads_per_process=6 launch.py --share --gradio-auth :

[migueelst]

I ran into the same issue when working on an AML compute instance as well. Did you figure out a solution?

[hdhayes]

I had the same problem with Azure but was able to solve it by changing the cache directory path.

Before launching the app, change the path:
export XDG_CACHE_HOME=/tmp/cache

Without this, the cache will be on /mnt/… which is causing the issue.

[schmolch-ai]

Hi, I use an Azure ML Compute Instance and have the same issue.

I changed the path for XDG_CACHE_HOME as you suggested. I see that some folders moved to the tmp\cache folder but the cache.db saved in stable-diffusion-webui/cache folder are still using and webui-start throws the error: sqlite3.OperationalError: database is locked

• stable-diffusion-webui/cache/safetensors-metadata
• stable-diffusion-webui/cache/hashes

[hdhayes]

The tmp directory I created is not within stable-diffiusion-webui
Make sure you have the slash in front of the directory: export XDG_CACHE_HOME=/tmp/cache
export XDG_CACHE_HOME=/tmp also works for me

If you change directory to /tmp do you see anything there? cd /tmp

[migueelst]

In my case setting the variable XDG_CACHE_HOME didn't work but setting SD_WEBUI_CACHE_DIR worked. I found the environment variable name by going into the modules/cache.py file.

stable-diffusion-webui/modules/cache.py

Line 12 in feee37d

cache_dir = os.environ.get('SD_WEBUI_CACHE_DIR', os.path.join(data_path, "cache"))

You can set the variable from the terminal or just add this line to the webui-user.sh script.

export SD_WEBUI_CACHE_DIR="/tmp/cache"

Thank you @hdhayes for your suggestion :)