sqlite3.OperationalError: table [schemas] already exists

[imax]

i was trying to follow new schemas tutorial and keep getting this error with different commands

% llm schemas --full

Traceback (most recent call last):
  File "/Users/max/.local/bin/llm", line 10, in <module>
    sys.exit(cli())
             ~~~^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 1161, in __call__
    return self.main(*args, **kwargs)
           ~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 1082, in main
    rv = self.invoke(ctx)
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 1697, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 1697, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 1443, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/click/core.py", line 788, in invoke
    return __callback(*args, **kwargs)
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/llm/cli.py", line 1467, in schemas_list
    migrate(db)
    ~~~~~~~^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/llm/migrations.py", line 14, in migrate
    fn(db)
    ~~^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/llm/migrations.py", line 244, in m014_schemas
    db["schemas"].create(
    ~~~~~~~~~~~~~~~~~~~~^
        {
        ^
    ...<3 lines>...
        pk="id",
        ^^^^^^^^
    )
    ^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/sqlite_utils/db.py", line 1703, in create
    self.db.create_table(
    ~~~~~~~~~~~~~~~~~~~~^
        self.name,
        ^^^^^^^^^^
    ...<13 lines>...
        strict=strict,
        ^^^^^^^^^^^^^^
    )
    ^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/sqlite_utils/db.py", line 1084, in create_table
    self.execute(sql)
    ~~~~~~~~~~~~^^^^^
  File "/Users/max/.local/share/uv/tools/llm/lib/python3.13/site-packages/sqlite_utils/db.py", line 535, in execute
    return self.conn.execute(sql)
           ~~~~~~~~~~~~~~~~~^^^^^
sqlite3.OperationalError: table [schemas] already exists

[rdslw]

Also see this problem.

It started after simultaneous:

• upgrade llm 0.22 -> llm 0.23
• change from using pipx to uv for managing llm
  - swaping plugin ffrom claude to llm-anthropic

[rdslw]

please advise @simonw

[rdslw]

tried to downgrade to 0.22 and moving back to pipx, the problem persists.

[rdslw]

OK, did more thorough analysis.
TL;dr bug in llm 0.23 resulting in corrupt logs.db

Findings:

• uv is not a culprit (pipx neither)
• llm-anthropic is not a culprit
• 0.22 works fine
• during first run of 0.23, it tries to add schemas, there is a bug in code which leaves logs.db in a state resulting in an error, no matter which version being used -> hence simple downgrade does not help.

[krzyzanowskim]

any idea what to delete to restore to the state where it does not trigger the migration?

[krzyzanowskim]

manual delete ~Library/Application Support/io.datasette.llm/logs.db solves that for me

[imax]

deleting the logs also worked for me