lllyasviel / lllyasviel/stable-diffusion-webui-forge

Fresh Forge install via pinokio fails with: sqlite3.OperationalError: no such column: "size"

Open
#2,669 18 comments 3 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Python
Stars
13k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

Seems to fail when reading metadata.
I've tried to redownload the model, but get the same message.

reading metadata for F:\pinokio\api\stable-diffusion-webui-forge.git\app\models\Stable-diffusion\flux1-dev-bnb-nf4-v2.safetensors: OperationalError
Traceback (most recent call last):
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\sd_models.py", line 89, in __init__
self.metadata = cache.cached_data_for_file('safetensors-metadata', "checkpoint/" + name, filename, read_metadata)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\cache.py", line 119, in cached_data_for_file
existing_cache[title] = entry
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 823, in __setitem__
self.set(key, value, retry=True)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 808, in set
self._row_insert(db_key, raw, now, columns)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 857, in _row_insert
sql(
sqlite3.OperationalError: no such column: "size" - should this be a string literal in single-quotes?

Loading Model: {'checkpoint_info': {'filename': 'F:\\pinokio\\api\\stable-diffusion-webui-forge.git\\app\\models\\Stable-diffusion\\flux1-dev-bnb-nf4-v2.safetensors', 'hash': 'f0770152'}
, 'additional_modules': [], 'unet_storage_dtype': None}
[Unload] Trying to free all memory for cuda:0 with 0 models keep loaded ... Done.
StateDict Keys: {'transformer': 1722, 'vae': 244, 'text_encoder': 198, 'text_encoder_2': 220, 'ignore': 0}
Using Detected T5 Data Type: torch.float8_e4m3fn
Using Detected UNet Type: nf4
Using pre-quant state dict!
Working with z of shape (1, 16, 32, 32) = 16384 dimensions.
K-Model Created: {'storage_dtype': 'nf4', 'computation_dtype': torch.bfloat16}
Calculating sha256 for F:\pinokio\api\stable-diffusion-webui-forge.git\app\models\Stable-diffusion\flux1-dev-bnb-nf4-v2.safetensors:
fef37763b8f2c8cc3463139bbb6d91aa517c605b654d4e5c540de
52813f30306
Traceback (most recent call last):
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules_forge\main_thread.py", line 30, in work
self.result = self.func(*self.args, **self.kwargs)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\txt2img.py", line 131, in txt2img_function
processed = processing.process_images(p)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\processing.py", line 836, in process_images
manage_model_and_prompt_cache(p)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\processing.py", line 804, in manage_model_and_prompt_cache
p.sd_model, just_reloaded = forge_model_reload()
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\torch\utils\_contextlib.py", line 115, in decorate_context
return func(*args, **kwargs)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\sd_models.py", line 511, in forge_model_reload
sd_model.sd_model_hash = checkpoint_info.calculate_shorthash()
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\sd_models.py", line 114, in calculate_shorthash
self.sha256 = hashes.sha256(self.filename, f"checkpoint/{self.name}")
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\modules\hashes.py", line 67, in sha256
hashes[title] = {
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 823, in __setitem__
self.set(key, value, retry=True)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 808, in set
self._row_insert(db_key, raw, now, columns)
File "F:\pinokio\api\stable-diffusion-webui-forge.git\app\venv\lib\site-packages\diskcache\core.py", line 857, in _row_insert
sql(
sqlite3.OperationalError: no such column: "size" - should this be a string literal in single-quotes?
no such column: "size" - should this be a string literal in single-quotes?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the traceback locations in modules/cache.py, modules/sd_models.py, and modules/hashes.py, then inspect how diskcache stores metadata and hashes in SQLite. Reproduce metadata reading and model loading with the reported safetensors file. Done means both operations complete without the `no such column: "size"` error.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
databases, machine-learning
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.