Exception occurred when using ChatExternalClient: sqlite3.OperationalError: no such column: "size" - should this be a string literal in single-quotes?

[hanweidong]

Hi, I have tried the official demo to optimize my prompt based on the Qwen model using TextGrad, but encountered some issues. Could you please check if there is any problem?

environment:

textgrad==0.1.8
openai == 2.14.0

code:

from openai import OpenAI
from textgrad.engine.local_model_openai_api import ChatExternalClient

client = OpenAI(api_key=*****',
                base_url='http://lanz.hikvision.com/v3/openai/model')
engine = ChatExternalClient(client=client, model_string="Qwen3-Coder-480B")
print(engine.generate(max_tokens=40, content='who are you ?'))

error:

sqlite3.OperationalError: no such column: "size" - should this be a string literal in single-quotes?

[vinid]

Hello!

Sqlite is not a dependency that comes from textgrad. Would you mind sharing the full stack trace so i can see where the error is?

[hanweidong]

Hello!

Sqlite is not a dependency that comes from textgrad. Would you mind sharing the full stack trace so i can see where the error is?

This is the complete stack information：

Traceback (most recent call last):
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/tenacity/__init__.py", line 478, in __call__
    result = fn(*args, **kwargs)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/textgrad/engine/openai.py", line 71, in generate
    return self._generate_from_single_prompt(content, system_prompt=system_prompt, **kwargs)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/textgrad/engine/openai.py", line 105, in _generate_from_single_prompt
    self._save_cache(sys_prompt_arg + prompt, response)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/textgrad/engine/base.py", line 32, in _save_cache
    self.cache[prompt] = response
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/diskcache/core.py", line 823, in __setitem__
    self.set(key, value, retry=True)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/diskcache/core.py", line 808, in set
    self._row_insert(db_key, raw, now, columns)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/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?

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/nepf/hwd/ruanyan/v1.8/cognisight-components/test/cognisight_trace_sink/llm_test.py", line 18, in <module>
    print(engine.generate(max_tokens=40, content='who are you ?'))
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/tenacity/__init__.py", line 336, in wrapped_f
    return copy(f, *args, **kw)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/tenacity/__init__.py", line 475, in __call__
    do = self.iter(retry_state=retry_state)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/tenacity/__init__.py", line 376, in iter
    result = action(retry_state)
  File "/mnt/disk1/ruanyan/python/env/lib/python3.10/site-packages/tenacity/__init__.py", line 419, in exc_check
    raise retry_exc from fut.exception()
tenacity.RetryError: RetryError[<Future at 0x7f5009605ff0 state=finished raised OperationalError>]

[vinid]

This looks like an issue with our diskcache, can you see if updating sqlite solves the problem? I can see that this is a recurring problem in some versions.

[hanweidong]

I checked my SQLite version and it is 3.49.1. I tried to update it.