Skip to content

Database migration failed

Please first check if another issue has been opened for your problem [+]

Versions

  1. OS: Arch Linux x86_64
  2. Gajim version: gajim-git 1:r21454. 5f0d246b-1
  3. GTK version: gtk2 2.24.33-3 gtk3 1:3.24.41-1 gtk4 1:4.14.4-1
  4. Python-nbxmpp version: python-nbxmpp-git 4.5.4.r23.gcd11cc3-1

Steps to reproduce the problem

  1. Type 'gajim -v' in terminal or launch through icon

Expected behavior

Start chatting with co-workers

Actual behavior

  1. Typing 'gajim -v'

  2. Get windows with 'Database migration failed'

  3. Copy this window content and closing it.

    Traceback (most recent call last): File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: index idx_stanza_id already exists

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

    Traceback (most recent call last): File "/usr/lib/python3.12/site-packages/gajim/common/application.py", line 84, in _init_core app.storage.archive.init() File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/storage.py", line 80, in init super().init() File "/usr/lib/python3.12/site-packages/gajim/common/storage/base.py", line 333, in init self._migrate_storage() File "/usr/lib/python3.12/site-packages/gajim/common/storage/base.py", line 410, in _migrate_storage self._migrate() File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/storage.py", line 104, in _migrate migration.run(self, user_version) File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 552, in run Migration(archive, user_version) File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 116, in init self._v9() File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 229, in _v9 self._execute_multiple(statements) File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 125, in _execute_multiple conn.execute(sa.text(stmt)) File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1422, in execute return meth( ^^^^^ File "/usr/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 517, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1984, in _exec_single_context self._handle_dbapi_exception( File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context self.dialect.do_execute( File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) index idx_stanza_id already exists [SQL: CREATE INDEX idx_stanza_id ON message(stanza_id, fk_remote_pk, fk_account_pk);] (Background on this error at: ``https://sqlalche.me/e/21/e3q8``)

  4. Copying terminal content

    [10:31:50] [asxpi@meow ~] $ gajim -v

    ** (gajim:81847): WARNING **: 10:34:43.252: expected enumeration type void, but got PyGLibOptionArg instead
    Logger gajim level set to 10
    Logger nbxmpp level set to 20
    Logger omemo_dr level set to 10
    2024-05-12T10:34:43 (I) gajim                      Gajim Version: 1.8.4
    2024-05-12T10:34:43 (W) gajim                      AV dependency test failed: Namespace Farstream not available

    (org.gajim.Gajim:81847): libenchant-WARNING **: 10:34:43.328: Error loading plugin: libaspell.so.15: cannot open sha
    red object file: No such file or directory


    (org.gajim.Gajim:81847): libenchant-WARNING **: 10:34:43.328: Error loading plugin: libhspell.so.0: cannot open shar
    ed object file: No such file or directory


    (org.gajim.Gajim:81847): libenchant-WARNING **: 10:34:43.329: Error loading plugin: libnuspell.so.5: cannot open sha
    red object file: No such file or directory


    (org.gajim.Gajim:81847): libenchant-WARNING **: 10:34:43.330: Error loading plugin: libvoikko.so.1: cannot open shar
    ed object file: No such file or directory

    2024-05-12T10:34:43 (I) gajim                      English (United States) (en_US) dict available
    2024-05-12T10:34:43 (I) gajim                      English (United States, LARGE) (en_US-large) dict available
    2024-05-12T10:34:43 (I) gajim                      Russian (Russia) (ru_RU) dict available
    2024-05-12T10:34:43 (I) gajim                      FARSTREAM     False
    2024-05-12T10:34:43 (I) gajim                      GST           True
    2024-05-12T10:34:43 (I) gajim                      AV            False
    2024-05-12T10:34:43 (I) gajim                      GEOCLUE       True
    2024-05-12T10:34:43 (I) gajim                      UPNP          False
    2024-05-12T10:34:43 (I) gajim                      GSOUND        False
    2024-05-12T10:34:43 (I) gajim                      GSPELL        True
    2024-05-12T10:34:43 (I) gajim                      IDLE          False
    2024-05-12T10:34:43 (I) gajim                      APPINDICATOR  False
    2024-05-12T10:34:43 (I) gajim                      AYATANA_APPINDICATOR True
    2024-05-12T10:34:43 (I) gajim                      SENTRY_SDK    True
    2024-05-12T10:34:43 (I) gajim                      Used language: en_US
    2024-05-12T10:34:43 (I) gajim.c.settings           Load app settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load soundevents settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load status_presets settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load proxies settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load plugins settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load workspaces settings
    2024-05-12T10:34:43 (I) gajim.c.settings           Load account settings: censured.work.domain
    2024-05-12T10:34:43 (I) gajim.c.settings           Load account settings: asxp.io
    2024-05-12T10:34:43 (I) gajim.c.settings           Commit
    2024-05-12T10:34:43 (I) gajim.c.passwords          Found keyring backend: keyring.backends.SecretService.Keyring (pr
    iority: 5)
    2024-05-12T10:34:43 (I) gajim.c.passwords          Found keyring backend: keyring.backends.chainer.ChainerBackend (p
    riority: 10)
    2024-05-12T10:34:43 (I) gajim.c.passwords          Found keyring backend: keyring.backends.libsecret.Keyring (priori
    ty: 4.8)
    2024-05-12T10:34:43 (I) gajim.c.passwords          Found keyring backend: keyring.backends.kwallet.DBusKeyring (prio
    rity: 5.1)
    2024-05-12T10:34:43 (I) gajim.c.passwords          Found keyring backend: keyring.backends.fail.Keyring (priority: 0
    )
    2024-05-12T10:34:43 (I) gajim.c.passwords          Select keyring.backends.chainer.ChainerBackend (priority: 10) bac
    kend
    2024-05-12T10:34:43 (I) gajim.c.storage.cache      Connect to /home/asxpi/.cache/gajim/cache.db
    2024-05-12T10:34:43 (I) gajim.c.storage.cache      8 DiscoInfo entries loaded
    2024-05-12T10:34:43 (D) gajim.c.storage            Execution time for _fill_disco_info_cache: 9 ms
    2024-05-12T10:34:43 (D) gajim.c.storage            Execution time for _clean_caps_table: 1 ms
    2024-05-12T10:34:43 (D) gajim.c.storage            Execution time for _load_caps_data: 21 ms
    2024-05-12T10:34:43 (I) gajim.c.storage.events     Create engine
    2024-05-12T10:34:43 (I) gajim.c.storage.events     Creating in memory
    2024-05-12T10:34:43 (I) gajim.c.storage.archive    Create engine
    2024-05-12T10:34:43 (D) gajim.c.ged                Raise event: db-migration
    2024-05-12T10:34:43 (D) gajim.c.ged                Call handler _on_db_migration on <application.GajimApplication ob
    ject at 0x7e69e70638c0 (gajim+gtk+application+GajimApplication at 0x5ff2c30d8920)>
    2024-05-12T10:34:43 (E) gajim.c.storage.archive    Migration error
    Traceback (most recent call last):
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
       self.dialect.do_execute(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute
       cursor.execute(statement, parameters)
    sqlite3.OperationalError: index idx_stanza_id already exists

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

    Traceback (most recent call last):
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/base.py", line 410, in _migrate_storage
       self._migrate()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/storage.py", line 104, in _migrate
       migration.run(self, user_version)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 552, in run
       Migration(archive, user_version)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 116, in __init__
       self._v9()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 229, in _v9
       self._execute_multiple(statements)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 125, in _execute_multiple
       conn.execute(sa.text(stmt))
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1422, in execute
       return meth(
              ^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 517, in _execute_on_connection
       return connection._execute_clauseelement(
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
       ret = self._execute_context(
             ^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context
       return self._exec_single_context(
              ^^^^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1984, in _exec_single_context
       self._handle_dbapi_exception(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception
       raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
       self.dialect.do_execute(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute
       cursor.execute(statement, parameters)
    sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) index idx_stanza_id already exists
    [SQL: CREATE INDEX idx_stanza_id ON message(stanza_id, fk_remote_pk, fk_account_pk);]
    (Background on this error at: https://sqlalche.me/e/21/e3q8)
    2024-05-12T10:34:43 (D) gajim.c.ged                Raise event: db-migration-error
    2024-05-12T10:34:43 (D) gajim.c.ged                Call handler _on_error on <db_migration.DBMigration object at 0x7
    e69d2924340 (gajim+gtk+db_migration+DBMigration at 0x5ff2c4199b90)>
    2024-05-12T10:34:43 (E) gajim.c.application        Failed to init storage
    Traceback (most recent call last):
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
       self.dialect.do_execute(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute
       cursor.execute(statement, parameters)
    sqlite3.OperationalError: index idx_stanza_id already exists

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

    Traceback (most recent call last):
     File "/usr/lib/python3.12/site-packages/gajim/common/application.py", line 84, in _init_core
       app.storage.archive.init()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/storage.py", line 80, in init
       super().init()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/base.py", line 333, in init
       self._migrate_storage()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/base.py", line 410, in _migrate_storage
       self._migrate()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/storage.py", line 104, in _migrate
       migration.run(self, user_version)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 552, in run
       Migration(archive, user_version)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 116, in __init__
       self._v9()
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 229, in _v9
       self._execute_multiple(statements)
     File "/usr/lib/python3.12/site-packages/gajim/common/storage/archive/migration.py", line 125, in _execute_multiple
       conn.execute(sa.text(stmt))
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1422, in execute
       return meth(
              ^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 517, in _execute_on_connection
       return connection._execute_clauseelement(
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement
       ret = self._execute_context(
             ^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1844, in _execute_context
       return self._exec_single_context(
              ^^^^^^^^^^^^^^^^^^^^^^^^^^
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1984, in _exec_single_context
       self._handle_dbapi_exception(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2351, in _handle_dbapi_exception
       raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1965, in _exec_single_context
       self.dialect.do_execute(
     File "/usr/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 933, in do_execute
       cursor.execute(statement, parameters)
    sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) index idx_stanza_id already exists
    [SQL: CREATE INDEX idx_stanza_id ON message(stanza_id, fk_remote_pk, fk_account_pk);]
    (Background on this error at: https://sqlalche.me/e/21/e3q8)
    2024-05-12T10:34:44 (D) gajim.c.storage            Execution time for _commit: 1 ms
    2024-05-12T10:37:59 (D) gajim.c.storage            Execution time for cleanup_chat_history: 1 ms
    2024-05-12T10:37:59 (D) gajim.c.storage            Execution time for _commit: 1 ms
    2024-05-12T10:37:59 (I) gajim.c.settings           Commit
    2024-05-12T10:37:59 (I) gajim.c.dbus.logind        Released shutdown delay inhibitor

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information