vorta icon indicating copy to clipboard operation
vorta copied to clipboard

Uncaught exception: sqlite3.OperationalError: duplicate column name: tooltip

Open Ganneff opened this issue 6 months ago • 1 comments

Description

After upgrade bookworm to trixie, vorta 0.8.10 to 0.10.3, a startup fails:

peewee.OperationalError: duplicate column name: tooltip

Reproduction

  • [x] I tried to reproduce the issue.
  • [ ] I was able to reproduce the issue.

OS

Debian trixie (KDE)

Version of Vorta

0.10.3-1

What did you install Vorta with?

Distribution package

Version of Borg

No response

Logs

2025-09-06 15:48:30,359 - root - CRITICAL - Uncaught exception, file a report at https://github.com/borgbase/vorta/issues/new/choose
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/peewee.py", line 3322, in execute_sql
    cursor.execute(sql, params or ())
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: duplicate column name: tooltip

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/bin/vorta", line 8, in <module>
    sys.exit(main())
             ~~~~^^
  File "/usr/lib/python3/dist-packages/vorta/__main__.py", line 74, in main
    init_db(sqlite_db)
    ~~~~~~~^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/vorta/store/connection.py", line 91, in init_db
    run_migrations(current_schema, con)
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/vorta/store/migrations.py", line 225, in run_migrations
    _apply_schema_update(
    ~~~~~~~~~~~~~~~~~~~~^
        current_schema,
        ^^^^^^^^^^^^^^^
        20,
        ^^^
        migrator.add_column(SettingsModel._meta.table_name, 'tooltip', pw.CharField(default='')),
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/usr/lib/python3/dist-packages/vorta/store/migrations.py", line 272, in _apply_schema_update
    migrate(*operations)
    ~~~~~~~^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 944, in migrate
    operation.run()
    ~~~~~~~~~~~~~^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 162, in run
    self._handle_result(method(*self.args, **kwargs))
    ~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 156, in _handle_result
    self._handle_result(item)
    ~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 153, in _handle_result
    result.run()
    ~~~~~~~~~~^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 162, in run
    self._handle_result(method(*self.args, **kwargs))
    ~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 151, in _handle_result
    self.execute(result)
    ~~~~~~~~~~~~^^^^^^^^
  File "/usr/lib/python3/dist-packages/playhouse/migrate.py", line 147, in execute
    self.migrator.database.execute(node)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
  File "/usr/lib/python3/dist-packages/peewee.py", line 3330, in execute
    return self.execute_sql(sql, params)
           ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/peewee.py", line 3320, in execute_sql
    with __exception_wrapper__:
         ^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/peewee.py", line 3088, in __exit__
    reraise(new_type, new_type(exc_value, *exc_args), traceback)
    ~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/peewee.py", line 196, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib/python3/dist-packages/peewee.py", line 3322, in execute_sql
    cursor.execute(sql, params or ())
    ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
peewee.OperationalError: duplicate column name: tooltip

Ganneff avatar Sep 06 '25 13:09 Ganneff

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

github-actions[bot] avatar Dec 06 '25 02:12 github-actions[bot]