lllyasviel / lllyasviel/stable-diffusion-webui-forge
Fresh Forge install via pinokio fails with: sqlite3.OperationalError: no such column: "size"
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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