sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: encryption.key
Please first check if another issue has been opened for your problem
Versions
- OS: Arch Linux
- Gajim version: nightly (flatpak)
- GTK version: 3.24.41
- Python-nbxmpp version: 4.5.4
Steps to reproduce the problem
- Start Gajim with a new empty profile (
flatpak run org.gajim.Gajim.Devel -c /tmp/gajim
) - Sign in with an account
Expected behavior
No traceback.
Actual behavior
2024-04-20T18:39:37 (W) gajim.c.m.message (example.org) Generating id
2024-04-20T18:39:37 (W) gajim.c.m.message (example.org) Received message without text
2024-04-20T18:39:37 (E) nbxmpp.dispatcher (example.org) Handler exception:
Traceback (most recent call last):
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
self.dialect.do_execute(
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
cursor.execute(statement, parameters)
sqlite3.IntegrityError: NOT NULL constraint failed: encryption.key
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/app/lib/python3.11/site-packages/gajim/common/storage/archive/storage.py", line 244, in _insert_row
pk = session.scalar(stmt)
^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2354, in scalar
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2191, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/orm/bulk_persistence.py", line 1276, in orm_execute_statement
result = conn.execute(
^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1422, in execute
return meth(
^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 514, in _execute_on_connection
return connection._execute_clauseelement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1644, in _execute_clauseelement
ret = self._execute_context(
^^^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1850, in _execute_context
return self._exec_single_context(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1990, in _exec_single_context
self._handle_dbapi_exception(
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2357, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
self.dialect.do_execute(
File "/app/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: encryption.key
[SQL: INSERT INTO encryption (pk, protocol, "key", trust) VALUES (?, ?, ?, ?) RETURNING pk]
[parameters: (None, 'OMEMO', None, <Trust.UNTRUSTED: 0>)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)